Question: Consider four mutually exclusive and a do nothing alternative, each having an 8-year useful life. A B C D First cost $1000 $800 $600 $500
Consider four mutually exclusive and a do nothing alternative, each having an 8-year useful life.
| A | B | C | D | |
| First cost | $1000 | $800 | $600 | $500 |
| Uniform annual benefit | 125 | 120 | 100 | 125 |
| Salvage value | 750 | 500 | 250 | 0 |
a.) Construct a choice table for interest rates from 0% to 100%.
b.) If the MARR is 8%, which alternative should be selected?
Please use Microsoft Excel to answer each part. Label each part accordingly.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
