CVP Analysis Solution
CVP Analysis Solution
CVP Analysis Solution
1 CONTRIBUTION MARGIN RATIO = CONTRIBUTION MARGIN ÷ SALES NOTE: WE CAN USE EITHER TOTAL OR
CM RATIO = 15/60 25% CM RATIO = 300,000/1,200,000
VARIABLE EXPENSES RATIO = VAR EXP ÷ SALES NOTE: WE CAN USE EITHER TOTAL OR
VAR EXP RATIO = 45/60 75% VAR EXP RATIO = 900,000/1,200,000
OR
VAR EXP RATIO = 1 - CM RATIO
2 NOI = Q (P - V) - F where Q=QTY SOLD, P=SALES PRICE PER UNIT, V=VARIABLE COST PER UNIT & F=TOTAL FIXED CO
PUT NOI = 0 IN EQUATION FOR BREAKEVEN
0 = Q (60 - 45) - 240,000 P= 60
0 = 15Q - 240,000 V= 45
15Q = 240,000 F= 240,000
Q = 240,000/15
QBE = 16,000 UNITS OR WE CAN USE FORMULA
$SALESBE = 960,000 $ 16,000 X 60
QBE =
3 INCREASE IN SALES 400,000
INCREASE IN NOI = 400,000 X 25% 100,000 SALES X CM RATIO
7 (b) QBE =
QBE = 210,000 / (60 - 48) 17,500 UNITS
SALES$BE =
7 (c) YES, CHANGES SOULD BE MADE BECAUSE OUR NOI INCREASE BY (78,000 - 60,000) $ 18,000.
E CAN USE EITHER TOTAL OR PER UNIT
O = 300,000/1,200,000 25%
E CAN USE EITHER TOTAL OR PER UNIT
RATIO = 900,000/1,200,000 75%
SALES$BE =