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

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 want to finish. What numbers will Al require? What are the decisions that need to be made? What should the objective be?

(b) Suppose that Al were to invest $20,000 each in investment A (year 1), investment B (year 2), and investment C (year 2). Calculate by hand what the ending cash position would be after each year.

(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 for years 1 through 3, and then thoroughly test the model.

(e) Expand the model to full scale, and then solve it.

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

(b) Suppose that Al were to invest $20,000 each in investment A (year 1), investment B (year 2), and investment C (year 2). Calculate by hand what the ending cash position would be after each year.

(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 for years 1 through 3, and then thoroughly test the model.

(e) Expand the model to full scale, and then solve it.

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

In contrast to the spreadsheet model for the Wyndor Glass Co. product-mix problem shown in Fig. 21.6, the spreadsheet given next is an example of a poorly formulated spreadsheet model for this same problem. Identify each of ...Using the PERT three-estimate approach, the three estimates for one of the activities are as follows: optimistic estimate = 30 days, most likely estimate = 36 days, pessimistic estimate = 48 days. What are the resulting ...Do Prob. 10.8-1. The Tinker Construction Company is ready to begin a project that must be completed in 12 months. This project has four activities (A, B, C, D) with the project network shown next. The project manager, Sean ...The P-H Microchip Co. needs to undertake a major maintenance and renovation program to overhaul and modernize its facilities for wafer fabrication. This project involves six activities (labeled A, B, . . . , F) with the ...You and several friends are about to prepare a lasagna dinner. The tasks to be performed, their immediate predecessors, and their estimated durations are as follows: *There is none in the refrigerator. (a) Construct the ...Post your question