Reference no: EM133216952
Question: 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 the construction 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 $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 minimum cash flow requirements in those years, as shown in the following table.
Income Per Unit of Assets |
Year |
Asset 1 |
Asset 2 |
Asset 3 |
Minimum Cash Flow Required |
5 |
$8 Million |
$2 Million |
$2 Million |
$1.6 Billion |
10 |
$2 Million |
$4 Million |
$4 Million |
$400 Million |
20 |
0 |
$6 Million |
$8 Million |
$1.2 Billion |
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 on a spreadsheet.
b. 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?
c. 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?
What could have been done differently
: What audience needs could've been recognized? What should have been taken into consideration? What could have been done differently
|
How the selected company does its marketing activities
: How the selected company does its marketing activities like its Targeting, Segmentation and positioning (eg. Tour operations, Sale of airline tickets, domestic
|
Discuss how you could use the data
: Discuss how you could use the data found on Statista. Please use reference and list them.
|
Discuss open communication channels
: Describe how open communication channels will be critical for successfully implementing the changes you recommend in the organization.
|
Formulate a linear programming model
: BSAD 103 Spartanburg Methodist College, Formulate a linear programming model for this problem on a spreadsheet and Take a few minutes to use a trial-and-error
|
Summarize the model in algebraic form
: Spartanburg Methodist College, Formulate and solve a linear programming model for this problem on a spreadsheet. Summarize the model in algebraic form
|
Discuss class as a controlling factor in the fictionalizing
: Discuss class as a controlling factor in the fictionalizing of Gordon in Orwell's novel, Keep the Aspidistra Flying. How do the environments of Gordon's life
|
How can vw ensure that its diesel cars now comply
: How can VW ensure that its diesel cars now comply with U.S. emissions standards? What can VW do to regain consumers' confidence after this worldwide scandal?
|
Determine how to respond effectively to challenges
: HCM 5312 Capella University, Develop a minimum of three logical solutions based on credible evidence (data, insights, best practices, et cetera)
|