Use Excel.

AEW Walmart is trying to compete with their competitors by enhancing the shipment speed of their goods to their customers. To do so, the company wants to replace its fork trucks with 50 robots which work for 9 years. The new robotic system will have the following characteristics: Each robot initially costs $29,100 Every year, each robot requires $490 of annual maintenance cost. Also, maintanence costs will increase $12 per year, per robot. Batteries are rechargeable, but they will need to be replaced in Years 3 and 6 at a cost of $1,750 per robot. If the company's MARR is 15%, what is the Annual Equivalent cost of this project for the 9 year life? Annual Equivalent Cost