Transcript Managerial Accounting - Natawidnyana's Weblog

Chapter 3
Cost Behavior Analysis
Types of Cost Behavior
Patterns
Recall the summary of our cost behavior
discussion from Chapter 2.
Summary of Variable and Fixed Cost Behavior
Cost
In Total
Per Unit
Variable
Total variable cost is
proportional to the activity
level within the relevant range.
Variable cost per unit remains
the same over wide ranges
of activity.
Fixed
Total fixed cost remains the
same even when the activity
level changes within the
relevant range.
Fixed cost per unit goes
down as activity level goes up.
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The Activity Base
Units
produce
d
Machine
hours
A measure of the
event that causes
the incurrence of a
variable cost – a
cost driver
Miles
driven
Cost Accounting – Third Sesion
Labor
hours
I Made R. Natawidnyana, Ak., CPMA
True Variable Cost Example
Total Long Distance
Telephone Bill
Your total long distance telephone bill is
based on how many minutes you talk.
Minutes Talked
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Variable Cost Per Unit Example
Per Minute
Telephone Charge
The cost per minute talked is constant. For
example, 10 cents per minute.
Minutes Talked
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Step-Variable Costs
Cost
Total cost remains
constant within a
narrow range of
activity.
Activity
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Step-Variable Costs
Cost
Total cost increases to a
new higher cost for the
next higher range of
activity.
Activity
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The Linearity Assumption and
the Relevant Range
Total Cost
A straight line
Economist’s
closely
Curvilinear Cost approximates a
Function
curvilinear
Relevant
Range
variable cost
line within the
relevant range.
Accountant’s Straight-Line
Approximation (constant
unit variable cost)
Activity
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Total Fixed Cost Example
Monthly Basic
Telephone Bill
Your monthly basic telephone bill is
probably fixed and does not change when
you make more local calls.
Number of Local Calls
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Fixed Cost Per Unit Example
Monthly Basic Telephone
Bill per Local Call
The fixed cost per local call decreases as
more local calls are made.
Number of Local Calls
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Cost Behavior
Examples of normally variable costs
Merchandisers
Service Organizations
Cost of Goods Sold
Supplies and travel
Manufacturers
Merchandisers and
Manufacturers
Direct Material, Direct
Labor, and Variable
Manufacturing Overhead
Sales commissions and
shipping costs
Examples of normally fixed costs
Merchandisers, manufacturers, and
service organizations
PBB taxes, Insurance, Sales salaries
Depreciation, Advertising
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Types of Fixed Costs
Committed
Discretionary
Long-term, cannot be
reduced in the short
term.
May be altered in the
short-term by current
managerial decisions
Examples
Examples
Depreciation on
Buildings and
Equipment
Advertising and
Research and
Development
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Fixed Costs and Relevant
Range
Example: Office space
is available at a rental
rate of $30,000 per year
in increments of 1,000
square feet. As the
business grows more
space is rented,
increasing the total cost.
Continue
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Rent Cost in
Thousands of Dollars
Fixed Costs and Relevant
Range
90
60
30
00
Cost Accounting – Third Sesion
Relevant
Range
Total cost doesn’t
change for a wide
range of activity,
and then jumps to a
new higher cost for
the next higher
range of activity.
1,000
2,000
3,000
Rented Area (Square Feet)
I Made R. Natawidnyana, Ak., CPMA
Fixed Costs and Relevant
Range
How does this type
of fixed cost differ
from a step-variable
cost?
Cost Accounting – Third Sesion
Step-variable costs
can be adjusted more
quickly and . . .
The width of the
activity steps is much
wider for the fixed
cost.
I Made R. Natawidnyana, Ak., CPMA
Semivariable Costs
A semivariable cost has both fixed and variable
components. Consider the example of utility cost.
Total Utility Cost
Y
Variable
Cost per KW
X
Activity (Kilowatt Hours)
Cost Accounting – Third Sesion
Fixed Monthly
Utility Charge
I Made R. Natawidnyana, Ak., CPMA
Semivariable Costs
The total semivariable cost line can be expresse
as an equation: Y = a + bX
Where:
Y = the total mixed cost
a = the total fixed cost (the
vertical intercept of the line)
b = the variable cost per unit of
activity (the slope of the line)
X = the level of activity
Total Utility Cost
Y
Variable
Cost per KW
Activity (Kilowatt Hours)
Cost Accounting – Third Sesion
X
Fixed Monthly
Utility Charge
I Made R. Natawidnyana, Ak., CPMA
The Analysis of Semivariable
Costs
1. High-Low Method
2. Scattergraph Method
3. Least-Square Regression Method
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The Scattergraph Method
Plot the data points on a
graph (total cost vs. activity).
Total Cost in
1,000’s of Dollars
Y
20
* *
* *
10
0
* ** *
**
X
0
1
2
3
4
Activity, 1,000’s of Units Produced
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The Scattergraph Method (2)
Draw a line through the data points with about an
equal numbers of points above and below the line.
Total Cost in
1,000’s of Dollars
Y
20
* ** *
**
* *
*
* Intercept
is the estimated
10
fixed cost (a) = $10,000
0
X
0
1
2
3
4
Activity, 1,000’s of Units Produced
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The Scattergraph Method (3)
The slope is the estimated variable cost per unit.
Slope = Change in cost ÷ Change in units
Total Cost in
1,000’s of Dollars
Y
20
* *
*
*Horizontal
10
distance is
the change in
activity.
0
* ** *
**
Vertical distance is
the change in cost.
X
0
1
2
3
4
Activity, 1,000’s of Units Produced
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The High-Low Method
WiseCo recorded the following production activity and
maintenance costs for two months:
High activity level
Low activity level
Change
Units
8,000
5,000
3,000
Cost
$ 9,800
7,400
$ 2,400
Using these two levels of activity, compute:
the variable cost per unit;
the fixed cost; and then
express the costs in equation form Y = a + bX.
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The High-Low Method
High activity level
Low activity level
Change
Units
8,000
5,000
3,000
Cost
$ 9,800
7,400
$ 2,400
in cost in units
 Variable cost per unit = ChangeChange
in cost ÷ change
Change in units
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The High-Low Method
High activity level
Low activity level
Change
Units
8,000
5,000
3,000
Cost
$ 9,800
7,400
$ 2,400
 Variable cost per unit = $2,400 ÷ 3,000 units
= $0.80 per unit
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The High-Low Method
High activity level
Low activity level
Change
Units
8,000
5,000
3,000
Cost
$ 9,800
7,400
$ 2,400
 Variable cost = $2,400 ÷ 3,000 units = $0.80 per unit
 Fixed cost = Total cost – Total variable cost
Fixed cost = $9,800 – ($0.80 per unit × 8,000 units)
Fixed cost = $9,800 – $6,400 = $3,400
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The High-Low Method
High activity level
Low activity level
Change
Units
8,000
5,000
3,000
Cost
$ 9,800
7,400
$ 2,400
 Variable cost = $2,400 ÷ 3,000 units = $0.80 per unit
 Fixed cost = Total cost – Total variable cost
Fixed cost = $9,800 – ($0.80 per unit × 8,000 units)
Fixed cost = $9,800 – $6,400 = $3,400
 Total cost = Fixed cost + Variable cost (Y = a + bX)
Y = $3,400 + $0.80X
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Least-Squares Regression
Method
Software can be used to fit
a regression line through
the data points.
The cost analysis objective
is the same: Y = a + bx
Least-squares regression also provides a statistic,
called the R2, that is a measure of the goodness
of fit of the regression line to the data points.
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
Least-Squares Regression
Method
R2 is the percentage of the variation in total cost
explained by the activity.
Y
Total Cost
20
* ** *
**
* *
* * R2 for this relationship is near
10
100% since the data points are
very close to the regression line.
0
0
Cost Accounting – Third Sesion
1
2
3
Activity
4
X
I Made R. Natawidnyana, Ak., CPMA
Cost Estimation Methods
Regression Analysis
A statistical method used to create an
equation relating independent (or X)
variables to dependent (or Y) variables.
Past data is used to estimate relationships
between costs and activities.
Independent variables
are the cost drivers that
are correlated with the
dependent variables.
Cost Accounting – Third Sesion
Dependent variables are
caused by the
independent variables.
I Made R. Natawidnyana, Ak., CPMA
Cost Estimation Methods
Regression Analysis
The simple cost model is actually a
regression model:
TC = F + VX
This model will only
be useful within a
relevant range of
activity.
Cost Accounting – Third Sesion
Caution: Before doing
the analysis, take time
to determine if a
logical relationship
between the variables
exists.
I Made R. Natawidnyana, Ak., CPMA
Cost Estimation Methods
Regression Analysis
A set of data can be regressed using several
techniques:
•Manual computations
•SPSS or SAS Statistical Software
•Excel or other spreadsheet
The result of the
regression process is a
regression model:
TC = F + VX
Cost Accounting – Third Sesion
Each regression model
has an R-square (R2)
measure of how good the
model is.
Range of R2 = 0 to 1.0
I Made R. Natawidnyana, Ak., CPMA
Simple Regression Analysis
Example
Fasco wants to
know its average
fixed cost and
variable cost per
unit.
Using the data to
the right, let’s see
how to do a
regression using
Excel.
Cost Accounting – Third Sesion
Month
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
Total Costs
$6,720
7,260
7,270
11,060
12,580
8,660
8,580
9,550
13,050
11,060
7,320
7,370
6,790
7,480
6,990
11,400
Units (Meals)
1,280
1,810
1,620
2,830
3,630
2,610
2,460
2,640
3,620
2,840
1,820
1,650
1,260
1,850
1,710
2,940
I Made R. Natawidnyana, Ak., CPMA
Simple Regression Analysis
Example
You will need three pieces
of information from your
regression analysis:
1. Estimated Variable Cost
per Unit (line slope)
2. Estimated Fixed Costs
(line intercept)
3. Goodness of fit, or R2
To get these three pieces
of information we will
need to use THREE
different excel functions.
LINEST, INTERCEPT, & RSQ
Cost Accounting – Third Sesion
Month
January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April
Total Costs
$6,720
7,260
7,270
11,060
12,580
8,660
8,580
9,550
13,050
11,060
7,320
7,370
6,790
7,480
6,990
11,400
Units (Meals)
1,280
1,810
1,620
2,830
3,630
2,610
2,460
2,640
3,620
2,840
1,820
1,650
1,260
1,850
1,710
2,940
I Made R. Natawidnyana, Ak., CPMA
Let’s put our
knowledge of cost
behavior to work by
preparing a
contribution format
income statement.
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The Contribution Format
Sales Revenue
Less: Variable costs
Contribution margin
Less: Fixed costs
Net operating income
Total
$ 100,000
60,000
$ 40,000
30,000
$ 10,000
Unit
$ 50
30
$ 20
The contribution margin format emphasizes cost
behavior. Contribution margin covers fixed costs
and provides for income.
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA
The Contribution Format
Used primarily for
external reporting.
Cost Accounting – Third Sesion
Used primarily by
management.
I Made R. Natawidnyana, Ak., CPMA
End of Session 3
Cost Accounting – Third Sesion
I Made R. Natawidnyana, Ak., CPMA