Refer to the scenario described in Prob. 3.4-10 (Chap. 3), but ignore the instructions given there. Focus instead 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 hire 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 objective cell.
(d) Build a spreadsheet model and then solve it.