Reference no: EM13207062
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 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 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.
Income per Unit of Asset
Year
5
10
20
Asset 1
$2 million
$0.5 million
$ 0
Asset 2
$1 million
$0.5 million
$1.5 million
Asset 3
$0.5 million
$1 million
$2 million
Minimum Cash Flow Required
$400 million
$100 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?
(e) Use the Excel Solver to solve the model by the simplex method.
|
State what is the uncertainty in the velocity of the car
: If the position of the car is known to within 5.0 feet at the time of the measurement, what is the uncertainty in the velocity of the car?
|
|
How far from city a is the point of no return
: it the speed of the plane in still air is 430 mph, how far from city a is the point of no return? round your answer to the nearest mile.
|
|
What will be the consequence of such change
: Should the U.S currency be backed by gold? Recently the dollar has been losing value and there were a few countries advocating a change from using the dollar as the "international" currency (for example petroleum on the international market is bou..
|
|
Supposing that the smallest measurable wavelength
: Assuming that the smallest measurable wavelength in an experiment is 0.410 fm (femtometers), what is the maximum mass of an object traveling
|
|
Formulate a linear programming model for the 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 pop..
|
|
Important or meaningful to the religion
: Sermon on the Mount - selection from the Gospel of Matthew is a guide for what it is to be a Christian. Discuss two points of the text that you consider to be the most important or meaningful to the religion
|
|
State the waters of hydration
: He decided to dry the alum by heating it strongly. Unfortunately he also drove off the waters of hydration. What is the mass of his remaining anhydrous salt?
|
|
Why is one slope positive and the other negative
: Explain any relationships you find between the slopes and equations of the two lines. D. Why is one slope positive and the other negative? Explain. Is this always true?
|
|
Write down the limit you are trying to show
: Prove that f is dierentiable at x = 0 and that f (0) = 0. Hint: Write down the limit you are trying to show to prove that the derivative at 0 exists.
|