Question: Prepare a professional Excel spreadsheet using the following information: A company is considering replacing a manual production process with a machine. The manual process requires
Prepare a professional Excel spreadsheet using the following information:
A company is considering replacing a manual production process with a machine. The manual process requires three relatively unskilled workers and a supervisor. Each of the three unskilled workers makes $ a year and the supervisor earns $ The new machine can be operated with only one skilled operator who will earn $ Payroll taxes and employee benefits are an additional onethird of all wages and salaries.
The machine costs $ to buy and $ to install. It will be depreciated on a straight line basis for five years. The project life is years and the machine is expected to have a zero salvage value by the end of the project.
A service contract covers all maintenance of the proposed new machine for $ a year. The machine's output will be virtually indistinguishable from that of the manual process in both quality and quantity. There are no other operating differences between the manual and machine processes.
The company's cost of capital is The corporate tax rate is Using the IRR and NPV criteria should you accept the project?
NOTE: All calculations must be completed within Excel, using cell references.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
