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 | |||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||
Fixed costs are 12% of the cost of goods sold and 37% of the selling and administrative expenses. Porcelain Tableware assumes that fixed costs would not be materially affected if the Cups line were discontinued.
a. Prepare a differential analysis dated May 31 to determine if Cups should be continued (Alternative 1) or discontinued (Alternative 2). If an amount is zero, enter "0". For those boxes in which you must enter subtracted or negative numbers use a minus sign.
| Differential Analysis | |||
| Continue Cups (Alt. 1) or Discontinue Cups (Alt. 2) | |||
| For the Month Ended May 31 |
| Continue Cups (Alternative 1) |
Discontinue Cups (Alternative 2) |
Differential Effect on Income (Alternative 2) |
|
| Revenues | $ | ||
| Costs: | |||
| Variable cost of goods sold | |||
| Variable selling and admin. expenses | |||
| Fixed costs | |||
| Income (Loss) |
b. Should the Cups line be retained?
Explain.
....................................
As indicated by the differential analysis in part (a), the income will ................................................. by $............................... if the Cups line is discontinued.
| Calculation of Fixed Cost | ||||||
| Bowls | Plates | Cups | Total | |||
| Cost of Goods Sold | 27,000.00 | 33,600.00 | 13,900.00 | 74,500.00 | ||
| Selling and administrative expenses | 28,700.00 | 35,000.00 | 16,300.00 | 80,000.00 | ||
| Fixed Cost on COGS | 3,240.00 | 4,032.00 | 1,668.00 | 8,940.00 | ||
| Fixed Cost on Selling Expense | 10,619.00 | 12,950.00 | 6,031.00 | 29,600.00 | ||
| Total Fixed Cost | 13,859.00 | 16,982.00 | 7,699.00 | 38,540.00 | ||
| Variable Cost on COGS | 23,760.00 | 29,568.00 | 12,232.00 | 65,560.00 | ||
| Variable Cost on Selling Expense | 18,081.00 | 22,050.00 | 10,269.00 | 50,400.00 | ||
| Total | 41,841.00 | 51,618.00 | 22,501.00 | 1,15,960.00 | ||
| If the Cups business is discontinued, than the Fixed cost of 7,699 will recovered from Bowls and Plates Business | ||||||
|
Continue Cups (Alternative 1) |
Discontinue Cups (Alternative 2) |
|||||
| Sales | 1,81,500.00 | 1,55,200.00 | ||||
| Less | ||||||
| Variable Cost of Goods Sold | 65,560.00 | 53,328.00 | ||||
| Variable Selling and administrative expenses | 50,400.00 | 40,131.00 | ||||
| Fixed Cost | 38,540.00 | 38,540.00 | ||||
| Income/Loss | 27,000.00 | 23,201.00 | 3,799.00 | |||
| A) | Its Better to continue the Cups business, as profit is higher | |||||
| B) | As indicated by the differential analysis in part (a), the income will decrease by $ 3,799 if the Cups line is discontinued. | |||||
The condensed product-line income statement for Porcelain Tableware Company for the month of May is as...
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 $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...
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...
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%...
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 $65,800 $88,700 $27,200 (26,100) (33,000) (13,900) Cost of goods sold Gross profit Selling and administrative expenses $39,700 $55,700 $13,300 (28,700) (35,200) (15,000) Operating income (loss) $11,000 $20,500 $(1,700) Fixed costs are 17% of the cost of goods sold and 44% of the selling and administrative expenses. Rhinebeck Company assumes...
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...