Beacon Company is considering automating its production facility. The initial investment in automation would be $10.97 million, and the equipment has a useful life of 9 years with a residual value of $1,160,000. The company will use straight-line depreciation. Beacon could expect a production increase of 43,000 units per year and a reduction of 20 percent in the labor cost per unit.

	Current (no automation)			Proposed (automation)
Production and sales volume	80,000 units			123,000 units
	Per Unit		Total	Per Unit		Total
Sales revenue	$	100	?	$	100	?
Variable costs
Direct materials	$	19		$	19
Direct labor		15			?
Variable manufacturing overhead		12			12
Total variable manufacturing costs		46			?
Contribution margin	$	54	?	$	57	?
Fixed manufacturing costs			$ 1,170,000			$ 2,250,000
Net operating income			?			?

1-a. Complete the following table showing the totals. (Enter all answers in whole dollars.)

1-b. Does Beacon Company favor automation?

2. Determine the project's accounting rate of return. (Round your answer to 2 decimal places.)

3. Determine the project's payback period. (Round your answer to 2 decimal places.)

4. Using a discount rate of 13 percent, calculate the net present value (NPV) of the proposed investment. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) (Use appropriate factor(s) from the tables provided. Negative amount should be indicated by a minus sign. Enter the answer in whole dollar. Round the final answer to nearest whole dollars.)

5. Recalculate the NPV using a 8% discount rate. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) (Use appropriate factor(s) from the tables provided. Negative amount should be indicated by a minus sign. Enter the answer in whole dollar. Round the final answer to nearest whole dollars.)

1-a. Complete the following table showing the totals. (Enter all answers in whole dollars.) Current (no automation) Proposed (automation) $80,000 Units Per Unit $100 $123,000 Units Per Unit $100 Production and Sales Volume Total Total Sales Revenue Variable Costs 19 19 15 12 46 54 Direct Materials Direct Labor 12 Variable Manufacturing Overhead Total Variable Manufacturing Costs Contribution Margin Fixed Manufacturing Costs Net Operating Income 57 $ 1,170,000 2,250,000