21 / 99
1
Date: 21/08/2017
Page:
Quorn Grange Hotel
Time: 10:18
All
Period From:
Profit & Loss by Department (Advanced Budget and Variance)
Department:
2017
Month 1, January
Year:
Period To:
Month 7, July
Chart of Accounts: Detailed Layout of Accounts
Actual
Budget
Variance
Sales
Food & Beverages
196,308.74
166,514.77
29,793.97
Miscellaneous Sales
3,731.82
4,250.00
(518.18)
Accomodation
367,442.70
330,343.09
37,099.61
Conferences
29,980.35
52,200.00
(22,219.65)
Weddings
144,462.96
159,000.00
(14,537.04)
Hotel Events
208.33
30,800.00
(30,591.67)
Breakfast Sales
26,520.88
33,034.30
(6,513.42)
Nursery Fees
617.53
0.00
617.53
Nursery Meals
14,290.76
19,100.00
(4,809.24)
Gym Membership
3,028.33
4,950.00
(1,921.67)
Bank Interest
22.93
350.00
(327.07)
Kurdish Event
3,200.10
0.00
3,200.10
789,815.43
800,542.16
(10,726.73)
Purchases
Food & Beverages Purchases
141,855.45
124,624.20
(17,231.25)
Miscellaneous Purchases
1,512.13
700.00
(812.13)
Function Purchases
13,395.21
0.00
(13,395.21)
Hotel Room Consumables
4,489.49
0.00
(4,489.49)
Movement in Stock
(1,734.79)
0.00
1,734.79
159,517.49
125,324.20
(34,193.29)
Direct Expenses
Operating Gross Wages
272,671.13
356,178.91
83,507.78
Operating Employer Pension
3,957.12
8,904.47
4,947.35
Admin Gross Wages
118,229.30
0.00
(118,229.30)
Admin Employers Pension
1,920.82
0.00
(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
2,379.10
0.00
(2,379.10)
Cleaning & Laundry
34,316.14
39,641.17
5,325.03
Events
8,907.62
4,002.70
(4,904.92)
Marketing
16,477.31
32,021.70
15,544.39
Recruitment Advertising
132.00
420.00
288.00
IT Expenses
15,418.79
7,000.00
(8,418.79)
Printing & Stationery
4,954.51
4,550.00
(404.51)
Postage
394.69
245.00
(149.69)
Garden Expenditure
12,119.75
10,712.00
(1,407.75)
Gym Expenditure
673.92
1,050.00
376.08
Repairs & Maintenance
13,337.69
10,791.62
(2,546.07)
Kitchen Repairs &
Maintenance
10,491.86
12,443.33
1,951.47
Refurbishment Expenses
500.00
0.00
(500.00)
Advertising
551.06
0.00
(551.06)
Uniforms
1,052.70
1,400.00
347.30