Flexible Budgets and Overhead Analysis

1
Flexible Budgets and Overhead Analysis
Chapter 11
2
Static Budgets and Performance Reports

• Static budgets are prepared for a single,
  planned level of activity.

Performance evaluation is difficult when
actual activity differs from the planned level of
activity.
3
Static Budgets and Performance Reports
CheeseCo
4
Static Budgets and Performance Reports
CheeseCo
5
Static Budgets and Performance Reports
CheeseCo
6
Static Budgets and Performance Reports
CheeseCo
F Favorable variance that occurs when actual
costs are less than budgeted costs.
7
Static Budgets and Performance Reports
CheeseCo
Since cost variances are favorable, havewe done
a good job controlling costs?
8
Static Budgets and Performance Reports
9
Static Budgets and Performance Reports

• The relevant question is . . .
• How much of the favorable cost variance is due
  to lower activity, and how much is due to good
  cost control?
• To answer the question,we mustthe budget to
  theactual level of activity.

10
Flexible Budgets
11
Flexible Budgets

• Central Concept
• If you can tell me what your activity wasfor
  the period, I will tell you what your costs and
  revenue should have been.

12
Preparing a Flexible Budget

• To a budget we need to know that
• Total variable costs changein direct proportion
  to changes in activity.
• Total fixed costs remainunchanged within
  therelevant range.

Variable
Fixed
13
Preparing a Flexible Budget
Lets prepare budgets
for CheeseCo.
14
Preparing a Flexible Budget
CheeseCo
15
Preparing a Flexible Budget
CheeseCo
16
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






Fixed costs
Depreciation
12,000


12,000






Insurance
2,000


2,000






Total fixed cost
14,000






Total overhead costs
74,000


?


17
Quick Check ?

• What should be the total overhead costs for the
  Flexible Budget at 10,000 hours?
• a. 92,500.
• b. 74,000.
• c. 89,000.
• d. 94,000.

18
Quick Check ?

• What should be the total overhead costs for the
  Flexible Budget at 10,000 hours?
• a. 92,500.
• b. 74,000.
• c. 89,000.
• d. 94,000.

Total overhead cost 14,000
7.50 per hour ? 10,000 hours
14,000 75,000 89,000
19
Preparing a Flexible Budget
CheeseCo
20
Quick Check ?

• What should be the total overhead costs for the
  Flexible Budget at 12,000 hours?
• a. 92,500.
• b. 89,000.
• c. 106,800.
• d. 104,000.

21
Quick Check ?

• What should be the total overhead costs for the
  Flexible Budget at 12,000 hours?
• a. 92,500.
• b. 89,000.
• c. 106,800.
• d. 104,000.

Total overhead cost 14,000
7.50 per hour ? 12,000 hours
14,000 90,000 104,000
22
Preparing a Flexible Budget
CheeseCo
23
Flexible BudgetPerformance Report
Lets prepare a budget
performance report for CheeseCo.
24
Flexible BudgetPerformance Report
25
Flexible BudgetPerformance Report
CheeseCo
26
Flexible BudgetPerformance Report
27
Flexible BudgetPerformance Report
CheeseCo
28
Overhead Rates and Overhead Analysis

• Recall that overhead costs are assigned to
  products and services using a predetermined
  overhead rate (POHR)

Assigned Overhead POHR Standard Activity
Overhead from theflexible budget for
thedenominator level of activity
POHR
Denominator level of activity
29
Overhead Rates and Overhead Analysis Example
Lets look at overhead rates in a budget for
ColaCo.
30
Overhead Rates and Overhead Analysis Example

• ColaCo prepared this budget for
  overhead

Total
Variable
Total
Fixed
Machine
Variable
Overhead
Fixed
Overhead
Hours
Overhead
Rate
Overhead
Rate
2,000


4,000


?
9,000


?
4,000


8,000


?
9,000


?
Lets calculate overhead rates.
ColaCo applies overhead basedon machine hour
activity.
31
Overhead Rates and Overhead Analysis Example

• ColaCo prepared this budget for
  overhead

This rate is constant at all levels of activity.
32
Overhead Rates and Overhead Analysis Example

• ColaCo prepared this budget for
  overhead

This rate decreases when activity increases.
33
Overhead Rates Fixed Overhead

• The POHR for variable overhead is 2.00 per
  machine hour
• HOWEVER
• To compute a POHR for fixed overhead, we need an
  estimated activity base
• Assuming 3,000 mach hrs as the estimated activity
  level . . .

34
Overhead Rates and Overhead Analysis Example

• ColaCo prepared this budget for
  overhead

35
Overhead Variances
Lets use the overhead rates, to determine
variable and fixed overhead variances.
36
Variable Overhead Variances Example

• ColaCos actual production for the period
  required 3,200 standard machine hours. Actual
  variable overhead incurred for the period was
  6,740. Actual machine hours worked were 3,300.
  
• Compute the variable overhead spending and
  efficiency variances.

37
Variable Overhead Variances
Actual Flexible Budget
Flexible Budget Variable
for Variable for Variable
Overhead Overhead at
Overhead at Incurred
Actual Hours
Standard Hours
AH SR
AH AR
SH SR
Spending Variance
EfficiencyVariance
Spending variance AH(AR - SR) Efficiency
variance SR(AH - SH)
38
Variable Overhead Variances Example
Actual Flexible Budget
Flexible Budget Variable
for Variable for Variable
Overhead Overhead at
Overhead at Incurred
Actual Hours
Standard Hours
3,300 hours
3,200 hours
2.00 per hour
2.00 per hour
6,740
6,600
6,400
Spending variance140 unfavorable
Efficiency variance200 unfavorable
340 unfavorable flexible budget total variance
39
Variable Overhead Variances A Closer Look

• Spending Variance

• Efficiency Variance

Results from paying moreor less than expected
foroverhead items and from excessive usage
ofoverhead items.
Controlled bymanaging theoverhead cost driver.
40
Overhead Variances
Now lets turn our attention to fixed overhead.
41
Overhead Rates and Overhead Analysis Example

• ColaCo prepared this budget for
  overhead

What is ColaCos fixed overhead rate for an
estimated activity of 3,000 machine hours?
42
Overhead Rates and Overhead Analysis Example

• ColaCo prepared this budget for
  overhead

Fixed Overhead Rate FR
9,000 3,000 machine hours FR
3.00 per machine hour
43
Fixed Overhead Variances Example

• ColaCos actual production required 3,200
  standard machine hours. Actual fixed overhead
  was 8,450.
• Compute the fixed overhead budget and volume
  variances.

44
Fixed Overhead Variances
Actual
Fixed Fixed
Fixed Overhead
Overhead Overhead
Incurred
Budget Applied
SH FR
Budget Variance
VolumeVariance
FR Standard Fixed Overhead RateSH Standard
Hours Allowed
45
Fixed Overhead Variances Example
Actual
Fixed Fixed
Fixed Overhead
Overhead Overhead
Incurred
Budget Applied
SH FR

3,200 hours

3.00 per hour
8,450
9,000
9,600
Budget variance550 favorable
Volume variance600 favorable
46
Fixed Overhead Variances A Closer Look

• Budget Variance

• Volume Variance

Results from paying moreor less than expected
foroverhead items.
Results from operatingat an activity
leveldifferent from thedenominator activity.
47
Volume Variance A Closer Look
48
Volume Variance A Closer Look
49
Overhead Variances and Under- or Overapplied
Overhead Cost
In a standardcost system
50
End of Chapter 11