F&GP Meeting November 2017

1

Page:

Date: 18/10/2017

Quorn Grange Hotel

Time: 10:46

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

2017 Month 9, September Year:

Department:

Period To:

Month 9, September

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

34,086.85 1,518.32 62,533.38 3,638.33 37,401.50

11,104.45 1,018.32 5,077.38 (1,861.67) (7,598.50) (2,500.00)

22,982.40

500.00

Accomodation Conferences

57,456.00 5,500.00 45,000.00 2,500.00 5,745.60 2,600.00

Weddings

Hotel Events

0.00

Breakfast Sales Nursery Meals Gym Membership

5,919.51 1,752.85

173.91

(847.15) (329.87) (37.88)

370.13

700.00

Bank Interest Kurdish Event

12.12 33.33

50.00

33.33

0.00

147,266.32

143,034.00

4,232.32

Purchases Food & Beverages Purchases Miscellaneous Purchases

20,000.91

5,187.33

25,188.24

0.00

100.00

100.00

Function Purchases

2,347.48 1,234.42 6,023.02

(2,347.48) (1,234.42) (6,023.02)

0.00 0.00 0.00

Hotel Room Consumables

Movement in Stock

29,605.83

25,288.24

(4,317.59)

Direct Expenses Operating Gross Wages

38,839.49

18,374.11

57,213.60 1,430.34

Operating Employer Pension

511.18

919.16

Admin Gross Wages

16,804.69

(16,804.69)

0.00 0.00 0.00

Agency Staff

766.72 269.29

(766.72) (269.29)

Admin Employers Pension

57,191.37

58,643.94

1,452.57

Gross Profit (Loss):

60,469.12

59,101.82

1,367.30

Overheads Bar & Restaurant Consumables Cleaning & Laundry

163.40

(163.40)

0.00

6,198.01 (6,531.46) 3,294.17

696.71

6,894.72

Events

7,246.63 2,427.19

715.17

Marketing

5,721.36

Recruitment Advertising

0.00

60.00

60.00

IT Expenses

4,508.45 2,376.95

(3,508.45) (1,726.95)

1,000.00

Printing & Stationery

650.00

Postage

118.00

(83.00) (935.23)

35.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

4,007.23

3,072.00

70.10

79.90

150.00

4,094.63 2,550.59 (40.76)

(2,083.67)

2,010.96 2,298.24

Kitchen Repairs & Maintenance Uniforms

(252.35)

240.76

200.00 350.00

Licences

266.10

83.90

Commissions

3,606.77

(1,308.53)

2,298.24