ABC, Inc., is segmented into three divisions and the company is
concerned about the performance of Division Y. During your analysis
of Division Y, you learn that $42,000 of the fixed expenses relate
to general corporate expenses and had been allocated equally
between the three divisions.
| Total Company | Division X | Division Y | Division Z | ||||||||||||
| Sales | $ | 200,000 | $ | 80,000 | $ | 50,000 | $ | 70,000 | |||||||
| Variable expenses | 120,000 | 52,000 | 30,000 | 38,000 | |||||||||||
| Contribution margin | $ | 80,000 | $ | 28,000 | $ | 20,000 | $ | 32,000 | |||||||
| Fixed expenses | 60,000 | 20,000 | 22,000 | 18,000 | |||||||||||
| Net income (loss) | $ | 20,000 | $ | 8,000 | $ | (2,000 | ) | $ | 14,000 | ||||||
(a.) Calculate what the company's net income would be if Division Y
were closed down.
(b.) Revise the income statement presented above into a more useful
segmented income statement.
a. As General corporate expenses are allocated equally between the three divisions it shows that it is a unavoidable fixed expenses which will still be incurred by the company even if the Division Y is closed down. Consequently the fixed expenses allocated to Division Y will now be transferred to the other two divisions.
Net income of the company after closing down Division Y = Net income of Division X + Net Income of Division Z - General corporate expenses allocated to Division Y = $8,000 + $14,000 - $14,000 = $8,000.
b. Revised income statement using segmented income statement:
| Total Company | Division X | Division Y | Division Z | |
| Sales | $200,000 | $80,000 | $50,000 | $70,000 |
| Variable expenses | $120,000 | $52,000 | $30,000 | $38,000 |
| Contribution margin | $80,000 | $28,000 | $20,000 | $32,000 |
| Avoidable fixed expenses* | $18,000 | $6,000 | $8,000 | $4,000 |
| Segment Income | $62,000 | $22,000 | $12,000 | $28,000 |
| General corporate expenses | $42,000 | |||
| Net Income | $20,000 |
*Avoidable fixed expenses - They will now be decreased by $42,000 which now will not be distributed to the three Divisions but will be decreased from the total segment income.
General corporate expenses distributed to each division = $42,000 / 3 = $14,000.
Avoidable fixed expense for Division X = $20,000 - $14,000 = $6,000
Avoidable fixed expense for Division Y = $22,000 - $14,000 = $8,000
Avoidable fixed expense for Division Z = $18,000 - $14,000 = $4,000.
ABC, Inc., is segmented into three divisions and the company is concerned about the performance of...
Assume a company with two divisions (A and B) prepared the following segmented income statement: Sales Variable expenses Contribution margin Traceable fixed expenses Segment margin Common fixed expenses Net operating income A $ ? 120,000 ? 100,000 $ ? B $ 200,000 140,000 ? 80,000 $ (20,000 What is Division A's segment margin? Multiple Choice O $53,000 $13,000 $72,700 100,000 $ ? 80,000 $ (20,000 $ Traceable fixed expenses Segment margin Common fixed expenses Net operating income What is Division...
Niangua Co. is divided into three segments and is interested in preparing a segmented income statement in order to better understand the operating performance of each segment. Fixed expenses in each division currently include an allocation of general corporate expenses equal to 20% of the division's sales. Division 1 Division 2 Division 3 Sales $ 320,000 $ 200,000 $ 280,000 Variable expenses 208,000 120,000 152,000 Contribution margin $ 112,000 $ 80,000 $ 128,000 Fixed expenses 80,000 88,000 72,000 Net income...
Chao, Inc., a service provider, has two divisions. The firm’s
most recent annual contribution format segmented income statement
appears below.
If the company eliminates the Western Division and the Eastern
Division sales increase by 10% as a result, how much will the
company’s net operating income decrease?
Chao, Inc., a service provider, has two divisions. The firm's most recent annual contribution format segmented income statement appears below Total Eastern Company Division Division $450,000 $90,000 $360,000 27,000 63,000 46,800 106,200 $16,200...
ABC Company operates two divisions with the following sales and
expense information for the month of August:
Division 1: sales, $144,000; contribution margin ratio, 50%; direct
fixed expenses, $30,000.
Division 2: sales, $98,000; contribution margin ratio, 70%; direct
fixed expenses, $19,000.
ABC Company’s total fixed expenses during August was
$121,600.
Required:
Prepare a segmented income statement for ABC Company to determine
the segment margin for Divisions 1 and 2 and the operating income
for ABC Company.
ABC Company operates two...
The following information was taken from the segmented income statement of Restin, Inc., and the company's three divisions: Restin, Inc. Los Angeles Division Bay Area Division Central Valley Division Revenues $ 952,000 $ 264,000 $ 299,000 $ 389,000 Variable operating expenses 525,200 145,200 160,000 220,000 Controllable fixed expenses 234,000 73,000 83,000 78,000 Noncontrollable fixed expenses 84,000 23,000 28,000 33,000 In addition, the company incurred common fixed costs of $20,400. Bay Area's segment profit margin is: Multiple Choice $28,000. $21,200. $139,000....
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 795,000 $ 265,000 $ 530,000 Cost of goods sold 535,300 148,400 386,900 Gross margin 259,700 116,600...
ABC Company operates two divisions with the following sales and expense information for the month of August: Division 1: sales, $150,000; contribution margin ratio, 50%; direct fixed expenses, $31,500. Division 2: sales, $102,500; contribution margin ratio, 70%; direct fixed expenses, $19,750. ABC Company’s total fixed expenses during August was $127,000. Required: Prepare a segmented income statement for ABC Company to determine the segment margin for Divisions 1 and 2 and the operating income for ABC Company. total company division 1...
Toxaway Company is a merchandiser that segments its business into two divisions-Commercial and Residential. The company's accounting intern was asked to prepare segmented income statements that the company's divisional managers could use to calculate their break-even points and make decisions. She took the prior month's companywide income statement and prepared the absorption format segmented income statement shown below: Sales Cost of goods sold Gross margin Selling and administrative expenses Net operating income Total Company $ 825,000 555,500 269,500 260,000 $...
Toxaway Company is a merchandiser that segments its business into two divisions—Commercial and Residential. The company’s accounting intern was asked to prepare segmented income statements that the company’s divisional managers could use to calculate their break-even points and make decisions. She took the prior month’s companywide income statement and prepared the absorption format segmented income statement shown below: Total Company Commercial Residential Sales $ 795,000 $ 265,000 $ 530,000 Cost of goods sold 535,300 148,400 386,900 Gross margin 259,700 116,600...
Pina Company has four operating divisions. During the first
quarter of 2017, the company reported aggregate income from
operations of $212,300 and the following divisional
results.
Division
I
II
III
IV
Sales
$254,000
$199,000
$501,000
$443,000
Cost of goods sold
204,000
190,000
301,000
247,000
Selling and administrative expenses
69,700
61,000
57,000
55,000
Income (loss) from operations
$ (19,700)
$ (52,000)
$143,000
$141,000
Analysis reveals the following percentages of variable costs in
each division.
I
II
III
IV
Cost of goods...