| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Dunmore Biscuits: 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 | 2,400.0 | 2,160.0 | (240.0) | (10.0%) | U | ||||||
| 5 | Cost of sales | 1,392.0 | 1,257.8 | (134.2) | (9.6%) | F | ||||||
| 6 | Gross profit | 1,008.0 | 902.2 | (105.8) | (10.5%) | U | ||||||
| 7 | Gross margin % | 42.0% | 41.8% | (0.2%) | ||||||||
| 8 | Operating expenses | |||||||||||
| 9 | Salaries | 360.0 | 362.9 | 2.9 | 0.8% | U | ||||||
| 10 | Marketing | 144.0 | 165.6 | (21.6) | (15.0%) | F | ||||||
| 11 | Rent & utilities | 108.0 | 109.3 | 1.3 | 1.2% | U | ||||||
| 12 | Restructuring & one-off items | 0.0 | 0.0 | 0.0 | n/a | - | ||||||
| 13 | Other operating costs | 72.0 | 72.4 | 0.4 | 0.6% | U | ||||||
| 14 | Total operating expenses | 684.0 | 710.2 | 26.2 | 3.8% | U | ||||||
| 15 | EBITDA | 324.0 | 192.0 | (132.0) | (40.7%) | U | ||||||
| 16 | EBITDA margin % | 13.5% | 8.9% | (4.6%) | ||||||||
| 17 | ||||||||||||
| 18 | ||||||||||||
| 19 | ||||||||||||
| 20 | ||||||||||||
| 21 | ||||||||||||
| 22 | ||||||||||||
| 23 | ||||||||||||
| 24 | ||||||||||||
| 25 | ||||||||||||
| 26 | ||||||||||||
| 27 | ||||||||||||
| 28 | ||||||||||||
| 29 | ||||||||||||
| 30 | ||||||||||||
TextReady