An electronics manufacturing firm is purchasing a new piece of equipment which cost $10,000 installed. The salvage value of…

An electronics manufacturing firm is purchasing a new piece of equipment which cost $10,000 installed. The salvage value of the equipment is expected to be $2000 after five years of use. The annual operating and maintenance cost of the equipment is $2200 per year with expected annual receipts of $5000 per year. The electronics manufacturing firm uses a before tax MARR of 8% per year for projects that involve the purchase of new equipment. Your supervisor has asked you to provide a purchase of new equipment. Your supervisor has asked you to provide a sensitivity analysis by varying three parameters on the project. The MARR value, life of the equipment and the operating and maintenance cose will vary from -90% to + 90% in increments of 10%. Compute the AW by varying the three parameters as specified. Provide a spider plot of your results.                  

 

The problem must be completed usin Excel and the engineering economy functions. Show all of your work and provide and easy to read format for your Excel output.