Calculation guide
Apply that rate to standard hours allowed for actual output. Positive variance means under-absorption or overspending.
Spending variance = Actual fixed overhead − Budgeted fixed overhead. Volume variance = Budgeted fixed overhead × (1 − Standard hours for actual output / Budgeted capacity hours). Total fixed overhead variance = Spending variance + Volume variance
Inputs
Budgeted fixed overhead
Example entry 10000 (in the selected currency).
Actual fixed overhead
Example entry 10500 (in the selected currency).
Budgeted capacity hours
Example entry 1000.
Standard hours for actual output
Example entry 900.
Worked example
| Input | Value |
|---|---|
| Budgeted fixed overhead | 10,000 |
| Actual fixed overhead | 10,500 |
| Budgeted capacity hours | 1,000 |
| Standard hours for actual output | 900 |
| Result | Value |
|---|---|
| Spending variance | 500 |
| Volume variance | 1,000 |
| Total fixed overhead variance | 1,500 |
Calculation steps
Spending variance = (Actual fixed overhead − Budgeted fixed overhead)
(10,500 − 10,000) = 500
Volume variance = (Budgeted fixed overhead × (1 − (Standard hours for actual output ÷ Budgeted capacity hours)))
(10,000 × (1 − (900 ÷ 1,000))) = 1,000
Total fixed overhead variance = (Spending variance + Volume variance)
(500 + 1,000) = 1,500
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Budgeted fixed overhead | 10,000 | 11,000 | Spending variance | 500 | -500 |
| Actual fixed overhead | 10,500 | 11,550 | Spending variance | 500 | 1,550 |
| Budgeted capacity hours | 1,000 | 1,100 | Volume variance | 1,000 | 1,818.181818 |
| Standard hours for actual output | 900 | 990 | Volume variance | 1,000 | 100 |
