EC Meeting Papers July 2018

QUORN GRANGE HOTEL

REVIEW OF ACCOUNTS AS AT 31 May, 2018

Accounts Review- Hotel

QUORN GRANGE HOTEL SUMMARY

May-18

YTD -May

YTD -Apr

Hotel

Hotel

Hotel

£

£

£

Net Profit/(loss)

11,309.95 (97,990.62)

(108,889)

Adjust for Expenses not budgeted: Depreciation Charge

6,230

31150

24,920

Trading Profit/(Loss)

17,540

(66,841)

(83,969) (19,338)

Budgeted Profit/(loss)

Quorn Grange Hotel HOTEL OCCUPANCY 2018

JAN FEB MAR APR MAY TOTAL (YTD)

Available Rooms

1,178

1,064

1,178

1,140

1,178

3,420

Occupancy 2017 Actual 2018 Actual 2018 Budget

59% 62% 65% 74% 70% 65% 64% 79% 73% 74% 78% 73% 61% 66% 66% 70% 72% 66%

Variance

3% 13% 7% 4% 6%

7%

Rooms Sold 2017 Actual 2018 Actual 2018 Budget

691 655 771 842 825 757 841 863 838 917 705 702 777 798 848

740 825 746

Variance

7% 20% 11% 5% 8% 11%

Average Room Rate 2017 Actual

61.2 65.7 63.8 61.9 63.9 59.3 56.5 62.7 62.3 72.0 55.0 60.0 65.0 65.0 65.0 8% -6% -4% -4% 11%

63.1 60.2 61.3 -2%

2018 Actual 2018 Budget

Variance

Hotel Turnover & Profit

Sales were £145k for May 2018. In comparison to last month sales have increase and were nearly in line with a budget of £150k.Accomoodation and Food and Beverages accounted for the increase in sales.