EC Meeting Papers January 2018

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 October November

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 81,272 92,632 1,078,849 144,565 125,722 93,968 148,952 142,374 116,747 98,422 1,217,788 112,411 104,985 124,536 115,457 122,170 93,994 107,438 1,116,784 128,433 130,683 155,763 146,436 147,266 120,712 101,783 1,306,011

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

April 6,875

May

June

July August September October November

Totals 58,039 48,506

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)

(12,953) (9,908) (17,669)

662

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

37,149 18,504

(14,559)

30,546 20,027

(9,070) (88,931)

(14,172) (25,000)

(6,470) (2,149)

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

11,036

(6,698)

(255,882) (146,141)

2,066

9,519

(10,961) (24,021)

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

March 8,465

April 3,863

May

June

July August September October November

Totals 4,970

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

3,686

(2,874) (24,021) (21,147)

(25,000) (33,465)

(2,221) (6,084)

(2,149) (9,023)

(6,215) (9,846)

(3,286)

2,066

(10,961) (14,647)

(146,142) (151,111)

(9,365) (4,887)

Variance

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

2017

Hotel

58,038.95 48,506.08

(255,881.76)

(146,141.26)