$6\mathrm{.}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.

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 $(8AM-4PM),$ afternoon $($noon$-8$ PM$),$ and evening $(4$

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

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.

Questions

Develop and solve a Linear Programming model for this problem on a spreadsheet. $[15]$

Parameters, Decision Variables, Objective function should be neatly positioned and colored in the

excel model. Constraints should be appropriately specified in the excel model. $[5]$