subject
Mathematics, 02.06.2020 16:57 josephgperez

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 S, 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 construc- tion costs, Maureen needs to invest some of the company's money now to meet these future cash-flow needs. Maureen may purchase only three kinds of financial assets, each of which costs $I 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 require- ment 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 hydroelectrie plant will be constructed
Income per Unit of Asset
Year Asset 1 Asset 2 Asset 3 Minimum Cash Flow Required
5 S2 million $1 million $0.5 million $400 million
10 $0.5 million $0.5 million $1 million $100 million
20 0 $1.5 million $2 million $300 million
Maureen wishes to determine the mix of investments in these assets that will cover the cash-flow requirements while minimizing the total amount invested.
(a) Formulate a linear programming model for this problem.
(b) Display the model on a spreadsheet.
(c) Use the spreadsheet to check the possibility of purchasing 100 units of Asset 1, 100 units of Asset 2, and 200 units of Asset 3. How much cash flow would this mix of investments generate 5, 10, and 20 years from now? What would be the total amount invested?
(d) Take a few minutes to use a trial-and-error approach with the spreadsheet to develop your best guess for the optimal solution. What is the total amount invested for your solution?
(e) Use the Excel Solver to solve the model by the simplex method.

ansver
Answers: 3

Other questions on the subject: Mathematics

image
Mathematics, 21.06.2019 15:30, lizzyhearts
Angel entered a triathlon (a three-part race). he swam 1 mile, rode his bike 30 miles, and ran 10 miles. how far did he go altogether? a. 11 miles b. 123 miles c. 41 miles d. 40 miles
Answers: 1
image
Mathematics, 21.06.2019 17:30, wwesuplexcity28
33% of college students say they use credit cards because of the rewards program. you randomly select 10 college students and ask each to name the reason he or she uses credit cards. find the probability that the number of college students who say they use credit cards because of the rewards program is (a) exactly two, (b) more than two, and (c) between two and five inclusive. if convenient, use technology to find the probabilities.
Answers: 1
image
Mathematics, 21.06.2019 23:30, natishtaylor1p8dirz
What is the gcf of 20c^3-5c^4+30c^6
Answers: 2
image
Mathematics, 21.06.2019 23:30, quinn2999
Which graph represents the same relation is the sa which graph represents the same relation as the set {(-3-2)}
Answers: 3
You know the right answer?
Maureen Laird is the chief financial officer for the Alva Electric Co, a major public utility in the...

Questions in other subjects:

Konu
Mathematics, 01.02.2021 20:10
Konu
Mathematics, 01.02.2021 20:10