i need help inserting this problem on excel
7-1 SOLVED PROBLEM 1 An automobile manufacturer is considering a change obile manufacturer is considering a change in an assembly line that should save money by reducing labor and material cost. The change involves the installation of four new robots that will automatically install windshields. The cost of the four robots, including instal- lation and initial programming is $400.000 Current practice is to amortize the initial cost of TODOts over two years on a straight-line basis. The process engineer estimates that one full- time technician will be needed to monitor maintain, and reprogram the robots on an ongoing basis. This person will be paid approximately $60,000 per year. Currently, the company uses four full-time employees on this job and each makes about $52,000 per year. One of these employees is a material handler, and this person will still be needed with the new process. To complicate matters, the process engineer estimates that the robots will apply the windshield sealing material in a manner that will result in a savings of $0.25 per windshield installed. how many automobiles need to be produced over the next two years to make the new robots an attractive investment? Due to the relatively short time horizon, do not consider the time value of money Solution The cost of the current process over the next two years is just the cost of the four full-time employees. $52,000/employee x 4 employees x 2 years = $416,000 The cost of the new process over the next two years, assuming the robot is completely costed over that time, is the following: ($52,000/material handler + $60,000/technician) x 2 + $400,000/robots - $0.25 x autos Equating the two alternatives: $416,000 = $624,000 - $0.25 x autos Solving for the break-even point: -$208,000/- $0.25 = 832,000 autos This indicates that, to break even, 832,000 autos would need to be produced with the robots over the next two years