Target Corporation believed it could increase the company's profits by closing its stores in Canada. Other companies have also tried to improve their financial performance by downsizing. In November 2017, General Electric announced it would begin a downsizing operation that would result in their exiting businesses that were using over $20 billion in assets in the next one to two years. In January 2018, Newell Brands, the company whose products include Tupperware, Sharpie pens, Elmer's Glue, and Rawlings sports products, announced it would be reducing its product offerings to the extent that it would close half of its facilities and reduce its revenues by 20 percent. Consider the additional information presented as follows, which is hypothetical. All dollar amounts are in thousands, unit amounts are not. Assume that a manufacturer of breakfast cereals decides to eliminate one of its products called Sugar-Bits from a segment that currently produces three products. As a result, the following are expected to occur: 1. The number of units sold for the segment is expected to drop by only 43,400 because of the elimination of Sugar-Bits, since most customers are expected to purchase a Fiber-Treats or Carbo-Crunch product instead. The shift of sales from Sugar-Bits to Fiber-Treats and Carbo-Crunch is expected to be evenly split. In other words, the sales of Fiber-Treats and Carbo-Crunch will each increase by 134,000 units. 2. Rent is paid for the entire production facility, and the space used by Sugar-Bits cannot be sublet. 3. Utilities costs are expected to be reduced by $27,400. 4. All of the supervisors for Sugar-Bits were terminated. No new supervisors will be hired for Fiber-Treats or Carbo-Crunch. 5. All of the equipment being used to produce Sugar-Bits will be sold at its current market value of $36,700. 6. Facility-level costs will continue to be allocated between the product lines based on the number of units produced. Annual Costs of Operating Each Product Line Sales in units Sales in dollars Unit-level costs: Cost of production Sales commissions Shipping and handling Miscellaneous Total unit-level costs Product-level costs: Supervisors' salaries. Facility-level costs: Rent Product Line Earnings Statements (Dollar amounts are in thousands) Utilities Depreciation on equipment Allocated companywide expenses Total facility-level costs Total product cost Profit on products Fiber-Treats Carbo-Crunch 561,600 561,600 $ 561,600 $ 561,600 56,160 7,020 12,636 4,212 80,028 5,140 51,400 70,200 226,000 14,040 361,640 446,808 $ 114,792 56,160 7,020 11, 232 2,808 77,220 3,940 51,400 70, 200 226,000 14,040 361,640 442,800 $ 118,800 Sugar-Bits 311,400 $ 311,400 34,900 2,740 5,140 2,400 45,180 2,400 24,000 38,925 130,000 7,785 200,710 248,290 $ 63,110 Total 1,434,600 $ 1,434,600 147,220 16,780 29,008 9,420 202,428 11,480 126,800 179,325 582,000 35,865 923,990 1,137,898 $ 296,702

Corporate Fin Focused Approach
5th Edition
ISBN:9781285660516
Author:EHRHARDT
Publisher:EHRHARDT
Chapter3: Analysis Of Financial Statements
Section: Chapter Questions
Problem 1bM
icon
Related questions
Question

Target Corporation believed it could increase the company’s profits by closing its stores in Canada. Other companies have also tried to improve their financial performance by downsizing. In November 2017, General Electric announced it would begin a downsizing operation that would result in their exiting businesses that were using over $20 billion in assets in the next one to two years. In January 2018, Newell Brands, the company whose products include Tupperware, Sharpie pens, Elmer’s Glue, and Rawlings sports products, announced it would be reducing its product offerings to the extent that it would close half of its facilities and reduce its revenues by 20 percent.

Consider the additional information presented as follows, which is hypothetical. All dollar amounts are in thousands, unit amounts are not. Assume that a manufacturer of breakfast cereals decides to eliminate one of its products called Sugar-Bits from a segment that currently produces three products. As a result, the following are expected to occur:

  1. The number of units sold for the segment is expected to drop by only 43,400 because of the elimination of Sugar-Bits, since most customers are expected to purchase a Fiber-Treats or Carbo-Crunch product instead. The shift of sales from Sugar-Bits to Fiber-Treats and Carbo-Crunch is expected to be evenly split. In other words, the sales of Fiber-Treats and Carbo-Crunch will each increase by 134,000 units.

  2. Rent is paid for the entire production facility, and the space used by Sugar-Bits cannot be sublet.

  3. Utilities costs are expected to be reduced by $27,400.

  4. All of the supervisors for Sugar-Bits were terminated. No new supervisors will be hired for Fiber-Treats or Carbo-Crunch.

  5. All of the equipment being used to produce Sugar-Bits will be sold at its current market value of $36,700.

  6. Facility-level costs will continue to be allocated between the product lines based on the number of units produced.

I am unable to get the total facility-level costs to add up properly. I'm not sure why as there are no other line items that should be required. Because this isn't adding up, the rest will be wrong as well.

Target Corporation believed it could increase the company's profits by closing its stores in Canada. Other companies have also tried to
improve their financial performance by downsizing. In November 2017, General Electric announced it would begin a downsizing
operation that would result in their exiting businesses that were using over $20 billion in assets in the next one to two years. In
January 2018, Newell Brands, the company whose products include Tupperware, Sharpie pens, Elmer's Glue, and Rawlings sports
products, announced it would be reducing its product offerings to the extent that it would close half of its facilities and reduce its
revenues by 20 percent.
Consider the additional information presented as follows, which is hypothetical. All dollar amounts are in thousands, unit amounts are
not. Assume that a manufacturer of breakfast cereals decides to eliminate one of its products called Sugar-Bits from a segment that
currently produces three products. As a result, the following are expected to occur:
1. The number of units sold for the segment is expected to drop by only 43,400 because of the elimination of Sugar-Bits, since
most customers are expected to purchase a Fiber-Treats or Carbo-Crunch product instead. The shift of sales from Sugar-Bits to
Fiber-Treats and Carbo-Crunch is expected to be evenly split. In other words, the sales of Fiber-Treats and Carbo-Crunch will
each increase by 134,000 units.
2. Rent is paid for the entire production facility, and the space used by Sugar-Bits cannot be sublet.
3. Utilities costs are expected to be reduced by $27,400.
4. All of the supervisors for Sugar-Bits were terminated. No new supervisors will be hired for Fiber-Treats or Carbo-Crunch.
5. All of the equipment being used to produce Sugar-Bits will be sold at its current market value of $36,700.
6. Facility-level costs will continue to be allocated between the product lines based on the number of units produced.
Annual Costs of Operating Each Product
Line
Sales in units
Sales in dollars
Unit-level costs:
Cost of production
Sales commissions
Shipping and handling
Miscellaneous
Product Line Earnings Statements
(Dollar amounts are in thousands)
Total unit-level costs
Product-level costs:
Supervisors' salaries.
Facility-level costs:
Rent
Utilities
Depreciation on equipment
Allocated companywide expenses
Total facility-level costs
Total product cost
Profit on products
Fiber-Treats Carbo-Crunch
561,600
561,600
$ 561,600
$ 561,600
56,160
7,020
12,636
4,212
80,028
5,140
51,400
70,200
226,000
14,040
361,640
446,808
$ 114,792
56,160
7,020
11, 232
2,808
77,220
3,940
51,400
70, 200
226,000
14,040
361,640
442,800
$ 118,800
Sugar-Bits
311,400
$ 311,400
34,900
2,740
5,140
2,400
45,180
2,400
24,000
38,925
130,000
7,785
200, 710
248,290
$ 63,110
Total
1,434,600
$ 1,434,600
147,220
16,780
29,008
9,420
202,428
11,480
126,800
179,325
582,000
35,865
923,990
1,137,898
$ 296,702
Transcribed Image Text:Target Corporation believed it could increase the company's profits by closing its stores in Canada. Other companies have also tried to improve their financial performance by downsizing. In November 2017, General Electric announced it would begin a downsizing operation that would result in their exiting businesses that were using over $20 billion in assets in the next one to two years. In January 2018, Newell Brands, the company whose products include Tupperware, Sharpie pens, Elmer's Glue, and Rawlings sports products, announced it would be reducing its product offerings to the extent that it would close half of its facilities and reduce its revenues by 20 percent. Consider the additional information presented as follows, which is hypothetical. All dollar amounts are in thousands, unit amounts are not. Assume that a manufacturer of breakfast cereals decides to eliminate one of its products called Sugar-Bits from a segment that currently produces three products. As a result, the following are expected to occur: 1. The number of units sold for the segment is expected to drop by only 43,400 because of the elimination of Sugar-Bits, since most customers are expected to purchase a Fiber-Treats or Carbo-Crunch product instead. The shift of sales from Sugar-Bits to Fiber-Treats and Carbo-Crunch is expected to be evenly split. In other words, the sales of Fiber-Treats and Carbo-Crunch will each increase by 134,000 units. 2. Rent is paid for the entire production facility, and the space used by Sugar-Bits cannot be sublet. 3. Utilities costs are expected to be reduced by $27,400. 4. All of the supervisors for Sugar-Bits were terminated. No new supervisors will be hired for Fiber-Treats or Carbo-Crunch. 5. All of the equipment being used to produce Sugar-Bits will be sold at its current market value of $36,700. 6. Facility-level costs will continue to be allocated between the product lines based on the number of units produced. Annual Costs of Operating Each Product Line Sales in units Sales in dollars Unit-level costs: Cost of production Sales commissions Shipping and handling Miscellaneous Product Line Earnings Statements (Dollar amounts are in thousands) Total unit-level costs Product-level costs: Supervisors' salaries. Facility-level costs: Rent Utilities Depreciation on equipment Allocated companywide expenses Total facility-level costs Total product cost Profit on products Fiber-Treats Carbo-Crunch 561,600 561,600 $ 561,600 $ 561,600 56,160 7,020 12,636 4,212 80,028 5,140 51,400 70,200 226,000 14,040 361,640 446,808 $ 114,792 56,160 7,020 11, 232 2,808 77,220 3,940 51,400 70, 200 226,000 14,040 361,640 442,800 $ 118,800 Sugar-Bits 311,400 $ 311,400 34,900 2,740 5,140 2,400 45,180 2,400 24,000 38,925 130,000 7,785 200, 710 248,290 $ 63,110 Total 1,434,600 $ 1,434,600 147,220 16,780 29,008 9,420 202,428 11,480 126,800 179,325 582,000 35,865 923,990 1,137,898 $ 296,702
Annual Costs of Operating Each Product Line
Sales in units
Sales in dollars
Unit-level costs:
Cost of production
Sales commissions
Shipping and handling
Miscellaneous
Total unit-level costs
Product-level costs:
Supervisors' salaries
Facility-level costs:
Rent
Utilities
Revised Product Line Earnings Statements
Depreciation on equipment
Allocated companywide expenses
Total facility-level costs
Answer is not complete.
Total product cost
Profit on products
Sale of Sugar-Bits equipment
Segment earnings
Fiber-
Treats
695,600
$ 695,600
69,560
8,695
15,651
5,217
99,123
5,140
63,400
75,963
226,000
17,933
383,296 X
487,559
Carbo-
Crunch
695,600
$ 695,600
69,560
8,695
13,912
3,478
95,645
3,940
63,400
75,963
226,000
17,933
383,296 X
482,881 X
Totals
1,391,200
$ 1,391,200
$
139,120
17,390
29,563
8,695
0
194,768
9,080
0
126,800
151,926
452,000
35,866
0
766,592
970,440
0
36,700
36,700
Transcribed Image Text:Annual Costs of Operating Each Product Line Sales in units Sales in dollars Unit-level costs: Cost of production Sales commissions Shipping and handling Miscellaneous Total unit-level costs Product-level costs: Supervisors' salaries Facility-level costs: Rent Utilities Revised Product Line Earnings Statements Depreciation on equipment Allocated companywide expenses Total facility-level costs Answer is not complete. Total product cost Profit on products Sale of Sugar-Bits equipment Segment earnings Fiber- Treats 695,600 $ 695,600 69,560 8,695 15,651 5,217 99,123 5,140 63,400 75,963 226,000 17,933 383,296 X 487,559 Carbo- Crunch 695,600 $ 695,600 69,560 8,695 13,912 3,478 95,645 3,940 63,400 75,963 226,000 17,933 383,296 X 482,881 X Totals 1,391,200 $ 1,391,200 $ 139,120 17,390 29,563 8,695 0 194,768 9,080 0 126,800 151,926 452,000 35,866 0 766,592 970,440 0 36,700 36,700
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

how did you get   695,600.00

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Income Statement Analysis
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
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning