Larry Edison is the director of the Computer Center for Buckly college. He now needs to schedule the staffing of the center. It is open from 8:00 AM until midnight. Larry has monitored the usage of the center at various times of the day and determined that the following number of computer consultants (qualified graduate students) 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 period the full-time consultants work for eight consecutive hours in any of the following shifts: mornings (8 AM - 4:00 PM), afternoon (noon - 8:00 PM), and evenings (4:00 PM to midnight). Full-time consultants are paid $17.50 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $15 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. Larry 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.Which category of linear programming problem does this problem fit? Why? b. Formulate and solve a linear programming model for this problem on a spreadsheet. c. Summarize the model in algebraic form
(Business Analytics)
I need some help on this problem, I'm not sure what to do.
Problem 2)
Larry Edison is the director of the Computer Center for Buckly college. He now needs to schedule the staffing of the center. It is open from 8:00 AM until midnight. Larry has monitored the usage of the center at various times of the day and determined that the following number of computer consultants (qualified graduate students) 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 period the full-time consultants work for eight consecutive hours in any of the following shifts: mornings (8 AM - 4:00 PM), afternoon (noon - 8:00 PM), and evenings (4:00 PM to midnight). Full-time consultants are paid $17.50 per hour.
Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $15 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.
Larry 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.Which category of linear programming problem does this problem fit? Why?
b. Formulate and solve a linear programming model for this problem on a spreadsheet.
c. Summarize the model in algebraic form.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
