Cost -Volume-Pro lume-Profit fit Analysis Chapter 4 Cost-Vo
CHAPTER
71
4
COST-VOLUME-PROFIT ANALYSIS
CHAPTER INTRODUCTION Te analysis of o! "osts an# $rofit "an%e !en &olume "an%es is referre# to as cost-volume-profit (CVP) analysis' In tis "a$ter( tools are #e&elo$e# to ena)le mana%ers to ans!er *uestions relatin% to $lannin%( $lannin%( "ontrol( "ontrol( an# #e"isio #e"ision n ma+in%' ma+in%'
Objectives, Terms, and Discussions LO1
Identify common common cost behavior patterns. patterns.
COMMON COST ,EAVIOR ,EAVIOR PATTERNS PATTERNS To $erform "ost-&olume-$rofit analysis .CVP/( you nee# to +no! o! "osts )ea&e !en )usiness a"ti&ity .e'%'( $ro#u"tion &olume or sales &olume/ "an%es' Tis se"tion #es"ri)es some "ommon $atterns of "ost )ea&io )ea&ior' r' Variable costs are "osts tat "an%e in $ro$ortion to "an%es in &olume or a"ti&ity' For e0am$le( if $ro#u"tion &olume in"reases )y 12 $er"ent( #ire"t materials are e0$e"te# to in"rease in total )y 12 $er"ent' E0am$les of &aria)le "osts are #ire"t material( #ire"t la)or( in#ire"t material( an# sales sales "ommi "ommissi ssions ons'' Te &aria)le &aria)le "ost per unit #oes not "an%e !en &olume or a"ti&ity "an%es' E0a"tly o! a"ti&ity soul# )e measure# in analy3in% a &aria)le "ost #e$en#s on te situation' For e0am$le( a "aterer4s foo# "ost .#ire"t material/ &aries !it num)er of %uests ser&e# !ile an airline4s fuel "ost &aries !it te num)er of miles flo!n' Fie! costs are "osts tat #o not "an%e in res$onse to "an%es in a"ti&ity le&els' E0am$les of fi0e# "osts are #e$re"iation( su$er&isory salaries( )uil#in% maintenan"e( an# rent' For e0am$le( if fi0e# "osts total 567(222 for te $erio#( !ate&er te num)er of units $ro#u"e#( te amount of fi0e# "osts remains at 567(222' o!e&er( te amount of fi0e# "ost $er unit #oes "an%e !it te le&el of a"ti&ity' For e0am$le( if 1(222 units are $ro#u"e#( fi0e# "ost $er unit is 567 .567(22281(222 units/( )ut if $ro#u"tion $ro#u"tion in"reases in"reases to 9(222 units( units( fi0e# "ost "ost $er unit #e"reases #e"reases to 57: .567(22289(222 units/' In te sort-run( some fi0e# "osts "an )e "an%e# "an%e# !ile oters oters "annot' "iscretionary fie! costs are tose fi0e# "osts tat mana%ement "an easily "an%e in te sort-run' E0am$les in"lu#e a#&ertisin%( resear" an# #e&elo$ment( an# re$air an# maintenan"e' Committe! fie! costs are tose
7#
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting Accounting
fi0e# "osts tat "annot )e easily "an%e# in te sort-run' Su" "osts in"lu#e rent( #e$re"iation of )uil#in%s )uil#in%s an# an# e*ui$men e*ui$ment( t( an# insuran"e insuran"e relate# relate# to )uil#in%s )uil#in%s an# e*ui$me e*ui$ment' nt' &ie! costs .also referre# to as semivariable costs/ are "osts tat "ontain )ot a &aria)le "ost element an# a fi0e# "ost element' For e0am$le( if a sales$erson is $ai# 5<2(222 $er year .fi0e# "ost/ $lus a "ommissio "ommission n e*ual to 1 $er"ent of sales .&aria)le "ost/( te sales$erson4s sales$erson4s total "om$ensatio "om$ensation n is a mi0e# "ost' Note es$e"ially tat total pro!uction cost is also a mie! cost sin"e it "ontains material( la)or( an# )ot &aria)le an# fi0e# o&erea# "osts' $tep costs are tose "osts tat are fi0e# for a ran%e of &alue )ut in"rease to a i%er le&el !en te u$$er )oun# of te ran%e is e0"ee#e#' At tat $oint te "osts a%ain remain fi0e# until anoter u$$er )oun# is e0"ee#e#' Ste$ "osts are often "lassifie# as eiter ste$ &aria)le or ste$ fi0e# "osts #e$en#in% on te ran%e of a"ti&ity for !i" te "ost remains fi0e#' If te ran%e is relati&ely lar%e( te "ost is "onsi#er "onsi#ere# e# to )e a ste$ fi0e# fi0e# "ost' Te relevant ran'e is te ran%e of a"ti&ity for !i" assum$tions as to o! a "ost )ea&es are reasona)le &ali#' LO#
Estimate the relation between cost and activity using account analysis and the high-low method.
COST ESTIMATION METO=S To $re#i"t o! mu" "ost !ill )e in"urre# at &arious le&els of a"ti&ity( o! mu" of te total "ost is fi0e# an# o! mu" is &aria)le must )e #etermine#' Fre*uently "ost information is not )ro+en out in terms of fi0e# an# &aria)le "ost "om$onents' Terefore( te amount of fi0e# an# &aria)le "ost must )e estimate#' In tis "a$ter( tree te"ni*ues are $resente# for estimatin% te amount of fi0e# an# &aria)le "ost> a""ount analysis( te i%-lo! meto#( an# re%ression analysis' ccount analysis is te most "ommon a$$roa" to estimatin% fi0e# an# &aria)le "osts' Tis meto# meto# re*uires re*uires tat te mana%er mana%er use $rofess $rofession ional al ?u#%e ?u#%eme ment nt to "lassify "lassify "osts as eiter eiter fi0e# or &aria)le' Te total of te "osts "lassifie# as &aria)le "an )e #i&i#e# )y a measure of a"ti&ity to "al"ulate te &aria)le "ost $er unit of a"ti&ity' Te total of te "osts "lassifie# as fi0e# $ro&i#es te estimate of fi0e# "ost' Te a""ount analysis a$$roa" is su)?e"ti&e in tat #ifferent mana%ers usin% te same set of fa"ts may rea" #ifferent "on"lusions re%ar#in% te "lassifi"ation of "osts into fi0e# an# &aria)le "om$onents' Illustrations 7-: an# 7-< in te te0t)oo+ $ro&i#e e0am$les of estimatin% fi0e# an# &aria)le "osts usin% a""ount analysis' $catter'raphs @ In some "ases( a mana%er may a&e "ost information from se&eral re$ortin% $erio#s $erio#s a&aila)le to estimate estimate o! "osts "an%e in res$onse to "an%es "an%es in a"ti&ity' a"ti&ity' A mana%er mana%er "an %ain insi%t into te relationsi$ )et!een $ro#u"tion "ost an# a"ti&ity )y $lottin% "osts an# a"ti&ity le&els' Te $lot of te #ata is referre# to as a scatter'raph' enerally( s"atter%ra$s are $re$are# !it "ost measure# on te &erti"al a0is an# a"ti&ity le&el measure# on te ori3ontal a0is' Ea" $oint in te s"atter%ra$ re$resents one $air of "ost an# a"ti&ity &alues' Te $re$aration of s"atter%ra$s is a sim$le $ro"e#ure usin% te %ra$i"al features in s$rea#seet $ro%rams' To ma+e $re#i"tions( mana%ers &isually fit a line to te #ata $oints !it te %eneral i#ea to try to minimi3e te #e&iations of te #ata $oints from te fitte# line' Te meto#s meto#s !e use to estimate estimate "ost )ea&ior )ea&ior assume tat "osts are linear' linear' In oter !or#s( tey assume tat "osts are !ell re$resente# )y strai%t lines' A s"atter%ra$ is useful in assessin% !eter tis assum$tion is reasona)le' Te s"atter%ra$ is also useful in assessin% !eter tere are any outliers .#ata $oints tat are mar+e#ly at o##s !it te tren# of oter #ata $oints/' Illustrations 7-6 an# 7-12 in te te0t)oo+ %i&e an e0am$le of estimatin% fi0e# an# &aria)le "ost usin% te s"atter%ra$ a$$roa"' Te hi'h-lo metho! fits a strai%t line to te #ata $oints re$resentin% te i%est an# lo!est le&els of a"ti&ity' Te slo$e of te line is te estimate of &aria)le "ost .)e"ause te slo$e measures te "an%e in "ost $er unit "an%e in a"ti&ity/( an# te inter"e$t .!ere te line meets te "ost a0is/ is te
Chapter 4 Cost-Volume-Profit Analysis
7*
estimate of total fi0e# "ost' Te slo$e is e*ual to te "an%e in "ost #i&i#e# )y te "an%e in a"ti&ity' Tus te estimate of &aria)le "ost .te slo$e/ is "al"ulate# as> Estimate of Varia)le Cost B Estimate of Varia)le Cost
B
Can%e in "ost Can%e in a"ti&ity
Cost at i%est le&el of a"ti&ity @ Cost at lo!est le&el of a"ti&ity i%est le&el of a"ti&ity @ Lo!est le&el of a"ti&ity
Te fi0e# "ost e*uals te #ifferen"e )et!een total "ost an# estimate# total &aria)le "ost at eiter te i% or lo! $oint' Fi0e# "osts !ill )e te same !eter "al"ulate# usin% te i%est le&el of a"ti&ity or te lo!est le&el of a"ti&ity' Te i%-lo! meto# is sim$le to #o( )ut not relia)le' ,e"ause only te i%est an# lo!est measures of a"ti&ity are use#( tese may not )e re$resentati&e of te ty$i"al "ost )ea&ior' +e'ression analysis is a statisti"al te"ni*ue tat uses all te a&aila)le #ata $oints to estimate te inter"e$t an# slo$e of a "ost e*uation' Te line fitte# to te #ata )y re%ression is te )est strai%tline fit to te #ata' Te formulas use# in "on#u"tin% re%ression analysis are "om$le0' o!e&er( soft!are $ro%rams tat $erform re%ression analysis are !i#ely a&aila)le' o! to use E0"el to "on#u"t re%ression analysis is e0$laine# in te a$$en#i0 to tis "a$ter' Re%ression analysis is "o&ere# in intro#u"tory statisti"s "lasses' Te a$$li"ation of re%ression analysis yiel#s te follo!in% e*uation> Total "ost B Fi0e# "ost D .Varia)le "ost $er unit 0 a"ti&ity le&el in units/ Estimates of fi0e# an# &aria)le "osts are only &ali# for a limite# ran%e of a"ti&ity' Te rele&ant ran%e is te ran%e of a"ti&ity for !i" estimates an# $re#i"tions are e0$e"te# to )e a""urate' Outsi#e te rele&ant ran%e( estimates of fi0e# an# &aria)le "osts may not )e &ery useful' Often( mana%ers are not "onfi#ent usin% estimates of fi0e# an# &aria)le "osts in ma+in% $re#i"tions for a"ti&ity le&els tat a&e not )een en"ountere# in te $ast' Sin"e te a"ti&ity le&els a&e not )een en"ountere# in te $ast( $ast relations )et!een "ost an# a"ti&ity may not )e a useful )asis for estimatin% "osts in tis situation' In some "ases( a"tual "osts )ea&e in a manner tat is #ifferent from te "ost )ea&ior $atterns #is"usse# a)o&e' All tose $atterns im$ly linear .strai%t line/ relations )et!een "ost an# a"ti&ity' In te real !orl#( some "osts are nonlinear' LO*
Perform cost-volume-profit analysis for single products.
COST-VOLUME-PROFIT ANALYSIS ,he Profit .uation / On"e fi0e# an# &aria)le "osts a&e )een estimate#( "ost-&olume-$rofit .CVP/ analysis "an )e "on#u"te#' CVP analysis is any analysis tat e0$lores te relations amon% "ost( &olume or a"ti&ity le&els( an# $rofit' Fun#amental to CVP analysis is te profit e.uation !i" states tat $rofit is e*ual to re&enue .sellin% $ri"e times *uantity/ minus &aria)le "ost .&aria)le "ost $er unit times *uantity/ minus total fi0e# "ost' Profit ere 0 SP VC TFC
0 $P() / VC() / ,FC B uantity of units $ro#u"e# an# sol# B Sellin% $ri"e $er unit B Varia)le "ost $er unit B Total fi0e# "ost
74
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
rea2-ven Point / One of te $rimary uses of CVP analysis is to "al"ulate te brea2-even point3 Te )rea+-e&en $oint is te num)er of units tat must )e sol# for a "om$any to )rea+ e&enGto neiter earn a $rofit nor in"ur a loss' To "al"ulate te )rea+-e&en $oint( !e set te $rofit e*uation e*ual to 3ero' Ten !e insert te a$$ro$riate sellin% $ri"e( &aria)le "ost( an# fi0e# "ost information an# sol&e for te *uantity (x)' For e0am$le( su$$ose Co#eConne"t $ro#u"es a $ro#u"t tat sells for 5922 $er unit( &aria)le "osts are estimate# to )e 562'
2 2 5126'1:0 0
B 5922.0/ - 562'
Sol&in% for x yiel#s a )rea+-e&en *uantity of 1(7< units' To e0$ress te )rea+-e&en in #ollars of sales rater tan units( te *uantity is sim$ly multi$lie# )y te sellin% $ri"e of 5922 to yiel# 596H(22' &ar'in of $afety / To e0$ress o! "lose mana%ers e0$e"t to )e to te )rea+-e&en le&el( tey may "al"ulate te mar%in of safety' Te mar'in of safety is te #ifferen"e )et!een te e0$e"te# le&el of sales an# )rea+-e&en sales' For e0am$le( if )rea+-e&en sales are 596H(22 an# mana%ement e0$e"ts to a&e sales of 5HJ2(222( te mar%in of safety is 5J(722 .5HJ2(222 - 596H(22/' &ar'in of $afety 0 pecte! sales / rea2-even sales
Te mar%in of safety "an also )e e0$resse# as a ratio "alle# te mar%in of safety ratio' It is e*ual to te mar%in of safety #i&i#e# )y e0$e"te# sales' Mar%in of Safety Ratio
B
Mar%in of Safety E0$e"te# Sales
Contribution &ar'in / Te $rofit e*uation "an )e re!ritten )y "om)inin% te terms !it x in tem to yiel# te contribution mar'in per unit3 Te "ontri)ution mar%in is #efine# as te #ifferen"e )et!een te sellin% $ri"e $er unit .SP/ an# &aria)le "ost $er unit .VC/' Profit is ten "al"ulate# as te #ifferen"e )et!een te "ontri)ution mar%in times te le&el of a"ti&ity an# te total fi0e# "osts .TFC/'
Profit B SP.0/ @ VC.0/ @ TFC Profit B .SP-VC/.0/ @ TFC Profit B Contri)ution mar%in $er unit .0/ @ TFC Te "ontri)ution mar%in $er unit measures te amount of in"remental $rofit %enerate# )y sellin% an a##itional unit' en sales an# $ro#u"tion in"rease )y one unit te "om$any )enefits from re&enue .sellin% $ri"e/( )ut tat )enefit is re#u"e# )y &aria)le "ost $er unit' Fi0e# "osts #o not affe"t te incremental $rofit asso"iate# !it sellin% an a##itional unit )e"ause fi0e# "osts are not affe"te# )y "an%es in &olume' Note tat if !e multi$ly te "ontri)ution mar%in $er unit )y te num)er of units sol#( !e o)tain te total in"remental $rofit relate# to te units sol#' nits nee!e! to chieve Profit ,ar'et / If !e sol&e te $rofit e*uation for te sales *uantity in units( !e %et a formula for "al"ulatin% te )rea+-e&en for te le&el of sales in units or for "al"ulatin% te num)er of units nee#e# to a"ie&e a s$e"ifie# or tar%et le&el of $rofit'
Chapter 4 Cost-Volume-Profit Analysis
Unit sales .K/ nee#e# to attain s$e"ifie# $rofit
B
Unit sales .K/ nee#e# to attain s$e"ifie# $rofit
B
75
Profit D TFC SP @ VC Profit D TFC Contri)ution mar%in $er unit
Te contribution mar'in ratio measures te amount of in"remental $rofit %enerate# )y an a##itional #ollar of sales' It is e*ual to te "ontri)ution mar%in $er unit #i&i#e# )y te sellin% $ri"e' Contri)ution mar%in ratio B
SP @ VC SP
e "an e0$ress te $rofit e*uation in terms of te "ontri)ution mar%in ratio as> =ollar sales nee#e# to attain s$e"ifie# $rofit
B
Profit D TFC Contri)ution mar%in ratio
Te $rofit e*uation also "an so! o! $rofit !ill )e affe"te# )y &arious o$tions un#er "onsi#eration )y mana%ement' Su" analysis is sometimes referre# to as 6hat if analysis )e"ause it e0amines what !ill a$$en if a $arti"ular a"tion is ta+en' LO4
Perform cost-volume-profit analysis for multiple products.
MULTIPLEPRO=UCT ANALYSIS Contribution &ar'in pproach @ CVP analysis "an )e e0ten#e# to "o&er multi$le $ro#u"ts' If te $ro#u"ts a "om$any sells are similar .e'%' &arious fla&ors of i"e "ream( &arious mo#els of similar )oats/( te !ei%te# a&era%e "ontri)ution mar%in $er unit "an )e use# in CVP analysis' Te !ei%te# a&era%e "ontri)ution mar%in $er unit is "al"ulate# e0a"tly te same as "ontri)ution mar%in $er unit for a sin%le $ro#u"t e0"e$t tat o&erall fi%ures are use#' Contribution &ar'in +atio pproach @ If te $ro#u"ts tat a "om$any sells are su)stantially #ifferent( CVP analysis soul# )e $erforme# usin% te "ontri)ution mar%in ratio' en a "om$any sells many #ifferent $ro#u"ts( o! many units must )e sol# to )rea+ e&en or ma+e a $rofit is not a$$ro$riate' A more a$$ro$riate measure is o! mu" sales must )e ma#e to )rea+ e&en or %enerate a $rofit' To "al"ulate o! mu" sales #ollars are nee#e#( te "ontri)ution mar%in ratio( rater tan te "ontri)ution mar%in $er unit( soul# )e use#' Te "ontri)ution mar%in ratio "an also )e use# to analy3e te effe"t on net in"ome of a "an%e in total "om$any sales'
ASSUMPTIONS IN CVP ANALYSIS ene&er CVP analysis is $erforme#( a num)er of assum$tions are ma#e tat affe"t te &ali#ity of te analysis> Costs "an )e a""urately se$arate# into teir fi0e# an# &aria)le "om$onents' • Fi0e# "osts remain fi0e#' • Varia)le "osts $er unit #o not "an%e o&er te a"ti&ity le&els of interest' • en $erformin% multi$ro#u"t CVP analysis( it is assume# tat te mi0 remains "onstant' • Sellin% $ri"e $er unit #oes not "an%e' •
78
LO5
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
Discuss the effect of operating leverage.
OPERATIN LEVERAE Operatin' levera'e relates to te le&el of fi0e# &ersus &aria)le "osts in a firm4s "ost stru"ture' Firms tat a&e relati&ely i% le&els of fi0e# "ost are sai# to a&e i% o$eratin% le&era%e' Te le&el of o$eratin% le&era%e is im$ortant )e"ause it affe"ts te "an%e in $rofit !en sales "an%e' Firms tat a&e i% o$eratin% le&era%es are %enerally tou%t to )e more ris+y )e"ause tey ten# to a&e lar%e flu"tuations in $rofit !en sales flu"tuate' ,e"ause of fi0e# "osts in te "ost stru"ture( !en sales in"rease )y say 12 $er"ent( $rofit !ill in"rease )y more tan 12 $er"ent' Te only time $rofit !ill in"rease )y te same $er"ent as sales is !en all "osts are &aria)le' If all "osts &ary in $ro$ortion to sales .i'e'( all "osts are &aria)le/( ten $rofit !ill &ary in $ro$ortion to sales' LO8
Use the contribution margin per unit of the constraint to analyze situations involving a resource constraint.
CONSTRAINTS In many "ases tere are "onstraints on o! many items "an )e $ro#u"e# or o! mu" ser&i"e "an )e $ro&i#e#' E0am$les of "onstraints fa"e# )y mana%ers in"lu#e sorta%es of s$a"e( e*ui$ment( or la)or' In su" "ases( te fo"us sifts from te contribution mar'in per unit to te contribution mar'in per unit of the constraint3 For e0am$le( su$$ose a "om$any "an $ro#u"e eiter Pro#u"t A or Pro#u"t , usin% te same e*ui$ment' Te "ontri)ution mar%in of A is 5922' Te "ontri)ution mar%in of , is 5122' Assume only 1(222 ma"ine ours are a&aila)le an# Pro#u"t A re*uires 12 ours of ma"ine time to $ro#u"e one unit !ile Pro#u"t , re*uires only 9 ours $er unit' Te "om$any !oul# only $ro#u"e Pro#u"t ,' Altou% its "ontri)ution mar%in is smaller( it "ontri)utes 5J2 $er ma"ine our( !ereas Pro#u"t A "ontri)utes only 592 $er ma"ine our' it 1(222 ma"ine ours a&aila)le( Pro#u"t A "an %enerate 592(222 of "ontri)ution mar%in !ile , "an %enerate 5J2(222 of "ontri)ution mar%in' PP9":;
Using Regression in Ecel ! to Estimate "ied and #ariable $osts.
Te a$$en#i0 uses #ata for Co#eConne"t $resente# in Illustration 7-: in te te0t)oo+ to illustrate te Re%ression fun"tion in E0"el' Te s$rea#seet $ro%ram ma+es performing re%ression analysis &ery easy' o!e&er( it #oes not ma+e understanding re%ression analysis easy On"e you a&e installe# te #ata analysis $ro%rams( o$en a s$rea#seet an# enter te $ro#u"tion an# "ost #ata from Illustration 7-:' No! %o un#er Data ta) an# s"roll #o!n to Data Analysis' Ten s"roll #o!n to Regression an# "li"+ O' Un#er Input Y ( s"roll #o!n from ,1 to ,1H .note tat tis in"lu#es te ea#in% Cost)' Un#er Input X, s"roll #o!n from A1 to A1H .tis in"lu#es te ea#in% Pro!uction/' Cli"+ on La)els !i" in#i"ates tat you a&e la)els in Pro#u"tion an# Cost #ata "olumns' Un#er output options ( "li"+ on ew wor!"oo! ' Un#er residuals ( "li"+ on #ine fit plot ' Tis in#i"ates tat you !ant a $lot of #ata an# te re%ression line' Inter$retation of "riti"al elements .te $lot( R S*uare( Inter"e$t an# Slo$e of te Re%ression Line( an# P-Value/ of te re%ression out$ut is im$ortant' ,he plot of te #ata an# te $lot of te re%ression line in#i"ate tat te #ata line u$ *uite "lose to te re%ression line' Tis su%%ests tat a strai%t line fit to te #ata !ill )e *uite su""essful' + $.uare is a statisti"al measure of o! !ell te re%ression line fits te #ata' R S*uare ran%es from a lo! of 2( in#i"atin% tat tere is no linear relation )et!een "ost an# $ro#u"tion( to a i% of 1( in#i"atin% tat tere is a $erfe"t linear relation )et!een
Chapter 4 Cost-Volume-Profit Analysis
77
"ost an# $ro#u"tion' Te intercept of the re'ression line is inter$rete# as te estimate of fi0e# "ost !ile te slope of the re'ression line is inter$rete# as te &aria)le "ost $er unit' Te p-values "orres$on#in% to te inter"e$t an# te slo$e measure te $ro)a)ility of o)ser&in% &alues as lar%e as te estimate# "oeffi"ients !en te true &alues are 3ero'
7<
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
Review o !e" Terms ccount analysis= A meto# of estimatin% "ost )ea&ior !i" re*uires $rofessional ?u#%ment to "lassify "osts as eiter fi0e# or &aria)le' Te total of te "osts "lassifie# as &aria)le are #i&i#e# )y a measure of a"ti&ity to "al"ulate te &aria)le "ost $er unit of a"ti&ity' Te total of te "osts "lassifie# as fi0e# $ro&i#es te estimate of fi0e# "ost' .19H/ rea2-even point= Te num)er of units a "om$any must sell to earn a 3ero $rofit' .1H2/ Committe! fie! costs= Tose fi0e# "osts tat "annot )e easily "an%e# in te sort-run' .199/ Contribution mar'in= Te #ifferen"e )et!een sales an# &aria)le "osts' .1H9/ Contribution mar'in ratio= Te "ontri)ution mar%in #i&i#e# )y sales or te "ontri)ution mar%in $er unit #i&i#e# )y te sellin% $ri"e' .1HH/ Cost-volume-profit (CVP)= Te analysis of o! "osts an# $rofit "an%e !en &olume "an%es' .116/ "iscretionary fie! costs= Tose fi0e# "osts tat mana%ement "an easily "an%e in te sort-run' .191/ Fie! cost= Costs tat #o not "an%e !en tere is a "an%e in )usiness a"ti&ity' .192/ >i'h-lo metho!= A meto# of estimatin% fi0e# an# &aria)le "ost "om$onents in !i" a strai%t line is fitte# to te #ata $oints re$resentin% te i%est an# lo!est le&els of a"ti&ity' .19/ &ar'in of safety= Te #ifferen"e )et!een te e0$e"te# le&el of sales an# )rea+-e&en sales' .1H1/
&ie! cost= Costs tat "ontain )ot &aria)le an# fi0e# "ost elements' .199/ Operatin' levera'e= Le&el of fi0e# &ersus &aria)le "osts in a firm4s "ost stru"ture' Firms tat a&e relati&ely i% le&els of fi0e# "ost are sai# to a&e i% o$eratin% le&era%e' .172/ Profit e.uation= E*uation tat states tat $rofit is e*ual to re&enue .sellin% $ri"e times *uantity/ minus &aria)le "ost .&aria)le "ost $er unit times *uantity/ minus total fi0e# "ost' .1H2/ +e'ression analysis= A statisti"al te"ni*ue use# to estimate te inter"e$t .an estimate of fi0e# "ost/ an# te slo$e .an estimate of &aria)le "ost/ of a "ost e*uation' .19 +elevant ran'e= Te ran%e of a"ti&ity for !i" estimates an# $re#i"tions are li+ely to )e a""urate' .19 $catter'raph= A %ra$ of "osts at &arious a"ti&ity le&els' .19J/ $emivariable costs= Costs tat "ontain )ot &aria)le an# fi0e# "ost elements' .199/ $tep costs= Tose "osts tat are fi0e# for a ran%e of &alue )ut in"rease to a i%er le&el !en te u$$er )oun# of te ran%e is e0"ee#e#' .199/ Variable costs= Tose "osts tat in"rease or #e"rease in res$onse to in"reases or #e"reases in )usiness a"ti&ity' .192/ 6?hat if analysis= An e0amination of te results of &arious "ourses of a"tion' .1HH/
Chapter 4 Cost-Volume-Profit Analysis
7@
C#a$ter 4 % True&'a(se 1'
T!o "ommon fi0e# "osts are rent an# sales "ommissions'
9'
Varia)le "osts( in total( "an%e in&ersely !it "an%es in a"ti&ity'
H'
Mi0e# "osts "ontain elements of )ot #ire"t material an# #ire"t la)or'
7'
Te a""ount analysis meto# is su)?e"ti&e in tat #ifferent mana%ers usin% te same set of fa"ts may rea" #ifferent "on"lusions re%ar#in% te "lassifi"ation of "osts into fi0e# an# &aria)le "om$onents'
J'
Usin% te i%-lo! meto# to "lassify "osts as fi0e# or &aria)le( te slo$e of te line is te estimate of &aria)le "ost'
'
Te le&el of o$eratin% le&era%e is im$ortant )e"ause it affe"ts te "an%e in $rofit !en sales "an%e'
:'
To "al"ulate te )rea+-e&en $oint( te $rofit e*uation is set to 51( an# ten te a$$ro$riate sellin% $ri"e( &aria)le "ost( an# fi0e# "ost information are inserte# into te e*uation'
<'
Te "ontri)ution mar%in is e*ual to te #ifferen"e in te sellin% $ri"e $er unit an# fi0e# "ost $er unit'
6'
Firms tat a&e relati&ely i% le&els of fi0e# "ost are sai# to a&e i% o$eratin% le&era%e'
12'
Te "ontri)ution mar%in $er unit measures te amount of in"remental $rofit %enerate# )y sellin% an a##itional unit'
11'
One of te $rimary uses of CVP analysis is to "al"ulate te )rea+-e&en $oint'
19'
Fi0e# "osts #o not affe"t te in"remental $rofit asso"iate# !it sellin% an a##itional unit )e"ause fi0e# "osts are not affe"te# )y "an%es in &olume'
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
C#a$ter 4 % !e" Terms )atc#in* Mat" te terms foun# in Ca$ter 7 !it te follo!in% #efinitions> a' )' "' #' e' f'
A""ount analysis ,rea+-e&en $oint Contri)ution mar%in i%-lo! meto# Mi0e# "ost Mar%in of safety
%' O$eratin% le&era%e ' Profit e*uation i' Re%ression analysis ?' S"atter%ra$ +' Ste$ "osts l' at if analysis
1'
A %ra$ of "osts at &arious a"ti&ity le&els'
9'
E*uation tat states tat $rofit is e*ual to re&enue .sellin% $ri"e times *uantity/ minus &aria)le "ost .&aria)le "ost $er unit times *uantity/ minus total fi0e# "ost'
H'
An e0amination of te results of &arious "ourses of a"tion'
7'
Te num)er of units a "om$any must sell to earn a 3ero $rofit'
J'
Costs tat "ontain )ot &aria)le an# fi0e# elements'
'
A meto# of estimatin% "ost )ea&ior !i" re*uires $rofessional ?u#%ment to "lassify "osts as eiter fi0e# or &aria)le'
:'
Te #ifferen"e )et!een sales an# &aria)le "osts'
<'
A statisti"al te"ni*ue use# to estimate te inter"e$t .an estimate of fi0e# "ost/ an# te slo$e .an estimate of &aria)le "ost/ of a "ost e*uation'
6'
Te #ifferen"e )et!een te e0$e"te# le&el of sales an# )rea+-e&en sales'
12' Tose "osts tat are fi0e# for a ran%e of &alue )ut in"rease to a i%er le&el !en te u$$er )oun# of te ran%e is e0"ee#e#' 11' Le&el of fi0e# &ersus &aria)le "osts in a firm4s "ost stru"ture' 19' A meto# of estimatin% fi0e# an# &aria)le "ost "om$onents in !i" a strai%t line is fitte# to te #ata $oints re$resentin% te i%est an# lo!est le&els of a"ti&ity'
Chapter 4 Cost-Volume-Profit Analysis
<1
C#a$ter 4 % )u(ti$(e C#oice 1'
Mi0e# "osts are also referre# to as> a' #ou)le "osts' )' assorte# "osts' "' sun#ry "osts' #' semi&aria)le "osts'
9'
i" of te follo!in% meto#s uses a statisti"al te"ni*ue to estimate fi0e# an# &aria)le "ostsQ a' S"atter%ra$' )' Re%ression analysis' "' A""ount analysis' #' i%-lo! meto#'
H'
An e0am$le of a #is"retionary fi0e# "ost is> a' a#&ertisin%' )' in#ire"t la)or' "' rent' #' #e$re"iation'
se the folloin' information to anser .uestions 4 throu'h <' Vi"+ Com$any $ro#u"es )oat motors' Te sellin% $ri"e $er motor is 51(922' Te &aria)le "ost $er motor is 5J22 an# te fi0e# "ost $er $erio# is 5<(:22' Vi"+ e0$e"ts to sell 9J motors #urin% te $erio#
7'
Te "ontri)ution mar%in $er unit is> a' 5H7<' )' 5J22' "' 5:22' #' 5
J'
Te )rea+-e&en $oint in units is> a' 12' )' 1H' "' 1<' #' 9J'
'
Te )rea+-e&en $oint in #ollars is> a' 519(222' )' 51J(22' "' 591(22' #' 5H2(222'
:'
Te "ontri)ution mar%in ratio is> a' 96'2' )' 71':' "' J<'H' #' :2'<'
<#
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
<'
Te mar%in of safety is> a' 5<(:22' )' 517(722' "' 51<(222' #' 5H2(222'
6'
Te tree elements of te $rofit e*uation are> a' sellin% $ri"e $er unit( &aria)le "ost $er unit( an# fi0e# "ost $er unit' )' total re&enue( total &aria)le "osts $er unit( an# total fi0e# "ost' "' sellin% $ri"e $er unit( &aria)le "ost $er unit( an# total fi0e# "osts' #' sellin% $ri"e $er unit( total &aria)le "osts( an# fi0e# "ost $er unit'
12'
Te "ontri)ution mar%in ratio $ro&i#es a measure of> a' te "ontri)ution of e&ery sales #ollar to "o&erin% fi0e# "ost an# %eneratin% a $rofit' )' te "ontri)ution of e&ery sales #ollar to "o&erin% &aria)le "ost an# %eneratin% a $rofit' "' te "ontri)ution of e&ery sales #ollar to "o&erin% &aria)le an# fi0e# "osts an# %eneratin% a $rofit' #' none of te a)o&e'
11'
i" of te follo!in% assum$tions ma#e !en usin% CVP analysis mi%t affe"t te &ali#ity of te analysisQ a' Costs "an )e a""urately se$arate# into teir fi0e# an# &aria)le "om$onents' )' Fi0e# "osts remain fi0e# an# &aria)le "osts $er unit #o not "an%e o&er te a"ti&ity le&els of interest' "' ,ot a an# )' #' Neiter a nor )'
19'
=alton Com$any "an $ro#u"e Pro#u"t A an# Pro#u"t , usin% te same e*ui$ment' Te "ontri)ution mar%in for A is 5922 !ile te "ontri)ution mar%in for , is 51J2' =alton as only 1(222 ours of ma"ine time a&aila)le' Pro#u"t A re*uires 1 ma"ine our to $ro#u"e one unit !ile Pro#u"t , re*uires 189 ma"ine our to $ro#u"e one unit' i" of te follo!in% units soul# =alton $ro#u"eQ a' Pro#u"t A )e"ause te "ontri)ution mar%in of 5922 is %reater tan te "ontri)ution mar%in of 51J2 for Pro#u"t ,' )' Pro#u"t , )e"ause te "ontri)ution mar%in $er "onstraint of 5H22 is %reater tan te "ontri)ution mar%in $er "onstraint of 5922 for Pro#u"t A' "' Pro#u"t A an# Pro#u"t , $ro$ortionately a""or#in% to teir res$e"ti&e "ontri)ution mar%ins' #' Pro#u"t A an# Pro#u"t , e*ually'
Chapter 4 Cost-Volume-Profit Analysis
<*
E+ercise 4 %
=urin% a re"ent si0-mont $erio#( Connie4s olesale Cu$"a+es a# te follo!in% montly &olume of "u$"a+es sol# an# total montly utilities e0$ense> &onth ;anuary Fe)ruary Mar" A$ril May ;une
9umber of Cupca2es H(J22 J(722 7(622 6(222 :(<22 (H22
tilities pense 5 622 1(H92 1(<22 9(112 9(222 9(22
Re*uire#> 1'
Com$ute te estimate# &aria)le "ost $er "u$"a+e for utilities e0$ense' 9umber of Cupca2es
tilities pense
i% le&el of a"ti&ity Lo! le&el of a"ti&ity Can%e
Estimate of Varia)le "ost 9'
B
Can%e in "ost Can%e in a"ti&ity
5
"u$"a+es
B 5 $er "u$"a+e
Com$ute te total estimate# fi0e# "ost $er mont for utilities e0$ense' Total "ost at te i% le&el of a"ti&ity
Less &aria)le "ost
Fi0e# "ost
H'
Com$ute te total amount of utilities e0$ense tat !oul# )e in"urre# at a le&el of 9(922 "u$"a+es' Varia)le "ost at a le&el of 9(922 "u$"a+es
Fi0e# "ost at a le&el of 9(922 "u$"a+es
Total utility "ost at a le&el of 9(922 "u$"a+es
<4
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
E+ercise 4 % -
arren( In"' as a sellin% $ri"e of 5<22 $er unit for its $ro#u"ts'' Varia)le "osts $er unit are 522 an# fi0e# "osts total 51J2(222 1'
at is te "ontri)ution mar%in $er unitQ
9'
at is te "ontri)ution mar%in ratioQ
H'
Com$ute te )rea+-e&en $oint in units'
7'
Com$ute te )rea+-e&en $oint in #ollar &olume of re&enue'
J'
Pro&e your ans!ers in $arts H an# 7 )y $re$arin% a "ontri)ution mar%in in"ome statement in %oo# or#er'
Re&enue
?arrenB :nc3 Contribution &ar'in :ncome $tatement une *AB #A1*
Less &aria)le "osts
Contri)ution mar%in
Less fi0e# "osts
Net in"ome
Chapter 4 Cost-Volume-Profit Analysis
E+ercise 4./
<5
For se&eral years( ,ella%io4s Restaurant as offere# a lun" s$e"ial for 5:'22' Montly fi0e# e0$enses a&e )een 57(922' Te &aria)le "ost of a meal as )een 59'12' Antony ,ella%io( te o!ner( )elie&es tat )y remo#elin% te restaurant an# u$%ra#in% te foo# ser&i"es( e "an in"rease te $ri"e of te lun" s$e"ial to 5:'72' Montly fi0e# e0$enses !oul# in"rease to 57(<22 an# te &aria)le e0$enses !oul# in"rease to 59'6 $er meal'
1'
Com$ute ,ella%ios montly )rea+-e&en sales in #ollars )efore remo#elin%'
9'
Com$ute ,ella%ios montly )rea+-e&en sales in #ollars after remo#elin%'
H'
at re"ommen#ation !oul# you ma+e to Antony ,ella%io "on"ernin% remo#elin% te restaurantQ
<8
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
Prob(em 4 % 4
o%an Manufa"turin% Com$any ma+es an# sells a sin%le $ro#u"t' Te "om$anys sales an# e0$enses for te most re"ent mont are %i&en )elo!> ,otal
Sales Less &aria)le e0$enses Contri)ution mar%in Less fi0e# e0$enses Net in"ome
5J22(222 H72(222 512(222 <2(222 5 <2(222
Per nit 5
9J 1: <
122 < H9
1' at is te montly )rea+-e&en $oint in units an# in sales #ollarsQ
9' itout resortin% to "om$utations( !at is te total "ontri)ution mar%in at te )rea+-e&en $ointQ
H' o! many units !oul# a&e to )e sol# ea" mont to earn a minimum tar%et net in"ome of 5122(222Q Pro&e your ans!er )y $re$arin% a "ontri)ution in"ome statement at te tar%et le&el of sales'
7' Assumin% o%an in"reases sales )y 12( o! mu" !ill net in"ome in"reaseQ
J' Pro&e your ans!er in $art 7 )y $re$arin% a "ontri)ution mar%in in"ome statement at tat le&el of a"ti&ity'
Chapter 4 Cost-Volume-Profit Analysis
<7
0o(utions % True&'a(se 1' 9' H' 7' J' ' :'
F F T T T F
<' F 6' 12' 11' 19'
F A "ommon fi0e# "ost is rent an# a "ommon &aria)le "ost is sales "ommissions' Varia)le "osts in total "an%e $ro$ortionately !it "an%es in a"ti&ity' Mi0e# "osts "ontain elements of )ot fi0e# "ost an# &aria)le "ost'
To "al"ulate te )rea+-e&en $oint( te $rofit e*uation is set to 3ero( an# ten insert te a$$ro$riate sellin% $ri"e( &aria)le "ost( an# fi0e# "ost information' Te "ontri)ution mar%in is e*ual to te #ifferen"e in te sellin% $ri"e $er unit an# &aria)le "ost $er unit'
T T T T
0o(utions % !e" Terms )atc#in* 1' 9' H' 7' J' '
?' S"atter%ra$ ' Profit e*uation l' at if analysis )' ,rea+-e&en $oint e' Mi0e# "ost a' A""ount analysis
:' <' 6' 12' 11' 19'
"' Contri)ution mar%in i' Re%ression analysis f' Mar%in of safety +' Ste$ "osts %' O$eratin% le&era%e #' i%-lo! meto#
0o(utions % )u(ti$(e C#oice 1' 9' H' 7' J' '
# ) a " ) )
:' <' 6' 12' 11' 19'
" ) " a " )
<<
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
0o(ution % E+ercise 4 %
=urin% a re"ent si0-mont $erio#( Connie4s olesale Cu$"a+es a# te follo!in% montly &olume of "u$"a+es sol# an# total montly utilities e0$ense> &onth ;anuary Fe)ruary Mar" A$ril May ;une
9umber of Cupca2es H(J22 J(722 7(622 6(222 :(<22 (H22
tilities pense 5 622 1(H92 1(<22 9(112 9(222 9(22
Re*uire#> a'
Com$ute te estimate# &aria)le "ost $er "u$"a+e for utilities e0$ense'
i% le&el of a"ti&ity Lo! le&el of a"ti&ity Can%e Estimate of Varia)le "ost )'
B
9umber of Cupca2es 6(222 H(J22 J(J22
Can%e in "ost Can%e in a"ti&ity
51(912 J(J22 "u$"a+es
B 52'99 $er "u$"a+e
Com$ute te total estimate# fi0e# "ost $er mont for utilities e0$ense' Total "ost at te i% le&el of a"ti&ity Less &aria)le "ost .6(222 0 52'99/ Fi0e# "ost
"'
tilities pense 59(112 622 51(912
59(112 1(6<2 5 1H2
Com$ute te total amount of utilities e0$ense tat !oul# )e in"urre# at a le&el of 9(922 "a+es' Varia)le "ost at a le&el of 9(922 "u$"a+es Fi0e# "ost at a le&el of 9(922 "u$"a+es Total utility "ost at a le&el of 9(922 "u$"a+es
57<7 1H2 517
Chapter 4 Cost-Volume-Profit Analysis
<@
0o(ution % E+ercise 4 % -
arren( In"' as a sellin% $ri"e of 5<22 $er unit for its $ro#u"ts'' Varia)le "osts $er unit are 522 an# fi0e# "osts total 51J2(222 1' at is te "ontri)ution mar%in $er unitQ Re&enue 5<22 Varia)le "ost 22 Contri)ution mar%in 5922 9' at is te "ontri)ution mar%in ratioQ Re&enue Varia)le "osts Contri)ution mar%in
5<22 22 5922
122 :J 9J
H' Com$ute te )rea+-e&en $oint in units' 51J2(222 ÷ 5922 B :J2 units 7' Com$ute te )rea+-e&en $oint in #ollar &olume of re&enue' 51J2(222 ÷ '9J B 522(222 J' Pro&e your ans!ers in $arts H an# 7 )y $re$arin% a "ontri)ution mar%in in"ome statement in %oo# or#er' arren( In"' Contri)ution Mar%in In"ome Statement ;une H2( 921H Re&enue .:J2 units 5<22/ Less &aria)le "osts .:J2 units 522/ Contri)ution mar%in Less fi0e# "osts Net in"ome
522(222 7J2(222 51J2(222 1J2(222 -2-
@A
$tu!y %ui!e to a""om$any ;iam)al&o Managerial Accounting
0o(ution % E+ercise 4 . /
For se&eral years( ,ella%io4s Restaurant as offere# a lun" s$e"ial for 5:'22' Montly fi0e# e0$enses a&e )een 57(922' Te &aria)le "ost of a meal as )een 59'12' Antony ,ella%io( te o!ner( )elie&es tat )y remo#elin% te restaurant an# u$%ra#in% te foo# ser&i"es( e "an in"rease te $ri"e of te lun" s$e"ial to 5:'72' Montly fi0e# e0$enses !oul# in"rease to 57(<22 an# te &aria)le e0$enses !oul# in"rease to 59'6 $er meal'
1' Com$ute ,ella%ios montly )rea+-e&en sales in #ollars )efore remo#elin%' Sales Varia)le "osts ontri)ution mar%in
5:'22 9'12 57'62
122 H2 :2
Fi0e# "osts ÷ CM ratio B ,EP in 5 &olume 57(922 ÷ ':2 B 5(222
9' Com$ute ,ella%ios montly )rea+-e&en sales in #ollars after remo#elin%' Sales Varia)le "osts Contri)ution mar%in
5:'72 9'6 57'77
122 72 2
Fi0e# "osts ÷ CM ratio B ,EP in 5 &olume 57(<22 ÷ '2 B 5<(222 H' at re"ommen#ation !oul# you ma+e to Antony ,ella%io "on"ernin% remo#elin% remo#elin% te restaurantQ Antony soul# not remo#el te restaurant )uil#in%' At te $resent time( e nee#s to a&e montly re&enue of only 5(222 to )rea+ e&en' o!e&er( !it te remo#elin%( e !oul# nee# montly re&enue of 5<(222 to )rea+-e&en'
Chapter 4 Cost-Volume-Profit Analysis
@1
0o(ution % Prob(em 4 % 4
o%an Manufa"turin% Com$any ma+es an# sells a sin%le $ro#u"t' Te "om$anys sales an# e0$enses for te most re"ent mont are %i&en )elo!> ,otal
Sales Less &aria)le e0$enses Contri)ution mar%in Less fi0e# e0$enses Net in"ome
5J22(222 H72(222 512(222 <2(222 5 <2(222
Per nit 5
9J 1: <
122 < H9
1' at is te montly )rea+-e&en $oint in units an# in sales #ollarsQ 5<2(222 5< B 12(222 units 5<2(222 'H9 B 59J2(222 9' itout resortin% to "om$utations( !at is te total "ontri)ution mar%in at te )rea+-e&en $ointQ 5<2(222 @ At te )rea+e&en $oint( "ontri)ution mar%in is al!ays e*ual to fi0e# "osts' H' o! many units !oul# a&e to )e sol# ea" mont to earn a minimum tar%et net in"ome of 5122(222Q Pro&e your ans!er )y $re$arin% a "ontri)ution in"ome statement at te tar%et le&el of sales' .5<2(222 D 5122(222/ 5< B 99(J22 units Sales .99(J22 0 9J/ Varia)le "osts .99(J22 0 51:/ Contri)ution mar%in Fi0e# "ost Net in"ome
5J9(J22 H<9(J22 1<2(222 <2(222 5122(222
7' Assumin% o%an in"reases sales )y 12( o! mu" !ill net in"ome in"reaseQ 51<2(222 0 '12 B 51<(222 J' Pro&e your ans!er in $art 7J )y $re$arin% a "ontri)ution in"ome statement at tat le&el of a"ti&ity' Sales .99(222 0 59J/ 5JJ2(222 Varia)le "osts .99(222 0 51:/ H:7(222 Contri)ution mar%in 1:(222 Fi0e# "ost <2(222 Net in"ome 5 6(222 5J22(222859J B 92(222 units 92(2220 1'12 B 99(222 units