Question

Kimbrell Inc. manufactures three sizes of utility tables—small (S), medium (M), and large (L). The income...

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?
$

Homework Answers

Answer #1
  1. Income Statement

KIMBRELL, INCC.

Variable Costing Income Statement

For the year ended 31st January, 2016

Particular

Size

Total

S

M

L

Sales

990000

1087500

945000

3022500

Variable cost of goods sold

538500

718500

567000

1824000

Manufacturing Margin

451500

369000

378000

1198500

Variable Operating Exp,

118100

108750

85050

311900

Contribution margin

333400

260250

292950

886600

Fixed Costs

Manufacturing Cost

779000

Operating expenses

88900

Total Fixed Cost

867900

Income from Operation

18700

2. If proposal 2 is accepted

Contribution margin of M

260250

Less: reduction in fixed costs

142500

Less: Reduction in fixed operating expenses

28350

170850

Reduction in annual income from operation

89400

3.

Increase in sale volume of Size S by additional 130%

Sale value

990000*130/100 = 1287000     then 990000+1287000 = 2277000

Variable cost

538500*130/100 = 700050 then 538500+700050 = 1238550

Variable expenses

118100*130/100 = 153530    then 118100+153530 = 271630

It is not mentioned in the question that whether the variable cost for Size S relatively increase or not. We assume that the cost of Size S is also increased by 130%.

If cost of Size M is added to Size S then relatively change the figure of Variable cost and Variable Expenses.

Particular

Size

Total

S

L

Sales

2277000

945000

3222000

Variable cost of goods sold

1238550

567000

1805550

Manufacturing Margin

1038450

378000

1416450

Variable Operating Exp,

271630

85050

356680

Contribution margin

766820

292950

1059770

Fixed Costs

Manufacturing Cost

779000

Operating expenses (including additional salary)

173950

Total Fixed Cost

952950

Income from Operation

106820

4. proposal 3 is accepted

Income from operation, proposal 3

106820

Income from operation, present condition (part 1)

18700

Increase in income from operation

88120

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Income Statements under Absorption and Variable Costing Patagucci Inc. manufactures and sells athletic equipment. The company...
Income Statements under Absorption and Variable Costing Patagucci Inc. manufactures and sells athletic equipment. The company began operations on August 1, 2016, and operated at 100% of capacity (38,500 units) during the first month, creating an ending inventory of 3,500 units. During September, the company produced 35,000 garments but sold 38,500 units at $80 per unit. The September manufacturing costs and selling and administrative expenses were as follows: Number of Units Unit Cost Total Cost Manufacturing costs in September beginning...
Income Statements under Absorption Costing and Variable Costing Joplin Industries Inc. manufactures and sells high-quality sporting...
Income Statements under Absorption Costing and Variable Costing Joplin Industries Inc. manufactures and sells high-quality sporting goods equipment under its highly recognizable J-Sports logo. The company began operations on May 1 and operated at 100% of capacity (42,900 units) during the first month, creating an ending inventory of 3,900 units. During June, the company produced 39,000 garments during the month but sold 42,900 units at $85 per unit. The June manufacturing costs and selling and administrative expenses were as follows:...
Which of the following is the income statement formula for the variable costing method? Sales Revenue...
Which of the following is the income statement formula for the variable costing method? Sales Revenue - All Variable Costs = Contribution Margin - All Fixed Expenses = Operating Income Sales Revenue - Cost of Goods Sold = Gross Margin - All Fixed Expenses = Operating Income Sales Revenue - Variable Manufacturing Costs = Contribution Margin - Fixed Manufacturing Costs = Operating Income Sales Revenue - Cost of Goods Sold = Gross Margin - Selling and Administrative Expenses = Operating...
Variable Costing Income Statement On November 30, the end of the first month of operations, Weatherford...
Variable Costing Income Statement On November 30, the end of the first month of operations, Weatherford Company prepared the following income statement, based on the absorption costing concept: Weatherford Company Absorption Costing Income Statement For the Month Ended November 30 Sales (2,900 units) $81,200 Cost of goods sold: Cost of goods manufactured (3,400 units) $68,000 Inventory, November 30 (500 units) (10,000) Total cost of goods sold 58,000 Gross profit $23,200 Selling and administrative expenses 13,820 Income from operations $9,380 Assume...
Income Statements under Absorption and Variable Costing Shawnee Motors Inc. assembles and sells MP3 players. The...
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 (17,000 units) $2,210,000 Production costs (22,000 units): Direct materials $1,058,200 Direct labor 508,200 Variable factory overhead 253,000 Fixed factory overhead 169,400 1,988,800 Selling and administrative expenses: Variable selling and administrative expenses $308,300 Fixed selling and administrative expenses 119,300 427,600...
Absorption and Variable Costing Income Statements During the first month of operations ended July 31, YoSan...
Absorption and Variable Costing Income Statements During the first month of operations ended July 31, YoSan Inc. manufactured 9,400 flat panel televisions, of which 8,800 were sold. Operating data for the month are summarized as follows: Sales $1,144,000 Manufacturing costs:     Direct materials $573,400     Direct labor 169,200     Variable manufacturing cost 150,400     Fixed manufacturing cost 75,200 968,200 Selling and administrative expenses:     Variable $88,000     Fixed 40,500 128,500 1. Prepare an income statement based on the variable costing...
On December 31, the end of the first year of operations, Frankenreiter Inc., manufactured 2,700 units...
On December 31, the end of the first year of operations, Frankenreiter Inc., manufactured 2,700 units and sold 2,300 units. The following income statement was prepared, based on the variable costing concept: Frankenreiter Inc. Variable Costing Income Statement For the Year Ended December 31, 20Y1 Sales $805,000 Variable cost of goods sold: Variable cost of goods manufactured $453,600 Inventory, December 31 (67,200) Total variable cost of goods sold 386,400 Manufacturing margin $418,600 Total variable selling and administrative expenses 96,600 Contribution...
Income Statements under Absorption and Variable Costing Shawnee Motors Inc. assembles and sells MP3 players. The...
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 (16,000 units) $2,240,000 Production costs (21,000 units): Direct materials $1,087,800 Direct labor 522,900 Variable factory overhead 260,400 Fixed factory overhead 174,300 2,045,400 Selling and administrative expenses: Variable selling and administrative expenses $317,000 Fixed selling and administrative expenses 122,700 439,700...
O'?Neill's Products manufactures a single product.? Cost, sales, and production information for the company and its...
O'?Neill's Products manufactures a single product.? Cost, sales, and production information for the company and its single product is as? follows: -Selling price per unit is $53 -Variable manufacturing costs per unit manufactured (includes direct materials [DM], direct labor [DL], and variable MOH $27 -Variable operating expenses per unit sold $1 -Fixed manufacturing overhead (MOH) in total for the year $64,000 -Fixed operating expenses in total for the year $91000 -Units manufactured and sold for the year 8,000 units Requirement...
Absorption Costing Income Statement On October 31, the end of the first month of operations, Maryville...
Absorption Costing Income Statement On October 31, the end of the first month of operations, Maryville Equipment Company prepared the following income statement, based on the variable costing concept: Maryville Equipment Company Variable Costing Income Statement For the Month Ended October 31 Sales (8,600 units) $361,200 Variable cost of goods sold: Variable cost of goods manufactured $175,100 Inventory, October 31 (1,700 units) (28,900) Total variable cost of goods sold (146,200) Manufacturing margin $215,000 Variable selling and administrative expenses (94,600) Contribution...