Using Excel Solver: College Expenses Revisited Revisit the college expense planning network example of this chapter. Suppose the rates on the four investments A, B, C, and D have dropped to 5, 11, 18, and 55 percent, respectively. Suppose that the estimated yearly costs of college (in thousands) have been revised to 25, 27, 30, and 33.
a. What is the minimum investment that will cover these expenses?
b. Show the network diagram corresponding to the solution in (a). That is, label each of the arcs in the solution and verify that the flows are consistent with the given information.
You must use Excel Solver