Question

In: Accounting

Question 1 SEGMENTED INCOME STATEMENTS, PRODUCT-LINE ANALYSIS (LO2) Walker Company produces blenders and coffeemakers. During the...

Question 1

SEGMENTED INCOME STATEMENTS, PRODUCT-LINE ANALYSIS (LO2)

Walker Company produces blenders and coffeemakers. During the past year, the company produced and sold 100,000 blenders and 25,000 coffeemakers. Fixed costs for Walker totalled $250,000, of which $90,000 can be avoided if the blenders are not produced and $45,000 can be avoided if the coffee makers are not produced. Revenue and variable cost information follow:

Blenders       Coffeemakers

Variable expenses per appliance $20               $43

Selling price per appliance           22              45

Required:

A )Prepare segmented income statements. Separate direct and common fixed costs.

B )What would the effect be on Walker's profit if the coffeemaker line is dropped? The blender line?

C) What would the effect be on firm profits if an additional 10,000 blenders could be produced (using existing capacity) and sold for $20.50 on a special-order basis? Existing sales would be unaffected by the special order.

Solutions

Expert Solution

Solution

Walker Company

  1. Segmented Income Statements –

Blenders

Coffeemakers

Total

Sales Revenue

$2,200,000

$1,125,000

$3,325,000

Variable expenses

$2,000,000

$1,075,000

$3,075,000

Contribution margin

$200,000

$50,000

$250,000

Direct traceable expenses

$90,000

$45,000

135,000

Segment Margin

$110,000

$5,000

$115,000

Common fixed costs

$115,000

Operating income

$0

  1. Blenders–

Sales = 100,000 x $22 = $2,200,000

Variable cost = 100,000 x $20 = $200,000

Avoidable fixed cost = direct traceable costs = $90,000

  1. Coffeemakers –

Sales = 25,000 x$45 = $1,125,000

Variable cost = 25,000 x $43 = $1,075,000

Avoidable fixed cost = direct traceable costs = $45,000

  1. Effect on profit if -

Coffeemaker line is dropped:

If coffeemaker line is dropped the segment margin of $5,000 will be lost and the overall profits of the company will decrease by $5,000.

The common fixed costs burden would be borne by Blenders resulting in a loss of $5,000 to the company.

Blenders line is dropped:

If blenders line is dropped the segment margin of $110,000 will be lost and the overall profits of the company will decrease by $110,000. The common fixed costs remain unabsorbed resulting in a loss of $110,000 to the company.

  1. Incremental revenue from sale of additional 10,000 blenders at $20.50 on a special-order basis = 10,000 x $20.50 = $205,000

Less: incremental costs – variable costs = 10,000 x $20 = $200,000

Increase in net income = $5,000


Related Solutions

Segmented Income Statements, Product-Line Analysis Alard Company produces blenders and coffee makers. During the past year,...
Segmented Income Statements, Product-Line Analysis Alard Company produces blenders and coffee makers. During the past year, the company produced and sold 65,000 blenders and 75,000 coffee makers. Fixed costs for Alard totaled $340,000, of which $184,000 can be avoided if the blenders are not produced and $142,500 can be avoided if the coffee makers are not produced. Revenue and variable cost information follows: Blenders Coffee Makers Selling price per appliance $24 $29 Variable expenses per appliance 18 27 Required: 1....
Income Statements Segmented by Territory Script, Inc., has two product lines. The September income statements of...
Income Statements Segmented by Territory Script, Inc., has two product lines. The September income statements of each product line and the company are as follows: SCRIPT, INC. Product Line and Company Income Statements For Month of September Pens Pencils Total Sales $25,000 $30,000 $55,000 Less variable expenses (10,000) (12,000) (22,000) Contribution margin 15,000 18,000 33,000 Less direct fixed expenses (10,000) (9,000) (19,000) Product margin $5,000 $9,000 $14,000 Less common fixed expenses (6,000) Net income $8,000 Pens and pencils are sold...
Income Statements Segmented by Territory Script, Inc., has two product lines. The September income statements of...
Income Statements Segmented by Territory Script, Inc., has two product lines. The September income statements of each product line and the company are as follows: SCRIPT, INC. Product Line and Company Income Statements For Month of September Pens Pencils Total Sales $25,000 $30,000 $55,000 Less variable expenses (10,000) (12,000) (22,000) Contribution margin 15,000 18,000 33,000 Less direct fixed expenses (8,000) (6,000) (14,000) Product margin $7,000 $12,000 $19,000 Less common fixed expenses (6,000) Net income $13,000 Pens and pencils are sold...
Alard Company produces blenders and coffee makers. During the past year, the company produced and sold...
Alard Company produces blenders and coffee makers. During the past year, the company produced and sold 65,000 blenders and 75,000 coffee makers. Fixed costs for Alard totaled $340,000, of which $184,000 can be avoided if the blenders are not produced and $142,500 can be avoided if the coffee makers are not produced. Revenue and variable cost information follows: Blenders Coffee Makers Selling price per appliance $24 $29 Variable expenses per appliance 18 27 Required: 1. Prepare segmented income statements. Separate...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Rhinebeck Company for the...
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 $65,700 $88,500 $27,100 Cost of goods sold (25,300) (32,000) (14,700) Gross profit $40,400 $56,500 $12,400 Selling and administrative expenses (29,200) (35,700) (16,200) Operating income (loss) $11,200 $20,800 $(3,800) Fixed costs are 14% of the cost of goods sold and 35% of the selling...
Four Finger Appliance Company manufactures small kitchen appliances. The product line consists of blenders and toaster...
Four Finger Appliance Company manufactures small kitchen appliances. The product line consists of blenders and toaster ovens. Four Finger Appliance presently uses the multiple production department factory overhead rate method. The factory overhead is as follows: 1 Assembly Department $186,000.00 2 Test and Pack Department 120,000.00 3 Total $306,000.00 The direct labor information for the production of 7,500 units of each product is as follows: Department Assembly Test and Pack Blender 750 dlh 2,250 dlh Toaster oven 2,250 750 Total...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Dish N’ Dat Company...
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,000 $90,000 $27,300 Cost of goods sold 27,300 31,900 14,100 Gross profit $37,700 $58,100 $13,200 Selling and administrative expenses 30,100 35,200 15,300 Income from operations $7,600 $22,900 $(2,100) Fixed costs are 13% of the cost of goods sold and...
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 $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...
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 $658,000 $903,000 $272,000 Cost of goods sold (271,000) (335,000) (154,000) Gross profit $387,000 $568,000 $118,000 Selling and administrative expenses (289,000) (344,000) (144,000) Operating income (loss) $98,000 $224,000 $(26,000) Fixed costs are 42% of the cost of goods sold and 16% of the selling and administrative expenses. Porcelain Tableware assumes that fixed...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Suffolk China Ware Company...
Differential Analysis for a Discontinued Product The condensed product-line income statement for Suffolk China Ware Company for the month of May is as follows: Suffolk China Ware Company Product-Line Income Statement For the Month Ended May 31 Bowls Plates Cups Sales $64,900 $89,400 $26,700 Cost of goods sold 25,700 33,400 14,300 Gross profit $39,200 $56,000 $12,400 Selling and administrative expenses 30,200 35,000 15,700 Income from operations $9,000 $21,000 $(3,300) Fixed costs are 12% of the cost of goods sold and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT