| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Brindle Cargo Trikes: 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 | 9,600.0 | 8,160.0 | (1,440.0) | (15.0%) | U | ||||||
| 5 | Cost of sales | 5,568.0 | 4,751.7 | (816.3) | (14.7%) | F | ||||||
| 6 | Gross profit | 4,032.0 | 3,408.3 | (623.7) | (15.5%) | U | ||||||
| 7 | Gross margin % | 42.0% | 41.8% | (0.2%) | ||||||||
| 8 | Operating expenses | |||||||||||
| 9 | Salaries | 1,440.0 | 1,451.5 | 11.5 | 0.8% | U | ||||||
| 10 | Marketing | 576.0 | 572.0 | (4.0) | (0.7%) | F | ||||||
| 11 | Rent & utilities | 432.0 | 437.2 | 5.2 | 1.2% | U | ||||||
| 12 | Restructuring & one-off items | 0.0 | 150.0 | 150.0 | n/a | U | ||||||
| 13 | Other operating costs | 288.0 | 289.4 | 1.4 | 0.5% | U | ||||||
| 14 | Total operating expenses | 2,736.0 | 2,900.1 | 164.1 | 6.0% | U | ||||||
| 15 | EBITDA | 1,296.0 | 508.2 | (787.8) | (60.8%) | U | ||||||
| 16 | EBITDA margin % | 13.5% | 6.2% | (7.3%) | ||||||||
| 17 | ||||||||||||
| 18 | ||||||||||||
| 19 | ||||||||||||
| 20 | ||||||||||||
| 21 | ||||||||||||
| 22 | ||||||||||||
| 23 | ||||||||||||
| 24 | ||||||||||||
| 25 | ||||||||||||
| 26 | ||||||||||||
| 27 | ||||||||||||
| 28 | ||||||||||||
| 29 | ||||||||||||
| 30 | ||||||||||||
TextReady