Office Arcade
← Levels

Variance Detective · Level 1: Why did revenue miss?

Time 0:00 / 4:00 targetFlags 0
Blue: typed inputBlack: formulaGreen: link to another sheet
ABCDEFGHIJKL
1Alder & Finch Blankets: budget vs actual ($000)
2Variance = actual - budget. Costs are shown as positive numbers. F = favourable, U = unfavourable.
3BudgetActualVarVar %F/U
4Revenue(212.4)(7.1%)U
5Cost of sales1,740.0 1,757.4 17.4 1.0% U
6Gross profit1,260.0 1,030.2 (229.8)(18.2%)U
7Gross margin %42.0% 37.0% (5.0%)
8Operating expenses
9Salaries450.0 453.6 3.6 0.8% U
10Marketing180.0 178.7 (1.3)(0.7%)F
11Rent & utilities135.0 136.6 1.6 1.2% U
12Restructuring & one-off items0.0 0.0 0.0 n/a-
13Other operating costs90.0 90.4 0.4 0.4% U
14Total operating expenses855.0 859.3 4.3 0.5% U
15EBITDA405.0 170.9 (234.1)(57.8%)U
16EBITDA margin %13.5% 6.1% (7.4%)
17
18
19
20
21
22
23
24
25
26
27
28
29
30
TextReady
Personal practice tool · all companies and numbers are fictional · runs entirely in your browser