Management math

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 8am 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 are required:

Minimum Number of
Consultants Required
Time of Day to be on Duty

8am-noon 6
Noon-4pm 8
4pm-8pm 12
8pm-midnight 6

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-8pm), and evening (4pm-midnight). Full-time
consultants are paid $14 per hour.
Part-time consultants can be hired to work any of the four shifts listed in the table. Part-time consultants are paid $12 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.

Focus on using spreadsheet modeling to address Larry Edison's problem by doing the following.

a. Visualize where you want to finish. What numbers will Larry require?
What are the decisions that need to be made?
What should the objective be?

b. Suppose that Larry were to hire three full-time workers for the morning shift, two for the afternoon shift, and four for the
evening shift, as well as three part-time workers for each of the four shifts. Calculate by hand how many workers would be working
at each time of the day and what the total cost would be for the entire day.

c. Make a rough sketch of a spreadsheet model, with blocks laid out for the data cells, changing cells, output cells, and target cell.

d. Build a spreadsheet model and then solve it.