November EC Meeting 2019

Quorn Grange Hotel

Date: 12/11/2019 Time: 17:38:39

Page: 1

Profit and Loss (Monthly Breakdown)

From: Month 1, January 2019 To: Month 10, October 2019 Chart of Accounts:

Detailed Layout of Accounts

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Totals

Sales Food & Beverages

28,422.48

34,007.75

31,507.13

36,863.51 42,450.97 52,437.76 46,332.94 62,198.77 50,085.33 41,562.86 425,869.50

Miscellaneous Sales

0.00

362.43

194.38

1,845.27 1,377.35 2,210.21 3,223.35 5,334.82 1,746.31 1,572.52 17,866.64

Accomodation

68,393.47

50,692.97

56,618.73

66,912.85 57,966.52 73,470.43 93,474.04 83,189.53 91,426.84 81,178.50 723,323.88

Conferences

166.67

5,057.97

7,370.35

7,790.47 7,010.45 9,361.68 9,189.60 6,912.12 7,723.37 8,777.51 69,360.19

Weddings

0.00

480.83

4,489.68

16,335.56 21,489.50 41,372.49 19,290.00 46,184.05 17,100.43 13,870.83 180,613.37

Hotel Events

(215.00)

(158.33)

373.33

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

Breakfast Sales

2,414.59

0.00

7,287.53

7,748.92 7,384.67 9,241.77 11,686.41 11,912.57 12,201.29 10,617.41 80,495.16

Sales Gym

0.00

124.76

54.04

153.73

187.01

224.38

62.34

37.38

24.92

12.46

881.02

Ledger Sales

0.00

17,513.97

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00 17,513.97

Gym Membership

200.89

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

0.00

200.89

Bank Interest

1.80 51.28 99,391.45 108,084.48 107,896.97 137,653.53 137,871.96 188,322.48 183,264.27 215,776.43 180,314.58 157,599.75 1,516,175. 2.13 8.35 3.22 5.49 3.76 5.59 7.19 6.09 7.66

Purchases Lodge Expenses

100.80

391.70

(122.50)

0.00

5.50

0.00

115.94

(99.36)

0.00

0.00

392.08

Food & Beverages Purchases Out Sourced Accommodation Miscellaneous Purchases Function Purchases

14,318.95

12,846.67

16,981.85

20,398.68 24,717.78 24,550.36 27,109.59 39,250.55 23,678.96 25,572.12 229,425.51

0.00

0.00

131.66

200.00

174.53

104.00

0.00

0.00

0.00

0.00

610.19

15.00

(322.85)

424.20

200.08

5.42

455.25

795.71

398.15

229.59

259.00 2,459.55

250.00

3,057.55

2,027.42

278.33 1,499.10 1,187.83 6,365.50 2,596.00 2,605.02 2,830.00 22,696.75

Hotel Room Consumables

0.00

463.17

195.03

0.00

168.00 1,766.80 (744.65)

1,208.72

875.77 1,063.57 4,996.41