Fox Enterprises is considering six projects for possible construction over the next four years. The expected (present value) returns and cash outlays for the projects are given below. Fox can undertake any of the projects partially or completely. A partial undertak-ing of a project will prorate both the return and cash outlays proportionately.

Make a solution with excel solver.

a).Formulate the problem as a linear program, and determine the optimal project mix that maximizes the total return. 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 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 that 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?

Cash outlay ($1000) Project Year! Year 2 Year 3 Year 4 22 10.5 8.3 auAN 10.2 72 14.4 12.6 14.2 10.5 10.1 7.8 9.5 5.6 7.5 8.3 6.9 2.4 3.1 4.2 5.0 6.3 5.1 20.0 Return (51000) 32.40 35.80 17.75 14.80 18.20 12.35 12.3 5 6 Available funds ($1000) 9.2 60.0 70.0 35.0