EC Meeting Papers July 2018

1

Page:

Date: 26/06/2018

Quorn Grange Hotel

Time: 19:04

Profit & Loss by Department (Advanced Budget and Variance)

Period From: Month 1, January

Year:

2018

Department:

All

Period To:

Month 5, May

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

164,293.15

(2,621.30) (1,756.37) 22,736.90 (30,806.59) (32,959.55) (3,400.17) (9,980.61) (2,028.17) 1,285.83

166,914.45

693.63

2,450.00

Accomodation Conferences

261,186.11 15,393.41 90,040.45 1,285.83 25,213.74 4,069.39 1,921.83

238,449.21 46,200.00 123,000.00 28,613.91 14,050.00 3,950.00 0.00

Weddings

Hotel Events

Breakfast Sales Nursery Meals Gym Membership

Bank Interest Kurdish Event

10.96

(239.04)

250.00

0.00

(19,000.00)

19,000.00

564,108.50

642,877.57

(78,769.07)

Purchases Lodge Expenses

1,855.41 91,396.10

(1,855.41) 31,657.89

0.00

Food & Beverages Purchases Out Sourced Accommodation Miscellaneous Purchases

123,053.99

118.21

(118.21)

0.00 0.00 0.00 0.00 0.00

1,436.31 7,805.29 3,135.28

(1,436.31) (7,805.29) (3,135.28)

Function Purchases

Hotel Room Consumables

Movement in Stock

(1,589.16)

1,589.16

104,157.44

123,053.99

18,896.55

Direct Expenses Operating Gross Wages

207,904.41

90,545.21 1,944.48

298,449.62

Operating Employer Pension

2,532.27

4,476.75

Admin Gross Wages

100,843.34

(100,843.34)

0.00 0.00 0.00

Agency Staff

357.00

(357.00)

Admin Employers Pension

1,377.52

(1,377.52)

313,014.54

302,926.37

(10,088.17)

Gross Profit (Loss):

146,936.52

216,897.21

(69,960.69)

Overheads Bar & Restaurant Consumables Cleaning & Laundry

214.86

(214.86) 1,188.99 2,193.59 13,288.42

0.00

27,424.92 1,020.80 5,997.91

28,613.91 3,214.39 19,286.33

Events

Marketing

Recruitment Advertising

0.00

300.00

300.00

IT Expenses

5,979.81 2,922.52

(3,479.81)

2,500.00 3,250.00

Printing & Stationery

327.48

Postage

78.94

96.06

175.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

18,073.37

(8,705.37)

9,368.00

413.29

336.71

750.00

14,507.38 5,057.63

(2,584.92)

11,922.46 9,537.98

Kitchen Repairs & Maintenance Advertising

4,480.35 (388.40)

388.40

0.00