Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

PLEASE SOLVE USING EXCEL

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Aviation Tax IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304131696, 978-1304131690

More Books

Students also viewed these Accounting questions