Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

You must use the Exhibit 19B.1 and Exhibit 19B.2 present value tables and Exhibit 19.5 to solve the following problems.

Required:

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 amount

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.

3. In practice, many financial officers tend to use a higher discount rate than is justified by the firm's cost of capital. For example, a firm may use a discount rate of 20 percent when its cost of capital is or could be 12 percent. Offer some reasons for this practice. Assume that the annual after-tax cash benefit of adopting the robotic system is $80,000 per year more than the manual system. The initial outlay for the robotic system is $340,000. Compute the NPV using 12 percent and 20 percent. Round intermediate calculations and your final answers to the nearest dollar. If the NPV is negative, enter your answer as a negative value.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Futures And Options Markets

Authors: John C. Hull

7th Edition

0136103227, 9780136103226

More Books

Students also viewed these Finance questions