| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Holloway Sensor Systems: 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 | 24,000.0 | 18,652.0 | (5,348.0) | (22.3%) | U | ||||||
| 5 | Cost of sales | 13,920.0 | 13,242.0 | (678.0) | (4.9%) | F | ||||||
| 6 | Gross profit | 10,080.0 | 6,130.0 | (3,950.0) | (39.2%) | U | ||||||
| 7 | Gross margin % | 42.0% | 32.9% | (9.1%) | ||||||||
| 8 | Operating expenses | |||||||||||
| 9 | Salaries | 3,600.0 | 4,032.0 | (432.0) | (12.0%) | F | ||||||
| 10 | Marketing | 1,440.0 | 1,429.9 | (10.1) | (0.7%) | F | ||||||
| 11 | Rent & utilities | 1,080.0 | 1,093.0 | 13.0 | 1.2% | U | ||||||
| 12 | Restructuring & one-off items | 0.0 | 300.0 | 300.0 | n/a | U | ||||||
| 13 | Other operating costs | 720.0 | 723.6 | 3.6 | 0.5% | U | ||||||
| 14 | Total operating expenses | 6,840.0 | 7,578.5 | 738.5 | 10.8% | U | ||||||
| 15 | EBITDA | 3,240.0 | (1,448.5) | (4,688.5) | (144.7%) | U | ||||||
| 16 | EBITDA margin % | 13.5% | (7.8%) | (21.3%) | ||||||||
| 17 | ||||||||||||
| 18 | ||||||||||||
| 19 | ||||||||||||
| 20 | ||||||||||||
| 21 | ||||||||||||
| 22 | ||||||||||||
| 23 | ||||||||||||
| 24 | ||||||||||||
| 25 | ||||||||||||
| 26 | ||||||||||||
| 27 | ||||||||||||
| 28 | ||||||||||||
| 29 | ||||||||||||
| 30 | ||||||||||||
TextReady