November EC Meeting 2019

Quorn Grange Hotel

Date: 12/11/2019 Time: 17:42:47

Page: 1

Profit and Loss (Actual, Budget & Prior Year)

From:

Month 10, October 2019 Month 10, October 2019

To:

Chart of Accounts:

Detailed Layout of Accounts

Period

Year to Date

Actual

Budget

Prior Year

Actual

Budget

Prior Year

Sales Food & Beverages Miscellaneous Sales

32,525.57

399,104.26

41,562.86 1,572.52 81,178.50 8,777.51 13,870.83

62,734.00

425,869.50 17,866.64 723,323.88 69,360.19 180,613.37

464,528.00

(21.07)

1,420.41

650.00

6,560.00

80,319.70 2,080.86 9,157.32

606,810.60 27,446.79 187,577.87 2,013.35 49,440.96

Accomodation Conferences

83,645.00 6,000.00 30,000.00

619,368.00 55,700.00 382,750.00

Weddings

118.34

Hotel Events

0.00

0.00

0.00

0.00

3,117.05

Breakfast Sales

10,617.41

12,546.00

80,495.16

92,904.00 5,000.00

0.00 0.00

0.00

Sales Gym

12.46

500.00

881.02

4,069.39 2,507.84

Ledger Sales

0.00 0.00 7.66 0.00

0.00 0.00

17,513.97

0.00 0.00

49.92

Gym Membership

200.89

1.54 0.00

31.28

Bank Interest Kurdish Event

50.00

51.28

500.00

0.00

3,500.00

0.00

26,700.00

157,599.75

199,625.00

127,349.23

1,516,175.90

1,654,010.00

1,280,422.75

Purchases Lodge Expenses

0.00

1,855.41

0.00

0.00

392.08

0.00

25,344.24

217,237.51

Food & Beverages Purchases Out Sourced Accommodation Miscellaneous Purchases

25,572.12

32,637.00

229,425.51

291,453.00

0.00

219.71

0.00

0.00 0.00 0.00 0.00 0.00

610.19

0.00 0.00 0.00 0.00 0.00

3,195.65 2,174.50 2,102.31 2,485.71

12,538.50 19,166.21 5,952.07 (2,093.67)

259.00

2,459.55 22,696.75 4,996.41 (1,657.49)

Function Purchases

2,830.00 1,063.57 (1,620.03)

Hotel Room Consumables

Movement in Stock

28,104.66

32,637.00

35,302.41

258,923.00

291,453.00

254,875.74

Direct Expenses Operating Gross Wages

43,920.60

439,903.47

60,644.16

53,708.00 1,497.00 21,151.00

498,424.84

457,314.00 13,394.00 211,510.00

417.74

5,076.03

Operating Employer Pension

989.39

7,349.47

22,324.22

204,785.72

Admin Gross Wages

19,821.96

199,723.90 10,718.72

0.00

1,269.35 2,748.02

Agency Staff

285.25 478.19

0.00 0.00

0.00 0.00

274.10

Admin Employers Pension

4,402.09

82,218.95

76,356.00

66,936.66

720,619.02

682,218.00

653,782.59

371,764.42

25,110.16

Gross Profit/(Loss):

47,276.14

90,632.00

536,633.88

680,339.00

Overheads Bar & Restaurant Consumables

0.00

224.81

174.15

0.00

1,763.39 61,248.77 4,045.00 8,073.01

0.00

5,668.03

56,480.05 1,279.80 7,713.51

Cleaning & Laundry

7,187.73

6,691.00

49,544.00 4,958.00 46,551.00 2,500.00 12,000.00 6,150.00 23,040.00 1,500.00 31,636.00 26,341.00 350.00

259.00 171.70

Events

0.00

598.00

Marketing

1,677.73

4,990.00

0.00

0.00

Recruitment Advertising

0.00

250.00

720.00

2,222.96 1,211.48

14,894.47 9,320.94

IT Expenses

1,487.96

1,200.00

13,188.42 6,637.82

Printing & Stationery

735.59

650.00

17.42

115.86

Postage

29.20

35.00

156.50

180.74

25,963.02

Garden Expenditure Gym Expenditure Repairs & Maintenance

1,344.96

2,500.00

9,862.91

97.70

808.71

227.50

150.00

870.22

3,493.57 6,888.56

37,454.26 25,430.00

10,462.66

3,764.00 3,345.00

49,106.78 7,462.11 2,230.00

Kitchen Repairs & Maintenance

656.86

0.00 0.00

613.16 922.18

Advertising

1,535.00

0.00

0.00

Uniforms

25.00

250.00

495.68

2,500.00