Office Arcade
← Levels

Variance Detective · Level 7: Cut-off day

Time 0:00 / 10:00 targetFlags 0
Blue: typed inputBlack: formulaGreen: link to another sheet
ABCDEFGHIJKL
1Garrick Marine Supplies: budget vs actual ($000)
2Variance = actual - budget. Costs are shown as positive numbers. F = favourable, U = unfavourable.
3BudgetActualVarVar %F/U
4Revenue17,100.0 16,750.0 (350.0)(2.0%)U
5Cost of sales9,918.0 9,957.7 39.7 0.4% U
6Gross profit7,182.0 6,792.3 (389.7)(5.4%)U
7Gross margin %42.0% 40.6% (1.4%)
8Operating expenses
9Salaries2,565.0 2,585.5 20.5 0.8% U
10Marketing1,026.0 1,018.8 (7.2)(0.7%)F
11Rent & utilities769.5 778.7 9.2 1.2% U
12Restructuring & one-off items0.0 0.0 0.0 n/a-
13Other operating costs513.0 515.6 2.6 0.5% U
14Total operating expenses4,873.5 4,898.6 25.1 0.5% U
15EBITDA2,308.5 2,406.7 98.2 4.3% F
16EBITDA margin %13.5% 14.4% 0.9%
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