1. Engineering
  2. Computer Science
  3. larry edison is the director of the computer center for...

Question: larry edison is the director of the computer center for...

Question details

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 A.M. 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 NOON-4PM 4PM-8PNM 4 10 8PM MIDNIGHT Two types of computer consultants can be hired: full-time and part-time. The full-time consultants work for 8 consecutive hours in any of the following shifts: morning (8 A.M.-4 P.M.), afternoon (noon-8 P.M.), and evening (4 P.M.-midnight). Full-time consultants are paid $40 per hour Part-time consultants can be hired to work any of the four shifts listed in the above table. Part-time consultants are paid $30 per hour An additional requirement is that during every time period, there must be at least 2 full-time consultants on duty for every part- time consultant on duty. Larry would like to determine how many full-time and how many part-time workers should work each shift to meet the above requirements at the minimum possible cost. Formulate a LP for this problem and solve it using Excel solver

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution