Using MS excel solver solve the below Larry Edison is the director of the Computer Center at Buckley College. He now needs to

schedule the staffing of the center. The center is open from $8$:$00$ a$.$m$.$ until midnight. Based

on previous usage of the center, Larry has determined that the following number of

computer consultants are required to monitor the center at various times of the day:

Time of Day Minimum Number of Consultants

Required to be on Duty

$8$:$00$ a$.$m$.-$ Noon $4$

Noon $4$:$00$ p$.$m$.8$

$4$:$00$ p$.$m$.8$:$00$ p$.$m$.10$

$8$:$00$ p$.$m$.-$ Midnight $6$

Two types of computer consultants can be hired: full$-$time and part$-$time. Full$-$time

consultants work for $8$ consecutive hours in any of the following shifts: morning $(8$:$00$ a$.$m$.$

$4$:$00$ p$.$m$.),$ afternoon $($Noon $8$:$00$ p$.$m$.),$ or evening $(4$:$00$ p$.$m$.$ Midnight$),$ and are

paid $$14/$hour$.$ Part$-$time consultants can be hires to work in any of the four$-$hour shifts

listed in the above table, and they are paid $$12/$hour$.$ An additional requirement is that

there must be at least $2$ full$-$time consultants on duty for every part$-$time consultant on

duty. Determine the number of full$-$time and part$-$time consultants that must work each

shift to meet the above demand at a minimum cost