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. Prepare segmented income statements. Separate direct and common fixed costs. Enter all amounts as positive numbers.
Alard Company | ||||
Segmented Income Statement | ||||
Blenders | Coffee Makers | Total | ||
$ | $ | $ | ||
$ | $ | $ | ||
$ | $ | $ | ||
$ |
2. What would the effect be on Alard’s profit if the coffee maker line is dropped? The blender line?
If the coffee maker line is dropped, profits will by $, the segment margin. If the blender line is dropped, profits will by $.
3. What would the effect be on firm profits if an additional 10,000 blenders could be produced (using existing capacity) and sold for $21.50 on a special-order basis? Existing sales would be unaffected by the special order. Enter all amounts as positive numbers.
Alard Company | ||||
Segmented Income Statement | ||||
Blenders | Coffee Makers | Total | ||
$ | $ | $ | ||
Contribution margin | $ | $ | $ | |
Segment margin | $ | $ | $ | |
$ |
1-Segment income Statement
65000 untis | 75000 untis | TOTAL | |
Details | Blenders | Coffe Makers | |
Sales | 1,560,000.00 | 2,175,000.00 | 3,735,000.00 |
Costs | |||
Fixed | 340,000.00 | ||
Variable | 1,170,000.00 | 2,025,000.00 | 3,195,000.00 |
Profit | 390,000.00 | 150,000.00 | 200,000.00 |
2.
Only blenders,Coffee maker dropped |
65000 untis | |
Details | Blenders |
Sales | 1,560,000.00 |
Costs | |
Fixed | 197,500.00 |
Variable | 1,170,000.00 |
Profit | 192,500.00 |
3.
Only Coffee,blenders dropped |
75000 untis | |
Details | Coffe Makers |
Sales | 2,175,000.00 |
Costs | |
Fixed | 156,000.00 |
Variable | 2,025,000.00 |
Profit | (6,000.00) |
4.Special order case with existng Capacity.
65000 untis+10,000 Unts | 75000 untis | TOTAL | |
Details | Blenders | Coffe Makers | |
Sales-Regular | 1,560,000.00 | 2,175,000.00 | 3,735,000.00 |
Sales-Special order | 215,000.00 | - | 215,000.00 |
Total Sales | 1,775,000.00 | 2,175,000.00 | 3,950,000.00 |
Costs | |||
Fixed | 340,000.00 | ||
Variable | 1,350,000.00 | 2,025,000.00 | 3,375,000.00 |
Profit | 425,000.00 | 150,000.00 | 235,000.00 |
Segmented Income Statements, Product-Line Analysis Alard Company produces blenders and coffee makers. During the past year,...
FunTime Company produces three lines of greeting cards: scented, musical, and regular. Segmented income statements for the past year are as follows: Scented Musical Regular Total Sales $ 10,000 $15,000 $25,000 $50,000 Less: Variable expenses 7,000 12,000 12,500 31,500 Contribution margin $ 3,000 $ 3,000 $12,500 $18,500 Less: Direct fixed expenses 4,000 5,000 3,000 12,000 Segment margin $ (1,000) $ (2,000) $ 9,500 $ 6,500 Less: Common fixed expenses 7,500 Operating income (loss) $(1,000) Kathy Bunker, president of FunTime, is...
Exercise 7-4 Basic Segmented Income Statement (L07-4) Royal Lawncare Company produces and sells two packaged products--Weedban and Greengrow. Revenue and cost information relating to the products follow: Selling price per unit Variable expenses per unit Traceable fixed expenses per year Product Weedban Greengrow $ 10.00 $ 32.00 $ 3.10 $ 13.00 $ 133,000 $ 49,000 Common fixed expenses in the company total $106,000 annually. Last year the company produced and sold 35,500 units of Weedban and 24,500 units of Greengrow....
Keep-or-Drop Decision Petoskey Company produces three products: Alanson, Boyne, and Conway. A segmented Income statement, with amounts given in thousands, follows: Alanson Boyne Conway Total Sales revenue $1,280 $185 $330 $1,795 Less: Variable expenses 1,115 45 Contribution margin $165 $140 Less direct fixed expenses: Depreciation Salaries 95 85 Segment margin $20 $40 $20 540 $(42) $18 Direct fixed expenses consist of depreciation and plant supervisory salaries. All depreciation on the equipment is dedicated to the product lines. None of the...
Keep-or-Drop Decision Petoskey Company produces three products: Alanson, Boyne, and Conway. A segmented income statement, with amounts given in thousands, follows: Alanson Boyne Conway Total Sales revenue $360 $1,825 Less: Variable expenses $1,280 1,115 $165 $185 45 $140 270 1,430 Contribution margin $395 Less direct fixed expenses: Depreciation 15 80 15 100 95 Salaries 85 280 20 $40 $(25) Segment margin $35 Direct fixed expenses consist of depreciation and plant supervisory salaries. All depreciation on the equipment is dedicated to...
Structuring a keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines: Strip Plank Parquet Total Sales revenue $400,000 $300,000 $200,000 120,000 $900,000 595,000 Less: Variable expenses 225,000 250,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses: Machine rent (5,000) (20,000) (30,000) (55,000) Supervision (15,000) (10,000) (5,000) (30,000) Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (10,000) $150,000 $ Hickory's management...
The segmented income statement for XYZ Company for the year ended December 31, 2016, follows: XYZ COMPANY Segmented Income Statement For the Year Ended December 31, 2016 Total Company Product A Product B Product C Sales $ 610,000 $ 305,000 $ 118,000 $ 187,000 Vari. expenses 273,000 146,000 53,000 74,000 Cont. margin $ 337,000 $ 159,000 $ 65,000 $ 113,000 Fixed expenses 283,000 164,000 49,000 70,000 Oper. income $ 54,000 $ (5,000 ) $ 16,000 $ 43,000 The company is...
Keep-or-Drop Decision Petoskey Company produces three products: Alanson, Boyne, and Conway. A segmented income statement, with amounts given in thousands, follows: Alanson Boyne Conway Total Sales revenue $1,825 $1,280 $185 1,11545 $360 270 Less: Variable expenses 1,430 Contribution margin $165 $140 $90 $395 Less direct fixed expenses: Depreciation 15 12 104 104 Salaries 95 85 284 Segment margin $20 $40 $(26) $34 Direct fixed expenses consist of depreciation and plant supervisory salaries. All depreciation on the equipment is dedicated to...
Keep-or-Drop Decision Petoskey Company produces three products: Alanson, Boyne, and Conway. A segmented income statement, with amounts given in thousands, follows: Alanson Boyne Conway Total Sales revenue $1,280 1,115 $185 45 $270 203 $1,735 1,363 Less: Variable expenses Contribution margin $165 $140 $372 Less direct fixed expenses: Depreciation 15 14 79 Salaries 95 85 120 300 Segment margin $20 $40 $(67) Direct fixed expenses consist of depreciation and plant supervisory salaries. All depreciation on the equipment is dedicated to the...
Keep-or-Drop Decision Petoskey Company produces three products: Alanson, Boyne, and Conway. A segmented income statement, with amounts given in thousands, follows: Alanson Boyne Conway Total Sales revenue $1,280 $185 $300 $1,765 Less: Variable expenses 1,115 45 225 1,385 Contribution margin $ 165 $140 $ 75 $ 380 Less direct fixed expenses: Depreciation 50 15 10 75 Salaries 95 85 80 260 Segment margin $ 20 $ 40 $ (15) $ 45 Direct fixed expenses consist of depreciation and plant supervisory...
Structuring a Keep-or-Drop Product Line Problem with Complementary Effects Shown below is a segmented income statement for Hickory Company's three wooden flooring product lines: Strip Plank Parquet Total Sales revenue $400,000 $200,000 $300,000 $900,000 Less: Variable expenses 225,000 120,000 250,000 595,000 Contribution margin $175,000 $ 80,000 $ 50,000 $305,000 Less direct fixed expenses: Machine rent (5,000) (20,000) (30,000) (55,000) Supervision (15,000) (10,000) (5,000) (30,000) Depreciation (35,000) (10,000) (25,000) (70,000) Segment margin $120,000 $ 40,000 $ (10,000) $150,000 Hickory's management is...