In: Accounting
Vast Spirit
Calendars imprints calendars with college names. The company has fixed expenses of
$1,125,000
each month plus variable expenses of
$4.50
per carton of calendars. Of the variable expense,
75%
is cost of goods sold, while the remaining
25%
relates to variable operating expenses. The company sells each carton of calendars for
$19.50.
Read the requirements
LOADING...
.
Requirement 1. Compute the number of cartons of calendars that
Vast Spirit
Calendars must sell each month to breakeven.
Begin by determining the basic income statement equation.
Sales revenue |
- |
Variable expenses |
- |
Fixed expenses |
= |
Operating income |
Using the basic income statement equation you determined above solve for the number of cartons to break even.
The breakeven sales is |
75,000 |
cartons. |
Requirement 2. Compute the dollar amount of monthly sales
Vast Spirit
Calendars needs in order to earn
$338,000
in operating income.
Begin by determining the formula.
( |
Fixed expenses |
+ |
Target operating income |
) / |
Contribution margin ratio |
= |
Target sales in dollars |
(Round the contribution margin ratio to two decimal places.)
The monthly sales needed to earn $338,000 in operating income is $ |
1,900,000 |
. |
Requirement 3. Prepare the company's contribution margin income statement for June for sales of
485,000
cartons of calendars.
Vast Spirit |
|||||
Contribution Margin Income Statement |
|||||
Month Ended June 30 |
|||||
Sales revenue |
$9,457,500 |
||||
Variable expenses: |
|||||
Cost of goods sold |
$1,636,875 |
||||
Operating expenses |
545,625 |
2,182,500 |
|||
Contribution margin |
7,275,000 |
||||
Fixed expenses |
1,125,000 |
||||
Operating income |
$6,150,000 |
Requirement 4. What is June's margin of safety (in dollars)? What is the operating leverage factor at this level of sales?
Begin by determining the formula.
Sales revenue |
- |
Sales revenue at breakeven |
= |
Margin of safety (in dollars) |
The margin of safety is $ |
7,995,000 |
. |
What is the operating leverage factor at this level of sales? Begin by determining the formula.
Contribution margin |
/ |
Operating income |
= |
Operating leverage factor |
(Round the operating leverage factor to three decimal places.)
The operating leverage factor is |
1.183 |
. |
Requirement 5. By what percentage will operating income change if July's sales volume is
13%
higher? Prove your answer. (Round the percentage to two decimal places.)
If volume increases 13%, then operating income will increase |
15.38 |
%. |
Prove your answer. (Round the percentage to two decimal places.)
Original volume (cartons) |
||
Add: Increase in volume |
||
New volume (cartons) |
||
Multiplied by: Unit contribution margin |
||
New total contribution margin |
||
Less: Fixed expenses |
||
New operating income |
||
vs. Operating income before change in volume |
||
Increase in operating income |
||
Percentage chang |
1. Income statement equation
Sales | - | Variable expenses | - | Fixed expenses | = | Operating income |
The breakeven sales is = Fixed expenses/ (Selling price - Variable cost)
= $1,125,000 / (19.50 - 4.50)
= 75,000 cartons
2.
Contribution margin ratio = Contribution/ Sales
= $15/ 19,50 = 76.92%
( | Fixed expenses | + | Target Operating income | )/ | Contribution margin ratio | = | Target sales in dollars |
The monthly sales needed to earn $312,000 in operating income is = ($1,125,000 + 338,000) / 76.92%
= $1,901,900
3. Contribution margin income statement
Sales revenue (485000 x $19,5) | $9,457,500 | |
Variable expenses: | ||
Cost of goods sold (4.50 x 75% x 485000) | $1,636,875 | |
Operating expenses (4.50 x 25% x 485000) | 545,625 | 2,182,500 |
Contribution margin | 7,275,000 | |
Fixed expenses | 1,125,000 | |
Operating income | $6,150,000 |
4.
Total sales | - | Breakeven sales | = | Margin of safety (in dollars) |
The margin of safety is = $9,457,500 - ($19.50 x 75,000) = $7,995,000
Contribution margin | / | Net operating income | = | Operating leverage factor |
The operating leverage factor is = $7,275,000 / $6,150,000 = 1.183
5. If volume increases 13%, then operating income will increase = 13% x 1.183 = 15.38%
Original volume (cartons) | 485,000 |
Add: Increase in volume | 63,050 |
New volume (cartons) | 548,050 |
Multiplied by: Unit contribution margin | $15 |
New total contribution margin | $8,220,750 |
Less: Fixed expenses | -1,125,000 |
New operating income | $7,095,750 |
vs. Operating income before change in volume | $6,150,000 |
Increase in operating income | $945,750 |
Percentage change | 15.38% |