Chapter 15 – Operational Performance Measurement: Indirect-Cost Variances and Resource-Capacity Management
15–43 Income Statement Effects of Alternative Denominator Activity Levels;
Spreadsheet Application (60 minutes)
(1) Production Volume Variance:
Budgeted Standard Standard Fixed OVH Production
Fixed Fixed OVH Allowed Applied to Volume
Alternative Overhead Rate/Hour Hours Production Variance
Theoretical $350,000 $11.6667 24,500 $285,833 $64,167U
Practical $350,000 $12.9630 24,500 $317,593 $32,407U
(2) Ending Inventory of Finished Goods:
Theoretical Practical Normal Budgeted
Beg. Inventory 0 0 0 0
Plus: Units Produced 12,250 12,250 12,250 12,250
Less: Units Sold 11,500 11,500 11,500 11,500
Units in Ending Inventory 750 750 750 750
Mfg. Cost/Unit:
Variable $60.25 $60.25 $60.25 $60.25
(3) Profit Reports:
Theoretical Practical Normal Budgeted
Revenues $1,150,000 $1,150,000 $1,150,000 $1,150,000
CGS (@ Standard Cost) $916,021 $945,836 $969,688 $983,104
Plus/Minus Vol. Variance $64,167 $32,407 $7,000 ($7,292)
CGS, Adjusted $980,188 $978,243 $976,688 $975,813
Gross Profit $169,813 $171,757 $173,313 $174,188
Less: Operating Expenses:
Variable $56,925 $56,925 $56,925 $56,925