In: Accounting
Acct-101B Ch 21
Segment variable costing income statement and effect on operating income of change in operations
Valdespin Company manufactures three sizes of camping tents—small (S), medium (M), and large (L). The income statement has consistently indicated a net loss for the M size, and management is considering three proposals: (1) continue Size M, (2) discontinue Size M and reduce total output accordingly, or (3) discontinue Size M and conduct an advertising campaign to expand the sales of Size S so that the entire plant capacity can continue to be used.
If Proposal 2 is selected and Size M is discontinued and production curtailed, the annual fixed production costs and fixed operating expenses could be reduced by $46,080 and $32,240, respectively. If Proposal 3 is selected, it is anticipated that an additional annual expenditure of $34,560 for the rental of additional warehouse space would yield an additional 130% in Size S sales volume. It is also assumed that the increased production of Size S would utilize the plant facilities released by the discontinuance of Size M.
The sales and costs have been relatively stable over the past few years, and they are expected to remain so for the foreseeable future. The income statement for the past year ended June 30, 20Y9, is as follows:
Size | ||||||||
S | M | L | Total | |||||
Sales | $668,000 | $737,300 | $956,160 | $2,361,460 | ||||
Cost of goods sold: | ||||||||
Variable costs | $(300,000) | $(357,120) | $(437,760) | $(1,094,880) | ||||
Fixed costs | (74,880) | (138,250) | (172,800) | (385,930) | ||||
Total cost of goods sold | $(374,880) | $(495,370) | $(610,560) | $(1,480,810) | ||||
Gross profit | $293,120 | $241,930 | $345,600 | $880,650 | ||||
Operating expenses: | ||||||||
Variable expenses | $(132,480) | $(155,500) | $(195,840) | $(483,820) | ||||
Fixed expenses | (92,160) | (103,680) | (115,200) | (311,040) | ||||
Total operating expenses | $(224,640) | $(259,180) | $(311,040) | $(794,860) | ||||
Operating income (loss) | $68,480 | $(17,250) | $34,560 | $85,790 |
Required:
1. Prepare an income statement for the past year in the variable costing format. Data for each size should be reported through contribution margin. The fixed costs should be deducted from the total contribution margin, as reported in the “Total” column, to determine operating income.
Valdespin Company | ||||
Variable Costing Income Statement | ||||
For the Year Ended June 30, 20Y9 | ||||
Size S | Size M | Size L | Total | |
Sales | $ | $ | $ | $ |
Variable cost of goods sold | ||||
Manufacturing margin | $ | $ | $ | $ |
Variable operating expenses | ||||
Contribution margin | $ | $ | $ | $ |
Fixed costs: | ||||
Manufacturing costs | $ | |||
Operating expenses | ||||
Total fixed costs | $ | |||
Operating income | $ |
2. Based on the income statement prepared in
(1) and the other data presented, determine the amount by which
total annual operating income would be reduced below its present
level if Proposal 2 is accepted.
$
3. Prepare an income statement in the variable costing format, indicating the projected annual operating income if Proposal 3 is accepted. Data for each style should be reported through contribution margin. The fixed costs should be deducted from the total contribution margin as reported in the “Total” column. For purposes of this problem, the expenditure of $34,560 for the rental of additional warehouse space can be added to the fixed operating expenses.
Valdespin Company | |||
Variable Costing Income Statement | |||
For the Year Ended June 30, 20Y9 | |||
Size S | Size L | Total | |
Sales | $ | $ | $ |
Variable cost of goods sold | |||
Manufacturing margin | $ | $ | $ |
Variable operating expenses | |||
Contribution margin | $ | $ | $ |
Fixed costs: | |||
Manufacturing costs | $ | ||
Operating expenses | |||
Total fixed costs | $ | ||
Operating income | $ |
4. By how much would total annual operating
income increase above its present level if Proposal 3 is
accepted?
$
1.) Variable costing Income Statement
Particulars | Size S | Size M | Size L | Total |
Sales | 6,68,000 | 7,37,300 | 9,56,160 | 23,61,460 |
Variable cost of goods sold | -3,00,000 | -3,57,120 | -4,37,760 | -10,94,880 |
Manufacturing Margin | 3,68,000 | 3,80,180 | 5,18,400 | 12,66,580 |
Variable operating expenses | -1,32,480 | -1,55,500 | -1,95,840 | -4,83,820 |
Contribution margin | 2,35,520 | 2,24,680 | 3,22,560 | 7,82,760 |
Fixed manufacturing costs | -3,85,930 | |||
Fixed Operating expenses | -3,11,040 | |||
Operating Income | 85,790 |
2) The operating income will be reduced by $ 146,360, as the discontinuing of Size M will yield loss of $ 60,570
Particulars | Size S | Size M | Size L | Total |
Sales | 6,68,000 | 9,56,160 | 16,24,160 | |
Variable cost of goods sold | -3,00,000 | -4,37,760 | -7,37,760 | |
Manufacturing Margin | 3,68,000 | - | 5,18,400 | 8,86,400 |
Variable operating expenses | -1,32,480 | -1,95,840 | -3,28,320 | |
Contribution margin | 2,35,520 | - | 3,22,560 | 5,58,080 |
Fixed manufacturing costs | -3,39,850 | |||
Fixed Operating expenses | -2,78,800 | |||
Operating Income | -60,570 |
3) Variable costing income statement for proposal 3
Particulars | Size S | Size M | Size L | Total |
Sales | 15,36,400 | 9,56,160 | 24,92,560 | |
Variable cost of goods sold | -6,90,000 | -4,37,760 | -11,27,760 | |
Manufacturing Margin | 8,46,400 | - | 5,18,400 | 13,64,800 |
Variable operating expenses | -3,04,704 | -1,95,840 | -5,00,544 | |
Contribution margin | 5,41,696 | - | 3,22,560 | 8,64,256 |
Fixed manufacturing costs | -3,85,930 | |||
Fixed Operating expenses | -3,45,600 | |||
Operating Income | 1,32,726 |
4) Total operating income will be increased by $ 46,936 if proposal 3 is accepted:-
($ 132,726 - $ 85,790)