Homework help (excel)
Gogold 
AET702Ch7hw1.xlsxPV
Payment2PV
A chemical engineer believes that by modifying the structure of a certain water treatment polymer, his company would earn an extra $5000 per year. At an interest rate of 10% per year, how much could the company afford to spend now to just break even over a 5 year project period? (A) $11,170 (B) 13,640 (C) $15,300 (D) $18,950
FV
Payment2FV
An industrial engineer made a modification to a chip manufacturing process that will save her company $10,000 per year. At an interest rate of 8% per year, how much will the savings amount to in 7 years? (A) $45,300 (B) $68,500 (C) $89,228 (D) $151,500
IRR
| Year | NCF |
| 0 | -20 |
| 1 | 7 |
| 2 | 7 |
| 3 | 15 |
The interest rate at which the present worth and equivalent uniform annual worth are equal to 0.
LinearProgramming
LinearProgWithButton
ProjectSelection
| Project | Init. Invest | Annual NCF | Life | PW |
| A | -25,000 | 6,000 | 4 | |
| B | -20,000 | 9,000 | 4 | |
| C | -50,000 | 15,000 | 4 | |
| Budget | 70000 | |||
ProjSelectionWithButton
| Project | Init. Invest | Annual NCF | Life | PW |
| A | -25,000 | 6,000 | 4 | |
| B | -20,000 | 9,000 | 4 | |
| C | -50,000 | 15,000 | 4 | |
| Budget | 70000 | |||
ProjectSelection2
| Project | Init. Invest | Annual NCF | Life | PW |
| A | -8,000 | 3,000 | 4 | |
| B | -15,000 | 2,930 | 9 | |
| C | -8,000 | 2,680 | 5 | |
| D | -8,000 | 2,540 | 4 | |
| E | -10,000 | 3,200 | 5 | |
| F | -12,000 | 3,400 | 6 | |
| G | -9000 | 2,930 | 5 | |
| H | -11000 | 3,400 | 5 | |
| I | -5000 | 1,500 | 5 | |
| J | -6000 | 1,900 | 5 | |
| Budget | 42000 | |||
| Constraint 1: Projects E and G cannot be selected together due to resource limitation. | ||||
| Constraint 2: Either project B or J must be selected, but not both. |
Maximize ($15)Chairs($20)Tables
subject to
Large Bricks:Chairs2Tables6
Small Bricks:2Chairs2Tables8
and
Chairs0, Tables0.
