Requirements at the minimum possible cost

Assignment Help Operation Management

Reference no: EM131225860

Angelina Aniston is the Director of the Computer Center for the Pitt College. She now needs to schedule the staffing of the center. It is open from 8 am until midnight. Angelina has monitored the usage at the center at various times of the day and determined that the following numbers of computer consultants are required: Time of Day Minimum Number of Consultants Required to be on Duty 8 AM - Noon 6 Noon – 4 PM 8 4 PM – 8 PM 12 8 PM – Midnight 6 Two types of computer consultants can be hired: full-time and part-time. The full time consultants work for eight hours in any of the following shifts: morning (8 AM- 4 PM) afternoon (Noon – 8 PM) and evening (4 PM – Midnight). Full-time consultants are paid $14 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $12 per hour. An additional requirement is that during every time period, there must be at least two full-time consultants on duty for every part-time consultant on duty. Angelina would like to determine how many full time and part-time consultants should work each shift to meet the above requirements at the minimum possible cost. a. Formulate an LP model for this problem. b. Implement your model in a spreadsheet and solve it. c. What is the optimal solution?

Reference no: EM131225860

Questions Cloud

Which has the higher aftertax yield : Which has the higher aftertax yield? If taxes did not exist, would Treasury bonds offer a higher or lower yield than municipal bonds with the same maturity?

Principles of classroom management : If one of the longterm goals of teaching is for students to gain control over their own behavior, what are some advantages and disadvantages of using each of the four teacher authority bases to help students achieve that goal?

Freeman-brown private school case study : Refer to the "Freeman-Brown Private School Case Study" document for details pertaining to this assignment. The board of directors at FBPS has hired you as part of a consulting team to review the situation and present your findings and recommendatio..

One of the objections to granting wage increases : One of the objections to granting wage increases on a percentage basis is that the lowest-paid employees, who are having the most trouble making ends meet, get the smallest increase, while the highest-paid employees get the largest increase. Is this ..

Requirements at the minimum possible cost : Angelina Aniston is the Director of the Computer Center for the Pitt College. She now needs to schedule the staffing of the center. It is open from 8 am until midnight. Angelina would like to determine how many full time and part-time consultants sho..

Protest of the company : Call the local environmental advocacy group and get it to stage a protest of the company.

Determine final value noted when and the value of constant : Give the permanent steady state equivalent of the circuit. Determine the final value noted when and the value of constant

Achieve positive provider relations under managed care : How would you work proactively to achieve positive provider relations under managed care? Tell me about risk-sharing arrangement in a managed care contract? Why might such an arrangement be beneficial to the parties?

How european economic conditions affect us interest rates : Impact of the European Economy In 2012, - Use the loanable funds framework to explain how European economic conditions might affect U.S. interest rates.

User Account

All Pages