Module 5 - Factory Overhead Variance
Module 5 - Factory Overhead Variance
Module 5 - Factory Overhead Variance
Chapter 11
Chapter Eleven
Hmm! Comparing
static budgets with
Static budgets actual costs is like
are prepared for comparing apples
a single, planned and oranges.
level of activity.
Performance
evaluation is difficult
when actual activity
differs from the
planned level of
activity.
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Flexible Budgets
CheeseCo
Static Actual
Budget Results Variances
Machine hours 10,000
Variable costs
Indirect labor $ 40,000
Indirect materials 30,000
Power 5,000
Fixed costs
Depreciation 12,000
Insurance 2,000
Total overhead costs $ 89,000
CheeseCo
Static Actual
Budget Results Variances
Machine hours 10,000 8,000
Variable costs
Indirect labor $ 40,000 $ 34,000
Indirect materials 30,000 25,500
Power 5,000 3,800
Fixed costs
Depreciation 12,000 12,000
Insurance 2,000 2,050
Total overhead costs $ 89,000 $ 77,350
CheeseCo
Static Actual
Budget Results Variances
Machine hours 10,000 8,000 2,000 U
Variable costs
U = Unfavorable variance
Indirect labor $ 40,000 $ 34,000 $6,000 F
CheeseCo was30,000
Indirect materials
unable to achieve
25,500 4,500 F
Power the budgeted 5,000
level of activity.
3,800 1,200 F
Fixed costs
Depreciation 12,000 12,000 0
Insurance 2,000 2,050 50 U
Total overhead costs $ 89,000 $ 77,350 $11,650 F
CheeseCo
Static Actual
Budget Results Variances
Machine hours 10,000 8,000 2,000 U
Variable costs
Indirect labor $ 40,000 $ 34,000 $6,000 F
Indirect materials 30,000 25,500 4,500 F
Power 5,000 3,800 1,200 F
F = Favorable
Fixed costs variance that occurs when
actual costs are less than
Depreciation budgeted12,000
12,000 costs. 0
Insurance 2,000 2,050 50 U
Total overhead costs $ 89,000 $ 77,350 $11,650 F
CheeseCo
Static Actual
Budget Results Variances
Machine hours 10,000 8,000 2,000 U
Variable costs
Indirect labor $ 40,000 $ 34,000 $6,000 F
Indirect materials 30,000 25,500 4,500 F
Power 5,000 3,800 1,200 F
Since
Fixed cost variances are favorable, have
costs
we done a good job controlling
Depreciation 12,000 costs?
12,000 0
Insurance 2,000 2,050 50 U
Total overhead costs $ 89,000 $ 77,350 $11,650 F
I don’t think I
can answer the Actual activity is below
question using budgeted activity.
a static budget. So, shouldn’t variable costs
be lower if actual activity
is lower?
The
The relevant
relevant question
question is
is .. .. ..
“How
“How much
much of
of the
the favorable
favorable cost
cost variance
variance isis
due
due to
to lower
lower activity,
activity, and
and how
how much
much isis due
due to
to
good
good cost
cost control?”
control?”
To
To answer
answer the
the question,
question,
we
we must
must
the
the budget
budget toto the
the
actual
actual level
level of
of activity.
activity.
Let’s prepare
budgets
for CheeseCo.
CheeseCo
Cost Total Flexible Budgets
Formula Fixed 8,000 10,000 12,000
per Hour Cost Hours Hours Hours
Machine hours 8,000 10,000 12,000
Variable costs Variable costs are expressed as
Indirect labor $ 4.00 a constant amount per hour.
Indirect material 3.00
Power 0.50 $40,000 ÷ 10,000 hours is
Total variable cost $ 7.50 $4.00 per hour.
Fixed costs Fixed costs are
Depreciation $ 12,000
Insurance 2,000
expressed as a
Total fixed cost total amount.
Total overhead costs
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Preparing a Flexible Budget
CheeseCo
Cost Total Flexible Budgets
Formula Fixed 8,000 10,000 12,000
per Hour Cost Hours Hours Hours
Machine hours 8,000 10,000 12,000
Variable costs
Indirect labor $ 4.00 $ 32,000
Indirect material 3.00 24,000
Power 0.50 4,000
Total variable cost $ 7.50 $ 60,000
CheeseCo
Cost Total Flexible Budgets
Formula Fixed 8,000 10,000 12,000
per Hour Cost Hours Hours Hours
Machine hours 8,000 10,000 12,000
Variable costs
Indirect labor $ 4.00 $ 32,000
Indirect material 3.00 24,000
Power 0.50 4,000
Total variable cost $ 7.50 $ 60,000
Fixed costs
Depreciation $ 12,000 $ 12,000
Insurance 2,000 2,000
Total fixed cost $ 14,000
Total overhead costs $ 74,000
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Preparing a Flexible Budget
CheeseCo
Cost Total Flexible Budgets
Formula Fixed 8,000 10,000 12,000
per Hour Cost Hours Hours Hours
Machine hours 8,000 10,000 12,000
Variable costs
Indirect labor $ 4.00 $ 32,000 $ 40,000
Indirect material 3.00 fixed costs
Total 24,000 30,000
Power 0.50
do not change in4,000 5,000
Total variable cost $ 7.50 $ 60,000 $ 75,000
the relevant range.
Fixed costs
Depreciation $ 12,000 $ 12,000 $ 12,000
Insurance 2,000 2,000 2,000
Total fixed cost $ 14,000 $ 14,000
Total overhead costs $ 74,000 $ 89,000 ?
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check
What
What should
should be
be the
the total
total overhead
overhead costs
costs for
for the
the
Flexible
Flexible Budget
Budget at
at 12,000
12,000 hours?
hours?
a.
a. $92,500.
$92,500.
b.
b. $89,000.
$89,000.
c.
c. $106,800.
$106,800.
d.
d. $104,000.
$104,000.
What
What should
should be
be the
the total
total overhead
overhead costs
costs for
for the
the
Flexible
Flexible Budget
Budget at
at 12,000
12,000 hours?
hours?
a.
a. $92,500.
$92,500.
b.
b. $89,000.
$89,000.
c.
c. $106,800.
$106,800.
d.
d. $104,000.
$104,000.
Fixed costs
Depreciation $ 12,000 $ 12,000 $ 12,000 $ 12,000
Insurance 2,000 2,000 2,000 2,000
Total fixed cost $ 14,000 $ 14,000 $ 14,000
Total overhead costs $ 74,000 $ 89,000 $ 104,000
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Flexible Budget Performance Report
Let’s prepare a
budget performance
report
for CheeseCo.
Fixed costs
Depreciation $ 12,000 $ 12,000
Insurance 2,000 2,050
Total fixed cost $ 14,050
Total overhead costs $ 77,350
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check
What
What isis the
the variance
variance for
for indirect
indirect labor
labor when
when the
the
flexible
flexible budget
budget forfor 8,000
8,000 hours
hours is
is compared
compared toto the
the
actual
actual results?
results?
a.
a. $2,000
$2,000 U U
b.
b. $2,000
$2,000 FF
c.
c. $6,000
$6,000 U U
d.
d. $6,000
$6,000 FF
What
What isis the
the variance
variance for
for indirect
indirect labor
labor when
when the
the
flexible
flexible budget
budget forfor 8,000
8,000 hours
hours is
is compared
compared toto the
the
actual
actual results?
results?
a.
a. $2,000
$2,000 U U
b.
b. $2,000
$2,000 FF
c.
c. $6,000
$6,000 U U
d.
d. $6,000
$6,000 FF
Fixed costs
Depreciation $ 12,000 $ 12,000
Insurance 2,000 2,050
Total fixed cost $ 14,050
Total overhead costs $ 77,350
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check
What
What isis the
the variance
variance for
for indirect
indirect material
material when
when the
the
flexible
flexible budget
budget forfor 8,000
8,000 hours
hours is
is compared
compared to
to the
the
actual
actual results?
results?
a.
a. $1,500
$1,500 U U
b.
b. $1,500
$1,500 FF
c.
c. $4,500
$4,500 U U
d.
d. $4,500
$4,500 FF
What
What isis the
the variance
variance for
for indirect
indirect material
material when
when the
the
flexible
flexible budget
budget forfor 8,000
8,000 hours
hours is
is compared
compared to
to the
the
actual
actual results?
results?
a.
a. $1,500
$1,500 U U
b.
b. $1,500
$1,500 FF
c.
c. $4,500
$4,500 U U
d.
d. $4,500
$4,500 FF
Fixed costs
Depreciation $ 12,000 $ 12,000 $ 12,000 $ 0
Insurance 2,000 2,000 2,050 50 U
Total fixed cost $ 14,000 $ 14,050 50 U
Total overhead costs $ 74,000 $ 77,350 $ 3,350 U
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Flexible Budget Performance Report
Three important
factors in selecting an
activity base for an overhead
flexible budget
Activity
Activity base
base and
and Activity
Activity base
base should
should
variable
variable overhead
overhead be
be simple
simple and
and
should
should bebe easily
easily understood.
understood.
causally
causally related.
related.
Activity
Activity base
base should
should
not
not be
be expressed
expressed
in
in dollars
dollars or
or
McGraw-Hill/Irwin
other
other currency.
currency. Copyright © 2006. The McGraw-Hill Companies, Inc.
Variable Overhead Variances –
A Closer Look
Both spending
Only a spending
and efficiency
variance can be
variances can be
computed.
computed.
Spending Variance
= $140 unfavorable
Spending Variance
Results from paying more
or less than expected for
overhead items and from Now,
Now,let’s
let’suse
usethe
the
excessive usage of standard
standardhours
hoursallowed,
allowed,
overhead items. along
alongwith
withthe
theactual
actual
hours,
hours, totocompute
computethe the
efficiency
efficiencyvariance.
variance.
Spending Efficiency
Variance Variance
Spending variance = AH(AR - SR)
Efficiency variance = SR(AH - SH)
Efficiency Variance
Controlled by
managing the
overhead cost driver.
Yoder
Yoder Enterprises’
Enterprises’ actual
actual production
production for for the
the
period
period required
required 2,100
2,100 standard
standard direct
direct labor
labor
hours.
hours. Actual
Actual variable
variable overhead
overhead forfor the
the period
period
was
was $10,950.
$10,950. Actual
Actual direct
direct labor
labor hours
hours worked
worked
were
were 2,050.
2,050. The
The predetermined
predetermined variable
variable
overhead
overhead rate
rate is
is $5
$5 per
per direct
direct labor
labor hour.
hour. What
What
was
was the
the spending
spending variance?
variance?
a.
a. $450
$450 UU
b.
b. $450
$450 FF
c.
c. $700
$700 FF
d.
d. $700
$700 UU
Spending
Yoder variance = AH (AR - production
SR)
Yoder Enterprises’
Enterprises’ actual
actual production for
for the
the
period
period=required
required 2,100 standard
2,100overhead
Actual variable standard direct
direct–labor
incurred labor
(AH × SR)
hours.
hours.=Actual
Actual variable
variable overhead
overhead for
for the
the period
period
$10,950 – (2,050 hours × $5 per hour)
was
was $10,950. Actual
$10,950. Actual direct
direct labor
labor hours
hours worked
worked
were
were 2,050.
2,050. The
The
= $10,950 predetermined
predetermined variable
– $10,250 variable
overhead
overhead rate
rate is
is $5
$5 per
per direct
direct labor
labor hour.
hour. What
What
= $700 U
was
was the
the spending
spending variance?
variance?
a.
a. $450
$450 UU
b.
b. $450
$450 FF
c.
c. $700
$700 FF
d.
d. $700
$700 UU
Yoder
Yoder Enterprises’
Enterprises’ actual
actual production
production for for the
the
period
period required
required 2,100
2,100 standard
standard direct
direct labor
labor
hours.
hours. Actual
Actual variable
variable overhead
overhead for for the
the period
period
was
was $10,950.
$10,950. Actual
Actual direct
direct labor
labor hours
hours worked
worked
were
were 2,050.
2,050. The
The predetermined
predetermined variable
variable
overhead
overhead rate
rate is
is $5
$5 per
per direct
direct labor
labor hour.
hour. What
What
was
was the
the efficiency
efficiency variance?
variance?
a.
a. $450
$450 UU
b.
b. $450
$450 FF
c.
c. $250
$250 FF
d.
d. $250
$250 UU
Yoder
Yoder Enterprises’
Enterprises’ actual
actual production
production for for the
the
period
period required
required 2,100
2,100 standard
standard direct
direct labor
labor
hours.
hours. Actual
Actual variable
variable overhead
overhead for for the
the period
period
Efficiency
was
was variance
$10,950.
$10,950. = SRdirect
Actual
Actual (AH – labor
direct SH) hours
labor hours worked
worked
were
were 2,050.
= $5 perThe
2,050. hourpredetermined
The predetermined variable
variable
(2,050 hours – 2,100 hours)
overhead
overhead rate
rate is
is $5
$5 per
per direct
direct labor
labor hour.
hour. What
What
was
was the= $250
the F
efficiency
efficiency variance?
variance?
a.
a. $450
$450 U U
b.
b. $450
$450 FF
c.
c. $250
$250 FF
d.
d. $250
$250 U U
ItIt is
is unlikely
unlikely that
that all
all
variable
variable overhead
overhead willwill be
be
driven
driven by by aa single
single activity.
activity.
Activity-based
Activity-based costing
costing
can
can be
be used
used when
when multiple
multiple
activity
activity bases
bases drive
drive
variable
variable overhead
overhead costs.
costs.
Budget Volume
Variance Variance
ColaCo
ColaCoapplies
appliesoverhead
overheadbased
based
on
onmachine-hour
machine-hour activity.
activity.
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Overhead Rates and Overhead
Analysis – Example
$8,450 $9,000
Budget variance
$550 favorable
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Fixed Overhead Variances –
A Closer Look
Budget Variance
Volume
Variance
Unfavorable Favorable
when standard hours when standard hours
< denominator hours > denominator hours
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Volume Variance – A Closer Look
Volume
Variance
Does not measure over-
or under spending
Results when standard hours
Itallowed
resultsforfrom
actualtreating fixed
output differs
from the denominator
overhead activity.
as if it were a
variable cost.
Unfavorable Favorable
when standard hours when standard hours
< denominator hours > denominator hours
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check
Yoder
Yoder Enterprises’
Enterprises’ actual
actual production
production for for the
the
period
period required
required 2,100
2,100 standard
standard direct
direct labor
labor
hours.
hours. Actual
Actual fixed
fixed overhead
overhead forfor the
the period
period
was
was $14,800.
$14,800. The
The budgeted
budgeted fixed
fixed overhead
overhead
was
was $14,450.
$14,450. The
The predetermined
predetermined fixed
fixed
overhead
overhead rate
rate was
was $7
$7 per
per direct
direct labor
labor hour.
hour.
What
What was
was the
the budget
budget variance?
variance?
a.
a. $350
$350 UU
b.
b. $350
$350 FF
c.
c. $100
$100 FF
d.
d. $100
$100 UU
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check
Budget
Yodervariance
Yoder Enterprises’ actual
Enterprises’ actual production
production for for the
the
period
period required
required
= Actual 2,100
2,100 standard
fixed overhead – Budgeteddirect
standard direct labor
labor
fixed overhead
hours.
hours. Actual
Actual
= $14,800 fixed
fixed overhead
overhead for
– $14,450 for the
the period
period
was
was $14,800.
$14,800. The The budgeted
budgeted fixed
fixed overhead
overhead
was= $14,450.
was $350 U
$14,450. The
The predetermined
predetermined fixed fixed
overhead
overhead raterate was
was $7
$7 per
per direct
direct labor
labor hour.
hour.
What
What was
was thethe budget
budget variance?
variance?
a.
a. $350
$350 U U
b.
b. $350
$350 FF
c.
c. $100
$100 FF
d.
d. $100
$100 U U
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check
Yoder
Yoder Enterprises’
Enterprises’ actual
actual production
production for for the
the
period
period required
required 2,100
2,100 standard
standard direct
direct labor
labor
hours.
hours. Actual
Actual fixed
fixed overhead
overhead forfor the
the period
period
was
was $14,800.
$14,800. The
The budgeted
budgeted fixed
fixed overhead
overhead
was
was $14,450.
$14,450. The
The predetermined
predetermined fixed
fixed
overhead
overhead rate
rate was
was $7
$7 per
per direct
direct labor
labor hour.
hour.
What
What was
was the
the volume
volume variance?
variance?
a.
a. $250
$250 UU
b.
b. $250
$250 FF
c.
c. $100
$100 FF
d.
d. $100
$100 UU
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check
Volume variance
Yoder
Yoder Enterprises’
Enterprises’ actual
actual production
production for for the
the
= Budgeted fixed overhead – (SH × FR)
period
period required
required 2,100
2,100 standard
standard direct
direct labor
labor
hours × $7
hours. =Actual
hours. $14,450
Actual – (2,100
fixed
fixed overhead
overhead forper
for the
the hour)
period
period
was = $14,450The
was $14,800.
$14,800. – $14,700
The budgeted
budgeted fixed
fixed overhead
overhead
was
was $14,450.
= $250 F The
$14,450. The predetermined
predetermined fixed fixed
overhead
overhead rate
rate was
was $7 $7 per
per direct
direct labor
labor hour.
hour.
What
What was
was the
the volume
volume variance?
variance?
a.
a. $250
$250 UU
b.
b. $250
$250 FF
c.
c. $100
$100 FF
d.
d. $100
$100 UU
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Quick Check Summary
Let’s look at a
graph showing
fixed overhead
variances. We will
use ColaCo’s
numbers from the
previous example.
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Fixed Overhead Variances
Cost
a d
rh e ts
ve uc
o r od
e d p
Fix d to
l ie
p
ap Activity
3,000 Hours
Expected
Activity
McGraw-Hill/Irwin Copyright © 2006. The McGraw-Hill Companies, Inc.
Fixed Overhead Variances
Cost
In a standard
cost system:
Unfavorable Favorable
variances are equivalent variances are equivalent
to underapplied overhead. to overapplied overhead.