EC Papers September 2018

1

Page:

Date: 16/08/2018

Quorn Grange Hotel

Time: 10:19

Profit & Loss by Department (Advanced Budget and Variance)

Period From: Month 1, January

Year:

2018

Department:

All

Period To:

Month 7, July

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

270,923.19

16,860.76 (3,322.08) 38,751.62 (32,344.09) (83,513.74) 1,681.67 (7,559.68) (15,030.61) (2,824.50)

254,062.43

927.92

4,250.00

Accomodation Conferences

401,697.95 21,855.91 129,486.26 1,681.67 35,993.88 4,069.39 2,125.50

362,946.33 54,200.00 213,000.00 43,553.56 19,100.00 4,950.00 0.00

Weddings

Hotel Events

Breakfast Sales Nursery Meals Gym Membership

Bank Interest Kurdish Event

19.34

(330.66)

350.00

0.00

(19,000.00)

19,000.00

868,781.01

975,412.32

(106,631.31)

Purchases Lodge Expenses

1,855.41

(1,855.41) 58,437.23

0.00

Food & Beverages Purchases Out Sourced Accommodation Miscellaneous Purchases

137,557.68

195,994.91

118.21

(118.21)

0.00 0.00 0.00 0.00 0.00

3,507.24 10,766.54 3,672.99 (1,674.05)

(3,507.24) (10,766.54) (3,672.99)

Function Purchases

Hotel Room Consumables

Movement in Stock

1,674.05

155,804.02

195,994.91

40,190.89

Direct Expenses Operating Gross Wages

298,780.72

127,652.80

426,433.52

Operating Employer Pension

3,675.25

2,721.25

6,396.50

Admin Gross Wages

139,954.78

(139,954.78)

0.00 0.00 0.00

Agency Staff

357.00

(357.00)

Admin Employers Pension

1,925.72

(1,925.72)

444,693.47

432,830.02

(11,863.45)

Gross Profit (Loss):

268,283.52

346,587.39

(78,303.87)

Overheads Bar & Restaurant Consumables Cleaning & Laundry

214.86

(214.86) 5,399.71 3,856.27 23,654.02

0.00

38,153.85 1,020.80 7,313.01

43,553.56 4,877.07 30,967.03

Events

Marketing

Recruitment Advertising

0.00

420.00

420.00

IT Expenses

7,765.59 3,555.49

(4,265.59)

3,500.00 4,550.00

Printing & Stationery

994.51 166.06

Postage

78.94

245.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

24,112.32

(13,400.32)

10,712.00 1,050.00 18,147.32 14,517.86

641.01

408.99

24,878.68 12,609.81

(6,731.36) 1,908.05

Kitchen Repairs & Maintenance Advertising

538.24

(538.24)

0.00