F&GP Meeting November 2017

QUORN GRANGE HOTEL FINANCIAL OVERVIEW (Jan 17 to Dec 17)

HOTEL SALES 2014-2017

January 75,891 71,508 65,457 69,680

February

March 99,170 101,137 104,534 86,334

April

May

June

July August September

Totals

2014 2015 2016 2017

75,521 83,912 78,246 88,225

92,463 90,480 87,556 130,696

117,353 112,281 127,392 116,905 87,970 904,946 144,565 125,722 93,968 148,952 142,374 1,002,618 112,411 104,985 124,536 115,457 122,170 915,352 128,433 130,683 155,763 146,436 147,266 1,083,516

HOTEL NET PROFIT/(LOSS) PRIOR YEAR COMPARISONS 2014-17 January February March

April 6,875

May

June

July August September

Totals 70,330 67,484

2014 2015 2016 2017

(7,522) (20,621) (50,664) (51,566)

(13,452) (7,539) (27,882) (32,308)

2,999 7,896

22,940 19,123 23,347 18,510

(2,490)

(3,918) (23,395) (2,221)

37,149 18,504

(14,559)

30,546 20,027

(14,172) (25,000)

(6,470) (2,149)

(14,549) (16,489) (6,215) (3,286)

11,036

(6,698)

(149,282) (111,159)

2,066

9,519

HOTEL BUDGET v ACTUAL NET PROFIT/(LOSS) 2017 January February

March 8,465

April 3,863

May

June

July August September

Totals 4,157

2017 BUDGET 2017 ACTUAL

(22,552) (51,566) (29,014)

(14,339) (32,308) (17,969)

6,874

3,631 6,079 6,953

5,183 9,519 4,337

(25,000) (33,465)

(2,221) (6,084)

(2,149) (9,023)

(6,215) (9,846)

(3,286) (9,365)

2,066

(111,160) (115,317)

(4,887)

Variance

YTD OVERALL PRIOR YEAR ANALYSIS HOTEL NET PROFIT/(LOSS) 2014 2015 2016

2017

Hotel

70,329.70

67,484.26

(149,281.76)

(111,159.42)