Please Help. At the bottom it also asks for total cost if you can find that as well. thanks

.

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 untl midnight. Larry has monitored the usage of the center at varlous times of the day and determined that the following number of computer consultants (qualified graduate students) are required. 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 ( 8AM to 4PM ), afternoon (noon to 8PM ), and evening ( 4PM to midnight). Full-time consultants are paid $17.50 per hour. Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are pald $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 " 0 " If no workers are assigned during that particular shift. b. Determine the total cost