In: Accounting
Try SpiritTry Spirit
Calendars imprints calendars with college names. The company has fixed expenses of
$ 1 comma 095 comma 000$1,095,000
each month plus variable expenses of
$ 6.50$6.50
per carton of calendars. Of the variable expense,
6868%
is cost of goods sold, while the remaining
3232%
relates to variable operating expenses. The company sells each carton of calendars for
$ 16.50$16.50.
Read the requirements
LOADING...
.
Requirement 1. Compute the number of cartons of calendars that
Try SpiritTry Spirit
Calendars must sell each month to breakeven.
Begin by determining the basic income statement equation.
|
- |
- |
= |
Operating income |
Using the basic income statement equation you determined above solve for the number of cartons to break even.
|
The breakeven sales is |
cartons. |
Requirement 2. Compute the dollar amount of monthly sales
Try SpiritTry Spirit
Calendars needs in order to earn
$ 308 comma 000$308,000
in operating income.
Begin by determining the formula.
|
( |
+ |
) / |
= |
Target sales in dollars |
(Round the contribution margin ratio to two decimal places.)
|
The monthly sales needed to earn $308,000 in operating income is $ |
. |
Requirement 3. Prepare the company's contribution margin income statement for June for sales of
495 comma 000495,000
cartons of calendars.
|
Try Spirit |
|||||
|
Contribution Margin Income Statement |
|||||
|
Month Ended June 30 |
|||||
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.
|
- |
= |
Margin of safety (in dollars) |
|
The margin of safety is $ |
. |
What is the operating leverage factor at this level of sales? Begin by determining the formula.
|
/ |
= |
Operating leverage factor |
(Round the operating leverage factor to three decimal places.)
|
The operating leverage factor is |
. |
Requirement 5. By what percentage will operating income change if July's sales volume is
1414%
higher? Prove your answer. (Round the percentage to two decimal places.)
|
If volume increases 14%, then operating income will increase |
%. |
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 change |
% |
| 1 | Sales Revenue - Variable Expenses - Fixed Expenses = Operating Income | ||||||||||
| (Sales price*Units Sold) - (Variablecost per unit*Units Sold) - Fixed Expenses = 0 | |||||||||||
| (16.50*Units Sold) - (6.50*Units Sold) - 1095000 = 0 | |||||||||||
| 10 Units sold = 1095000 | |||||||||||
| Units Sold | 109500 | 1095000/10 | |||||||||
| The breakeven sales is 109500 cartons | |||||||||||
| 2 | Fixed Expenses + Target Operating Income/Contribution margin ratio = Target sales in dollars | ||||||||||
| (1095000+308000)/(10/16.50) | |||||||||||
| 2314950 | |||||||||||
| Monthly Sales needed to earn $ 308000 in operating income is $ 2314950 | |||||||||||
| 3 | College Try | ||||||||||
| Contribution Margin Income Statement | |||||||||||
| Month ended June 30 | |||||||||||
| Sales Revenue | (495000*16.50) | 8167500 | |||||||||
| Less : Variable Expenses | |||||||||||
| Cost of Goods Sold | (495000*6.50*68%) | 2187900 | |||||||||
| Operating Expenses | (495000*6.50*32%) | 1029600 | |||||||||
| Contribution Margin | 4950000 | ||||||||||
| Less: Fixed Expenses | 1095000 | ||||||||||
| Operating Income | 3855000 | ||||||||||
| Margin of Safety = Sales - Sales at breakeven | |||||||||||
| 8167500 - (109500*16.50) | |||||||||||
| 6360750 | |||||||||||
| Operating Leverage Factor | Contribution Margin/Operating Income | ||||||||||
| 4950000/3855000 | |||||||||||
| 1.284 | |||||||||||
| If Volume increases by 14%, the net operating income will increase by 0.14*1.284 = 17.98% | |||||||||||
| Original Volume (cartons) | 495000 | ||||||||||
| Add : Increase in Volume | 69300 | ||||||||||
| New Volume Cartons | 564300 | ||||||||||
| Multiplied by : Unit contribution margin | 10 | ||||||||||
| New total contribution margin | 5643000 | ||||||||||
| Less : fixed Expenses | 1095000 | ||||||||||
| New Operating income | 4548000 | ||||||||||
| vs Operating income before change in volume | 3855000 | ||||||||||
| Increase in operating income | 693000 | ||||||||||
| percentage change | 17.98% | ||||||||||