last one is 9% discount rate

The following information applies to the questions displayed below! Beacon Company is considering automating its production facility. The initial investment in automation would be $6.17 million, and the equipment has a useful life of 5 years with a residual value of $1.120,000. The company will use straight-line depreciation Beacon could expecta production increase of 40,000 units per year and a reduction of 20 percent in the labor cost per unit Production and sales volume Current (no automation 74.000 units Per Total Unit 1 Proposed (automation) 114.000 units Total Unit $ 91 Per $ 17 Sales revenue Variable costs Direct materials Direct labor Variable manufacturing overhead Total variable manufacturing costs Contribution margin Fixed manufacturing costs Net operating income $ 42 $ 1.200.000 $ 2.230.000 Required: 1-a. Complete the following table showing the totals (Enter all answers in whole dollars.) Production and Sales Volume Current (no automation) $ 74,000 Units Per Unit Total 91 Proposed (automation) $ 114,000 Units Per Unit Total $ 911 Sales Revenue Variable Costs Direct Materials Direct Labor Variable Manufacturing Overhead Total Variable Manufacturing Costs Contribution Margin Fixed Manufacturing Costs Net Operating Income $ 42 $ 1.200.000 2.230.000 1-b. Does Beacon Company favor automation? No 2. Determine the project's accounting rate of return. (Round your answer to 2 decimal places.) Accounting Rate of Retum References eBook & Resources Worksheet Learning Objective 11-05 Use the net presen analyze mutually exclusive capital investment Learning Objective: 11-01 Calculate the accounting rate of return and describe its major weaknesses PA11-2 Part 2 Leaming Objective: 11-02 Calculate the payback period and describe its major weaknesses Difficulty: 3 Hard Learning Objective: 11-03 Calculate net present value and describe why it is superior to the other capital budgeting techniques Check my work A. 200 points PA11-2 Part 3 3. Determine the project's payback period (Round your answer to 2 decimal places Payback Period years PA11-2 Part 4 4. Using a discount rate of 14 percent caleate the nel present value (NPV) of the proposed investment CEM alvo 31. Present Value of $1. Future ab Anno 51. Present Value Annvily 31) Use appropriate factors from the tables provided Negative amount should be indicated by a minus sign Enter the answer in wiscie doll Round the final answer to nearest whole dollars Net Present Value References Bock & Resources Worksheet Leaming Objective 11.01 Looming of active 11.00 Use the not present value method to Calculate the accounting rate of an y cus return and descrbeit PA 11-2 Part 4 Leaming Objective 11.02 Calculate the payback period and describe is major. weaknesses Difficulty: 3 Hard Leaming O ve Calculate not procent value and doserbe why it is superior to the 6. PA11- 2 Part 5 5. Recate the NPV conte Future of th 31 ) se appropriate factors from the tables provided Negative mount should data helw estado by i US sign whole Net Present Value