Ideally you should know how to do these problems using Excel (for work) and by hand (for the test). You may do this homework assignment by hand or use Excel. 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, $ Life, years System 1 -10,000 -600 -100 -1750 8 System 2 -17,000 -150 -300 -3000 12 i. ii. iii. 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] $ For system 1, develop a Spider plot for MARR, Annual Operating cost and New motor cost over the ranges given in part iii, above. Perform a two way sensitivity analysis in which you determine the AW for System 1 as you vary MARR over the range [0%; 12%], and Annual Operating Cost over the range [-1200; -300] $/year. Please also develop a surface where AW is the z-axis, and both MARR and Annual Operating Cost are independent variables. iv. V