EC Meeting November 2018

1

Page:

Date: 12/10/2018

Quorn Grange Hotel

Time: 18:50

Profit & Loss by Department (Advanced Budget and Variance)

Period From: Month 1, January

Year:

2018

Department:

All

Period To:

Month 8, August

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

333,747.85

37,070.09 (3,597.29) 74,674.76 (33,978.25) (117,977.53) (9,910.17) (17,630.61) (3,208.50) 1,848.34

296,677.76

1,152.71

4,750.00

Accomodation Conferences

498,500.13 23,221.75 160,022.47 1,848.34 40,948.87 4,069.39 2,341.50

423,825.37 57,200.00 278,000.00 50,859.04 21,700.00 5,550.00 0.00

Weddings

Hotel Events

Breakfast Sales Nursery Meals Gym Membership

Bank Interest Kurdish Event

26.23

(373.77)

400.00

0.00

(19,000.00)

19,000.00

1,065,879.24

1,157,962.17

(92,082.93)

Purchases Lodge Expenses

2,755.41

(2,755.41) 71,762.37

0.00

Food & Beverages Purchases Out Sourced Accommodation Miscellaneous Purchases

167,715.24

239,477.61

118.21

(118.21)

0.00 0.00 0.00 0.00 0.00

7,108.77 14,801.29 3,771.52 (3,722.61)

(7,108.77) (14,801.29) (3,771.52)

Function Purchases

Hotel Room Consumables

Movement in Stock

3,722.61

192,547.83

239,477.61

46,929.78

Direct Expenses Operating Gross Wages

345,206.98

150,595.48

495,802.46

Operating Employer Pension

4,131.16

3,305.87

7,437.03

Admin Gross Wages

159,554.16

(159,554.16)

0.00 0.00 0.00

Agency Staff

1,269.35 2,199.82

(1,269.35) (2,199.82)

Admin Employers Pension

512,361.47

503,239.49

(9,121.98)

Gross Profit (Loss):

360,969.94

415,245.07

(54,275.13)

Overheads Bar & Restaurant Consumables Cleaning & Laundry

214.86

(214.86) 5,943.99 4,769.02 31,152.41

0.00

44,915.05 1,020.80 7,116.61

50,859.04 5,789.82 38,269.02

Events

Marketing

Recruitment Advertising

0.00

480.00

480.00

IT Expenses

10,412.21 6,264.95

(6,412.21) (1,064.95)

4,000.00 5,200.00

Printing & Stationery

Postage

82.89

197.11

280.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

25,659.36

(14,275.36)

11,384.00 1,200.00 21,191.27 16,953.02

682.01

517.99

30,254.17 17,013.09

(9,062.90)

Kitchen Repairs & Maintenance Advertising

(60.07) (613.16)

613.16

0.00