A mechanical engineer is considering two robots for improving materials handling in the production of rigid shaft couplings that mate dissimilar drive components. Robot X has a first cost of $84,000, an annual maintenance and operation (M&O) cost of $31,000, a $40,000 salvage value, and will improve net revenues by $96,000 per year. Robot Y has a first cost of $146,000, an annual M&O cost of $28,000, a $47,000 salvage value, and will increase net revenues by $119,000 per year. Which one should be selected on the basis of a rate of return analysis if the company’s MARR is 15% per year? Use a three-year study period.
Use Excel to create a table and solve the problem.