Kimbrell Inc. manufactures three sizes of utility tables—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 $142,500 and $28,350, respectively. If Proposal 3 is selected, it is anticipated that an additional annual expenditure of $85,050 for the salary of an assistant brand manager (classified as a fixed operating expense) 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 December 31, 20Y8, is as follows:
Size | ||||||||
S | M | L | Total | |||||
Sales | $990,000 | $1,087,500 | $945,000 | $3,022,500 | ||||
Cost of goods sold: | ||||||||
Variable costs | $538,500 | $718,500 | $567,000 | $1,824,000 | ||||
Fixed costs | 241,000 | 288,000 | 250,000 | 779,000 | ||||
Total cost of goods sold | $779,500 | $1,006,500 | $817,000 | $2,603,000 | ||||
Gross profit | $210,500 | $81,000 | $128,000 | $419,500 | ||||
Operating expenses: | ||||||||
Variable expenses | $118,100 | $108,750 | $85,050 | $311,900 | ||||
Fixed expenses | 32,125 | 42,525 | 14,250 | 88,900 | ||||
Total operating expenses | $150,225 | $151,275 | $99,300 | $400,800 | ||||
Income from operations | $60,275 | $(70,275) | $28,700 | $18,700 |
Required:
1. Prepare an income statement for the past year in the variable costing format. 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, to determine income from operations. Enter all amounts as positive numbers.
Kimbrell Inc. | ||||
Variable Costing Income Statement | ||||
For the Year Ended December 31, 20Y8 | ||||
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 | $ | |||
Income from operations | $ |
2. Based on the income statement prepared in
(1) and the other data presented above, determine the amount by
which total annual income from operations 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 income from operations 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 additional expenditure of $85,050 for the assistant brand manager’s salary can be added to the fixed operating expenses. Enter all amounts as positive numbers.
Kimbrell Inc. | |||
Variable Costing Income Statement | |||
For the Year Ended December 31, 20Y8 | |||
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 | $ | ||
Income from operations | $ |
4. By how much would total annual income
increase above its present level if Proposal 3 is accepted?
$
1.
Kimbrell Inc. |
||||
Variable Costing Income Statement |
||||
For the Year Ended December 31, 20Y8 |
||||
Size S |
Size M |
Size L |
Total |
|
Sales |
$990,000 |
$1,087,500 |
$945,000 |
$3,022,500 |
Variable cost of goods sold |
538,500 |
718,500 |
567,000 |
1,824,000 |
Manufacturing margin |
$451,500 |
$369,000 |
$378,000 |
$1,198,500 |
Variable operating expenses |
118,100 |
108,750 |
85,050 |
311,900 |
Contribution margin |
$333,400 |
$260,250 |
$292,950 |
$886,600 |
Fixed costs: |
||||
Manufacturing costs |
241,000 |
288,000 |
250,000 |
$779,000 |
Operating expenses |
32,125 |
42,525 |
14,250 |
88,900 |
Total fixed costs |
273,125 |
330,525 |
264,250 |
$867,900 |
Income from operations |
60,275 |
-70,275 |
28,700 |
$18,700 |
2. Amount by which total annual income from operations would be reduced below its present level if Proposal 2 is accepted = $260,250 – 142,500-28,350 = $89,400
3.
Kimbrell Inc. |
|||
Variable Costing Income Statement |
|||
For the Year Ended December 31, 20Y8 |
|||
Size S |
Size L |
Total |
|
Sales |
$2,277,000 |
$945,000 |
$3,222,000 |
Variable cost of goods sold |
1,238,550 |
567,000 |
1,805,550 |
Manufacturing margin |
$1,038,450 |
$378,000 |
$1,416,450 |
Variable operating expenses |
271,630 |
85,050 |
356,680 |
Contribution margin |
$766,820 |
$292,950 |
$1,059,770 |
Fixed costs: |
|||
Manufacturing costs |
241,000 |
250,000 |
$491,000 |
Operating expenses |
117,175 |
14,250 |
131,425 |
Total fixed costs |
358,175 |
264,250 |
$622,425 |
Income from operations |
408,645 |
28,700 |
$437,345 |
4. Increase in total income from present level = 437,345 – 18,700
= $418,645
Kimbrell Inc. manufactures three sizes of utility tables—small (S), medium (M), and large (L). The income...
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...
Variable Costing Income Statement and Effect on Income of Change in Operations Kombrelling manufactures three sires of utility tableswall (S), medium (M), and large (L). The income statement has consistently indicated and loss for the M , and management considering three proposals (1) continue Se M. (2) discontinue Sise Mand reduce total output accordingly.or () discontinue Se Mand conduct an advertising campaign to expand the sales of S S so that the entire plant capacity can continue to be used...
Variable Corting Income Statement and Effect on Income of Change in Operations Kimbrell Inc, manufactures three sizes of utility tables-small (S), medium (M), and large (L). The income statement has consistently indicated a net loss for the 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...
Income Statements under Absorption and Variable Costing Shawnee Motors Inc, assembles and sells snowmobile engines. The company began operations on August 1 and operated at 100% of capacity during the first month. The following data summarize the results for August: $600,000 Sales (2,000 units) Production costs (2,400 units): Direct materials Direct labor $300,000 115,200 43,200 21,600 Variable factory overhead Fixed factory overhead 480,000 Selling and administrative expenses: Variable selling and administrative expenses $50,000 22,000 Fixed selling and administrative expenses 72,000...
Income Statements under Absorption and Variable Costing Shawnee Motors Inc. assembles and sells snownmobile engines. The company began operations on August 1 and operated at 100 % of capacity during the first month. The following data summarize the results for August: Sales (2,000 units) $600,000 Production costs (2,400 units): Direct materials $300,000 Direct labor 115,200 Variable factory overhead 43,200 Fixed factory overhead 21,600 480,000 Selling and administrative expenses: Variable selling and administrative expenses $50,000 Fixed selling and administrative expenses 22,000...
Translate Income statements under absorption costing and variable costing Fresno Industries Inc. manufactures and sells high-quality camping tents. The company began operations on January 1 and operated at 100% of capacity (166,000 units) during the first month, creating an ending inventory of 21,000 units. During February, the company produced 145,000 units during the month but sold 166,000 units at $540 per unit. The February manufacturing costs and selling and administrative expenses were as follows: Number of Total Unit Cost Units...
Can anyone help me with this last few problems? Show Me How Absorption costing Income Statement For the Month Ended August 31 Sales $ 1,200,000 Cost of goods sold 835,000 Gross profit s 365,000 Selling and administrative expenses 233,400 Income from operations Feedback Check My Work b. Prepare an income statement according to the variable costing concept. Shawnee Motors Inc. Variable Costing Income Statement For the Month Ended August 31 Sales $ 1,200,000 Variable cost of goods sold 764,000 Manufacturing...
Tami Tyler opened Tami’s Creations, Inc., a small manufacturing company, at the beginning of the year. Getting the company through its first quarter of operations placed a considerable strain on Ms. Tyler’s personal finances. The following income statement for the first quarter was prepared by a friend who has just completed a course in managerial accounting at State University. Tami’s Creations, Inc. Income Statement For the Quarter Ended March 31 Sales (28,150 units) $ 1,126,000 Variable expenses: Variable cost of...
Income Statements under Absorption and Variable Costing Shawnee Motors Inc. assembles and sells MP3 players. The company began operations on August 1 and operated at 100% of capacity during the first month. The following data summarize the results for August: Sales (13,500 units) $1,350,000 Production costs (17,000 units): Direct materials $629,000 Direct labor 302,600 Variable factory overhead 151,300 Fixed factory overhead 100,300 1,183,200 Selling and administrative expenses: Variable selling and administrative expenses $183,400 Fixed selling and administrative expenses 71,000 254,400...
Absorption and Variable Costing Income Statements During the first month of operations ended July 31, YoSan Inc. manufactured 11,900 flat panel televisions, of which 10,900 were sold. Operating data for the month are summarized as follows: Sales $1,798,500 Manufacturing costs: Direct materials $928,200 Direct labor 273,700 Variable manufacturing cost 238,000 Fixed manufacturing cost 119,000 1,558,900 Selling and administrative expenses: Variable $141,700 Fixed 65,200 206,900 Required: 1. Prepare an income statement based on the absorption...