EC Papers September 2017

1

Page:

Date: 21/08/2017

Quorn Grange Hotel

Time: 10:18

Profit & Loss by Department (Advanced Budget and Variance)

All

Period From:

Month 1, January

Year:

2017

Department:

Period To:

Month 7, July

Chart of Accounts: Detailed Layout of Accounts

Actual

Budget

Variance

Sales Food & Beverages Miscellaneous Sales

196,308.74

29,793.97 (518.18) 37,099.61 (22,219.65) (14,537.04) (30,591.67) (6,513.42) (4,809.24) (1,921.67) (327.07) 3,200.10 617.53

166,514.77

3,731.82

4,250.00

Accomodation Conferences

367,442.70 29,980.35 144,462.96

330,343.09 52,200.00 159,000.00 30,800.00 33,034.30

Weddings

Hotel Events

208.33

Breakfast Sales Nursery Fees Nursery Meals Gym Membership

26,520.88

617.53

0.00

14,290.76 3,028.33

19,100.00 4,950.00

Bank Interest Kurdish Event

22.93

350.00

3,200.10

0.00

789,815.43

800,542.16

(10,726.73)

Purchases Food & Beverages Purchases Miscellaneous Purchases

141,855.45 1,512.13 13,395.21 4,489.49 (1,734.79)

(17,231.25)

124,624.20

(812.13)

700.00

Function Purchases

(13,395.21) (4,489.49)

0.00 0.00 0.00

Hotel Room Consumables

Movement in Stock

1,734.79

159,517.49

125,324.20

(34,193.29)

Direct Expenses Operating Gross Wages

272,671.13

83,507.78 4,947.35

356,178.91

Operating Employer Pension

3,957.12

8,904.47

Admin Gross Wages

118,229.30

(118,229.30)

0.00 0.00

Admin Employers Pension

1,920.82

(1,920.82)

396,778.37

365,083.38

(31,694.99)

Gross Profit (Loss):

233,519.57

310,134.58

(76,615.01)

Overheads Bar & Restaurant Consumables Cleaning & Laundry

2,379.10 34,316.14 8,907.62 16,477.31

(2,379.10)

0.00

5,325.03

39,641.17 4,002.70 32,021.70

Events

(4,904.92) 15,544.39

Marketing

Recruitment Advertising

132.00

288.00

420.00

IT Expenses

15,418.79 4,954.51

(8,418.79)

7,000.00 4,550.00

Printing & Stationery

(404.51) (149.69)

Postage

394.69

245.00

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

12,119.75

(1,407.75)

10,712.00 1,050.00 10,791.62 12,443.33

673.92

376.08

13,337.69 10,491.86

(2,546.07)

1,951.47 (500.00) (551.06)

500.00 551.06

0.00 0.00

Advertising

Uniforms

1,052.70

347.30

1,400.00