Question
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
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. 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? 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started