Structured Problem Solving, Cash Flows, NPV, Choice of Discount Rate, Advanced Manufacturing Environment

Ashley Thayn, president and owner of Orangeville Metal Works, has just returned from a trip to Europe. While there, she toured several plants that use robotic manufacturing. Seeing the efficiency and success of these companies, Ashley became convinced that robotic manufacturing is essential for Orangeville to maintain its competitive position.

Based on this conviction, Ashley requested an analysis detailing the costs and benefits of robotic manufacturing for the materials handling and merchandising equipment group. This group of products consists of such items as cooler shelving, stocking carts, and bakery racks. The products are sold directly to supermarkets.

A committee, consisting of the controller, the marketing manager, and the production manager, was given the responsibility to prepare the analysis. As a starting point, the controller provided the following information on expected revenues and expenses for the existing manual system:

		Percentage of Sales
Sales	$400,000	100%
Less: Variable cash expensesa	228,000	57
Contribution margin	$172,000	43
Less: Fixed expensesb	92,000	23
Income before income taxes	$80,000	20

^aVariable cost detail (as a percentage of sales):

Direct materials	16%
Direct labor	25
Variable overhead	8
Variable selling	8

^b$20,000 is depreciation; the rest is cash expenses.

Given the current competitive environment, the marketing manager thought that the preceding level of profitability would not likely change for the next decade.

After some investigation into various robotic equipment, the committee settled on an Aide 900 system, a robot that has the capability to weld stainless steel or aluminum. It is capable of being programmed to adjust the path, angle, and speed of the torch. The production manager was excited about the robotic system because it would eliminate the need to hire welders. This was an attractive possibility because the market for welders seemed perpetually tight. By reducing the dependence on welders, better production scheduling and fewer late deliveries would result. Moreover, the robot's production rate is four times that of a person.

It was also discovered that robotic welding is superior in quality to manual welding. As a consequence, some of the costs of poor quality could be reduced. By providing better-quality products and avoiding late deliveries, the marketing manager was convinced that the company would have such a competitive edge that it would increase sales by 50 percent for the affected product group by the end of the fourth year. The marketing manager provided the following projections for the next 10 years, the useful life of the robotic equipment:

	Year 1	Year 2	Year 3	Years 410
Sales	$400,000	$450,000	$500,000	$600,000

Currently, welding is the only variable direct labor cost. If the robot is acquired, it will need one operator, who will be paid a salary of $40,000 per year. Only one operator will be needed for the range of sales the company will experience. Because of improved quality, the robotic system will also reduce the cost of direct materials by 25 percent, the cost of variable overhead by 33.33 percent, and variable selling expenses by 10 percent. All of these reductions will take place immediately after the robotic system is in place and operating. Fixed costs will be increased by the depreciation associated with the robot. The robot will be depreciated using MACRS. (The manual system uses straight-line depreciation without a half-year convention and has a current book value of $200,000.) If the robotic system is acquired, the old system will be sold for $40,000.

The robotic system requires the following initial investment:

Purchase price	$380,000
Installation	70,000
Training	30,000
Engineering	40,000

At the end of 10 years, the robot will have a salvage value of $20,000. Assume that the company's cost of capital is 12 percent. The tax rate is 25 percent.

1. Prepare a schedule of after-tax cash flows for the manual system. Enter cash outflows as negative amounts and cash inflows as positive amounts.

Prepare a schedule of after-tax cash flows for the robotic system. When performing intermediate calculations, round percentages to two decimal places (15.456% rounds to 15.46%) and round computed amounts to the nearest dollar. Enter cash outflows as negative amounts and cash inflows as positive amounts.

2. Using the schedules of cash flows computed in Requirement 1, compute the NPV for each system. Round intermediate calculations and your final answers to the nearest dollar.