EC Meeting Papers January 2020
QGH Quorn Grange Hotel Budget 2020
SALES
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
TOTAL
TOTAL
ROOM OCCUPANCY
BUDGET 2020
ACT/FORC 2019
Available Rooms
1953
1827
1953
1890
1953
1890
1953
1953
1890
1953
1890
1953
1921.50
1551
Budget Occupancy
63%
74%
75%
77%
77%
76%
69%
68%
73%
65%
66%
60%
70%
70%
Budget Rooms Sold
1230
1352
1465
1455
1504
1436
1348
1328
1380
1269
1247
1172
1372
819
£Average Room Rate
63.00
67.00
72.00
72.00
72.00
72.00
72.00
70.00
70.00
68.00
68.00
65.00
69.25
66.5
SALES FOOD/BEVERAGE
Budget
44,958
52,538
61,168
60,773
62,799
59,984
56,275
53,918
56,016
50,067
49,197
44,177
651,870
641342
SALES MISC
Budget
1,500
1,700
1,700
2,000
2,000
2,000
2,000
2,000
2,000
2,000
1,400
900
21,200
8360
SALES ACCOMODATION
Budget
77,515
90,583
105,462
104,782
108,274
103,421
97,025
92,963
96,579
86,323
84,823
76,167
1,123,916
855122
SALES CONFERENCES
Budget
2,500
4,000
12,200
12,000
10,000
9,000
6,000
5,000
5,000
6,000
5,500
1,500
78,700
62700
SALES WEDDINGS
Budget
7,200
7,200
11,700
35,000
52,000
52,000
60,000
80,000
70,000
48,000
15,000
12,000
450,100
371750
SALES EVENTS
Budget
1,100
1,100
2,000
2,000
2,500
2,500
5,000
2,000
5,000
3,500
2,500
42,000
71,200
77200
BREAKFAST
Budget
9,302
10,870
12,655
12,574
12,993
12,410
11,643
11,156
11,589
10,359
10,179
9,140
134,870
128268
GYM
Budget
500
500
500
500
500
500
500
500
500
500
500
500
6,000
6000
BANK INTEREST
Budget
50
50
50
50
50
50
50
50
50
50
50
50
600
600
TOTAL SALES
Budget
144,625
168,541
207,435
229,679
251,116
241,865
238,493
247,587
246,734
206,799
169,149
186,434
2,538,456
2151342
Budget 2020 DIRECT COSTS
JAN
FEB
MAR
APR
MAY
JUN
JUL
AUG
SEP
OCT
NOV
DEC
TOTAL
PURCHASES
Budget
20,169
23,469
30,914
37,928
43,491
42,127
43,065
47,143
45,758
36,557
25,537
33,733
429,889
353822
GROSS WAGES
Operating Budget
-
Kitchen (Hourly)
10,000
9,000
9,000
10,000
9,000
9,000
10,000
9,000
9,000
10,000
9,000
9,000
112,000
Housekeeping (Hourly)
9,000
8,000
8,000
9,000
8,000
8,000
8,000
8,000
8,000
8,000
8,000
5,000
95,000
F & B (Hourly)
13,000
12,000
12,000
13,000
12,000
12,000
13,000
12,000
12,000
13,000
12,000
12,000
148,000
Salaried
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
12,000
144,000
Total Operating Wages
44,000
41,000
41,000
44,000
41,000
41,000
43,000
41,000
41,000
43,000
41,000
38,000
499,000
Management & Admin
26,500
26,500
26,500
26,500
26,500
26,500
26,500
26,500
26,500
26,500
26,500
26,500
318,000
COMPANY PENSION
Budget
3,525
3,375
3,375
3,525
3,375
3,375
3,475
3,375
3,375
3,475
3,375
3,225
40,850
TOTAL PAYROLL
Budget
74,025
70,875
70,875
74,025
70,875
70,875
72,975
70,875
70,875
72,975
70,875
67,725
857,850
819216
PAYROLL % Sales (Total)
51.2
42.1
34.2
32.2
28.2
29.3
30.6
28.6
28.7
35.3
41.9
36.3
33.8
38.1
Kitchen (F & B Sales)
15.6
12.1
9.2
8.3
6.5
6.7
7.5
6.0
6.3
8.7
11.3
13.5
33.8
Housekeeping (Accom Sales)
14.1
8.8
7.6
8.6
7.4
7.7
8.2
8.6
8.3
9.3
9.4
6.6
8.5
F & B (F & B Sales)
20.3
16.1
12.3
10.8
8.7
9.0
9.7
8.0
8.4
11.4
15.0
18.0
11.3
Salaried (Total Sales)
8.3
7.1
5.8
5.2
4.8
5.0
5.0
4.8
4.9
5.8
7.1
6.4
5.7
Total Operating Wages (Total Sales)
30.4
24.3
19.8
19.2
16.3
17.0
18.0
16.6
16.6
20.8
24.2
20.4
19.7
Management & Admin (Total Sales)
18.3
15.7
12.8
11.5
10.6
11.0
11.1
10.7
10.7
12.8
15.7
14.2
12.5
TOTAL DIRECT COSTS
94,194
94,344
101,789
111,953
114,366
113,002
116,040
118,018
116,633
109,532
96,412
101,458
1,287,739
1,173,038
GROSS MARGIN
50,431
74,196
105,646
117,726
136,751
128,863
122,453
129,569
130,101
97,267
72,738
84,976
1,250,716
978,304
GROSS MARGIN %
34.9
44.0
50.9
51.3
54.5
53.3
51.3
52.3
52.7
47.0
43.0
45.6
49.3
45.5
Made with FlippingBook - professional solution for displaying marketing and sales documents online