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% |