File:Spencer Spencer Enterprises is attempting to choose among a series of new investment alternatives. The potential investment alternatives, the net present value of the future stream of returns, and the capital requirements are summarized in the attached file. The available capital funds over the next three years are $7,500, $10,000 and $10,000. Solve the model to maximize the net present value in dollars. Suppose that one and only one of the warehouse projects must be completed. Modify the formulation to reflect this new situation. What is the new maximum net present value in dollars? $ Parameters Capital Requirements Alternative NPV Year 1 Year 2 Year 3 1. Limited Warehouse Expansion $4,000 $3,000 $1,000 2. Extensive Warehourse Expansion $6,000 $2,500 $3,500 3. Test Market New Product $10,500 $6,000 $4,000 4. Advertising Campaign $4,000 $2,000 $1,500 5. Basic Research $8,000 $5.000 $1,000 6. Purchase New Equipment $3.000 $1,000 $500 $4,000 $3,500 $5,000 $1,800 $4,000 $900 Year 1 Year 2 Funds Available Year 3 5 Model Alternative Select 0 0 Funds Used Year 1 SO Year 2 SO 1 2 3 4 S Year 3 SO 9 0 1 2 3 24 ES 0 NPV SO 0 0 0 File:Spencer Spencer Enterprises is attempting to choose among a series of new investment alternatives. The potential investment alternatives, the net present value of the future stream of returns, and the capital requirements are summarized in the attached file. The available capital funds over the next three years are $7,500, $10,000 and $10,000. Solve the model to maximize the net present value in dollars. Suppose that one and only one of the warehouse projects must be completed. Modify the formulation to reflect this new situation. What is the new maximum net present value in dollars? $ Parameters Capital Requirements Alternative NPV Year 1 Year 2 Year 3 1. Limited Warehouse Expansion $4,000 $3,000 $1,000 2. Extensive Warehourse Expansion $6,000 $2,500 $3,500 3. Test Market New Product $10,500 $6,000 $4,000 4. Advertising Campaign $4,000 $2,000 $1,500 5. Basic Research $8,000 $5.000 $1,000 6. Purchase New Equipment $3.000 $1,000 $500 $4,000 $3,500 $5,000 $1,800 $4,000 $900 Year 1 Year 2 Funds Available Year 3 5 Model Alternative Select 0 0 Funds Used Year 1 SO Year 2 SO 1 2 3 4 S Year 3 SO 9 0 1 2 3 24 ES 0 NPV SO 0 0 0