Cornerstones of Cost Management (Cornerstones Series)
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN: 9781305970663
Author: Don R. Hansen, Maryanne M. Mowen
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 19, Problem 30P

Mallette Manufacturing, Inc., produces washing machines, dryers, and dishwashers. Because of increasing competition, Mallette is considering investing in an automated manufacturing system. Since competition is most keen for dishwashers, the production process for this line has been selected for initial evaluation. The automated system for the dishwasher line would replace an existing system (purchased one year ago for $6 million). Although the existing system will be fully depreciated in nine years, it is expected to last another 10 years. The automated system would also have a useful life of 10 years.

The existing system is capable of producing 100,000 dishwashers per year. Sales and production data using the existing system are provided by the Accounting Department:

Chapter 19, Problem 30P, Mallette Manufacturing, Inc., produces washing machines, dryers, and dishwashers. Because of

*All cash expenses with the exception of depreciation, which is $6 per unit. The existing equipment is being depreciated using straight-line with no salvage value considered.

The automated system will cost $34 million to purchase, plus an estimated $20 million in software and implementation. (Assume that all investment outlays occur at the beginning of the first year.) If the automated equipment is purchased, the old equipment can be sold for $3 million.

The automated system will require fewer parts for production and will produce with less waste. Because of this, the direct material cost per unit will be reduced by 25 percent. Automation will also require fewer support activities, and as a consequence, volume-related overhead will be reduced by $4 per unit and direct fixed overhead (other than depreciation) by $17 per unit. Direct labor is reduced by 60 percent. Assume, for simplicity, that the new investment will be depreciated on a pure straight-line basis for tax purposes with no salvage value. Ignore the half-life convention.

The firm’s cost of capital is 12 percent, but management chooses to use 20 percent as the required rate of return for evaluation of investments. The combined federal and state tax rate is 40 percent.

Required:

  1. 1. Compute the net present value for the old system and the automated system. Which system would the company choose?
  2. 2. Repeat the net present value analysis of Requirement 1, using 12 percent as the discount rate.
  3. 3. Upon seeing the projected sales for the old system, the marketing manager commented: “Sales of 100,000 units per year cannot be maintained in the current competitive environment for more than one year unless we buy the automated system. The automated system will allow us to compete on the basis of quality and lead time. If we keep the old system, our sales will drop by 10,000 units per year.” Repeat the net present value analysis, using this new information and a 12 percent discount rate.
  4. 4. An industrial engineer for Mallette noticed that salvage value for the automated equipment had not been included in the analysis. He estimated that the equipment could be sold for $4 million at the end of 10 years. He also estimated that the equipment of the old system would have no salvage value at the end of 10 years. Repeat the net present value analysis using this information, the information in Requirement 3, and a 12 percent discount rate.
  5. 5. Given the outcomes of the previous four requirements, comment on the importance of providing accurate inputs for assessing investments in automated manufacturing systems.

1.

Expert Solution
Check Mark
To determine

Ascertain the net present value for both the old and automated system, and state the system that the company would choose.

Explanation of Solution

Net present value method (NVP): Net present value method is the method which is used to compare the initial cash outflow of investment with the present value of its cash inflows. In the net present value, the interest rate is desired by the business based on the net income from the investment, and it is also called as the discounted cash flow method.

Ascertain the net present value for both the old and automated system, and state the system that the company would choose:

For Old system (in thousands):

YearRevenueExpensesDepreciation after taxCash flowDiscount factor @ 20%Present value
 (1) (a)(2) (b)(3) (c)(d=a+b+c)(e)(d×e)
1$18,000 ($13,440)$240 4,8000.833    3,998
2$18,000 ($13,440)$240 4,8000.694    3,331
3$18,000 ($13,440)$240 4,8000.579   2,779
4$18,000 ($13,440)$240 4,8000.482    2,314
5$18,000 ($13,440)$240 4,8000.402    1,930
6$18,000 ($13,440)$240 4,8000.335    1,608
7$18,000 ($13,440)$240 4,8000.279    1,339
8$18,000 ($13,440)$240 4,8000.233    1,118
9$18,000 ($13,440)$240 4,8000.194      931
10$18,000 ($13,440)- 4,5600.162739
      20,088
Less: Initial investment0
Net present value 20,088

Table (1)

Working note (1):

Compute the amount of revenue:

Revenue=[(Total sales×selling price)×(1Tax rate)]=$100,000×$300×(140100)=$18,000,000

Working note (2):

Compute the amount of expense:

Expenses=[(Total sales unit×Total cost)×(1Tax rate)]=[$100,000×($80+$90+$20+$34)×(140100)]=$13,440,000

Working note (3):

Compute the amount of after tax depreciation expense:

Depreciation Expenses=[Acquisition costSalvage value Estimated life×Tax rate]=[$6,000,000010×40100]=[$600,000×0.4]=$240,000

For New system (in thousands):

YearRevenueExpensesDepreciation after taxCash flowDiscount factorPresent value
 (1) (a)(4) (b)(6) (c)(d=a+b+c)(e)(d×e)
0   (50,040) (7)1.000$(50,040)
1$18,000 ($7,740)$2,160 12,4200.833    3,998
2$18,000 ($7,740)$2,160 12,4200.694    3,331
3$18,000 ($7,740)$2,160 12,4200.579   2,779
4$18,000 ($7,740)$2,160 12,4200.482    2,314
5$18,000 ($7,740)$2,160 12,4200.402    1,930
6$18,000 ($7,740)$2,160 12,4200.335    1,608
7$18,000 ($7,740)$2,160 12,4200.279    1,339
8$18,000 ($7,740)$2,160 12,4200.233    1,118
9$18,000 ($7,740)$2,16012,4200.194      931
10$18,000 ($7,740)$2,16012,4200.162739
Net present value 2,025

Table (2)

Working note (4):

Step 1: Compute the total cost:

ParticularsTotal cost
Direct materials ((100%25%)×$80)$60
Direct labor ((100%60%)×$90)$36
Volume-related overhead ($20$4)$16
Direct fixed overhead (($40$6)$17)$17
Unit cost$129

Table (3)

Step 2: Compute the amount of expense:

Expenses=[(Total sales×Total cost)×(1Tax rate)]=[$100,000×$129×(140100)]=$7,740,000

Working note (5):

Compute the loss on sale of old machinery:

Loss from saleof old machinery}=[Acquisition costDepreciation ExpensesSales value×Tax rate]=[$6,000,000($6,000,000010)3,000,000×40100]=[$6,000,000$600,0003,000,000×40100]=$960,000

Working note (6):

Compute the depreciation expense for cash outflow:

Depreciation Expenses=[Acquisition costSalvage value Estimated life×Tax rate]=[$34,000,000+20,000,000010×40100]=[$5,400,000×0.4]=$2,160,000

Working note (7):

Compute the cash outflow:

Cash outflow=[Loss on sale of old machinery(Acquisition cost of new machinerysale value)]=[$960,000 (5)($54,000,000$3,000,000)]=$(50,040,000)

Description:

The company should choose the old system because it has the higher net present value.

2.

Expert Solution
Check Mark
To determine

Ascertain the net present value for both the old and automated system under 12% discount rate, and state the system that the company would choose.

Explanation of Solution

Ascertain the net present value for both the old and automated system under 12% discount rate, and state the system that the company would choose:

For Old system (in thousands):

YearRevenueExpensesDepreciation after taxCash flowDiscount factorPresent value
 (1) (a)(2) (b)(3) (c)(d=a+b+c)(e)(d×e)
1$18,000 ($13,440)$240 4,8000.893  4,286
2$18,000 ($13,440)$240 4,8000.797   3,826
3$18,000 ($13,440)$240 4,8000.712  3,418
4$18,000 ($13,440)$240 4,8000.636  3,053
5$18,000 ($13,440)$240 4,8000.567   2,722
6$18,000 ($13,440)$240 4,8000.507   2,434
7$18,000 ($13,440)$240 4,8000.452  2,170
8$18,000 ($13,440)$240 4,8000.404   1,939
9$18,000 ($13,440)$240 4,8000.361   1,733
10$18,000 ($13,440)- 4,5600.322   1,468
      27,048
Less: Initial investment0
Net present value 27,048

Table (4)

For New system (in thousands):

YearRevenueExpensesDepreciation after taxCash flowDiscount factorPresent value
 (1) (a)(4) (b)(6) (c)(d=a+b+c)(e)(d×e)
0   (50,040) (7)1.000$(50,040)
1$18,000 ($7,740)$2,160 12,4200.893   11,091
2$18,000 ($7,740)$2,160 12,4200.797     9,899
3$18,000 ($7,740)$2,160 12,4200.712     8,843
4$18,000 ($7,740)$2,160 12,4200.636      7,899
5$18,000 ($7,740)$2,160 12,4200.567      7,042
6$18,000 ($7,740)$2,160 12,4200.507      6,297
7$18,000 ($7,740)$2,160 12,4200.452      5,614
8$18,000 ($7,740)$2,160 12,4200.404    5,018
9$18,000 ($7,740)$2,16012,4200.361     4,484
10$18,000 ($7,740)$2,16012,4200.322      3,999
Net present value20,145

Table (5)

Description:

The company should choose the old system because it has the higher net present value. However when using 12% discount rate, the automated system becomes more attractive because under 10% discount rate the NPV was $ 2,025, whereas under 12% discount rate the NPV was $ 20,145.

3.

Expert Solution
Check Mark
To determine

Ascertain the net present value for the 12% discount rate using this given information.

Explanation of Solution

Ascertain the net present value for the 12% discount rate using this given information.

YearRevenueExpensesDepreciation after taxCash flowDiscount factorPresent value
 (8) (a)(9) (b)(6) (c)(d=a+b+c)(e)(d×e)
0   $01.000$0
1$18,000 ($13,440)$240 4,8000.8934,286
2$16,200 (12,300)$240 4,1400.7973,300
3$14,400 (11,160)$240 3,4800.7122,478
4$12,600 (10,020)$240 2,8200.6361,794
5$10,800 (8,880)$240 2,1600.5671,225
6$9,000 ($7,740)$240 1,5000.507761
7$7,200 (6,600)$240 8400.452380
8$5,400 (5,460)$240 1800.40473
9$3,600 (4,320)$240 (480)0.361(173)
10$1,800 (3,180)-(1,380)0.322(444)
Net present value$13,680

Table (6)

Working Note (8):

Compute the amount of revenue:

YearSales unitsSelling price(1Tax rate)Revenue
 (a)(b)(c)(d=a×b×c)
1$100,000 $30060%$18,000
2$90,000 $30060%$16,200
3$80,000 $30060%$14,400
4$70,000 $30060%$12,600
5$60,000 $30060%$10,800
6$50,000 $30060%$9,000
7$40,000 $30060%$7,200
8$30,000 $30060%$5,400
9$20,000 $30060%$3,600
10$10,000 $30060%$1,800

Table (7)

Working Note (9):

Compute the amount of expense:

YearSales unitsTotal cost per unitPurchase cost(1Tax rate)Expense
 (a)(b)(c)(c) 
1$100,000 $190$3,400,00060%$(13,440,000)
2$90,000 $190$3,400,00060%$(12,300,000)
3$80,000 $190$3,400,00060%$(11,160,000)
4$70,000 $190$3,400,00060%$(10,020,000)
5$60,000 $190$3,400,00060%$(8,880,000)
6$50,000 $190$3,400,00060%$(7,740,000)
7$40,000 $190$3,400,00060%$(6,600,000)
8$30,000 $190$3,400,00060%$(5,460,000)
9$20,000 $190$3,400,00060%$(4,320,000)
10$10,000 $190$3,400,00060%$(3,180,000)

Table (8)

4.

Expert Solution
Check Mark
To determine

Ascertain the net present value for the given analysis; use the information in Requirement 3,

Explanation of Solution

Compute the salvage value for the new system:

Salvage value=[(Sale value×Estimated life)×1Tax rate]=[($400,000×10)×140100]=$2,400,000

Compute the net present value for the new system:

Net present value=[(NPV of new system existing)+(Salvage value×Discountfactor @12%)]=[($20,133,000)+($2,400,000×0.322)]=$20,133,000+$772,800=$20,905,800

Thereby, the salvage value of the new system would increase the after-tax cash flows by $2,400,000. On the other hand, the NPV of the new system has been increased by $772,800, whereas, the NPV analysis for the old system remains unchanged. Thus this makes the new investment more attractive.

5.

Expert Solution
Check Mark
To determine

Interpret the significance of providing accurate inputs for evaluating investments in automated manufacturing systems.

Explanation of Solution

Interpret the significance of providing accurate inputs for evaluating investments in automated manufacturing systems:

The key importance is that the usage of correct discount rate. Under requirement 2, the usage of 20% discount rate made the automated alternative system look entirely unappealing. Thus when using the correct discount rate (12%), the automated system results in a larger NPV, even though it was less than the NPV of the old system. However, the projections of future revenues for the old system were overly optimistic. On the other hand, the old system was not able to produce the same level of quality as the new system could produce. Thus, by considering the correct discount rate, the new system dominated the old. Moreover, the addition of salvage value simply increased this dominance.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Amold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by body builders. The project requires use of an existing warehouse, which the firm acquired three years ago for $1 million and which it currently rents out for $127,000. Rental rates are not expected to change going forward. In addition to using the warehouse, the project requires an upfront investment into machines and other equipment of $1.5 million. This investment can be fully depreciated straight-line over the next 10 years for tax purposes. However, Amold Inc. expects to terminate the project at the end of eight years and to sell the machines and equipment for $446,000. Finally, the project requires an initial investment into net working capital equal to 10 percent of predicted first-year sales. Subsequently, net working capital is 10 percent of the predicted sales over the following year. Sales of protein bars are expected to be $4.6 million in the first year and to stay constant…
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by body builders. The project requires use of an existing warehouse, which the firm acquired three years ago for $1 million and which it currently rents out for $116,000. Rental rates are not expected to change going forward. In addition to using the warehouse, the project requires an upfront investment into machines and other equipment of $1.3 million. This investment can be fully depreciated straight-line over the next 10 years for tax purposes. However, Arnold Inc. expects to terminate the project at the end of eight years and to sell the machines and equipment for $581,000. Finally, the project requires an initial investment into net working capital equal to 10% of predicted first-year sales. Subsequently, net working capital is 10% of the predicted sales over the following year. Sales of protein bars are expected to be $4.5 million in the first year and to stay constant for eight…
Arnold Inc. is considering a proposal to manufacture high-end protein bars used as food supplements by body builders. The project requires use of an existing warehouse, which the firm acquired three years ago for $2 million and which it currently rents out for $130,000. Rental rates are not expected to change going forward. In addition to using the warehouse, the project requires an upfront investment into machines and other equipment of $1.2 million. This investment can be fully depreciated straight-line over the next 10 years for tax purposes. However, Arnold Inc. expects to terminate the project at the end of eight years and to sell the machines and equipment for $424,000. Finally, the project requires an initial investment into net working capital equal to 10% of predicted first-year sales. Subsequently, net working capital is 10% of the predicted sales over the following year. Sales of protein bars are expected to be $4.9 million in the first year and to stay constant for eight…

Chapter 19 Solutions

Cornerstones of Cost Management (Cornerstones Series)

Knowledge Booster
Background pattern image
Accounting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Text book image
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License