Hotel Directors Meeting March 2020

Quorn Grange Hotel

Date: 06/03/2020 Time: 14:35:40

Page: 1

Profit and Loss (Actual, Budget & Prior Year)

From:

Month 2, February 2020 Month 2, February 2020

To:

Chart of Accounts:

Detailed Layout of Accounts [PARTIAL]

Period

Year to Date

Actual

Budget

Prior Year

Actual

Budget

Prior Year

Sales Food & Beverages Miscellaneous Sales

34,007.75

62,430.23

41,248.52 2,240.61 73,845.54 10,053.15 3,915.39

53,638.00 1,700.00 90,583.00 4,000.00 7,200.00

80,776.31 2,599.89 141,048.12 19,269.81

99,696.00 3,200.00 168,098.00 6,500.00 14,400.00

362.43

362.43

50,692.97 5,057.97

119,086.44

Accomodation Conferences

5,224.64

480.83

480.83

Weddings

5,562.47

(158.33)

(373.33) 2,414.59

Hotel Events

0.00

0.00

0.00

0.00

0.00

Breakfast Sales

9,410.82

10,870.00

18,420.04

20,172.00 1,000.00

124.76

124.76

Sales Gym

20.75

500.00

91.34

17,513.97

17,513.97

Ledger Sales

0.00 0.00 3.66

0.00 0.00

0.00 0.00 6.82

0.00 0.00

0.00 2.13

200.89

Gym Membership

10.48

Bank Interest

50.00

100.00

140,738.44

168,541.00

108,084.48

267,774.80

313,166.00

207,475.93

Purchases Lodge Expenses

391.70

492.50

11.70

0.00

11.70

0.00

12,846.67

27,165.62

Food & Beverages Purchases Out Sourced Accommodation Miscellaneous Purchases

21,273.43

23,469.00

41,247.38

43,638.00

0.00

0.00

0.00

0.00 0.00 0.00 0.00 0.00

349.98 775.28

0.00 0.00 0.00 0.00 0.00

(322.85) 3,057.55

(307.85) 3,307.55

672.76

Function Purchases

1,199.40

1,723.34 1,902.09

463.17

463.17

Hotel Room Consumables

913.62

2,730.95

1,801.30

Movement in Stock

0.00

740.40

24,070.91

23,469.00

19,167.19

46,750.17

43,638.00

32,922.29

Direct Expenses Operating Gross Wages

47,898.22

100,013.37

46,487.50

41,000.00 3,375.00 26,500.00

100,320.35 1,631.97 38,688.65

85,000.00 6,900.00 53,000.00

390.92

871.89

Operating Employer Pension

735.47

20,222.08

40,404.97

Admin Gross Wages

19,215.36

450.27 274.10

450.27 540.36

Agency Staff

0.00

0.00 0.00

0.00

0.00 0.00

Admin Employers Pension

459.06

927.27

66,897.39

70,875.00

69,235.59

141,568.24

144,900.00

142,280.86

32,272.78

19,681.70

Gross Profit/(Loss):

49,770.14

74,197.00

79,456.39

124,628.00

Overheads Bar & Restaurant Consumables

0.00

40.92

382.75

0.00

754.45

0.00

5,830.38

9,991.62

Cleaning & Laundry

6,336.66

8,152.00

11,875.91

15,128.00

0.00

0.00

Events

418.00

506.00

418.00

940.00

(562.90)

(562.90)

Marketing

1,959.40

4,214.00

3,770.30

7,830.00

0.00

0.00

Recruitment Advertising

0.00

300.00

0.00

600.00

(66.62) 232.67

545.77 649.80

IT Expenses

1,359.11

1,200.00

2,593.31 2,153.37

2,400.00 1,300.00

Printing & Stationery

945.01

650.00

13.40

61.56

Postage

0.00

35.00

4.25

70.00

(120.20)

(47.21) 150.10 8,735.90 1,256.90

Garden Expenditure Gym Expenditure Repairs & Maintenance

(2,815.97)

1,800.00

1,184.03

3,600.00

69.10

50.90

150.00

66.00

300.00

1,430.30

768.34 916.10

5,435.00 3,623.00

2,956.31 1,685.22

10,086.00 6,724.00

809.34

Kitchen Repairs & Maintenance

0.00 0.00 0.00

0.00 0.00 0.00

Advertising

0.00 0.00

0.00

160.00 551.29 270.00

0.00

Uniforms Licences

350.00 400.00

700.00 800.00

135.00