![strent45](/avatars/9309.jpg)
strent45
02.06.2020 •
Mathematics
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.
Solved
Show answers
More tips
- F Food and Cooking Pu-erh Tea: History, Varieties, Benefits, and Risks...
- H Health and Medicine How to Whiten Teeth and Get the Perfect Smile...
- F Food and Cooking How to Make Thin Pancakes: Recipe and Tips...
- S Style and Beauty Is Hot Scissor Haircutting Beneficial or Dangerous?...
- S Style and Beauty How to Get Rid of Under Eye Bruises?...
- F Food and Cooking Is Bacon Good for You?...
- S Style and Beauty Discover the Art of Nail Design: How Do You Paint Your Nails?...
- P Philosophy How to Develop Extrasensory Abilities?...
- O Other Everything You Need to Know About Kudyabliks...
- C Computers and Internet The Twitter Phenomenon: What it is and How to Use it...
Answers on questions: Mathematics
- M Mathematics 60 ft/s = ? Km/h Please show me how to solve this....
- M Mathematics The chs baseball team was on the field in the batter popped the ball up the equation pt equals 80 t -16 t squared +3.5 represents the height of the bar above the ground...
- M Mathematics If u answer I will give you brainliest. A car traveled a distance of 600 km at a speed of 75 km/hr. How many hours did it take the car to travel that distance? * A 8 hrs...
- M Mathematics How do you write 5.1 x 10^5 in standard form?...
- M Mathematics 3. Fun Zone charges an entrance fee of $6.00 and $0.45 per token to play games. Crazy World charges an entrance fee of $12.00 and $0.30 per token to play games. How many...
- M Mathematics 15 points please help :)...
Ответ:
The diagonal is 39.54 in
Step-by-step explanation:
First we use the Pythagorean theorem to calculate the length of the diagonal of the base.
If the base measures 13 inches by 35 inches then the diagonal is:
Now we use the Pythagorean theorem again to find the diagonal of the cube.
If the height of the box is 13 inches and the diagonal of the base is 37.34 inches then the diagonal of the cube will be
The baton will fit in the box if it is placed in the direction of the diagonal of the cube, since:
39.54\ in > 38 inches