Larry Edison is the Director of the Computer Center for Buckly College

Subject:FinancePrice:3.87 Bought7

Share With

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 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 are required:

Time of Day	Minimum Number of Consultants Required to be on Duty
8 AM -noon	4
Noon – 4 PM	8
4 PM – 8 PM	10
8 PM - Midnight	6

            Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for eight consecutive hours in any of the following shifts: morning (8 AM – 4 PM), and evening (4 PM – Midnight). Full-time consultants are paid $14.00 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.00 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-Formulate a linear programming model for this problem on a spreadsheet. Use the Solver to solve this model.

 

b-Summarize the model in algebraic form by defining the decision variables, the objective function and all the constraints.