New Exercise Bank Content Qu$.06-15$

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 $($qualified graduate students$)$ are required.

$\backslash$table$[[$Time$,$Minimum$],[$Required$,],[$Noon to Noon $4$ PM$,9],[4$ PM to $8$ PM$,8],[8$PM to Midnight,$12]]$

Click here for the Excel Data File

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 to $4$ PM $),$ afternoon $($noon to $8$ PM $),$ and evening $(4$ PM to midnight$).$ Full$-$time consultants are paid $$17\mathrm{.}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.

Formulate a spreadsheet model for this problem. Then use Solver to solve the model.

a$.$ 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.

Note: Enter $"$O$"$ if no workers are assigned during that particular shift.

$\backslash$table$[[$Full Time,,Part Time$],[$E AM to $4$ PM$,$Noon to $8$ PM$,\backslash$table$[[4$ PM to$],[$Midnight$]],8$ AM to Noon,Noon to $4$ PM$,4$ PM to $8$ PM$,\backslash$table$[[8$ PM to$],[$Midnight$]]],[,,,,,,],[,,,,,,]]$