USE Excel and show formulas used in excel

DO i. and ii. and Label each problem answered i. and ii.

If done so it will result in a positive review

1. Your boss has asked you evaluate the economic viability of two competing systems that perform the same functionality, and with relevant parameters as described in the table below. Note that the New Motor represents a new motor that must be installed at the mid-point of the respective system life (i.e., year 4 for System 1 and year 6 for System 2). Please answer the following questions regarding this case. First cost, $ Annual Op. cost, $ Salvage value, $ New Motor, $ System 1 - 10,000 -600 -100 - 1750 8 System 2 -17,000 - 150 -300 -3000 12 Life, years i. ii. For a MARR of 4% which system would you recommend for implementation? Perform a one way sensitivity analysis in which you determine the respective AW for both these systems as you vary MARR in 1% increments within the range [0%; 12%]. Please also plot your results with AW $/year as a function of MARR. What is the breakeven value for MARR? Develop a Tornado Diagram for System 1 to determine the impact on AW as you vary the following parameters over the respective ranges: MARR [0%; 12%] Annual Operating cost [-1200; -300] $/year New motor cost [-3500; - 800] $