EC Meeting Papers January 2018

1

Page:

Date: 20/12/2017

Quorn Grange Hotel

Time: 15:05

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

Month 1, January

Year:

2017

Department:

Period To:

Month 11, November

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

319,656.32 12,741.53 585,707.22 46,718.72 261,054.47

58,150.37 6,191.53 39,537.81 (24,981.28) (33,445.53) (40,825.01) (6,191.55)

261,505.95

6,550.00

Accomodation Conferences

546,169.41 71,700.00 294,500.00 41,300.00 54,616.93

Weddings

Hotel Events

474.99

Breakfast Sales Nursery Fees Nursery Meals Gym Membership

48,425.38

617.53

617.53

0.00

22,236.06 4,246.80

(7,263.94) (3,403.20)

29,500.00 7,650.00

Bank Interest Kurdish Event

42.26

(507.74) 4,091.72

550.00

4,091.72

0.00

1,306,013.00

1,314,042.29

(8,029.29)

Purchases Food & Beverages Purchases Miscellaneous Purchases

230,305.23 1,962.46 24,539.15 8,412.11 (2,574.38)

(19,064.67)

211,240.56

(862.46)

1,100.00

Function Purchases

(24,539.15) (8,412.11)

0.00 0.00 0.00

Hotel Room Consumables

Movement in Stock

2,574.38

262,644.57

212,340.56

(50,304.01)

Direct Expenses Operating Gross Wages

435,818.44

130,973.33

566,791.77 14,169.79

Operating Employer Pension

6,065.88

8,103.91

Admin Gross Wages

188,351.30

(188,351.30)

0.00 0.00 0.00

Agency Staff

1,256.44 2,997.98

(1,256.44) (2,997.98)

Admin Employers Pension

634,490.04

580,961.56

(53,528.48)

Gross Profit (Loss):

408,878.39

520,740.17

(111,861.78)

Overheads Bar & Restaurant Consumables Cleaning & Laundry

3,097.28 55,862.46 4,025.13 24,198.94

(3,097.28) 9,677.87 2,545.07 28,362.76

0.00

65,540.33 6,570.20 52,561.70

Events

Marketing

Recruitment Advertising

297.00

363.00

660.00

IT Expenses

25,590.43 8,345.36

(14,590.43) (1,195.36)

11,000.00 7,150.00

Printing & Stationery

Postage

746.87

(361.87)

385.00

Garden Expenditure Gym Expenditure Repairs & Maintenance Kitchen Repairs & Maintenance Refurbishment Expenses

25,182.99

(8,117.99)

17,065.00 1,650.00 18,345.53 21,076.39

941.44

708.56

23,416.15 17,823.29

(5,070.62) 3,253.10 (500.00) (1,516.64)

500.00

0.00 0.00

Advertising

1,516.64