36 / 99
QUORN GRANGE HOTEL
REVIEW OF ACCOUNTS AS AT July 31, 2017
Accounts Review- Hotel
QUORN GRANGE HOTEL
SUMMARY
July
YTD -July
YTD - June
Hotel
Hotel
Hotel
£
£
£
Net Profit/(loss)
(1,786)
(121,247)
(119,461)
Adjust for Expenses not budgeted:
Gift Aid GFTU
4,000
28,000
24,000
Less Kurdish Festival income
(3,200)
(3,200)
Add Kurdish Festival expenses
8,908
8,908
Trading Profit/(Loss)
7,922
(87,539)
(95,461)
Budgeted Profit/(loss)
6,079
(7,978)
(14,058)
The hotel occupancy for
January through to July in
comparison
to budget
and
to 2016
can be
summarised as follows:
Turnover & Gross Profit
The total turnover for the hotel 15.4k higher than budget for July 17 and (£10.7)k below year to date.
Turnover has increases as we are in wedding season.
Quorn Grange Hotel
HOTEL OCCUPANCY 2017
JAN
FEB
MAR
APR
MAY
June
July
Available Rooms
1,178 1,064 1,178 1,126 1,178 1,140
1,178
Occupancy
2016 Actual
44%
56%
54%
65%
68%
68%
68%
2017 Actual
59%
62%
65%
74%
70%
79%
77%
2017 Budget
55%
58%
60%
65%
68%
68%
70%
Variance
4%
4%
5%
9%
2%
11%
7%
Rooms Sold
2016 Actual
506
600
609
729
767
766
788
2017 Actual
691
655
771
842
825
900
909
2017 Budget
636
617
707
741
801
775
825
Variance
9%
6%
9%
14%
3%
16%
10%
Average Room Rate
2016 Actual
61.7
62.8
65.6
62.3
58.0
55.0
66.5
2017 Actual
61.2
65.7
63.8
61.9
63.87
63.15
65.13
2017 Budget
61.0
62.0
65.0
66.0
66.0
66.0
66.0
Variance
0.2%
6%
-2%
-6%
-3%
-4%
-1%