In: Accounting
Company manufactures and sells a single product. The company's sales and expenses for last year follow:
LOADING...
(Click the icon to view the information.)Read the requirements
LOADING...
.
Requirement 1. Fill in the missing numbers in the table. Use the following questions to help fill in the missing numbers in the table:
a. What is the total contribution margin?
The total contribution margin is |
. |
b. What is the total variable expense?
The total variable expense is |
. |
c. How many units were sold?
units were sold. |
d. What is the per-unit variable expense?
The per-unit variable expense is |
. |
e. What is the per-unit contribution margin?
The per-unit contribution margin is |
. |
Now fill in the missing numbers in the table. (Enter the percentages as whole numbers, "XX")
Total |
Per Unit |
% |
||
Sales. . . . . . . . . . . . . . . . . . |
$115,000 |
$50 |
% |
|
Variable expenses. . . . . . . . |
% |
|||
Contribution margin. . . . . . |
% |
|||
Fixed expenses. . . . . . . . . . |
11,500 |
|||
Operating income. . . . . . . . |
$46,000 |
Requirement 2. Answer the following questions about breakeven analysis:
a. What is the breakeven point in units?
Begin by identifying the formula to compute the breakeven point in units.
( |
+ |
) ÷ |
= |
Breakeven sales in units |
The breakeven point in units is |
. |
b. What is the breakeven point in sales dollars?
Begin by identifying the formula to compute the breakeven point in sales dollars.
( |
+ |
) ÷ |
= |
Breakeven sales in dollars |
The breakeven point in sales dollars is |
. |
Requirement 3. Answer the following questions about target profit analysis and safety margin:
a. How many units must the company sell in order to earn a profit of
$58,000?
The company must sell |
units in order to earn a profit of $58,000. |
b. What is the current margin of safety in units?
Begin by identifying the formula to compute the current margin of safety in units.
– |
= |
Margin of safety in units |
The current margin of safety in units is |
. |
c. What is the margin of safety in sales dollars?
Begin by identifying the formula to compute the margin of safety in dollars.
– |
= |
Margin of safety in dollars |
The margin of safety in dollars is |
. |
d. What is the margin of safety in percentage?
Begin by identifying the formula to compute the margin of safety in percentage.
Margin of safety as a |
|||||||
÷ |
= |
percentage of budgeted sales |
(Round the percentage to the nearest tenth percent, X.X%.)
The margin of safety percentage is |
%. |
Sales. . . . . . . . . . . . . . . . . . .
$115,000
$50
?
Variable expenses. . . . . . .
?
?
?
Contribution margin. . . . . .
?
?
?
Fixed expenses. . . . . . . . . .
11,500
Operating income. . . . . . . .
$46,000
a.Total contribution Margin = Fixed expenses + Operating Income
= 11500+46,000
= $57,500
b.Total variable expense = Total Sales – Total contribution margin
= 115,000-57,500
= $57,500
c.Units sold = Total Sales/Selling price per unit
= 115,000/50
= 2,300 units
d. Per unit variable expense = 57,500/2,300
= $25 per unit
e. Per unit CM = 57,500/2,300
= $25 per unit
total |
per unit |
% |
|
Sales |
115,000 |
50 |
100% |
Variable expenses |
57,500 |
25 |
50% |
Contribution margin |
57,500 |
25 |
50% |
Fixed expenses |
11,500 |
||
Operating income |
46,000 |
a. Break even point in units = (Fixed expenses + operating income)/Contribution margin per unit
= (11500+0)/25
= 460 units
b. Sales dollars = (Fixed expenses + Operating Income)/Contribution Margin ratio
= (11,500+ 0)/50%
= $23,000
3.a. Units = (11500+58000)/25
= 2,780 units
b. Margin of safety = Budgeted sales in units – break even sales in units
= 2300 – 460
= 1,840 units
c. Sales dollars = Budgeted Sales dollars – breakeven sales in dollars
= 115,000 – 23000
= $92,000
% = Margin of safety in dollars/Budgeted sales in dollars
= 92000/115,000
= 80%