November EC Meeting 2019

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

HOTEL SALES 2014-2018

January 75,891 71,508 65,457 69,680 84,943 99,391

February 75,521 83,912 78,246 88,225 107,994 108,084

March 99,170 101,137 104,534 86,334 107,823 107,897

April

May

June

July

August

September October November December

Totals

2014 2015 2016 2017 2018 2019

92,463 90,480 87,556 130,696 117,886 137,654

117,353 144,565 112,411 128,433 165,115 137,872

112,281 125,722 104,985 130,683 140,461 188,322

127,392 116,905 87,970 81,272 92,632 113,301 1,192,149 148,952 142,374 116,747 98,422 123,528 1,341,316 124,536 115,457 122,170 93,994 107,438 128,105 1,244,889 155,763 146,436 147,266 120,712 101,783 125,647 1,431,658 144,560 149,930 134,361 127,349 125,852 133,202 1,539,476 93,968

183,264 215,777 180,315 157,599

1,516,175

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

April 6,875

May

June

July

August 18,510 30,546 11,036

September October November December

Totals 63,311 43,535

2014 2015 2016 2017 2018 2019

(7,522) (20,621) (50,664) (51,566) (43,625) (34,887)

(13,452) (7,539) (27,882) (32,308) (23,524) (23,624)

2,999 7,896

22,940 37,149 (6,470) (2,149) 30,984 (21,700)

19,123 18,504

23,347

(2,490) 20,027 (6,698)

(12,953) (9,908) (17,669) (10,961) (27,229) (19,555)

662

5,272

(3,918) (23,395) (2,221) (1,646) (8,205)

(14,559) (16,489) (3,286)

(9,070) (88,931) (11,426) (1,180)

(4,971) (5,047) (11,882) (27,188)

(14,172) (25,000) (39,095) (14,074)

(14,549) (6,215) (5,633)

(260,929) (145,848) (192,060) (26,262)

2,066

9,099

5,606

(33,794)

(25,736)

33,094

15,859

25,228

21,602

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

March 6,110

April 5,676

May

June

July

August 27,838 25,228 (2,610)

September October November December

Totals

2019 BUDGET ACTUAL 2019

(25,549) (34,887) (9,338)

(18,923) (23,624) (4,701)

5,271

18,634 33,094 14,460

23,567 15,859 (7,708)

22,518 24,283 18,299

29,827 137,551

(14,074) (20,184)

(8,204) (13,880)

(21,700) (26,971)

21,602

(19,555) (43,838)

(0)

(0)

(26,261) (163,812)

(916)

(18,299)

(29,827)

Variance

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

2017

2018

2019

Hotel

63,311.15 43,535.39

(260,928.80)

(145,848.22)

(192,060.00)

(26,262.00)