How would you create a system to manage the resource constraints?

Case Power Train, Ltd.We have smashing systems for reporting, tracking, and controlling costs on design projects. Our planning of projects is better than any I have seen at other companies. Our scheduling seemed to serve us well when we were small and we had only a few projects. Now that we have many more projects and schedule using multi-project software, there are too many occasions when the right people are not assigned to the projects deemed important to our success. This situation is costing us big money, headaches, and stress!Claude Jones, VP, Design and OperationsHISTORYPower Train, Ltd. (PT), was founded in 1970 by Daniel Gage, a skilled mechanical engineer and machinist. Prior to founding PT he worked for three years as design engineer for a company that designed and built transmissions for military tanks and trucks. It was a natural transition for Dan to start a company designing and building power trains for farm tractor companies. Today, Dan is no longer active in the management of PT but is still revered as its founder. He and his family still own 25 percent of the company, which went public in 1998. PT has been growing at a 6 percent clip for the last five years but expects industry growth to level off as supply exceeds demand.Today, PT continues its proud tradition of designing and building the best-quality power trains for manufacturers of farm tractors and equipment. The company employs 178 design engineers and has about 1,800 production and support staff. Contract design projects for tractor manufacturers represent a major portion of PT’s revenue. At any given time, about 45 to 60 design projects are going on concurrently. A small portion of their design work is for military vehicles. PT only accepts military contracts that involve very advanced, new technology and are cost plus.A new phenomenon has attracted management of PT to look into a larger market. Last year a large Swedish truck manufacturer approached PT to consider designing power trains for its trucks. As the industry consolidates, the opportunities for PT should increase because these large firms are moving to more outsourcing to cut infrastructure costs and stay very flexible. Only last week a PT design engineer spoke to a German truck manufacturing manager at a conference. The German manager was already exploring outsourcing of drive trains to Porsche and was very pleased to be reminded of PT’s expertise in the area. A meeting is set up for next month.CLAUDE JONESClaude Jones joined PT in 1999 as a new MBA from the University of Edinburgh. He worked as a mechanical engineer for U.K. Hydraulics for five years prior to returning to school for the MBA. “I just wanted to be part of the management team and where the action is.” Jones moved quickly through the ranks. Today he is the vice president of design and operations. Sitting at his desk, Jones is pondering the conflicts and confusion that seem to be increasing in scheduling people to projects. He gets a real rush at the thought of designing power trains for large trucks; however, given their current project scheduling problems, a large increase in business would only compound their problems. Somehow these conflicts in scheduling have to be resolved before any serious thought can be given to expanding into design of power transmissions for truck manufacturers.Jones is thinking of the problems PT had in the last year. The MF project is the first to come to mind. The project was not terribly complex and did not require their best design engineers. Unfortunately, the scheduling software assigned one of the most creative and expensive engineers to the MF project. A similar situation, but reversed, happened on the Deer project. This project involved a big customer and new hydrostatic technology for small tractors. In this project the scheduling software assigned engineers who were not familiar with small tractor transmissions. Somehow, thinks Jones, the right people need to be scheduled to the right projects. Upon reflection, this problem with scheduling has been increasing since PT went to multiproject scheduling. Maybe a project office is needed to keep on top of these problems.A meeting with the information technology team and software vendors was positive but not very helpful because these people are not really into detailed scheduling problems. The vendors provided all sorts of evidence suggesting the heuristics used—least slack, shortest duration, and identification number—are absolutely efficient in scheduling people and minimizing project delays. One project software vendor, Lauren, kept saying their software would allow PT to customize the scheduling of projects and people to almost any variation selected. Lauren repeated over and over, “If the standard heuristics do not meet your requirements, create your own heuristics that do.” Lauren even volunteered to assist in setting up the system. But she is not willing to spend time on the problem until PT can describe to her exactly what criteria will be used (and their sequence) to select and schedule people to projects.(No word count)Question: How would you create a system to manage the resource constraints? Your answer must be supported with the facts of the case

Complete the information-level design for a database that satisfies the following constraints and user view requirements.

The purpose of this assignment is to develop data models and map Database System into a standard development environment to gain understanding of data model development. Then implement the data model using a commercially available database management system development tool.On completion of this assignment students will be able to:a. Understand the fundamental principles of the networking and data requirements of a network.b. Identify organisational information requirements.c. Model organisational information requirements using conceptual data modelling techniques.d. Convert the conceptual data models into relational data models and verify their structural characteristics with normalisation techniques.e. Implement and utilise a relational database using a database system.Questions:1. Complete the information-level design for a database that satisfies the following constraints and user view requirements. In order to complete this information–level design you are required to answer the questions given below 1(a) – (e).Mindful Body Fitness Company is planning to design a data model to hold information relating to their programs, coaches, exercise logs and their customers. As a database designer for Mindful Body Fitness, you need to ensure that each Exercise Log has a unique ID number, Date, Exercise category, Exercise sub category, Time spent, calories burnt.Each customer has a unique Cust_number and their first name, last name, address, program number, program tile and Payment must be recorded.Every program has a program number (PNum) that uniquely identifies the program. The program title, StartDate, Finish Date, Price must also be recorded.Each coach has a unique ID number. Their first name, last name, date of birth, address, contactNo, user name and password must be recorded.A coach can work on only one program. A program can have one or more coaches associated with it. One customer can enrol for only one program at one time.Write down any assumptions you make, if they are not explicitly described here.a. Identify and list entities described in all user requirements given above. (5 Marks)b. Add attributes to these entities and represent them as a collection of tables and attributes (Database schema): e.g. Customer (Customer_Num, Cust_First_Name,. . . . . . )Note: Select and underline suitable primary key for each table. (5 Marks)c. Outline 3 business rules that describe the relationships between entities. (5 Marks)Note: You can make assumptions to create certain relationships, if it is not specifically mentioned in the given business rules.e.g. A Coach can work on only one program.d. Determine the functional dependences. (5 Marks)e.g. Customer_Num ? Cust_First_Name e. Then normalise these tables. Make the normalization to 3NF. State for every step in the normalization, which functional dependency causes it.

ANALYZE EXAMPLES OF HOW LOBBYISTS AFFECT HEALTHCARE LEGISLATION.

Part I: Lobbyists have been part of the U.S. Government system since the early 1800s. Lobbyists play an important role in healthcare, as they are advocates for their interest group. In a 4-5 page paper, analyze two examples of how lobbyists affect healthcare legislation. Conclude your paper with your opinion about whether the actions of lobbyists have a positive or negative effect on healthcare legislation in the United States. Please keep in mind the position and facility you selected. Make sure to include the following:

Discuss the specific interest of the lobbyist in each example.
Discuss in detail some of the ethical issues and moral disputes for each example.
Discuss your position on whether the lobbyists’ actions are positive or negative on healthcare legislation in the United States and support your points with details.
This portion of your assignment will require you to research and examine information from various sources. Use a minimum of five credible sources for your paper, with three being an academic source from the Rasmussen College Online Library (don’t forget to include in-text citations throughout your paper with paraphrasing or quoting)
Make sure to include your APA formatted reference page.

Part II: An agenda can set the tone for a meeting. It’s an important tool to ensure meetings are staying on track and meeting all of the objectives. Create a detailed meeting agenda for a meeting you will hold with your supervisor and fellow department heads discussing your findings (Hint: Microsoft Word has many agenda templates). SkillSurfer in the online tutoring platform offers beginner, intermediate, and advanced tutorials on Microsoft Office products. Make sure to include the following in our agenda:

Explain each example
The majority of the agenda should be focused on whether the actions of lobbyists have a positive or negative effect on healthcare legislation in the United States.

Make sure to use audience specific language and tone in your agenda. Remember, your supervisor and other department heads will be in attendance. Also, make sure to follow proper agenda/business formatting guidelines and make sure document is professional in appearance.

Choose an topic of interest to you that deals with women or children

Review Healthy People 2020. Choose an topic of interest to you that deals with women or children. Research your area of interest specifically for Miami Dade County. Your assignment must be 500 words, complete with proper spelling and grammar. Be sure to answer the following issues in you writing

* identify the topic you chose

* relate this area to women or children

* give a summary of Healthy People 2020 goals for this area

* give a detailed summary of the topic in Miami Dade County

* give a summary of how the area is being addressed in Miami Dade County

Analyze the major connections between liability of professionals, insurance policy coverage, and settlement of claims due to health care liability issues.

End-of-Life Issues and Professional Liability Insurance. Please respond to the following: (ASAP)
Week 10 “End-of-Life Issues and Professional Liability Insurance” Please respond to the following: Week 9 Discussion “Procreation and Ethical Dilemmas in Health Care” Please respond to the following:
Week 10
“End-of-Life Issues and Professional Liability Insurance” Please respond to the following:
• * From the scenario, analyze the concept of patients’ rights and the concerns of physicians and nurses, as they apply to patients facing end-of-life decisions. Give your opinion on whether or not health care professionals are suitably educated in the sensitive nature of end-of-life and patient expectations. Provide a rationale for your response.
• Analyze the major connections between liability of professionals, insurance policy coverage, and settlement of claims due to health care liability issues. Consider the concept of insurance coverage denial, and ascertain the manner in which such denial is built upon the limitation clauses and conditions set forth by the insurance provider.
Week 9 Discussion
“Procreation and Ethical Dilemmas in Health Care” Please respond to the following:
• * From the scenario, examine the concept of health care ethics, and ascertain the fundamental way in which such concepts apply to procreation-related issues. Speculate on the major ramifications of using moral principles to make decisions concerning such issues.
• Consider the concept of ethics in health care predicated on ethical theories and moral theories, and explore the connection of such ethics with ethics committee decision making. Rationalize the primary concerns of conception, wrongful birth, and abortion from the perspective of health care professionals who must make these decisions.

What role or roles should community members have in a community needs assessment?

“The Future of Public Health,” the Institute of Medicine of the National Academies (1988) recognizes assessments of community health status and community health needs as a core public health function. The course textbook states that some of the goals of community health assessment are to evaluate health status, identify community health needs, identify strengths and weaknesses of a community’s health systems, recommend strategies to address community health needs, and locate existing or needed resources to meet identified needs.

Read the report and based on it, respond to the following questions in relation to the role of community members:

  • What role or roles should community members have in a community needs assessment? Justify your answer.
  • What are some strategies for engaging community members?

Public health agencies use data to identify health problems, establish and track health objectives, and assess the effectiveness of policies, programs, and services.

Respond to the following questions in relation to community needs assessment:

  • Which key factors are important to consider when gathering and presenting data for a community needs assessment?
  • When presenting data, which strategies would you recommend for creating a strong and compelling statement of need?

no pages required, just answer the question with 100% accuracy.

APA formatted references.