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 | $658,000 | $887,000 | $262,000 | |||||
| Cost of goods sold | (262,000) | (320,000) | (148,000) | |||||
| Gross profit | $396,000 | $567,000 | $114,000 | |||||
| Selling and administrative expenses | (291,000) | (347,000) | (145,000) | |||||
| Operating income (loss) | $105,000 | $220,000 | $(31,000) | |||||
Fixed costs are 43% of the cost of goods sold and 17% 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?
| Porcelain Tableware Company | ||||
| Product Income | ||||
| Differential analysis Report | ||||
| Bowls | Plates | Cups | ||
| Differential revenue from monthly sales | ||||
| Revenues from sales | $ 6,58,000 | $ 8,87,000 | $ 2,62,000 | |
| Differential cost from monthly sales | ||||
| Variable cost of goods sold | $ 1,49,340 | $ 1,82,400 | $ 84,360 | |
| Variable selling and administrative cost | $ 2,41,530 | $ 2,88,010 | $ 1,20,350 | |
| Total variable costs | $ 3,90,870 | $ 4,70,410 | $ 2,04,710 | |
| Monthly differential Income from sales | $ 2,67,130 | $ 4,16,590 | $ 57,290 | |
| Bowls | Plates | Cups | ||
| (i) | Total cost of goods sold | $ 2,62,000 | $ 3,20,000 | $ 1,48,000 |
| (ii) = (i) X 43% | Fixed cost of goods sold | $ 1,12,660 | $ 1,37,600 | $ 63,640 |
| (i) - (ii) | Variable cost of goods sold | $ 1,49,340 | $ 1,82,400 | $ 84,360 |
| Bowls | Plates | Cups | ||
| (i) | Total selling and administrative cost | $ 2,91,000 | $ 3,47,000 | $ 1,45,000 |
| (ii) = (i) X 17% | Fixed selling and administrative cost | $ 49,470 | $ 58,990 | $ 24,650 |
| (i) - (ii) | Variable selling and administrative cost | $ 2,41,530 | $ 2,88,010 | $ 1,20,350 |
Differential Analysis Report for a Discontinued Product The condensed product-line income statement for Porcelain Tableware Company...
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 $649,000 $895,000 $276,000 Cost of goods sold (256,000) (335,000) (148,000) Gross profit $393,000 $560,000 $128,000 Selling and administrative expenses (291,000) (349,000) (151,000) Operating income (loss) $102,000 $211,000 $(23,000) Fixed costs are 35% of the cost of goods sold and 17% of the selling and administrative expenses. Porcelain Tableware assumes that fixed...
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 $648,000 $904,000 $269,000 Cost of goods sold (253,000) (336,000) (154,000) Gross profit $395,000 $568,000 $115,000 Selling and administrative expenses (300,000) (356,000) (146,000) Operating income (loss) $95,000 $212,000 $(31,000) Fixed costs are 41% of the cost of goods sold and 16% of the selling and administrative expenses. Porcelain Tableware assumes that fixed...
The condensed product-line income statement for Porcelain Tableware Company for the month of May is as follows: Porcelain Tableware Company Product-Line Income Statement For the Month Ended May 31 Bowls Plates Cups Sales $65,400 $89,800 $26,300 Cost of goods sold 27,000 33,600 13,900 Gross profit $38,400 $56,200 $12,400 Selling and administrative expenses 28,700 35,000 16,300 Income from operations $9,700 $21,200 $(3,900) Fixed costs are 12% of the cost of goods sold and 37% of the selling and administrative expenses. Porcelain...
Differential Analysis Report for a Discontinued Product The condensed product-line income statement for Dinner Ware Company is as follows: DINNER WARE COMPANY Product-Line Income Statement Bowls Plates Cups Sales $1,500,000 $2,350,000 $975,000 (900,000) Cost of goods sold Gross profit (1,400,000) $950,000 (700,000) $250,000 $600,000 (270,000) $330,000 (780,000) $195,000 (300,000) $(105,000) Selling and administrative expenses Operating income (loss) Fixed costs are 40% of the cost of goods sold and 18% of the selling and administrative expenses. Dinner Ware assumes that fixed...
1- Differential Analysis for a Discontinued Product The condensed product-line income statement for Porcelain Tableware Company for the month of May is as follows: Porcelain Tableware Company Product-Line Income Statement For the Month Ended May 31 Bowls Plates Cups Sales $65,100 $89,400 $27,700 Cost of goods sold 27,000 33,000 14,600 Gross profit $38,100 $56,400 $13,100 Selling and administrative expenses 30,400 34,200 14,600 Income from operations $7,700 $22,200 $(1,500) Fixed costs are 17% of the cost of goods sold and 38%...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Dish N’ Dat Company for the month of March is as follows: Dish N’ Dat Company Product-Line Income Statement For the Month Ended March 31 Bowls Plates Cups Sales $64,700 $88,700 $27,900 Cost of goods sold 26,000 32,900 15,000 Gross profit $38,700 $55,800 $12,900 Selling and administrative expenses 28,800 34,400 14,800 Income from operations $9,900 $21,400 $(1,900) Fixed costs are 13% of the cost of goods sold and...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Dish N' Dat Company for the month of March is as follows: Dish N' Dat Company Product-Line Income Statement For the Month Ended March 31 Bowls Plates Cups Sales $66,000 $27,600 $88,600 32,700 Cost of goods sold 26,300 15,600 $39,700 $12,000 Gross profit Selling and administrative expenses $55,900 35,100 28,900 14,400 Income from operations $10,800 $20,800 $(2,400) Fixed costs are 13% of the cost of goods sold and...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Dish N’ Dat Company for the month of March is as follows: Dish N’ Dat Company Product-Line Income Statement For the Month Ended March 31 Bowls Plates Cups Sales $65,500 $88,700 $26,000 Cost of goods sold 25,600 32,800 15,400 Gross profit $39,900 $55,900 $10,600 Selling and administrative expenses 29,400 34,300 15,900 Income from operations $10,500 $21,600 $(5,300) Fixed costs are 15% of the cost of goods sold and...
EX 25-4 The condensed product-line of May is as follows: Differential analysis for a discontinued product income statement for Disi h N' Dat Company for the month 0BI.1 tive 1 Dish N' Dat Company Product-Line Income Statement For the Month Ended May 31 Bowls Plates $71,000 $105,700 $33,500 32,600 42.300 20,500 $38,400 63,400 $12,900 27400 42800 17,200 $11,000 $ 20,600 $(4,300) Cups Sales Cost of goods sold Gross profit Selling and administrative expenses Income from operations Fixed costs are 15%...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Rhinebeck Company for the month of October is as follows: Rhinebeck Company Product-Line Income Statement For the Month Ended October 31 Hats Gloves Mufflers Sales $71,000 $105,700 $45,000 Cost of goods sold (32,600) (42,300) (27,000) $38,400 $18,000 Gross profit Selling and administrative expenses $63,400 (42,800) $20,600 (27,400) $11,000 (25,000) Operating income (loss) $(7,000) Fixed costs are 20% of the cost of goods sold and 30% of the selling...