23 / 99
1
Date: 21/08/2017
Page:
Quorn Grange Hotel
Time: 10:19
All
Period From:
Profit & Loss by Department (Advanced Budget and Variance)
Department:
2017
Month 7, July
Year:
Period To:
Month 7, July
Chart of Accounts: Detailed Layout of Accounts
Actual
Budget
Variance
Sales
Food & Beverages
31,924.46
21,769.44
10,155.02
Miscellaneous Sales
431.05
900.00
(468.95)
Accomodation
57,313.27
54,423.60
2,889.67
Conferences
4,913.12
3,000.00
1,913.12
Weddings
49,876.59
50,000.00
(123.41)
Hotel Events
0.00
2,000.00
(2,000.00)
Breakfast Sales
5,306.04
5,442.36
(136.32)
Nursery Fees
617.53
0.00
617.53
Nursery Meals
1,764.83
2,300.00
(535.17)
Gym Membership
411.88
500.00
(88.12)
Bank Interest
3.64
50.00
(46.36)
Kurdish Event
3,200.10
0.00
3,200.10
155,762.51
140,385.40
15,377.11
Purchases
Food & Beverages Purchases
28,705.11
26,238.89
(2,466.22)
Miscellaneous Purchases
275.30
100.00
(175.30)
Function Purchases
3,248.00
0.00
(3,248.00)
Hotel Room Consumables
920.72
0.00
(920.72)
Movement in Stock
102.31
0.00
(102.31)
33,251.44
26,338.89
(6,912.55)
Direct Expenses
Operating Gross Wages
40,394.51
56,154.16
15,759.65
Operating Employer Pension
551.28
1,403.85
852.57
Admin Gross Wages
17,084.44
0.00
(17,084.44)
Admin Employers Pension
269.29
0.00
(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
367.44
0.00
(367.44)
Cleaning & Laundry
5,453.88
6,530.83
1,076.95
Events
7,640.29
701.93
(6,938.36)
Marketing
2,534.00
5,615.42
3,081.42
Recruitment Advertising
132.00
60.00
(72.00)
IT Expenses
5,285.49
1,000.00
(4,285.49)
Printing & Stationery
2,130.29
650.00
(1,480.29)
Postage
87.98
35.00
(52.98)
Garden Expenditure
175.97
672.00
496.03
Gym Expenditure
135.87
150.00
14.13
Repairs & Maintenance
2,877.66
1,904.83
(972.83)
Kitchen Repairs &
Maintenance
1,451.86
2,176.94
725.08
Advertising
66.58
0.00
(66.58)
Uniforms
0.00
200.00
200.00
Licences
262.01
350.00
87.99