Question

In: Accounting

Sherpa Manufacturing has the following income statement for 6,000 units: Sales $600,000 Variable costs 360,000 Contribution...

Sherpa Manufacturing has the following income statement for 6,000 units: Sales $600,000 Variable costs 360,000 Contribution margin 240,000 Fixed costs 80,000 Net income $160,000 (a) At what sales volume (in sales dollars) does Sherpa break even? (b) At what sales volume (in units) does Sherpa break even? (c) Given the income statement above, compute the margin of safety. (d) What level of sales volume must be attained to reach net income of $200,000? (e) What level of sales volume must be attained to reach net income of $180,000, assuming Sherpa had to pay income taxes at a rate of 40%?

Solutions

Expert Solution

  • All working forms part of the answer
  • Requirement ‘a’

A

Contribution margin

$        240,000

B

Sales

$        600,000

C = A/B

Contribution margin per unit

40%

D

Fixed Cost

$          80,000

E = C/D

Sales Dollars required to break even

$        200,000 = Answer

  • Requirement ‘b’

A

Contribution margin

$              240,000

B

Units sold

                      6,000

C = A/B

Contribution margin per unit

$                         40

D

Fixed Cost

$                80,000

E = C/D

Sales Volume required to break even

                      2,000 units = Answer

  • Requirement ‘c’

--You have not mentioned if MoS is required in Dollar amount or Units, so I’ve given answer in both – Dollar amounts and Units

Working

Amount

Units

A

Sales

$              600,000

                      6,000

B

Break Even Point

$              200,000

                      2,000

C = A - B

Margin of Safety

$              400,000

                      4,000 units

  • Requirement ‘d’

A

Target Net Income

$              200,000

B

Fixed cost

$                80,000

C = A+B

Total Contribution margin required

$              280,000

D

Contribution margin per unit

$                         40

E = C/D

Sales Volume required

                      7,000 units = Answer

  • Requirement ‘e’

A

Target Net Income [after tax]

$        180,000

B = A/60%

Target Net Income [before tax]

$        300,000

C

Fixed cost

$          80,000

D = B+C

Total Contribution margin required

$        380,000

E

Contribution margin per unit

$                   40

F = D/E

Sales Volume required

                9,500 units = Answer


Related Solutions

given below is the variable costing income statement for a XY Company:                         Sales, 6,000 units...
given below is the variable costing income statement for a XY Company:                         Sales, 6,000 units @ $35                                                         $210,000 Variable costs: Beginning inventory, 680 units @ $20               $13,600 Variable manufacturing cost of goods manufactured, 6,600 units @ $20       + $132,000 Ending inventory, 1,280 units @ $20               - $25,600 Variable manufacturing cost of goods              $120,000 Variable selling and administrative exp.           + $24,900 Total variable costs                                                       - $144,900 Contribution margin                                                                 $65,100 Fixed costs: Fixed factory overhead                                     $19,800 Fixed selling and...
Contribution Income Statement Sales (16,000 units) ……………………….. 128,000 Variable expenses ……………………… 80,000 Contribution Margin ………………… 48,000...
Contribution Income Statement Sales (16,000 units) ……………………….. 128,000 Variable expenses ……………………… 80,000 Contribution Margin ………………… 48,000 Fixed expenses ………………………… 12,000 Net Operating Income ………………. 36,000 Jackpot company sells a single product, has provided its contribution format income statement for June. Required: Prepare Contribution Income Statement assuming that the business expects an increase in its total sales (as revenue) by 10% and decrease in variable cost per unit by $3. (2.5 marks) Refer to the original data, how much is the...
Below is the variable costing income statement for South Bend Co. Sales, 6,000 units                             &n
Below is the variable costing income statement for South Bend Co. Sales, 6,000 units                                                                        $210,000 Total variable costs:           Beg. inventory,            680 units              $13,600           Variable manufacturing cost of           goods manufactured,       ? units           + 132,000           Ending inventory,     1,280 units           - (25,600)           Variable manufacturing cost of goods $120,000           Variable selling & admin. exp.              + 24,900     ($144,900) Contribution margin                                                                    $65,100 Total fixed costs:           Fixed factory overhead                            $19,800...
Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000...
Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000 0.24 $1,350,000 $1,150,000 Fixed Costs Selling $500,000 Administrative $485,000 Manufacturing Overhead $150,000 $1,135,000 Profit Dollars Percentage Calculate the Contribution Margin Calculate the Gross Margin Ratio Calculate Breakeven Sales Calculate Margin of Safety based on the 5% expected sales increase. Income Statement Projected Income Statement Sales Revenue $2,500,000 Variable Costs Purchases $750,000 0.3 Direct labor $600,000 0.24 $1,350,000 $1,150,000 Fixed Costs Selling $500,000 Administrative $485,000...
MDI Enterprises prepared the following income statement for June: Sales revenue (6,000 units) $150,000 Cost of...
MDI Enterprises prepared the following income statement for June: Sales revenue (6,000 units) $150,000 Cost of goods sold: Fixed costs $18,000 Variable costs 30,000 48,000 Gross profit 102,000 Operating expenses: Fixed costs 27,000 Variable costs 12,000 39,000 Operating income $ 63,000 How many units must MDI sell in order to break-even? 2,500 units 900 units 3,480 units There is not enough information provided to determine the answer.
1. Test Company reported the following income statement for the most recent period. Sales (6,000 units)...
1. Test Company reported the following income statement for the most recent period. Sales (6,000 units) $120,000 Variable expenses      72,000 Contribution margin 48,000 Fixed expenses      30,000 Operating income $18,000 Determine the breakeven point in units. Note: Give your answer using commas. Do not include the word “units.” Example: 12,345 2. Determine the number of units Test Company must sell to earn operating income of $20,000. Note: Give your answer using commas. Do not include the word “units.” 3....
The following is Antisdale Corporation's contribution format income statement for last month: Sales $             3,750,000 Variable...
The following is Antisdale Corporation's contribution format income statement for last month: Sales $             3,750,000 Variable expenses                 1,687,500 Contribution margin                 2,062,500 Fixed expenses                     950,000 Net operating income $             1,112,500 The company has no beginning or ending inventories and produced and sold 60,000 units during the month. Required: a. What is the company's contribution margin ratio? b. What is the company's break-even in units? c. If sales increase by 6,000 units, by how much should net operating income...
Company prepared the following contribution format income statement based on a sales volume of 1,000 units...
Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): Sales $ 70,000 Variable expenses 38,500 Contribution margin 31,500 Fixed expenses 23,310 Net operating income $ 8,190 5. If sales decline to 900 units, what would be the net operating income? 6. If the selling price increases by $2 per unit and the sales volume decreases by 100 units, what would be the...
1. The following is Ark Corporation's contribution format income statement for last month: Sales $1,200,000 Variable...
1. The following is Ark Corporation's contribution format income statement for last month: Sales $1,200,000 Variable expenses     800,000 Contribution margin 400,000 Fixed expenses     300,000 Net operating income $  100,000 The company has no beginning or ending inventories and produced and sold 25,000 units during the month. Required: a. What is the company's contribution margin ratio? b. What is the company's break-even in units? c. If sales increase by 100 units, by how much should net operating income increase? d. How many...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units
    Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units):         Sales $ 90,000 Variable expenses   49,500 Contribution margin   40,500 Fixed expenses   33,210 Net operating income $ 7,290   14. Assume that the amounts of the company’s total variable expenses and total fixed expenses were reversed. In other words, assume that the total variable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT