PLEASE SOLVE USING EXCEL

Michelin is considering going "lights-out" in the mixing area of the business that operates 24/7. Currently, personnel with a loaded cost of $590,000 per year are used to manually weigh real rubber, synthetic rubber, carbon black, oils, and other components prior to manual insertion in a Banbary mixer that provides a homogeneous blend of rubber for making tires (rubber products). New technology is available that has the reliability and consistency desired to equal or exceed the quality of blend now achieved manually. It requires an investment of $2,250,000, with $93,000 per year operational costs and will replace all the manual effort described above. The planning horizon is 8 years, and there will be a $275,000 salvage value at that time for the new technology. Marginal taxes are 25%, and the after-tax MARR is 10%. The new investment relates to the 7 -Year Property Class. Click here to access the TVM Factor Table Calculator Click here to access the MACRS-GDS table. Parta Determine the annual cost of purchasing the new technology. $ Carry all interim calculations to 5 decimal places and then round your final answer to the nearest dollar. The tolerance is 50. Attempts: 0 of 3 used Michelin is considering going "lights-out" in the mixing area of the business that operates 24/7. Currently, personnel with a loaded cost of $590,000 per year are used to manually weigh real rubber, synthetic rubber, carbon black, oils, and other components prior to manual insertion in a Banbary mixer that provides a homogeneous blend of rubber for making tires (rubber products). New technology is available that has the reliability and consistency desired to equal or exceed the quality of blend now achieved manually. It requires an investment of $2,250,000, with $93,000 per year operational costs and will replace all the manual effort described above. The planning horizon is 8 years, and there will be a $275,000 salvage value at that time for the new technology. Marginal taxes are 25%, and the after-tax MARR is 10%. The new investment relates to the 7 -Year Property Class. Click here to access the TVM Factor Table Calculator Click here to access the MACRS-GDS table. Parta Determine the annual cost of purchasing the new technology. $ Carry all interim calculations to 5 decimal places and then round your final answer to the nearest dollar. The tolerance is 50. Attempts: 0 of 3 used