38-39 / 99
QUORN GRANGE HOTEL
FINANCIAL OVERVIEW (Jan 17 to Dec 17)
HOTEL SALES 2014-2017
January
February
March
April
May
June
July
Totals
2014
75,891
75,521
99,170
92,463
117,353
112,281 127,392 700,071
2015
71,508
83,912
101,137
90,480
144,565
125,722 93,968 711,292
2016
65,457
78,246
104,534
87,556
112,411
104,985 124,536 677,725
2017
69,680
88,225
86,334
130,696
128,433
130,683 155,763 789,814
HOTEL NET PROFIT/(LOSS) PRIOR YEAR COMPARISONS 2014-17
January
February
March
April
May
June
July
Totals
2014
(7,522)
(13,452)
2,999
6,875
22,940
19,123 23,347 54,309
2015
(20,621)
(7,539)
7,896
(3,918)
37,149
18,504
(14,559)
16,912
2016
(50,664)
(27,882)
(14,172)
(23,395)
(6,470)
(14,549) (16,489) (153,620)
2017
(51,566)
(32,308)
(25,000)
(2,221)
(2,054)
(6,215) (1,786)
(121,150)
HOTEL BUDGET v ACTUAL NET PROFIT/(LOSS) 2017
January
February
March
April
May
June
July
Totals
2017 BUDGET
(22,552)
(14,339)
8,465
3,863
6,874
3,631 6,079
(7,979)
2017 ACTUAL
(51,566)
(32,308)
(25,000)
(2,221)
(2,054)
(6,215)
(1,786) (121,150)
Variance
(29,014)
(17,969)
(33,465)
(6,084)
(8,928)
(9,846)
(7,865)
(113,172)
YTD OVERALL PRIOR YEAR ANALYSIS HOTEL NET PROFIT/(LOSS)
2014
2015
2016
2017
Hotel
54,309.46
16,911.69
(153,620.08)
(121,150.23)