# Question: Refer to the scenario described in Prob 3 4 10 Chap 3

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.

(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.

**View Solution:**## Answer to relevant Questions

Refer to the scenario described in Prob. 3.4-12 (Chap.3), but ignore the instructions given there. Focus instead on using spreadsheet modeling to address Al Ferris’s problem by doing the following. (a) Visualize where you ...Refer to the activity list given in Prob. 22.2-2 as Christine Phillips does more detailed planning for next spring’s sales management training program for her company. After constructing the project network, she now is ...Label each of the following statements about the PERT three-estimate approach as true or false, and then justify your answer by referring to specific statements (with page citations) in the chapter. (a) Activity durations ...Reconsider Prob. 22.5-4 involving the Good Homes Construction Co. project to construct a large new home. Michael Dean now has generated the plan for how to crash this project. Since this plan causes all three paths through ...Follow the instructions for Prob. 22.3-6 except use the crash times given in Table 22.7 (Sec. 22.5) instead.Post your question