EC Meeting Papers January 2018

1

Page:

Date: 20/12/2017

Quorn Grange Hotel

Time: 15:03

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

2017 Month 11, November Year:

Department:

Period To:

Month 11, November

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

27,176.60 1,101.57 53,334.80 5,422.93 7,980.90

(1,660.84)

28,837.44

301.57

800.00

Accomodation Conferences

5,272.40 (77.07)

48,062.40 5,500.00 10,500.00 2,500.00 4,806.24 2,500.00

Weddings

(2,519.10) (2,366.67)

Hotel Events

133.33

Breakfast Sales Nursery Meals Gym Membership

4,364.16 1,900.75

(442.08) (599.25) (334.04) (47.75)

365.96

700.00

Bank Interest

2.25

50.00

101,783.25

104,256.08

(2,472.83)

Purchases Food & Beverages Purchases Miscellaneous Purchases

16,898.23

(1,505.82)

15,392.41

17.83

82.17

100.00

Function Purchases

2,459.19

(2,459.19)

0.00 0.00 0.00

Hotel Room Consumables

938.47

(938.47)

Movement in Stock

(830.17)

830.17

19,483.55

15,492.41

(3,991.14)

Direct Expenses Operating Gross Wages

39,318.40

7,596.84

46,915.24 1,172.88

Operating Employer Pension

480.46

692.42

Admin Gross Wages

18,113.19

(18,113.19)

0.00 0.00

Admin Employers Pension

269.29

(269.29)

58,181.34

48,088.12

(10,093.22)

Gross Profit (Loss):

24,118.36

40,675.55

(16,557.19)

Overheads Bar & Restaurant Consumables Cleaning & Laundry

100.10

(100.10)

0.00

4,965.17

802.32 521.28

5,767.49

Events

0.00

521.28

Marketing

884.00

3,286.24

4,170.24

Recruitment Advertising

0.00

60.00

60.00

IT Expenses

2,260.59

(1,260.59)

1,000.00

Printing & Stationery

346.23

303.77

650.00

Postage

28.00

7.00

35.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

2,334.75

(1,608.75)

726.00 150.00

86.00

64.00

1,374.06 1,246.45

308.12 676.05

1,682.18 1,922.50

Kitchen Repairs & Maintenance Advertising

899.00

(899.00) 200.00 (67.35) (942.87)

0.00

Uniforms Licences

0.00

200.00 350.00

417.35

Commissions

2,865.37 6,287.93

1,922.50 4,691.52

Rates and Insurance

(1,596.41)