Worked example
An event caterer budgeted 400 events at an average price of 2,500, variable costs of 1,400 an event and fixed costs of 300,000. It actually catered 440 events.
| Static budget | Flexible budget | Actual | |
|---|---|---|---|
| Events | 400 | 440 | 440 |
| Revenue | 1,000,000 | 1,100,000 | 1,078,000 |
| Variable costs | 560,000 | 616,000 | 638,000 |
| Fixed costs | 300,000 | 300,000 | 312,000 |
| Operating income | 140,000 | 184,000 | 128,000 |
- Static budget variance: 128,000 - 140,000 = 12,000 unfavorable.
- Sales-volume variance: 184,000 - 140,000 = 44,000 favorable. Forty more events at a budgeted margin of 1,100 each.
- Flexible-budget variance: 128,000 - 184,000 = 56,000 unfavorable, made up of revenue 22,000 unfavorable (an average price of 2,450), variable costs 22,000 unfavorable (1,450 an event) and fixed costs 12,000 unfavorable.
The static comparison says the caterer missed its profit target by 12,000. The flexible budget shows that strong volume hid weak pricing and cost control.