In: Accounting
A Company is considering discontinuing one of their two poorest profit performers, namely the Shampoo product or the Diapers product. Using the data in the Condensed Income Statement: Create Discontinue Alternatives for both products and make a recommendation as to which product would be the best to discontinue and why?
Company XYZ
Condensed Income Statement
For the Year Ended December 31 20Y9
Shampoo | Diapers | |
Sales | $2,750,000 | $6,200,000 |
Cost of Goods Sold: | ||
Variable Costs | $850,000 | $4,250,000 |
Fixed Costs | $75,000 | $100,000 |
Total cost of goods sold | $925,000 | $4,350,000 |
Gross Profit | $1,825,000 | $1,850,000 |
Operating Expenses: | ||
Variable Costs |
$1,875,000 | $1,800,000 |
Fixed Costs | $50,000 | $200,000 |
Total Operating Expenses | $1,925,000 | $2,000,000 |
Income (Loss) from operations | ($100,000) (A) | ($150,000) (B) |
Discontinue Alternatives:
Continue Shampoo |
Discontinue Shampoo |
Differential Effect on Income |
|
Sales | |||
Costs: | |||
Variable | |||
Fixed | |||
Income (Loss) | (C) | ||
Continue Diapers |
Discontinue Diapers |
Differential Effect on Income |
|
Sales |
|||
Costs: | |||
Variable | |||
Fixed | |||
Income (Loss) | (D) |
If I discontinue Shampoo:
Annual Loss from Retaining Diapers (B) | ($150,000) |
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) | ($100,000) |
Total Annual Loss |
Which product would you recommend to discontinue and why?
Answer:
Continue | Discontinue | Differential | |
Shampoo | Shampoo | Effect on Income | |
Sales | $ 2,750,000 | $ - | $ 2,750,000 |
Costs: | |||
Variable | $ 2,725,000 | $ - | $ 2,725,000 |
Fixed | $ 125,000 | $ 125,000 | $ - |
Income (Loss) | $ (100,000) | $ (125,000) | $ 25,000 |
Continue | Discontinue | Differential | |
Diapers | Diapers | Effect on Income | |
Sales | $ 6,200,000 | $ - | $ 6,200,000 |
Costs: | |||
Variable | $ 6,050,000 | $ - | $ 6,050,000 |
Fixed | $ 300,000 | $ 300,000 | $ - |
Income (Loss) | $ (150,000) | $ (300,000) | $ 150,000 |
Table 2:
If I discontinue Shampoo: | |
Annual Loss from Retaining Diapers (B) | $(150,000) |
Annual Loss from Discontinuing Shampoo (C) | $ (25,000) |
Total Annual Loss | $(175,000) |
If I discontinue Diapers: | |
Annual Loss from Discontinuing Diapers (D) | $(150,000) |
Annual Loss from Retaining Shampoo (A) | $(100,000) |
Total Annual Loss | $(250,000) |
Conclusion:
Shampoo should be discontinued because the total loss in discontinuing shampoo is lower.
In case of any doubt, please feel free to comment.