Question: PLEASE please please formulate and solve the linear programming algebraic model in AMPL only, Thank you!! Problem 3 (Investment Planning Problem) Maureen Laird is the
PLEASE please please formulate and solve the linear programming algebraic model in AMPL only, Thank you!!
Problem 3 (Investment Planning Problem)
Maureen Laird is the chief financial officer for the Alva Electric Co., a major public utility in the midwest. The company has scheduled the construction of new hydroelectric plants 5, 10, and 20 years from now to meet the needs of the growing population in the region served by the company. To cover at least the construction costs, Maureen needs to invest some of the companys money now to meet these future cash-flow needs. Maureen may purchase only three kinds of financial assets, each of which costs $1 million per unit. Fractional units may be purchased. The assets produce income 5, 10, and 20 years from now, and that income is needed to cover at least minimum cash-flow requirements in those years. (Any excess income above the minimum requirement for each time period will be used to increase dividend payments to shareholders rather than saving it to help meet the minimum cash-flow requirement in the next time period.) The following table shows both the amount of income generated by each unit of each asset and the minimum amount of income needed for each of the future time periods when a new hydroelectric plant will be constructed.

Maureen wishes to determine the mix of investments in these assets that will cover the cash-flow requirements while minimizing the total amount invested. Formulate a linear programming algebraic model for this problem in AMPL and solve it using AMPL for the above data.
Minimum Cash Flow Required Year 5 10 20 Income per unit of asset (million $) Asset 1 Asset 2 Asset 3 2 1 0.5 0.5 0.5 1 0 1.5 2 400 100 300Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
