Prepare a schedule of after-tax cash flows for manual system

Assignment Help Taxation
Reference no: EM13947805

Charles Bradshaw, president and owner of Wellington Metal Works, had just returned from a trip to Europe.1 While there, he had toured several plants using robotic man- ufacturing. Seeing the efficiency and success of these companies, Charles became convinced that robotic manufacturing is the wave of the future and that Wellington could gain a competitive advantage by adopting the new technology.

Based on this vision, Charles requested an analysis detailing the costs and bene- fits of robotic manufacturing for the material handling and merchandising equip- ment group. This group of products consists of such items as cooler shelving, stock- ing carts, and bakery racks. The products are sold directly to supermarkets.

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

1 This case is based, in part, on David A. Greenberg, "Robotics: One Small Company's Experience," in CostAccounting for the 90's (Montvale, NJ: National Association of Accountants, 1986): pp. 57-63.

 

    Percentage of Sales

Sales

$400,000

100%

Less: Variable expensesa

  228,000

  57

Contribution margin

$172,000

43

Less: Fixed expensesb

    92,000

  23

Income before income taxes

$ 80,000

  20

a. Variable cost detail (as a percentage of sales): Direct materials, 16%

Direct labor, 20%

Variable overhead, 9%

Variable selling, 12%

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

Given the current competitive environment, the marketing manager thought that this level of profitability would likely not 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 alu- minum. 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, which was so attractive because the mar- ket 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 man- ager 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 4-10

Sales

$400,000

$450,000

$500,000

$600,000

Currently, the company employs four welders, who work 40 hours per week and 50 weeks per year at an average wage of $10 per hour. If the robot is acquired, it will need one operator who will be paid $10 per hour.

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 34 percent.

Required

1. Prepare a schedule of after-tax cash flows for the manual and robotic systems.

2. Using the schedule of cash flows computed in Requirement 1, compute the NPV for each system. Should the company invest in the robotic system?

3. In practice, many financial officers tend to use a higher discount rate than is jus- tified by what the firm's cost of capital is. For example, a firm may use a dis- count 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. Would the robotic system be acquired if 20 percent is used? Could this conservative approach have a negative impact on a firm's ability to stay competitive?

Reference no: EM13947805

Questions Cloud

How does water change to steam : As you have learned throughout the course, engaging young students in hands-on science experiments will enhance their knowledge in a fun and interesting way. These simple experiments will prepare them for more complex science experiences in the fut..
Graph that illustrates a recent change in law : Write a 5-paragraph essay that introduces the topic you've chosen, summarizes the various points of view, and concludes with the current status of the issue you are addressing. Be sure to use at least 2 citations to support your essay.
Create an ms access database called memberledger.mdb : Create an MS Access database called MemberLedger.mdb. Add a table called Members with the following columns. (Already done, see attachment).
Determine the variation of the relative density : 1. Refer to Problem 3.19. Using Eq. (3.51), determine the variation of the relative density with depth. Use Qc 5 1.
Prepare a schedule of after-tax cash flows for manual system : Prepare a schedule of after-tax cash flows for the manual and robotic systems. Should the company invest in the robotic system?
Explain and reason how tcp congestion control will react : Explain and reason how TCP congestion control will react: for example, describe what transmission rate TCP would give each of the connections.
Estimate the average peak friction angle : Assuming the dry unit weight of sand to be 16 kN/m3, estimate the average peak friction angle, f 9, of the sand. Use Eq. (3.53).
Concern in the u.s. and defensive medicine practices : Health care costs have become a major issue of concern in the U.S. and defensive medicine practices have become a topic of increased interest among a variety of stakeholders
Explain what is internet storage. : Write down all the reasons why you would or would not use Internet storage. List at least one advantage and one disadvantage of using Internet storage.

Reviews

Write a Review

Taxation Questions & Answers

  Taxable income

Determine taxable income before considering expense.

  Prepare a tax research memo

Prepare a tax research memo to the file that addresses the issues you feel are most relevant to Mimi's various issures.

  Income by ordinary concepts

Explain what is meant by income by ordinary concepts

  Identify the tax issues

Identify the tax issues that are raised and the relevant sections of the legislation. Identify any cases and other sources of law or information that apply.

  Calculate carolines taxable income

Calculate Carolines taxable income

  Taxation – law and practice

Show the tax issues that are raised and the relevant sections of the legislation.

  Payment to the taxpayer

Brief statement in your own words of the facts of the cases.

  Prepare regular corporation tax return

Prepare the C Regular Corporation Tax Return for the Lawson And Norman Enterprise

  Taxation law

Advise the participants in the ‘barter' system of the income tax implications, if any, of participating in the system.

  A tax on cigarettes is a good way of raising tax revenue

Discuss- A tax on cigarettes is a good way of raising tax revenue for the government

  Prepare the required journal entry

Prepare the required journal entry to record the tax expense

  Calculate barbs taxable income

Calculate Barb's taxable income? What nonrefundable credit is Barb eligible for based on the information you have?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd