flexiblebudgetexample.xlsx
Sheet1
| | Annual |
| | Budget | per | | Flexible | | | | | Budget | Actual | Variance |
| Direct labor hours | 240,000 | | | 18,000 | 20,000 | 22,000 | 24,000 | | 20,000 | 20,000 |
| Variable: |
| Indirect labor | 72,000 | 0.30 | | 5,400 | 6,000 | 6,600 | 7,200 | | 6,000 | 6,200 | (200) |
| Indirect materials | 48,000 | 0.20 | | 3,600 | 4,000 | 4,400 | 4,800 | | 4,000 | 3,600 | 400 |
| Repairs | 36,000 | 0.15 | | 2,700 | 3,000 | 3,300 | 3,600 | | 3,000 | 2,300 | 700 |
| Utilities | 24,000 | 0.10 | | 1,800 | 2,000 | 2,200 | 2,400 | | 2,000 | 1,700 | 300 |
| Lubricants | 12,000 | 0.05 | | 900 | 1,000 | 1,100 | 1,200 | | 1,000 | 1,050 | (50) |
| | 192,000 | | | 14,400 | 16,000 | 17,600 | 19,200 | | 16,000 | 14,850 | 1,150 |
| Fixed: |
| Supervision | 75,600 | 6,300 | | 6,300 | 6,300 | 6,300 | 6,300 | | 6,300 | 6,300 | 0 |
| Depreciation | 30,000 | 2,500 | | 2,500 | 2,500 | 2,500 | 2,500 | | 2,500 | 2,500 | 0 |
| Insurance | 12,000 | 1,000 | | 1,000 | 1,000 | 1,000 | 1,000 | | 1,000 | 1,000 | 0 |
| Rent | 9,600 | 800 | | 800 | 800 | 800 | 800 | | 800 | 850 | (50) |
| Property Taxes | 6,000 | 500 | | 500 | 500 | 500 | 500 | | 500 | 500 | 0 |
| | 133,200 | | | 11,100 | 11,100 | 11,100 | 11,100 | | 11,100 | 11,150 | (50) |
Damond
