Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

solve ysing excel only please( show functions) 2 ABC company manufactures rolls of Metal sheets. The company has been using a Plasma CNC machine for

solve ysing excel only please( show functions) image text in transcribed
image text in transcribed
2 ABC company manufactures rolls of Metal sheets. The company has been using a Plasma CNC machine for the last 10 years. The company bought this machine for $940,000 ten years ago. Right now the company is considering buying a new laser cutting machine for $990,000. The costs associated with using each one the machines are presented i the tables. What is your recommendation? Should the company buy the new laser cutting machine, or keep using the existing plasma cutting machine? Why? Assume taht the MAAR is 10%, and the project life is 10 years. Also, assume that the plasma machine can work for 10 more years and, you can sell it for $30,000 today while it would have no resale value in 10 years from now. 4 Your recommendation? Why? 9 10 Plasma Machine Laser Machine Item Production Labor Cost Rate Item Rate Production Labor Cost$25.00 per hour with Benefits Set-up time and Clean up 30 minutes before the first shift starts on $25.00 per hour with Benefits Set-up time and Clean up 2 hours before the first shift starts on each time per day Cutting time Salvage value in year 10 Screp cost Currently, they work day-1 person time per day Cutting time Salvage value in year 10 Scrap cost each day-1 person 20 minutes-1 Person $32,000 20 minutes-2 Person $120 per hour one 8 hour shift -5 days per week, 52 weeks per year $105 per hour Currently, they work: one 8 hour shift -5 days per week, 52 weeks per year

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

Principles Of Auditing

Authors: O. Ray Whittington, Kurt Pany, Walter B. Meigs

12th Edition

0256167796, 978-0256167795

More Books

Students also viewed these Accounting questions

Question

Explain the importance of nonverbal messages.

Answered: 1 week ago

Question

Describe the advantages of effective listening.

Answered: 1 week ago

Question

Prepare an employment application.

Answered: 1 week ago