Determine a schedule to meet the above requirements at the


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 8am 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 is required: Time Period of Day Minimum Number of Consultants Required to Be on Duty 8am to noon 6 Noon to 4pm 8 4pm to 8pm 8pm to midnight 12 6 The Computer Center operates with 7 different shifts: Shift Type Salary per Hour 8am to 4pm Noon to 8pm 4pm to midnight 8am to noon Noon to 4pm 4pm to 8pm 8pm to midnight Full-time Full-time Full-time Part-time Part-time Part-time Part-time $20 $20 $20 $15 $15 $15 $15 Larry would like to determine a schedule to meet the above requirements at the minimum possible cost. You should first algebraically formulate this problem into a LP model by defining the decision variables, objective function and constraints, then use SOLVER to find the optimal solution and the minimum cost.

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Determine a schedule to meet the above requirements at the
Reference No:- TGS02594074

Expected delivery within 24 Hours