EC Meeting Papers July 2018

Date: 26/06/2018

Page:

1

Quorn Grange Hotel

Time: 16:27

Profit & Loss per Department (Advanced Budget and Variance)

Period From:

Month 5, May Month 5, May

Year: 2018

Department:

All

Period To:

Chart of Accounts: Detailed Layout of Accounts

Department:

0

Hotel

Actual

Budget

Variance

Sales Groupon Discounts

0.00

0.00

0.00

Food & Beverages

44,664.64

6,073.36

38,591.28

Miscellaneous Sales

92.98

(307.02)

400.00

Accomodation

77,765.04

22,634.64

55,130.40

Conferences

2,593.97

(5,406.03)

8,000.00

Weddings

13,110.01

(24,889.99)

38,000.00

Hotel Events

299.17

299.17

0.00

Breakfast Sales

6,689.62

73.97

6,615.65

Nursery Meals

0.00

(2,800.00)

2,800.00

Lodge Rental Income

0.00

0.00

0.00

Gym Membership

242.65

(357.35)

600.00

Bank Interest

3.79

(46.21)

50.00

Kurdish Event

0.00

0.00

0.00

145,461.87

150,187.33

(4,725.46)

Purchases Food & Beverages Purchases

23,122.71

8,699.85

31,822.56

Out Sourced Accommodation

0.00

0.00

0.00

Miscellaneous Purchases

254.76

(254.76)

0.00

Function Purchases

875.00

(875.00)

0.00

Hotel Room Consumables

841.54

(841.54)

0.00

Movement in Stock

(2,021.95)

2,021.95

0.00

23,072.06

31,822.56

8,750.50

Direct Expenses Operating Gross Wages

46,985.26

17,595.29

64,580.55

Operating Employer Pension

496.11

472.60

968.71

Staff Holidays

0.00

0.00

0.00

Admin Gross Wages

19,449.23

(19,449.23)

0.00

Admin Holidays

0.00

0.00

0.00

Admin Employers Pension

274.10

(274.10)

0.00

Sessional Pay

0.00

0.00

0.00

67,204.70 55,185.11

65,549.26 52,815.51

(1,655.44) 2,369.60

Gross Profit(Loss): Overheads Holiday Pay for Staff

0.00

0.00

0.00

Bar & Restaurant Consumables

0.00

0.00

0.00

Made with FlippingBook HTML5