In: Accounting
Differential Analysis Report for a Discontinued Product
The condensed product-line income statement for Porcelain Tableware Company is as follows:
PORCELAIN TABLEWARE COMPANY Product-Line Income Statement |
||||||||
Bowls | Plates | Cups | ||||||
Sales | $660,000 | $885,000 | $276,000 | |||||
Cost of goods sold | (261,000) | (332,000) | (153,000) | |||||
Gross profit | $399,000 | $553,000 | $123,000 | |||||
Selling and administrative expenses | (300,000) | (357,000) | (157,000) | |||||
Operating income (loss) | $99,000 | $196,000 | $(34,000) |
Fixed costs are 35% of the cost of goods sold and 16% of the selling and administrative expenses. Porcelain Tableware assumes that fixed costs would not be significantly affected if the Cups line were discontinued.
a. Prepare a differential analysis report for all three products.
PORCELAIN TABLEWARE COMPANY | |||
Product Income | |||
Differential Analysis Report | |||
Bowls | Plates | Cups | |
Differential revenue from monthly sales: | |||
$ | $ | $ | |
Differential costs of monthly sales: | |||
$ | $ | $ | |
$ | $ | $ | |
Monthly differential income from sales | $ | $ | $ |
b. Which of the following statements about the
Cups line is true?
Solution for Question-1(a) | |||
Differential revenue from monthly sales. | |||
Particular | Bowls | Plates | Cups |
Revenue from Sales | $660,000 | $885,000 | $276,000 |
Differential costs of monthly sales | |||
Variable cost of goods Sold | $169,650 | $215,800 | $99,450 |
Variable Selling and administration | $252,000 | $299,880 | $131,880 |
Total Variable Expense | $421,650 | $515,680 | $231,330 |
Monthly differential Income from Sales | $238,350 | $369,320 | $44,670 |
Working Notes-1 | |||
Particulars | Bowls | Plates | Cups |
Total COGS | $261,000 | $332,000 | $153,000 |
Fixed COGS 35% | $91,350 | $116,200 | $53,550 |
Variable COGS | $169,650 | $215,800 | $99,450 |
Working Notes-2 | |||
Particulars | Bowls | Plates | Cups |
Total Selling and administration | $300,000 | $357,000 | $157,000 |
Fixed Selling and administration @16% | $48,000 | $57,120 | $25,120 |
Variable Selling and administration | $252,000 | $299,880 | $131,880 |