| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Calder Outdoor Gear: budget vs actual ($000) | |||||||||||
| 2 | Variance = actual - budget. Costs are shown as positive numbers. F = favourable, U = unfavourable. | |||||||||||
| 3 | Budget | Actual | Var | Var % | F/U | |||||||
| 4 | Revenue | 12,000.0 | 10,620.0 | (1,380.0) | (11.5%) | U | ||||||
| 5 | Cost of sales | 6,960.0 | 6,289.1 | (670.9) | (9.6%) | F | ||||||
| 6 | Gross profit | 5,040.0 | 4,330.9 | (709.1) | (14.1%) | U | ||||||
| 7 | Gross margin % | 42.0% | 40.8% | (1.2%) | ||||||||
| 8 | Operating expenses | |||||||||||
| 9 | Salaries | 1,800.0 | 1,814.4 | 14.4 | 0.8% | U | ||||||
| 10 | Marketing | 720.0 | 715.0 | (5.0) | (0.7%) | F | ||||||
| 11 | Rent & utilities | 540.0 | 546.5 | 6.5 | 1.2% | U | ||||||
| 12 | Restructuring & one-off items | 0.0 | 0.0 | 0.0 | n/a | - | ||||||
| 13 | Other operating costs | 360.0 | 361.8 | 1.8 | 0.5% | U | ||||||
| 14 | Total operating expenses | 3,420.0 | 3,437.7 | 17.7 | 0.5% | U | ||||||
| 15 | EBITDA | 1,620.0 | 893.2 | (726.8) | (44.9%) | U | ||||||
| 16 | EBITDA margin % | 13.5% | 8.4% | (5.1%) | ||||||||
| 17 | ||||||||||||
| 18 | ||||||||||||
| 19 | ||||||||||||
| 20 | ||||||||||||
| 21 | ||||||||||||
| 22 | ||||||||||||
| 23 | ||||||||||||
| 24 | ||||||||||||
| 25 | ||||||||||||
| 26 | ||||||||||||
| 27 | ||||||||||||
| 28 | ||||||||||||
| 29 | ||||||||||||
| 30 | ||||||||||||
TextReady