A large city in the midwest needs to acquire a street$-$cleaning machine to keep its roads

looking nice year round. A used cleaning vehicle will cost $$85,000$ and have a $$20,000$

market $($salvage$)$ value at the end of its five$-$year life. A new system with advanced

features will cost $$150,000$ and have a $$40,000$ market value at the end of its five$-$year

life. The new system is expected to reduce labor hours compared with the used system.

Current street$-$cleaning activity requires the used system to operate $8$ hours per day for

$20$ days per month. Labor costs $$50$ per hour $($including fringe benefits$),$ and MARR is

$12\%$ per year.

a$.$ Find the breakeven percent reduction in labor hours for the new system. $(20$

points$)$

b$.$ If the new system is expected to be able to reduce labor hours by $17\%$ compared

with the used system, which machine should the city purchase? $(20$ points$)$

Assume the best estimate for the reduction of labor hours for the new system is $17\%$

$($compared with the used system$).$ Investigate how sensitive the decision is to changes

in the MARR, changes in the market value of the new system, and the productivity

improvement of the new system. Graph your results. Use Excel Sheet and construct

Spider Plot for $40\%$ changes $($i$.$e$.,-40\%$ up to $40\%$ with $5\%$ increment$)$ on

aforementioned parameters.

PLEASE HAVE THE PLOT DONE BY $11$pm CT$.$ THANKS