| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Eastgate Valves: 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 | 5,300.0 | 4,880.0 | (420.0) | (7.9%) | U | ||||||
| 5 | Cost of sales | 3,074.0 | 2,841.7 | (232.3) | (7.6%) | F | ||||||
| 6 | Gross profit | 2,226.0 | 2,197.3 | (28.7) | (1.3%) | U | ||||||
| 7 | Gross margin % | 42.0% | 45.0% | 3.0% | ||||||||
| 8 | Operating expenses | |||||||||||
| 9 | Salaries | 795.0 | 801.4 | 6.4 | 0.8% | U | ||||||
| 10 | Marketing | 318.0 | 315.8 | (2.2) | (0.7%) | F | ||||||
| 11 | Rent & utilities | 238.5 | 241.4 | 2.9 | 1.2% | U | ||||||
| 12 | Restructuring & one-off items | 0.0 | 0.0 | 0.0 | n/a | - | ||||||
| 13 | Other operating costs | 159.0 | 159.8 | 0.8 | 0.5% | U | ||||||
| 14 | Total operating expenses | 1,510.5 | 1,518.4 | 7.9 | 0.5% | U | ||||||
| 15 | EBITDA | 715.5 | 678.9 | (36.6) | (5.1%) | U | ||||||
| 16 | EBITDA margin % | 13.5% | 13.9% | 0.4% | ||||||||
| 17 | ||||||||||||
| 18 | ||||||||||||
| 19 | ||||||||||||
| 20 | ||||||||||||
| 21 | ||||||||||||
| 22 | ||||||||||||
| 23 | ||||||||||||
| 24 | ||||||||||||
| 25 | ||||||||||||
| 26 | ||||||||||||
| 27 | ||||||||||||
| 28 | ||||||||||||
| 29 | ||||||||||||
| 30 | ||||||||||||
TextReady