Question: 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)  solve ysing excel only please( show functions) 2 ABC company manufactures
rolls of Metal sheets. The company has been using a Plasma CNC

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!