EC Papers September 2017

1

Page:

Date: 21/08/2017

Quorn Grange Hotel

Time: 10:19

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

Month 7, July Month 7, July

Year:

2017

Department:

Period To:

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

31,924.46

10,155.02 (468.95) 2,889.67 1,913.12 (123.41) (2,000.00)

21,769.44

431.05

900.00

Accomodation Conferences

57,313.27 4,913.12 49,876.59

54,423.60 3,000.00 50,000.00 2,000.00 5,442.36

Weddings

Hotel Events

0.00

Breakfast Sales Nursery Fees Nursery Meals Gym Membership

5,306.04

(136.32)

617.53

617.53

0.00

1,764.83

(535.17) (88.12) (46.36) 3,200.10

2,300.00

411.88

500.00

Bank Interest Kurdish Event

3.64

50.00

3,200.10

0.00

155,762.51

140,385.40

15,377.11

Purchases Food & Beverages Purchases Miscellaneous Purchases

28,705.11

(2,466.22)

26,238.89

275.30

(175.30)

100.00

Function Purchases

3,248.00

(3,248.00)

0.00 0.00 0.00

Hotel Room Consumables

920.72 102.31

(920.72) (102.31)

Movement in Stock

33,251.44

26,338.89

(6,912.55)

Direct Expenses Operating Gross Wages

40,394.51

15,759.65

56,154.16 1,403.85

Operating Employer Pension

551.28

852.57

Admin Gross Wages

17,084.44

(17,084.44)

0.00 0.00

Admin Employers Pension

269.29

(269.29)

58,299.52

57,558.01

(741.51)

Gross Profit (Loss):

64,211.55

56,488.50

7,723.05

Overheads Bar & Restaurant Consumables Cleaning & Laundry

367.44

(367.44) 1,076.95 (6,938.36) 3,081.42

0.00

5,453.88 7,640.29 2,534.00

6,530.83

Events

701.93

Marketing

5,615.42

Recruitment Advertising

132.00

(72.00)

60.00

IT Expenses

5,285.49 2,130.29

(4,285.49) (1,480.29)

1,000.00

Printing & Stationery

650.00

Postage

87.98

(52.98) 496.03

35.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

175.97 135.87

672.00 150.00

14.13

2,877.66 1,451.86

(972.83) 725.08 (66.58) 200.00

1,904.83 2,176.94

Kitchen Repairs & Maintenance Advertising

66.58

0.00

Uniforms Licences

0.00

200.00 350.00

262.01

87.99