EC Papers September 2018

1

Page:

Date: 16/08/2018

Quorn Grange Hotel

Time: 11:55

Profit & Loss by Department (Advanced Budget and Variance)

Period From: Month 7, July

Year:

2018

Department:

All

Period To:

Month 7, July

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

49,730.87

5,994.09 (822.59) 6,638.52 (439.15)

43,736.78

77.41

900.00

Accomodation Conferences

69,119.64 2,560.85 18,112.05

62,481.12 3,000.00 50,000.00

Weddings

(31,887.95)

Hotel Events

307.51

307.51

0.00

Breakfast Sales Nursery Meals Gym Membership

7,097.80

(399.93)

7,497.73 2,300.00

0.00

(2,300.00)

112.25

(387.75) (45.49)

500.00

Bank Interest

4.51

50.00

147,122.89

170,465.63

(23,342.74)

Purchases Food & Beverages Purchases Miscellaneous Purchases

21,904.21 1,132.49

16,403.56 (1,132.49)

38,307.77

0.00 0.00 0.00 0.00

Function Purchases

827.92 291.24

(827.92) (291.24) 2,017.38

Hotel Room Consumables

Movement in Stock

(2,017.38)

22,138.48

38,307.77

16,169.29

Direct Expenses Operating Gross Wages

47,944.87

16,832.07

64,776.94

Operating Employer Pension

625.50

346.15

971.65

Admin Gross Wages

19,599.38

(19,599.38)

0.00 0.00

Admin Employers Pension

274.10

(274.10)

68,443.85

65,748.59

(2,695.26)

Gross Profit (Loss):

56,540.56

66,409.27

(9,868.71)

Overheads Cleaning & Laundry

4,642.68

2,855.05

7,497.73

Events

0.00

852.33

852.33

Marketing

1,162.60

5,656.03

6,818.63

Recruitment Advertising

0.00

60.00

60.00

IT Expenses

857.64

(357.64)

500.00 650.00

Printing & Stationery

61.09

588.91

Postage

0.00

35.00

35.00

Garden Expenditure Gym Expenditure Repairs & Maintenance

2,842.29

(2,170.29)

672.00 150.00

164.72

(14.72)

6,523.94 3,766.18

(3,399.88) (1,266.94) (74.92) 250.00 174.17 1,947.24 2,637.24 2,023.28

3,124.06 2,499.24

Kitchen Repairs & Maintenance Advertising

74.92

0.00

Uniforms Licences

0.00

250.00 350.00

175.83 552.00

Commissions

2,499.24 6,511.93 8,523.28

Rates and Insurance Heat, Light and Power

3,874.69 6,500.00