Chapter 14 – Operational Performance Measurement: Sales, Direct Cost Variances, and the Role of Nonfinancial
Performance Measures
Reading 14-8: Jason Porter and Teresa Stephanson “Calculating Operating Variances:
Completing a Benchmarking Analysis with Your Excel-Based Master Budget,” Strategic
Finance (September 2011), pp. 45-51.
This is the third article in a series that describes how you can use an Excel-based Master Budget for
making managerial decisions. Following the “Flexible Budget” created in part two, the authors now focus
on the final statement to calculate the company’s operating variances. They build a third budget in the
Contribution Margin Income Statement format and compare the original budget and flexible version to
determine variances.
This assignment is an extension of the Master Budgeting extended example by Porter & Stephanson, as
reported in the following issues of Strategic Finance: February-March-April-May-June-July, 2010. A
student handout containing information needed to prepare the master budget is available for students (pdf
file), as is an Excel template (“Student Template [Master Budgeting Example]”).
Discussion Questions
1. Explain the information contained in the CM IS tab (i.e., explain the difference between each of
the three forms of the Contribution Margin Income Statement).
See Figure 1 of the article. The left-most Contribution Margin (CM) Income Statement (IS) is the
original (i.e., master or static) budget for the period. The actual results for year are presented in the
right-most column of Figure 1. The middle column in Figure 1 is the Flexible Budget (based on
2. Use the information from the three CM Income Statements to calculate and interpret the direct
labor variances for the year.
Actual labor hours worked (viz., 77,559) are provided in Figure 2 of the article. Figure 3 of the article
shows that the total flexible-budget variance for direct labor during the period was an Unfavorable
$63,254. By introducing a second flexible budget into Figure 3 (i.e., the middle column, $1,085,826)
we see that the total price (rate) variance for direct labor during the period was $40,420 Unfavorable,
3. Calculate and interpret the total direct materials flexible budget variance for the year. Show the
breakdown of the flexible budget variance for steel and expanded shift component, into price and
quantity components.
The total flexible budget variance for all direct materials combined is given in Figure 5 of the article.
For the actual output produced during the period (17,074 basic bicycles and 8,356 deluxe bicycles) the
company should have used a total of $2,447,298 of direct materials. Actual direct materials used
14-15
Education.