Fox Enterprises is considering six projects for possible construction over the next four years. Fox can undertake
Question:
Fox Enterprises is considering six projects for possible construction over the next four years. Fox can undertake any of the projects partially or completely. A partial undertaking of a project will prorate both the return and cash outlays proportionately.
The expected (present value) returns and cash outlays for the projects are given in the following table.
Cash outlay ($1000)
Project Year 1 Year 2 Year 3 Year 4 Return ($1000)
1 10.5 14.4 2.2 2.4 324.00 2 8.3 12.6 9.5 3.1 358.00 3 10.2 14.2 5.6 4.2 177.50 4 7.2 10.5 7.5 5.0 148.00 5 12.3 10.1 8.3 6.3 182.00 6 9.2 7.8 6.9 5.1 123.50 Available funds ($1000) 60.0 70.0 35.0 20.0
(a) Formulate the problem as a linear program, and determine the optimal project mix that maximizes the total return using AMPL, Solver, or TORA. Ignore the time value of money.
(b) Suppose that if a portion of project 2 is undertaken, then at least an equal portion of project 6 must be undertaken. Modify the formulation of the model, and find the new optimal solution.
(c) In the original model, suppose that any funds left at the end of a year are used in the next year. Find the new optimal solution, and determine how much each year
“borrows” from the preceding year. For simplicity, ignore the time value of money.
(d) Suppose in the original model the yearly funds available for any year can be exceeded, if necessary, by borrowing from other financial activities within the company. Ignoring the time value of money, reformulate the LP model, and find the optimum solution.
Would the new solution require borrowing in any year? If so, what is the rate of return on borrowed money?
Step by Step Answer: