Question

In: Accounting

Johnson & Johnson, Inc.                       Condensed Income Statement                  ...

Johnson & Johnson, Inc.                      
Condensed Income Statement                      
For the Year Ended December 3, 2019       
Baby Oil       Dial Soap       Shampoo       Diapers
Sales: $1,200,000   $3,500,000      $2,750,000    $6,200,000
Cost Of Goods Sold:   
Variable Costs $480,000      $1,200,000 $850,000       $4,250,000
Fixed Costs $50,000        $50,000       $75,000        $100,000
Total Cost of Goods Sold $530,000       $1,250,000 $925,000       $4,350,000
                      
Gross Profit $670,000    $2,250,000    $1,825,000    $1,850,000
Operating Expenses

Variable Costs $125,000        $1,800,000    $1,875,000    $1,800,000
Fixed Costs $300,000        $375,000       $50,000        $200,000
Total Operating Expenses $425,000        $2,175,000    $1,925,000    $2,000,000
                      
Income (Loss) From Op. $245,000        $75,000       ($100,000) A ($150,000)

Discontinue Alternatives:
Continue Discontinue Differential
Shampoo Shampoo Effect on Income
Sales:
Costs:
Variable
Fixed
Income (Loss) C
Continue Discontinue Differential
Diapers Diapers Effect on Income
Sales
Costs:
Variable
Fixed
Income (Loss) D


(Transfer your results from the Discontinue Alternatives to make a recommendation)  

Solution:  

If I discontinue Shampoo:  

Annual Loss from Retaining Diapers:(B)
Annual Loss from Discontinuing Shampoo:(C)
Total Annual Loss:

If I discontinue Diapers:  

Annual Loss from Discontinuing Diapers: (D)
Annual Loss from Retaining Shampoo: (A)

Total Annual Loss:

Answer: State which product would you recommend to discontinue and why?  

Solutions

Expert Solution

Differential analysis
Continue Discontinue Differential
Shampoo Shampoo effect on income
Sales 13650000 10900000 -2750000
Cost:
Variable 12380000 9655000 2725000
Fixed cost 1200000 1200000 0
Income /(Loss) 70000 45000 -25000
Differential Analysis
Continue Discontinue Differential
Diapers Diapers effect on income
Sales 13650000 7450000 -6200000
Cost:
Variable 12380000 6330000 6050000
Fixed cost 1200000 1200000 0
Income /(Loss) 70000 -80000 -150000
Solution:
If discontinue Shampoo:
Annual loss from retaining Diapers -150000
Annual loss from Discontinue shampoo -25000
Total annual loss -175000
If discontinue diapers:
Annual loss from discontinue diapers -150000
Annual loss from Retaining shampoo -100000
Total annual loss -250000
Shampoo shall discontinue

Related Solutions

The following is a portion of the condensed income statement for Rowan, Inc., a manufacturer of plastic containers:
The following is a portion of the condensed income statement for Rowan, Inc., a manufacturer of plastic containers: Required:1. Determine Rowan's inventory turnover.2. What information does this ratioprovide?  
The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows...
The condensed income statement for the Consumer Products Division of Fargo Industries Inc. is as follows (assuming no service department charges): Sales $1,008,000 Cost of goods sold 453,600 Gross profit $554,400 Administrative expenses 201,600 Income from operations $352,800 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that...
A condensed income statement for the Commercial Division of Maxell Manufacturing Inc. for the year ended...
A condensed income statement for the Commercial Division of Maxell Manufacturing Inc. for the year ended December 31, 20Y9, is as follows: 1 Sales $3,900,000.00 2 Cost of goods sold 2,505,000.00 3 Gross profit $1,395,000.00 4 Operating expenses 888,000.00 5 Income from operations $507,000.00 6 Invested assets $3,250,000.00 Assume that the Commercial Division received no charges from service departments. The president of Maxell Manufacturing has indicated that the division’s return on a $3,250,000 investment must be increased to at least...
. A condensed income statement by product line for Crown Beverage Inc. indicated the following for...
. A condensed income statement by product line for Crown Beverage Inc. indicated the following for King Cola for the past year: Sales $234,800 Cost of goods sold 110,000 Gross profit $124,800 Operating expenses 143,000 Loss from operations $(18,200) It is estimated that 15% of the cost of goods sold represents fixed factory overhead costs and that 19% of the operating expenses are fixed. Since King Cola is only one of many products, the fixed costs will not be materially...
A condensed income statement by product line for Warrick Beverage Inc. indicated the following for Mango...
A condensed income statement by product line for Warrick Beverage Inc. indicated the following for Mango Cola for the past year: Sales $235,100 Cost of goods sold (111,000) Gross profit $124,100 Operating expenses (143,000) Operating loss $(18,900) It is estimated that 14% of the cost of goods sold represents fixed factory overhead costs and that 23% of the operating expenses are fixed. Because Mango Cola is only one of many products, the fixed costs will not be materially affected if...
8. A condensed income statement by product line for Warrick Beverage Inc. indicated the following for...
8. A condensed income statement by product line for Warrick Beverage Inc. indicated the following for Mango Cola for the past year: Sales $233,700 Cost of goods sold (108,000) Gross profit $125,700 Operating expenses (145,000) Operating loss $(19,300) It is estimated that 12% of the cost of goods sold represents fixed factory overhead costs and that 23% of the operating expenses are fixed. Because Mango Cola is only one of many products, the fixed costs will not be materially affected...
A condensed income statement by product line for British Beverage Inc. indicated the following for King...
A condensed income statement by product line for British Beverage Inc. indicated the following for King Cola for the past year: Sales $233,300 Cost of goods sold 110,000 Gross profit $123,300 Operating expenses 145,000 Loss from operations $(21,700) It is estimated that 12% of the cost of goods sold represents fixed factory overhead costs and that 22% of the operating expenses are fixed. Since King Cola is only one of many products, the fixed costs will not be materially affected...
1.The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows...
1.The condensed income statement for the Consumer Products Division of Tri-State Industries Inc. is as follows (assuming no support department allocations): Sales $1,232,000 Cost of goods sold (554,400) Gross profit $677,600 Administrative expenses (431,200) Operating income $246,400 The manager of the Consumer Products Division is considering ways to increase the return on investment. a. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment of the Consumer Products Division, assuming that $3,080,000...
Best Buy Co, Inc., is a leading retailer specializing in consumer electronics. A condensed income statement...
Best Buy Co, Inc., is a leading retailer specializing in consumer electronics. A condensed income statement and balance sheet for the fiscal year ended January 28, 2017, are shown below. Best Buy Co, Inc. Balance Sheet At January 28, 2017 ($ in millions) Assets Current assets: Cash and cash equivalents $ 2,240 Short-term investments 1,681 Accounts receivable (net) 1,347 Inventory 4,864 Other current assets 384 Total current assets 10,516 Long-term assets 3,340 Total assets $ 13,856 Liabilities and Shareholders’ Equity...
Presented below are condensed data from the 2017 and 2018 Johnson Plumbing Corporation’s income statements (in...
Presented below are condensed data from the 2017 and 2018 Johnson Plumbing Corporation’s income statements (in millions): 2017 2018 Revenues $15,060 $12,260 Operational Expenses 9,660 8,120 Operating Income $5,400 $4,140 Required: Analyze Johnson Plumbing’s cost-volume-profit relationships by applying the high-low method of cost estimation to the above information and complete the following: a. Estimate the variable cost ratio. b. Estimate annual fixed costs. c. Compute the contribution margin ratio. d. Compute the annual break-even point in dollars. e. Applying these...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT