November EC Meeting 2019

Hotel

Cash Flow

Jul-19

Months

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

TOTAL

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

Forecast

ROOM OCCUPANCY

Average

Available Rooms

1178

1064

1178

1140

1178

1465

1922

1922

1860

1922

1860

1922

1550.92

Forecast Occupancy

61%

75%

74%

76%

74%

73%

67%

68%

70%

65%

65%

62%

69%

Rooms Sold

719

798

872

866

872

1069

1288

1307

1302

1249

1209

1192

815

Average Room Rate

61.00

63.00

65.00

71.00

70.00

68.00

70.00

70.00

66.00

65.00

66.00

58.00

66.08

SALES CONFERENCES

Forecast

2,500.00

4,000.00

12,200.00

8,000.00

10,000.00

8,000.00

1,000.00

-

-

8,000.00

11,000.00

3,000.00

67,700.00

SALES WEDDINGS

Forecast

7,000.00

2,750.00

26,000.00

26,000.00

48,000.00

58,000.00

36,000.00

78,000.00

33,000.00

20,000.00

7,000.00

-

341,750.00

SALES EVENTS

Forecast

1,100.00

1,100.00

2,000.00

2,000.00

2,500.00

2,500.00

5,000.00

2,000.00

5,000.00

3,500.00

2,500.00

52,000.00

81,200.00

TOTAL SALES

Forecast

95,233.42

104,030.60

148,757.42

153,927.36

177,488.76

208,372.94

214,969.42

255,075.68

202,470.80

186,988.55

173,558.60

187,768.73

2,108,642.28

Forecast

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

TOTAL

EXPENDITURE

GROSS WAGES

Forecast

58,568.55

57,216.83

60,990.54

61,570.94

62,121.07

66,679.34

72,014.76

76,522.70

66,815.36

61,706.22

62,481.10

67,596.74

774,284.16

Forecast Wage % (of Sales)

61.50

55.00

41.00

40.00

35.00

32.00

33.50

30.00

33.00

33.00

36.00

36.00

38.83

Depreciation

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

6,230.00

74,760.00

NET PROFIT/ (LOSS) FORECAST

(25,553.40)

(18,929.94)

5,105.41

4,214.32

17,904.79

36,291.27

35,048.59

52,734.47

29,282.24

29,406.28

21,916.43

36,731.22

224,151.68

NP/LOSS % BUDGET

-27% -18%

3%

3%

10%

17%

16%

21%

14%

16%

13%

20%

11%

Quorn Grange Hotel

CASH Flow

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG SEP

OCT

NOV

DEC

TOTAL

FORECAST

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Actual

Forecast Forecast

Forecast

Operating Profit/Loss

(34,887)

(23,624)

(18,713)

(9,204)

(21,700)

33,556

15,925

26,412

23,158

(19,555)

21,916

36,731

30,016 -

Working Capital

26,835

(50,524)

23,097

40,021

6,318

(4,003)

41,019

(21,643)

49,044

22,892

(30,000)

(10,000)

93,056