EC Meeting November 2018

1

Page:

Date: 12/10/2018

Quorn Grange Hotel

Time: 18:48

Profit & Loss by Department (Advanced Budget and Variance)

Period From: Month 8, August

Year:

2018

Department:

All

Period To:

Month 8, August

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

62,824.66

20,209.33 (275.21) 35,922.14 (1,634.16) (34,463.79)

42,615.33

224.79

500.00

Accomodation Conferences

96,801.18 1,365.84 30,536.21

60,879.04 3,000.00 65,000.00

Weddings

Hotel Events

166.67

166.67

0.00

Breakfast Sales Nursery Meals Gym Membership

4,954.99

(2,350.49) (2,600.00)

7,305.48 2,600.00

0.00

216.00

(384.00) (43.11)

600.00

Bank Interest

6.89

50.00

197,097.23

182,549.85

14,547.38

Purchases Lodge Expenses

900.00

(900.00) 12,886.78 (3,601.53) (4,034.75)

0.00

Food & Beverages Purchases Miscellaneous Purchases

30,595.92 3,601.53 4,034.75

43,482.70

0.00 0.00 0.00 0.00

Function Purchases

Hotel Room Consumables

98.53

(98.53) 2,048.56

Movement in Stock

(2,048.56)

37,182.17

43,482.70

6,300.53

Direct Expenses Operating Gross Wages

44,009.51

25,359.43

69,368.94 1,040.53

Operating Employer Pension

455.91

584.62

Admin Gross Wages

19,599.38

(19,599.38)

0.00 0.00 0.00

Agency Staff

912.35 274.10

(912.35) (274.10)

Admin Employers Pension

65,251.25

70,409.47

5,158.22

Gross Profit (Loss):

94,663.81

68,657.68

26,006.13

Overheads Cleaning & Laundry

6,761.20

544.28 912.75

7,305.48

Events

0.00

912.75

Marketing

587.50

6,714.49

7,301.99

Recruitment Advertising

0.00

60.00

60.00

IT Expenses

2,646.62 2,709.46

(2,146.62) (2,059.46)

500.00 650.00

Printing & Stationery

Postage

3.95

31.05

35.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

1,547.04

(875.04)

672.00 150.00

41.00

109.00

5,025.49 4,403.28

(1,981.54) (1,968.12)

3,043.95 2,435.16

Kitchen Repairs & Maintenance Advertising

74.92 94.00

(74.92) 156.00 (120.83) (795.36)

0.00

Uniforms Licences

250.00 350.00

470.83

Commissions

3,230.52

2,435.16