Question

In: Accounting

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.

Determine the breakeven point in dollars.

Note: Give your answer using dollar signs and commas but not decimal points (cents).

Example: $12,345

4.

Determine the sales revenue Test Company must generate to earn operating income of $30,000.

Note: Give your answer using dollar signs and commas but not decimal points (cents).

5.

Determine the margin of safety in dollars.

Note: Give your answer using dollar signs and commas but not decimal points (cents).

6.

Determine the margin of safety in units.

Note: Give your answer using commas. Do not include the word “units.”

Example: 12,345

7.

Test Company’s sales manager proposed holding a Holiday Sale. Prices would be discounted 5% and an additional $1,000 would be used for advertising to promote the event. Determine the number of units Test Company must sell during the promotion to continue earning $18,000.

Note: Give your answer using commas. Do not include the word “units.”

Example: 12,345

8.

Test Company reported sales of $250,000, variable expenses of $190,000 and fixed expenses of $48,000. Determine the sales revenue needed to break even.

Note: Give your answer using dollar signs and commas but not decimal points (cents).

Example: $12,345

Solutions

Expert Solution

(1)Break Even point(in units):

Sales(6,000units) = $120,000

Selling price per unit(120,000/6000) = 20

Variable Cost per unit(72,000/6000) = 12

Contribution Margin per unit($)    8

Fixed Expenses = $30,000

Break-even point is computed by using the following equation:

     Fixed Costs/Unit Contribution Margin

= 30,000/8

= 3,750

(2)Sales(units) to earn Operating Income or target profir of ($20,000) is computed as follows:

Required Sales(units) = [Fixed costs + Target Profit]/Unit contribution margin

= [30,000+20,000]/8

   = 6,250

(3)Break Point in dollars is computed by using the following equation:

Total Fixed costs/Contribution margin ratio

Contributiion margin ratio = (Contribution margin/Sales)*100

= [48,000/120,000]*100

=40%

Break even point (in dollars) = 30,000/40%

= 75,000

(4) Required Sales revenue to earn Operating Income of ($30,000) is computed as follows:

Required Sales in dollars =[Total fixed costs+ Target Profit]/Contribution margin ratio

= [30,000+30,000]/40%

= 150,000

(5)Margin of Safety:

Sales = $120,000

Sales at Breakeven = $75,000

Margin of Safety = [Sales-Break even sales]/Sales

= [120,000-75,000]/120,000

= 37.5%

Margin of Safety(in dollars) = 45,000(120,000/37.5%)

Or Margin of Safety(in dollars) = Sales - Breakeven Sales($120,000-75,000)

(6)Margin of Safety (in units) = 2,250[45,000/Selling price per unit ($20)]

orMargin ofSafety(units) can be computed by using the following formula(Sales in units- Breakeven Sales in units)


Related Solutions

White Limited’s most recent income statement is shown below: Total Per Unit Sales (6,000 units) $...
White Limited’s most recent income statement is shown below: Total Per Unit Sales (6,000 units) $ 312,000 $ 52.00 Variable expenses 216,000. 36.00 Contribution margin 96,000 $ 16.00 Fixed expenses. 84,000 Operating income $ 12,000 Fixed expenses 84,000 Operating income $ 12,000 Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): 1. The sales volume increases by 200 units. 2. The sales volume declines by 200 units. 3. The sales volume...
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...
1. A recent income statement of Bantom Corporation reported the following data: Sales revenue $ 8,358,000...
1. A recent income statement of Bantom Corporation reported the following data: Sales revenue $ 8,358,000 Variable costs 4,998,000 Fixed costs 3,130,000 If these data are based on the sale of 21,000 units, the contribution margin per unit would be: Multiple Choice $50. $160. $300. $370. 2.   Bloomfield Stores reported sales revenues of $720,000, a total contribution margin of $200,000, and fixed costs of $325,000. If sales volume amounted to 10,000 units, the company's variable cost per unit must have...
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.
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...
Berry Company reported the following on the company's income statement in two recent years
Berry Company reported the following on the company's income statement in two recent yearsParticularsCurrent YearPrior YearInterest expense$320,000$300,000Income before income tax expense3,200,0003,600,000(a)Determine the times interest earned ratio for the current year and the prior year.Round to one decimal place(b) Is the number of times interest charges are earned improving or declining
White Limited’s most recent income statement is shown below: Total Per Unit   Sales (5,100 units) $...
White Limited’s most recent income statement is shown below: Total Per Unit   Sales (5,100 units) $ 163,200 $ 32   Variable expenses 56,100 11   Contribution margin 107,100 $ 21   Fixed expenses 91,350   Operating income $ 15,750 Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): 1. The sales volume increases by 220 units. 2. The sales volume declines by 220 units. 3. The sales volume is 4,350 units.
Whirly Corporation’s most recent income statement is shown below: Total Per Unit   Sales (7,200 units) $...
Whirly Corporation’s most recent income statement is shown below: Total Per Unit   Sales (7,200 units) $ 237,600 $ 33.00   Variable expenses 136,800 19.00   Contribution margin 100,800 $ 14.00   Fixed expenses 55,400   Net operating income $ 45,400 Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): 1. The sales volume increases by 40 units.       2. The sales volume decreases by 40 units.       3. The sales volume is 6,200 units.      
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...
Whirly corporation most recent income statement is shown below: Total Per Unit Sales (7,600 units) 243,200...
Whirly corporation most recent income statement is shown below: Total Per Unit Sales (7,600 units) 243,200 32.00 Variable Expenses 144,400 19.00 Contribution Margin 98,800 Fixed Expenses 55,300 Net Operating Income 43,500 Required: Prepare a new contribution format income statement under each of the following conditions (consider each case independently): 1. The sales volume increases by 60 units 2. The Sales Volume decreases by 60 units 3. The Sales Volume is 6,600
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT