Office Arcade
← Levels

Variance Detective · Level 6: The short total

Time 0:00 / 9:00 targetFlags 0
Blue: typed inputBlack: formulaGreen: link to another sheet
ABCDEFGHIJKL
1Fairhaven Assay Labs: budget vs actual ($000)
2Variance = actual - budget. Costs are shown as positive numbers. F = favourable, U = unfavourable.
3BudgetActualVarVar %F/U
4Revenue3,300.0 3,324.0 24.0 0.7% F
5Cost of sales1,914.0 1,921.7 7.7 0.4% U
6Gross profit1,386.0 1,402.3 16.3 1.2% F
7Gross margin %42.0% 42.2% 0.2%
8Operating expenses
9Salaries495.0 499.0 4.0 0.8% U
10Marketing198.0 196.6 (1.4)(0.7%)F
11Rent & utilities148.5 169.3 (20.8)(14.0%)F
12Restructuring & one-off items0.0 210.0 210.0 n/aU
13Other operating costs99.0 116.8 17.8 18.0% U
14Total operating expenses940.5 1,074.9 134.4 14.3% U
15EBITDA445.5 327.4 (118.1)(26.5%)U
16EBITDA margin %13.5% 9.8% (3.7%)
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