Subiect to the Constraints:

Quantity

Make Unconstrained Variables Non$-$Negative

Select a Solving

Method:

Solving Method

Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Sir

engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that ar

non$-$smooth.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 $(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 for the highlighted cells $($show work$).$