Profit & Loss Forecast Summary Summary Profit & Loss
January February
March
April
May
June
Total Revenue
6 4, 4 8 6
111 11 1,67 670 0
1 1 1, 6 6 9
94,,00 94 002 2
104, 4,8 8 16
1 2 1, 5 1 2
Total Contribution
5 7, 4 4 9
99,975
99 , 9 75
82,523
9 0, 6 4 9
1 0 5, 63 8
Labour & Other Staff Costs
5 3, 3 1 5
53,315
53 , 3 15
53,315
5 3, 3 1 5
5 3 , 31 5
Direct Costs & Overheads
6 , 54 6
6,882
6 , 88 2
6,840
6, 9 6 6
7 , 2 18
Selling Costs
5 , 41 8
6,333
6 , 33 3
5,992
6, 2 0 3
6 , 5 27
- 7 , 83 0
33,445
3 3, 4 45
16,377
2 4 , 1 65
38 , 5 78
0
0
0
0
0
0
- 7 , 83 0
33,445
3 3, 4 45
16,377
2 4 , 1 65
38 , 5 78
0
0
0
0
0
0
Profit/(Loss) after tax
-7,830
33,445
33,445
16,377
24,165
38,578
Occupancy
4 5 . 2 0%
78 . 60 %
71 . 0 0%
70 . 0 0 %
7 7. 4 0 %
1 0 0. 0 0% 10
Average Room rate
2 32 . 8
21 4. 3
214.3
2 15
211.1
2 0 2. 6
Rev Par
1 05 . 2
16 8. 3
1 52
1 5 0. 5
163.4
2 0 2. 6
Direct Labour Cost %
7 9 . 0 0%
45 . 60 %
45 . 6 0%
54 . 2 0 %
4 8. 6 0 %
4 1. 90 %
Direct Costs & Overheads %
1 0 . 2 0%
6.20%
6. 2 0 %
7. 3 0%
6 . 60 %
5. 9 0%
8 . 4 0%
5.70%
5 . 70 %
6 . 40 %
5 . 9 0%
5 . 40 %
Operating Profit %
- 1 2 . 10 %
2 9 . 90 %
2 9 . 90 %
17 . 4 0%
23 . 1 0 %
3 1. 7 0%
Net Profit %
- 1 2 . 10 %
2 9 . 90 %
2 9 . 90 %
17 . 4 0%
23 . 1 0 %
3 1. 7 0%
Operating Profit Non Operating Costs Net Profit/(Loss) Taxation
Selling Costs %
July
August
eptembe October
ovemberDecember
T ot a l
129, 12 9,30 306 6
129, 12 9,30 306 6
121, 12 1,51 513 3
115, 11 5,08 086 6
98,,17 98 177 7
55,9 55 ,959 59 1, 1,25 257, 7,50 502 2
112, 11 2,19 197 7
112, 11 2,19 197 7
105, 10 5,63 639 9
103, 10 3,77 774 4
88,,75 88 750 0
50,4 50 ,495 95 1, 1,10 109, 9,26 260 0
53,315
53 , 3 15
53,315
5 3 , 31 5
53,315
53 , 3 15
639,780
7, 2 60
7 , 26 0
7,218
6 , 96 6
6,798
6 , 5 04
83,344
6, 6 78
6 , 67 8
6,527
6 , 39 8
6,070
5 , 2 52
74,408
44,943
44 , 9 43
38,579
3 7 , 09 5
22,567
-1 4 , 5 7 6
311,729
0
0
0
0
0
0
0
44,943
44 , 9 43
38,579
3 7 , 09 5
22,567
-1 4 , 5 7 6
311,729
0
0
0
0
0
0
0
44,943
44,943
38,579
37,095
22,567
-14,576
311,729
100. 0.0 00%
100.00% 100
100 00..00 00% %
7 7. 40 %
6 6. 70 %
4 1 . 90 %
77 . 3 0%
206.1
206.1
20 2. 6
2 16 . 6
21 1. 4
269.4
2 1 6. 9
206.1
206.1
20 2. 6
1 67 . 7
14 1
11 3
16 4 . 7
39.40%
39 . 4 0%
41.90%
4 4. 3 0 %
5 1 . 90 %
9 1. 10 %
48 . 6 0%
5.60%
5 . 60 %
5.90%
6 . 1 0%
6.90%
1 1. 6 0 %
6 . 6 0%
5.20%
5 . 20 %
5.40%
5 . 6 0%
6.20%
9. 40 %
5. 9 0 %
34.80%
34 . 8 0%
31.70%
3 2. 2 0 %
2 3 . 00 %
-26.00%
24 . 8 0%
34.80%
34 . 8 0%
31.70%
3 2. 2 0 %
2 3 . 00 %
-26.00%
24 . 8 0%
July
August
eptembe October
ovemberDecember
T ot a l
129, 12 9,30 306 6
129, 12 9,30 306 6
121, 12 1,51 513 3
115, 11 5,08 086 6
98,,17 98 177 7
55,9 55 ,959 59 1, 1,25 257, 7,50 502 2
112, 11 2,19 197 7
112, 11 2,19 197 7
105, 10 5,63 639 9
103, 10 3,77 774 4
88,,75 88 750 0
50,4 50 ,495 95 1, 1,10 109, 9,26 260 0
53,315
53 , 3 15
53,315
5 3 , 31 5
53,315
53 , 3 15
639,780
7, 2 60
7 , 26 0
7,218
6 , 96 6
6,798
6 , 5 04
83,344
6, 6 78
6 , 67 8
6,527
6 , 39 8
6,070
5 , 2 52
74,408
44,943
44 , 9 43
38,579
3 7 , 09 5
22,567
-1 4 , 5 7 6
311,729
0
0
0
0
0
0
0
44,943
44 , 9 43
38,579
3 7 , 09 5
22,567
-1 4 , 5 7 6
311,729
0
0
0
0
0
0
0
44,943
44,943
38,579
37,095
22,567
-14,576
311,729
100. 0.0 00%
100.00% 100
100 00..00 00% %
7 7. 40 %
6 6. 70 %
4 1 . 90 %
77 . 3 0%
206.1
206.1
20 2. 6
2 16 . 6
21 1. 4
269.4
2 1 6. 9
206.1
206.1
20 2. 6
1 67 . 7
14 1
11 3
16 4 . 7
39.40%
39 . 4 0%
41.90%
4 4. 3 0 %
5 1 . 90 %
9 1. 10 %
48 . 6 0%
5.60%
5 . 60 %
5.90%
6 . 1 0%
6.90%
1 1. 6 0 %
6 . 6 0%
5.20%
5 . 20 %
5.40%
5 . 6 0%
6.20%
9. 40 %
5. 9 0 %
34.80%
34 . 8 0%
31.70%
3 2. 2 0 %
2 3 . 00 %
-26.00%
24 . 8 0%
34.80%
34 . 8 0%
31.70%
3 2. 2 0 %
2 3 . 00 %
-26.00%
24 . 8 0%
Overall Profit & Loss Overall Profit & Loss
January February
March
April
May
June
Revenue Accommodation
3 2, 5 9 9
47,135
47 , 1 35
45,153
5 0, 6 6 0
6 0 , 79 2
Office Rental
0
0
0
0
0
0
Meeting Room / Equipment Hire
0
0
0
0
0
0
2 0, 8 8 2
34,508
34 , 5 08
33,824
4 1, 6 0 1
4 6 , 84 8
Bar
6 , 05 5
10,226
10 , 2 2 6
10,074
12 , 55 5
13 , 8 72
Other
4 , 95 0
19,800
19 , 8 0 0
4,950
0
0
Total Revenue
6 4, 4 8 6
111 11 1,67 670 0
1 1 1, 6 6 9
94,,00 94 002 2
104, 4,8 8 16
1 2 1, 5 1 2
Total Contribution
5 7, 4 4 9
99,975
99 , 9 75
82,523
9 0, 6 4 9
1 0 5, 63 8
Reception
4 , 36 3
4,363
4 , 36 3
4,363
4, 3 6 3
4 , 3 63
Porters / Security
5 , 30 9
5,309
5 , 30 9
5,309
5, 3 0 9
5 , 3 09
Housekeeping
8 , 74 2
8,742
8 , 74 2
8,742
8, 7 4 2
8 , 7 42
2 0, 2 5 4
20,254
20 , 2 54
20,254
2 0, 2 5 4
2 0 , 25 4
Kitchen
0
0
0
0
0
0
Bar
0
0
0
0
0
0
Maintenance
2 , 30 2
2,302
2 , 30 2
2,302
2, 3 0 2
2 , 3 02
Management/Administration
7 , 98 7
7,987
7 , 98 7
7,987
7, 9 8 7
7 , 9 87
0
0
0
0
0
0
2 , 00 0
2,000
2 , 00 0
2,000
2, 0 0 0
2 , 0 00
5 0, 9 5 7
50,957
50 , 9 57
50,957
5 0, 9 5 7
5 0 , 95 7
0
0
0
0
0
0
8 33
83 3
83 3
8 33
83 3
83 3
4 13
41 3
41 3
4 13
41 3
41 3
1 , 11 2
1,112
1 , 11 2
1,112
1, 1 1 2
1 , 1 12
0
0
0
0
0
0
5 3, 3 1 5
53,315
53 , 3 15
53,315
5 3, 3 1 5
5 3 , 31 5
ESB & Heating
8 33
83 3
83 3
8 33
83 3
83 3
Linen Supplies
5 88
92 4
92 4
8 82
1, 0 0 8
1 , 2 60
Insurance & Security
4 17
41 7
41 7
4 17
41 7
41 7
Rates
7 50
75 0
75 0
7 50
75 0
75 0
Repairs & Renewals
2 08
20 8
20 8
2 08
20 8
20 8
Maintenance Contracts
3 75
37 5
37 5
3 75
37 5
37 5
Waste Disposal
1 67
16 7
16 7
1 67
16 7
16 7
Service Charge
0
0
0
0
0
0
3 33
33 3
33 3
3 33
33 3
33 3
Cable T.V. & Licences
42
42
42
42
42
42
Stationery & Postage
1 42
14 2
14 2
1 42
14 2
14 2
Food
Labour & Other Staff Costs
Restaurant
Sales & Marketing Bonus Payments
Recruitment Training & Development Uniforms Staff Food Other HR Establishment & Administration
Telephone
Plants & Flowers
4 33
43 3
43 3
4 33
43 3
43 3
Crockery,cutlery,glassware
1 00
10 0
10 0
1 00
10 0
10 0
1 00
10 0
10 0
1 00
10 0
10 0
Laundry & Dry Clean
2 67
26 7
26 7
2 67
26 7
26 7
Cleaning&Bathroom Cleaning&Bathroom Supplies
2 50
25 0
25 0
2 50
25 0
25 0
Audit & Accountancy
5 00
50 0
50 0
5 00
50 0
50 0
Legal Fees
2 08
20 8
20 8
2 08
20 8
20 8
Motor & Travel Exps.
5 83
58 3
58 3
5 83
58 3
58 3
Bank Charges & Overdraft Int.
2 50
25 0
25 0
2 50
25 0
25 0
Bad Debt Provision
0
0
0
0
0
0
Other Expenses
0
0
0
0
0
0
6 , 54 6
6,882
6 , 88 2
6,840
6, 9 6 6
7 , 2 18
0
0
0
0
0
0
Credit card charges
1 , 25 1
2,166
2 , 16 6
1,825
2, 0 3 6
2 , 3 60
Advertising Advertising & Promotions
4 , 16 7
4,167
4 , 16 7
4,167
4, 1 6 7
4 , 1 67
5 , 41 8
6,333
6 , 33 3
5,992
6, 2 0 3
6 , 5 27
- 7 , 83 0
33,445
3 3, 4 45
16,377
2 4 , 1 65
38 , 5 78
Loan Interest
0
0
0
0
0
0
Lease Interest
0
0
0
0
0
0
Depreciation
0
0
0
0
0
0
Directors Expenses
0
0
0
0
0
0
Refurbishment
0
0
0
0
0
0
Other non operating costs
0
0
0
0
0
0
0
0
0
0
0
0
-7,830
33,445
33,445
16,377
24,165
38,578
Tea/Coffee Supplies
Selling Costs Commissions
Operating Profit Non Operating Costs
Net Profit/(Loss)
July
August
eptembe October
ovemberDecember
T ot a l
63,876
63 , 8 76
60,792
5 1 , 98 1
42,290
35 , 0 22
601,310
0
0
0
0
0
0
0
0
0
0
0
0
0
0
50,395
50 , 3 95
46,849
3 3 , 58 5
27,987
16 , 3 31
437,714
15,036
15 , 0 36
13,872
9 , 7 20
8,100
4 , 6 07
129,379 12
0
0
0
1 9, 80 0
19,800
0
89,100
129, 12 9,30 306 6
129, 12 9,30 306 6
121, 12 1,51 513 3
115, 11 5,08 086 6
98,,17 98 177 7
55,9 55 ,959 59 1, 1,25 257, 7,50 502 2
112, 11 2,19 197 7
112, 11 2,19 197 7
105, 10 5,63 639 9
103, 10 3,77 774 4
88,,75 88 750 0
50,4 50 ,495 95 1, 1,10 109, 9,26 260 0
4, 3 63
4 , 36 3
4,363
4 , 36 3
4,363
4 , 3 63
52,355
5, 3 09
5 , 30 9
5,309
5 , 30 9
5,309
5 , 3 09
63,713
8, 7 42
8 , 74 2
8,742
8 , 74 2
8,742
8 , 7 42
104,908
20,254
20 , 2 54
20,254
2 0 , 25 4
20,254
20 , 2 54
243,045
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2, 3 02
2 , 30 2
2,302
2 , 30 2
2,302
2 , 3 02
27,625
7, 9 87
7 , 98 7
7,987
7 , 98 7
7,987
7 , 9 87
95,840
0
0
0
0
0
0
0
2, 0 00
2 , 00 0
2,000
2 , 00 0
2,000
2 , 0 00
24,000
50,957
50 , 9 57
50,957
5 0 , 95 7
50,957
50 , 9 57
611,486
0
0
0
0
0
0
0
83 3
83 3
83 3
8 33
83 3
8 33
10,000
41 3
41 3
41 3
4 13
41 3
4 13
4,950
1, 1 12
1 , 11 2
1,112
1 , 11 2
1,112
1 , 1 12
13,344
0
0
0
0
0
0
0
53,315
53 , 3 15
53,315
5 3 , 31 5
53,315
53 , 3 15
639,780
83 3
83 3
83 3
8 33
83 3
8 33
10,000
1, 3 02
1 , 30 2
1,260
1 , 00 8
84 0
54 6
11,844
41 7
41 7
41 7
4 17
41 7
4 17
5,000
75 0
75 0
75 0
7 50
75 0
7 50
9,000
20 8
20 8
20 8
2 08
20 8
2 08
2,500
37 5
37 5
37 5
3 75
37 5
3 75
4,500
16 7
16 7
16 7
1 67
16 7
1 67
2,000
0
0
0
0
0
0
0
33 3
33 3
33 3
3 33
33 3
3 33
4,000
42
42
42
42
42
42
5 00
14 2
14 2
14 2
1 42
14 2
1 42
1,700
433
433
433
433
433
433
5,200
100
100
100
100
100
100
1,200
100
100
100
100
100
100
1,200
267
267
267
267
267
267
3,200
250
250
250
250
250
250
3,000
500
500
500
500
500
500
6,000
208
208
208
208
208
208
2,500
583
583
583
583
583
583
7,000
250
250
250
250
250
250
3,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
7,260
7,260
7,218
6,966
6,798
6,504
83,344
0
0
0
0
0
0
0
2,512
2,512
2,360
2,232
1,904
1,085
24,408
4,167
4,167
4,167
4,167
4,167
4,167
50,000
6,678
6,678
6,527
6,398
6,070
5,252
74,408
44,943
44,943
38,579
37,095
22,567
-14,576
311,729
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
44,943
44,943
38,579
37,095
22,567
-14,576
311,729
Accommodation Revenue Accommodation Revenue
January February
March
April
May
Number of Rooms
10
10
10
10
10
Days per month
31
28
31
30
31
Rooms Sold Comp/Staff/Agent Corporate
20
20
20
20
Meeting rooms FIT
80
Groups
80 60
Midweek Leisure Promo / Package Cookery School
30
120
120
30
Rack rate
10
Weekend Leisure
80
80
80
80
100
140
220
220
210
240
198.23
198.23
198.23
198.23
Room Rate Comp/Staff/Agent Corporate Meeting rooms FIT
198.23
Groups
198.23 176.21
Midweek Leisure Promo / Package Cookery School
198.23
198.23
198.23
198.23
Rack rate
330.39
Weekend Leisure
242.29
242.29
242.29
242.29
242.29
232.85
214.25
214.25
215.01
211.08
0
0
0
0
0
3,965
3,965
3,965
3,965
0
Meeting rooms
0
0
0
0
0
FIT
0
0
0
15,858
15,858
Groups
0
0
0
0
10,573
Midweek Leisure
0
0
0
0
0
Promo / Package
0
0
0
0
0
Cookery School
5,947
23,788
23,788
5,947
0
Rack rate
3,304
0
0
0
0
19,383
19,383
19,383
19,383
24,229
32,599
47,135
47,135
45,153
50,660
310
280
310
300
310
Revenue Comp/Staff/Agent Corporate
Weekend Leisure
Rooms Available
Rooms Sold
140
220
220
210
240
Occupancy
45.20%
78.60%
71.00%
70.00%
77.40%
Room Rate
232.85
214.25
214.25
215.01
211.08
259
385
385
368
420
Rate per Sleeper
125.86
122.43
122.43
122.87
120.62
Rev Par
105.16
168.34
152.05
150.51
163.42
0
0
0
0
0
9.5
1,330
2,090
2,090
1,995
2,280
4.2
588
924
924
882
1,008
0
0
0
0
0
Sleepers
Cost of Sales Loss on Hotel Bookouts (Value)
Overheads based on Rooms / Revenue: Housekeeping Staff rate per ro Linen Supplies: rate per ro Commissions: as a % of r Credit Card Charges: % of rev ta
85.00%
Rooms Div
2.00%
725
1,292
1,292
967
977
F&B Div C/
2.00%
527
875
875
858
1,059
1,251
2,166
2,166
1,825
2,036
Total Credit Card Charges
June
July
August
eptembe October
ovemberDecember
10
10
10
10
10
10
10
30
31
31
30
31
30
31
Total 365
0 20
20
120 0
120
120
120
120
640
100
90
90
100
440 0 90 120
120
540 40
80
100
100
80
100
60
300
310
310
300
240
200
90 50 940
130
2,820
#DIV/0! 198.23
198.23
198.23 #DIV/0!
198.23
198.23
198.23
198.23
198.23
176.21
176.21
176.21
176.21
176.21 #DIV/0! 242.29 198.23
198.23
242.29 198.23
330.39
330.39
242.29
242.29
242.29
242.29
242.29
242.29
242.29
242.29
202.64
206.05
206.05
202.64
216.59
211.45
269.4
213.23
0
0
0
0
0
0
0
0
0
0
0
0
3,965
3,965
0
23788
0
0
0
0
0
0
0
0
23,788
23,788
23,788
23,788
0
0
0
126867
17,621
15,859
15,859
17,621
0
0
0
77532
0
0
0
0
0
0
0
0
0
0
0
0
0
0
21,806
21806
0
0
0
0
23,788
23,788
0
107044
0
0
0
0
0
0
13,216
16520
19,383
24,229
24,229
19,383
24,229
14,537
0
227753
60,792
63,876
63,876
60,792
51,981
42,290
35,022
601310
300
310
310
300
310
300
310
3,650
300
310
310
300
240
200
130
2,820
100.00% 100.00%
100.00%
100.00%
77.40%
66.70%
41.90%
77.30%
202.64
206.05
206.05
202.64
216.59
211.45
269.4
213.23
525
543
543
525
420
350
228
4,949
115.79
117.74
117.74
115.79
123.76
120.83
153.94
121.5
202.64
206.05
206.05
202.64
167.68
140.97
112.97
164.74
0
0
0
0
0
0
0
0
2,850
2,945
2,945
2,850
2,280
1,900
1,235
26,790
1,260
1,302
1,302
1,260
1,008
840
546
11,844
0
0
0
0
0
0
0
0
1,173
1,232
1,232
1,173
1,385
1,198
676
13,321
1,187
1,279
1,279
1,187
847
706
409
11,087
2,360
2,512
2,512
2,360
2,232
1,904
1,085
24,408
Non-Accommodation Revenue Non-Rooms Revenue & COS January February
March
April
May
Revenue Office Rentals (Value)
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
100%
100%
100%
100%
100%
11
11
11
11
11
2,849
4,235
4,235
4,043
4,620
2,849
4,235
4,235
4,043
4,620
20%
20%
20%
20%
20%
17.62
17.62
17.62
17.62
17.62
913
1,357
1,357
1,295
1,480
913
1,357
1,357
1,295
1,480
% of Sleepers
100%
100%
100%
100%
100%
Average spend (net
57.26
57.26
57.26
57.26
57.26
14,830
22,045
22,045
21,043
24,049
Passerby Dinners (V
2,290
6,871
6,871
7,444
11,452
Total Dinners Reven
17,121
28,916
28,916
28,487
35,501
% of Sleepers
100%
100%
100%
100%
100%
Rate
20.25
20.25
20.25
20.25
20.25
Inhouse Beverage
5,245
7,796
7,796
7,442
8,505
Passerby Beverage
810
2,430
2,430
2,633
4,050
Total Beverage Rev
6,055
10,226
10,226
10,074
12,555
0
0
0
0
0
Total Office Rental Revenue Meeting Rooms Revenue Number of Meeting Rooms Sold Average Meeting Room Rate Total Meeting Room Equipment Hire (Value) Total Equipment Hire Revenue Breakfast Revenue % of Sleepers Average spend (net Inhouse Breakfasts Passerby Breakfasts Total Breakfast Reve Lunch Revenue % of Sleepers Average spend (net Inhouse Lunches Passerby Lunches ( Total Lunch Revenu Dinner Revenue
Inhouse Dinners
Beverage Revenue
Telephone Revenue Rate per sleeper
0
Guest Laundry (Value) Car Transfer Revenue Amount per month (Value) Site Visit Revenue Amount per month (Value)
Cookery School Fe
4,950
19,800
19,800
4,950
Cost of Sales Equipment Hire Cos Food Breakfast Cost
25.00%
712
1,059
1,059
1,011
1,155
Lunch Cost
25.00%
228
339
339
324
370
Dinner Cost
25.00%
4,280
7,229
7,229
7,122
8,875
5,221
8,627
8,627
8,456
10,400
25%
25%
25%
25%
25%
1,816
3,068
3,068
3,022
3,767
0
0
0
0
0
Overall Cost of Sale Overall Cost % Beverage Beverage Cost
30.00%
Other Cost of Sales Telephone Costs (V Guest Laundry (Val Car Parking Costs ( Masts Other Cost of Sales
Total Non-Rooms R
31,887
64,534
64,534
48,849
54,156
Total Cost of Sales
7,037
11,695
11,695
11,478
14,167
Total Non-Rooms C
24,850
52,839
52,839
37,370
39,989
June
July
August
eptembe October
ovemberDecember
Total
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 #DIV/0! 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
100%
100%
100%
100%
100%
100%
100%
11
11
11
11
11
11
11
5,775
5,968
5,968
5,775
4,620
3,850
2,503
54,439 0
5,775
5,968
5,968
5,775
4,620
3,850
2,503
20%
20%
20%
20%
20%
20%
20%
17.62
17.62
17.62
17.62
17.62
17.62
17.62
1,850
1,912
1,912
1,850
1,480
1,233
802
54,439
17,440 0
1,850
1,912
1,912
1,850
1,480
1,233
802
17,440
100%
100%
100%
100%
100%
100%
100%
57.26
57.26
57.26
57.26
57.26
57.26
57.26
30,062
31,064
31,064
30,062
24,049
20,041
13,027
9,162
11,452
11,452
9,162
3,436
2,863
39,223
42,516
42,516
39,224
27,485
22,904
13,027
100%
100%
100%
100%
100%
100%
100%
20.25
20.25
20.25
20.25
20.25
20.25
20.25
10,631
10,986
10,986
10,631
8,505
7,088
4,607
3,241
4,050
4,050
3,241
1,215
1,013
13,872
15,036
15,036
13,872
9,720
8,100
4,607
129,379
0
0
0
0
0
0
0
0
283,380 2,290 365,834
100,217 29,162
0
0
0
0
19,800
19,800
89,100
0
1,444
1,492
1,492
1,444
1,155
963
626
13,610
463
478
478
463
370
308
200
4,360
9,806
10,629
10,629
9,806
6,871
5,726
3,257
91,459
11,712
12,599
12,599
11,712
8,396
6,997
4,083
109,428
25%
25%
25%
25%
25%
25%
25%
4,162
4,511
4,511
4,162
2,916
2,430
1,382
38,814
0 0 0 0 0 0 0
0
0
0
0
0
0
0
60,720
65,430
65,430
60,721
63,105
55,887
20,938
656,193
15,874
17,109
17,109
15,874
11,312
9,427
5,465
148,242
44,847
48,321
48,321
44,847
51,793
46,461
15,473
507,951
Rooms Division Payroll Yes or No
Gross Pay
Bonus
ER PRSI Hol Prov
per annum
p.a
10.50% equired?
Front Office Manager
25,000
2,000
2,835
no
Receptionist
22,000
2,000
2,520
no
Rooms Division Payroll Reception
0 0 0 0 0 INSERT EXTRA ROWS ABOVE THIS ONE 47,000
4,000
5,355
0
Porters / Security Day Porter
21,000
2,205
no
Night Porter
25,000
2,625
yes
Part Time Night Porter
10,000
1,050
yes
0 0 INSERT EXTRA ROWS ABOVE THIS ONE 56,000
0
5,880
0
Restaurant N/A
0 0 0 0 0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Kitchen N/A
0 0 0 0 0 0 0 0 0
0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Bar N/A
0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Maintenance Handy Man
25,000
2,625
no
0 0 INSERT EXTRA ROWS ABOVE THIS ONE 25,000
0
2,625
Management/Administration N/A
0 0 0 0 0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Sales & Marketing N/A
0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE
Overall
0
0
0
128,000
4,000
13,860
0
Holidays
Pension
Payroll Cost excl
@ 8.33% ealth etc Cost p.a
Allocation
Monthly Allocation
Bonus
Check
Jan
Feb
Mar
0
29,835
27,835
OK
2,320
2,320
2,320
0
26,520
24,520
OK
2,043
2,043
2,043
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
4,363
4,363
4,363
OK 0
56,355
52,355
0
23,205
23,205
OK
1,934
1,934
1,934
1,833
29,458
29,458
OK
2,455
2,455
2,455
0
11,050
11,050
OK
921
921
921
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
63,713
63,713
5,309
5,309
5,309
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
1,833
0
0
0
0
0
0
0
0
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
0
27,625
27,625
OK
2,302
2,302
2,302
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
27,625
27,625
2,302
2,302
2,302
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,833
0
147,693
143,693
11,974
11,974
11,974
f Cost excl Bonus Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
2,320
2,320
2,320
2,320
2,320
2,320
2,320
2,320
2,320
2,043
2,043
2,043
2,043
2,043
2,043
2,043
2,043
2,043
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4,363
4,363
4,363
4,363
4,363
4,363
4,363
4,363
4,363
1,934
1,934
1,934
1,934
1,934
1,934
1,934
1,934
1,934
2,455
2,455
2,455
2,455
2,455
2,455
2,455
2,455
2,455
921
921
921
921
921
921
921
921
921
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
5,309
5,309
5,309
5,309
5,309
5,309
5,309
5,309
5,309
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,302
2,302
2,302
2,302
2,302
2,302
2,302
2,302
2,302
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,302
2,302
2,302
2,302
2,302
2,302
2,302
2,302
2,302
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
11,974
11,974
11,974
11,974
11,974
11,974
11,974
11,974
11,974
Total 27,835 24,520 0 0 0 0 0 52,355
23,205 29,458 11,050 0 0 63,713
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0
0 0 0 0
27,625 0 0 27,625
0 0 0 0 0 0 0 0
0 0 0 0 143,693
Rooms Division Fixed Overhaed Budget Fixed Overheads Rooms Division
Allocation Monthly Allocation of Overhead 2008
Check
Jan
Feb
OK Recruitment
OK
Training & Development
OK
Uniforms
700
OK
58
58
Staff Food
864
OK
72
72
588
924
OK
208
208
OK
0
0
OK
83
83
OK
0
0
Other HR
OK
ESB & Heating
OK
Linen Supplies
11,844
OK
Rates
OK 2,500
Maintenance Contracts Waste Disposal
OK
Insurance & Security Repairs & Renewals
1,000
Service Charge
Telephone
OK
0
Cable T.V. & Licences
OK
0
0
Stationery & Postage
OK
0
0
Plants & Flowers
OK
0
0
Crockery,cutlery,glassware
OK
0
0
Tea/Coffee Supplies
500
Laundry & Dry Clean
OK
42
42
OK
0
0
OK
125
125
Audit & Accountancy
OK
0
0
Legal Fees
OK
0
0
Motor & Travel Exps.
OK
0
0
Bank Charges & Overdraft Int.
OK
0
0
Bad Debt Provision
OK
0
0
Other Expenses
OK
0
0
Advertising & Promotions
OK
0
0
Rent
OK
0
0
Loan Interest
OK
0
0
Lease Interest
OK
0
0
Depreciation
OK
0
0
Directors Expenses
OK
0
0
Refurbishment
OK
0
0
Other non operating costs
OK
0
0
1,177
1,513
Cleaning & Bathroom Supplies
Overall
1,500
18,908
0
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
58
58
58
58
58
58
58
58
58
72
72
72
72
72
72
72
72
72
924
882
1,008
1,260
1,302
1,302
1,260
1,008
840
208
208
208
208
208
208
208
208
208
0
0
0
0
0
0
0
0
0
83
83
83
83
83
83
83
83
83
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
42
42
42
42
42
42
42
42
42
0
0
0
0
0
0
0
0
0
125
125
125
125
125
125
125
125
125
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,513
1,471
1,597
1,849
1,891
1,891
1,849
1,597
1,429
Dec
Total 0 0 0
58
700
72
864 0 0
546
11,844 0 0
208
2,500
0
0
83
1,000
0
0
0
0
0
0
0
0
0
0
0
0
42
500
0
0
125
1,500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,135
18,908
Rooms Division P&L Rooms Division
January February
March
April
May
June
Revenue Accommodation
32,599
47,135
47,135
45,153
50,660
60,792
Office Rental
0
0
0
0
0
0
Meeting Room / Equipment Hire
0
0
0
0
0
0
4,950
19,800
19,800
4,950
0
0
Total Revenue
37,549
66,935
66,935
50,103
50,660
60,792
Total Contribution
37,549
66,935
66,935
50,103
50,660
60,792
Reception
4,363
4,363
4,363
4,363
4,363
4,363
Porters / Security
5,309
5,309
5,309
5,309
5,309
5,309
Housekeeping
0
0
0
0
0
0
Restaurant
0
0
0
0
0
0
Kitchen
0
0
0
0
0
0
Bar
0
0
0
0
0
0
2,302
2,302
2,302
2,302
2,302
2,302
Management/Administration
0
0
0
0
0
0
Sales & Marketing
0
0
0
0
0
0
333
333
333
333
333
333
0
0
0
0
0
0
0
0
0
0
0
0
Uniforms
58
58
58
58
58
58
Staff Food
72
72
72
72
72
72
0
0
0
0
0
0
130
130
130
130
130
130
ESB & Heating
0
0
0
0
0
0
Linen Supplies
588
924
924
882
1,008
1,260
Insurance & Security
0
0
0
0
0
0
Rates
0
0
0
0
0
0
208
208
208
208
208
208
0
0
0
0
0
0
Waste Disposal
83
83
83
83
83
83
Service Charge
0
0
0
0
0
0
0
0
0
0
0
0
Cable T.V. & Licences
0
0
0
0
0
0
Stationery & Postage
0
0
0
0
0
0
Food Bar Other
Labour & Other Staff Costs
Maintenance
Bonus Payments
Recruitment Training & Development
Other HR Establishment & Administration
Repairs & Renewals Maintenance Contracts
Telephone
Plants & Flowers
0
0
0
0
0
0
Crockery,cutlery,glassware
0
0
0
0
0
0
42
42
42
42
42
42
0
0
0
0
0
0
125
125
125
125
125
125
Audit & Accountancy
0
0
0
0
0
0
Legal Fees
0
0
0
0
0
0
Motor & Travel Exps.
0
0
0
0
0
0
Bank Charges & Overdraft Int.
0
0
0
0
0
0
Bad Debt Provision
0
0
0
0
0
0
Other Expenses
0
0
0
0
0
0
1,046
1,382
1,382
1,340
1,466
1,718
0
0
0
0
0
0
725
1,292
1,292
967
977
1,173
0
0
0
0
0
0
0
0
0
0
0
0
725
1,292
1,292
967
977
1,173
35,647
64,131
64,131
47,666
48,086
57,770
Rent
0
0
0
0
0
0
Loan Interest
0
0
0
0
0
0
Lease Interest
0
0
0
0
0
0
Depreciation
0
0
0
0
0
0
Directors Expenses
0
0
0
0
0
0
Refurbishment
0
0
0
0
0
0
Other non operating costs
0
0
0
0
0
0
0
0
0
0
0
0
35,647
64,131
64,131
47,666
48,086
57,770
Tea/Coffee Supplies Laundry & Dry Clean Cleaning&Bathroom Supplies
Selling Costs Commissions Credit card charges Advertising & Promotions
Operating Profit Non Operating Costs
Net Profit/(Loss)
July
August
eptembe October
ovemberDecember
Total
63,876
63,876
60,792
51,981
42,290
35,022
601,310
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
19,800
19,800
0
89,100
63,876
63,876
60,792
71,781
62,090
35,022
690,410
63,876
63,876
60,792
71,781
62,090
35,022
690,410
4,363
4,363
4,363
4,363
4,363
4,363
52,355
5,309
5,309
5,309
5,309
5,309
5,309
63,713
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2,302
2,302
2,302
2,302
2,302
2,302
27,625
0
0
0
0
0
0
0
0
0
0
0
0
0
0
333
333
333
333
333
333
4,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
58
58
58
58
58
58
700
72
72
72
72
72
72
864
0
0
0
0
0
0
0
130
130
130
130
130
130
1,564
0
0
0
0
0
0
0
1,302
1,302
1,260
1,008
840
546
11,844
0
0
0
0
0
0
0
0
0
0
0
0
0
0
208
208
208
208
208
208
2,500
0
0
0
0
0
0
0
83
83
83
83
83
83
1,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
42
42
42
42
42
42
500
0
0
0
0
0
0
0
125
125
125
125
125
125
1,500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,760
1,760
1,718
1,466
1,298
1,004
17,344
0
0
0
0
0
0
0
1,232
1,232
1,173
1,385
1,198
676
13,321
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,232
1,232
1,173
1,385
1,198
676
13,321
60,752
60,752
57,770
68,800
59,463
33,211
658,180
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
60,752
60,752
57,770
68,800
59,463
33,211
658,180
Food & Beverage Division P&L Food & Beverage Division
January February
March
April
May
June
Revenue Accommodation Office Rental Meeting Room / Equipment Hire Food
20,882
34,508
34,508
33,824
41,601
46,848
6,055
10,226
10,226
10,074
12,555
13,872
Total Revenue
26,937
44,734
44,734
43,899
54,156
60,720
Total Contribution
19,900
33,039
33,039
32,420
39,989
44,847
Reception
0
0
0
0
0
0
Porters / Security
0
0
0
0
0
0
8,742
8,742
8,742
8,742
8,742
8,742
20,254
20,254
20,254
20,254
20,254
20,254
Kitchen
0
0
0
0
0
0
Bar
0
0
0
0
0
0
Maintenance
0
0
0
0
0
0
Management/Administration
0
0
0
0
0
0
Sales & Marketing
0
0
0
0
0
0
1,000
1,000
1,000
1,000
1,000
1,000
0
0
0
0
0
0
0
0
0
0
0
0
Uniforms
208
208
208
208
208
208
Staff Food
520
520
520
520
520
520
0
0
0
0
0
0
728
728
728
728
728
728
ESB & Heating
0
0
0
0
0
0
Linen Supplies
0
0
0
0
0
0
Insurance & Security
0
0
0
0
0
0
Rates
0
0
0
0
0
0
Repairs & Renewals
0
0
0
0
0
0
Maintenance Contracts
0
0
0
0
0
0
Waste Disposal
83
83
83
83
83
83
Service Charge
0
0
0
0
0
0
0
0
0
0
0
0
Cable T.V. & Licences
0
0
0
0
0
0
Stationery & Postage
0
0
0
0
0
0
Bar Other
Labour & Other Staff Costs
Housekeeping Restaurant
Bonus Payments
Recruitment Training & Development
Other HR Establishment & Administrati
Telephone
Plants & Flowers
0
0
0
0
0
0
100
100
100
100
100
100
58
58
58
58
58
58
0
0
0
0
0
0
125
125
125
125
125
125
Audit & Accountancy
0
0
0
0
0
0
Legal Fees
0
0
0
0
0
0
Motor & Travel Exps.
0
0
0
0
0
0
Bank Charges & Overdraft Int.
0
0
0
0
0
0
Bad Debt Provision
0
0
0
0
0
0
Other Expenses
0
0
0
0
0
0
367
367
367
367
367
367
527
875
875
858
1,059
1,187
0
0
0
0
0
0
527
875
875
858
1,059
1,187
18,279
31,070
31,070
30,467
37,836
42,564
Rent
0
0
0
0
0
0
Loan Interest
0
0
0
0
0
0
Lease Interest
0
0
0
0
0
0
Depreciation
0
0
0
0
0
0
Directors Expenses
0
0
0
0
0
0
Refurbishment
0
0
0
0
0
0
Other non operating costs
0
0
0
0
0
0
0
0
0
0
0
0
18,279
31,070
31,070
30,467
37,836
42,564
Crockery,cutlery,glassware Tea/Coffee Supplies Laundry & Dry Clean Cleaning&Bathroom Supplies
Selling Costs Commissions Credit card charges Advertising & Promotions
Operating Profit Non Operating Costs
Net Profit/(Loss)
July
August
eptembe October
ovemberDecember
Total
50,395
50,395
46,849
33,585
27,987
16,331
437,714
15,036
15,036
13,872
9,720
8,100
4,607
129,379
65,430
65,430
60,721
43,305
36,087
20,938
567,093
48,321
48,321
44,847
31,993
26,661
15,473
418,851
0
0
0
0
0
0
0
0
0
0
0
0
0
0
8,742
8,742
8,742
8,742
8,742
8,742
104,908
20,254
20,254
20,254
20,254
20,254
20,254
243,045
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,000
1,000
1,000
1,000
1,000
1,000
12,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
208
208
208
208
208
208
2,500
520
520
520
520
520
520
6,240
0
0
0
0
0
0
0
728
728
728
728
728
728
8,740
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
83
83
83
83
83
83
1,000
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
100
100
100
100
100
100
1,200
58
58
58
58
58
58
700
0
0
0
0
0
0
0
125
125
125
125
125
125
1,500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
367
367
367
367
367
367
4,400
1,279
1,279
1,187
847
706
409
11,087
0
0
0
0
0
0
0
1,279
1,279
1,187
847
706
409
11,087
45,947
45,947
42,565
30,051
24,860
13,969
394,624
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
45,947
45,947
42,565
30,051
24,860
13,969
394,624
Food & Beverage Division Fixed Overhead Budget Fixed Overheads Food & Bev Division
Allocation Monthly Allocation of Overhead 2008
Check
Jan
Feb
OK Recruitment
OK
Training & Development
OK
0
0
Uniforms
2,500
OK
208
208
Staff Food
6,240
OK
520
520
Other HR
OK
0
0
ESB & Heating
OK
0
0
Linen Supplies
OK
0
0
Insurance & Security
OK
0
0
Rates
OK
0
0
Repairs & Renewals
OK
0
0
Maintenance Contracts
OK
0
0
OK
83
83
OK
0
0
Waste Disposal
1,000
Service Charge Telephone
OK
0
Cable T.V. & Licences
OK
0
0
Stationery & Postage
OK
0
0
Plants & Flowers
OK
0
0
OK
100
100
Crockery,cutlery,glassware replacement
1,200
Tea/Coffee Supplies
700
Laundry & Dry Clean
OK
58
58
OK
0
0
OK
125
125
Audit & Accountancy
OK
0
0
Legal Fees
OK
0
0
Motor & Travel Exps.
OK
0
0
Bank Charges & Overdraft Int.
OK
0
0
Bad Debt Provision
OK
0
0
Other Expenses
OK
0
0
Advertising & Promotions
OK
0
0
Rent
OK
0
0
Loan Interest
OK
0
0
Lease Interest
OK
0
0
Depreciation
OK
0
0
Directors Expenses
OK
0
0
Refurbishment
OK
0
0
Other non operating costs
OK
0
0
1,095
1,095
Cleaning & Bathroom Supplies
Overall
1,500
13,140
0
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
0
0
0
0
0
0
0
0
0
208
208
208
208
208
208
208
208
208
520
520
520
520
520
520
520
520
520
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
83
83
83
83
83
83
83
83
83
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
100
100
100
100
100
100
100
100
100
58
58
58
58
58
58
58
58
58
0
0
0
0
0
0
0
0
0
125
125
125
125
125
125
125
125
125
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,095
1,095
1,095
1,095
1,095
1,095
1,095
1,095
1,095
Dec
Total 0 0
0
0
208
2,500
520
6,240
0
0
0
0
0
0
0
0
0
0
0
0
0
0
83
1,000
0
0
0
0
0
0
0
0
0
0
100
1,200
58
700
0
0
125
1,500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0 0
1,095
13,140
Administrative Division Fixed Overhead Budget Fixed Overheads Administration
Allocation Monthly Allocation of Overhead 2008
Check
Jan
Feb
OK Recruitment Training & Development
OK 10,000
OK
833
833
Uniforms
1,750
OK
146
146
Staff Food
6,240
OK
520
520
OK
0
0
OK
833
833
OK
0
0
Other HR ESB & Heating
10,000
Linen Supplies Insurance & Security
5,000
OK
417
417
Rates
9,000
OK
750
750
OK
0
0
OK
375
375
Waste Disposal
OK
0
0
Service Charge
OK
0
0
Repairs & Renewals Maintenance Contracts
4,500
Telephone
4,000
OK
333
333
Cable T.V. & Licences
500
OK
42
42
Stationery & Postage
1,700
OK
142
142
Plants & Flowers
5,200
OK
433
433
OK
0
0
Crockery,cutlery,glassware Tea/Coffee Supplies Laundry & Dry Clean
OK 3,200
Cleaning & Bathroom Supplies
0
0
OK
267
267
OK
0
0
Audit & Accountancy
6,000
OK
500
500
Legal Fees
2,500
OK
208
208
Motor & Travel Exps.
7,000
OK
583
583
Bank Charges & Overdraft Int.
3,000
OK
250
250
Bad Debt Provision
OK
0
0
Other Expenses
OK
0
0
OK
4,167
4,167
Advertising & Promotions
50,000
OK Loan Interest
OK
0
0
Lease Interest
OK
0
0
Depreciation
OK
0
0
Directors Expenses
OK
0
0
Refurbishment
OK
0
0
Other non operating costs
OK
0
0
10,799
10,799
Overall
129,590
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
833
833
833
833
833
833
833
833
833
146
146
146
146
146
146
146
146
146
520
520
520
520
520
520
520
520
520
0
0
0
0
0
0
0
0
0
833
833
833
833
833
833
833
833
833
0
0
0
0
0
0
0
0
0
417
417
417
417
417
417
417
417
417
750
750
750
750
750
750
750
750
750
0
0
0
0
0
0
0
0
0
375
375
375
375
375
375
375
375
375
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
333
333
333
333
333
333
333
333
333
42
42
42
42
42
42
42
42
42
142
142
142
142
142
142
142
142
142
433
433
433
433
433
433
433
433
433
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
267
267
267
267
267
267
267
267
267
0
0
0
0
0
0
0
0
0
500
500
500
500
500
500
500
500
500
208
208
208
208
208
208
208
208
208
583
583
583
583
583
583
583
583
583
250
250
250
250
250
250
250
250
250
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4,167
4,167
4,167
4,167
4,167
4,167
4,167
4,167
4,167
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
10,799
10,799
10,799
10,799
10,799
10,799
10,799
10,799
10,799
Dec
Total 0 0
833
10,000
146
1,750
520
6,240
0
0
833
10,000
0
0
417
5,000
750
9,000
0
0
375
4,500
0
0
0
0
333
4,000
42
500
142
1,700
433
5,200
0
0
0
0
267
3,200
0
0
500
6,000
208
2,500
583
7,000
250
3,000
0
0
0
0
4,167
50,000 0
0
0
0
0
0
0
0
0
0
0
0
0
10,799
129,590
Administrative Division Payroll Yes or No
Administration Payroll
Gross Pay
Bonus
ER PRSI Hol Prov
per annum
p.a
10.50% equired?
Reception N/A
0 0 0 0 0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Porters / Security N/A
0 0 0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Restaurant N/A
0 0 0 0 0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Kitchen N/A
0 0 0 0 0 0 0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Bar N/A
0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
Maintenance N/A
0 0 0
INSERT EXTRA ROWS ABOVE THIS ONE 0
0
0
General Manager
60,000
6,000
630
no
Deputy Manager
35,000
2,000
210
no
Management/Administration
0 0 0 0 0 INSERT EXTRA ROWS ABOVE THIS ONE 95,000
8,000
840
Sales & Marketing 0 0 0 INSERT EXTRA ROWS ABOVE THIS ONE
Overall
0
0
0
95,000
8,000
840
Holidays
Pension
Payroll Cost excl
@ 8.33% ealth etc Cost p.a
Allocation
Bonus
Check
Monthly Allocation
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
0
Jan
Feb
Mar
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
0
0
0
OK
0
0
0
OK
0
0
0
OK
0
0
0
0
0
0
66,630
60,630
OK
5,053
5,053
5,053
0
37,210
35,210
OK
2,934
2,934
2,934
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
103,840
95,840
7,987
7,987
7,987
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
OK
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
103,840
95,840
7,987
7,987
7,987
f Cost excl Bonus Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
5,053
5,053
5,053
5,053
5,053
5,053
5,053
5,053
5,053
2,934
2,934
2,934
2,934
2,934
2,934
2,934
2,934
2,934
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
7,987
7,987
7,987
7,987
7,987
7,987
7,987
7,987
7,987
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
7,987
7,987
7,987
7,987
7,987
7,987
7,987
7,987
7,987
Total 0 0 0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0
0 0 0 0
0 0 0 0
60,630 35,210 0 0 0 0 0 95,840
0 0 0 0 95,840
Administrative Division P&L Administration Division
January February
March
April
May
June
Revenue Accommodation Office Rental Meeting Room / Equipment Hire Food Bar Other
0
0
0
0
0
0
Total Revenue
0
0
0
0
0
0
Total Contribution
0
0
0
0
0
0
Reception
0
0
0
0
0
0
Porters / Security
0
0
0
0
0
0
Restaurant
0
0
0
0
0
0
Kitchen
0
0
0
0
0
0
Bar
0
0
0
0
0
0
Maintenance
0
0
0
0
0
0
7,987
7,987
7,987
7,987
7,987
7,987
0
0
0
0
0
0
667
667
667
667
667
667
8,653
8,653
8,653
8,653
8,653
8,653
0
0
0
0
0
0
833
833
833
833
833
833
Uniforms
146
146
146
146
146
146
Staff Food
520
520
520
520
520
520
0
0
0
0
0
0
10,153
10,153
10,153
10,153
10,153
10,153
ESB & Heating
833
833
833
833
833
833
Linen Supplies
0
0
0
0
0
0
Insurance & Security
417
417
417
417
417
417
Rates
750
750
750
750
750
750
0
0
0
0
0
0
375
375
375
375
375
375
Waste Disposal
0
0
0
0
0
0
Service Charge
0
0
0
0
0
0
333
333
333
333
333
333
Cable T.V. & Licences
42
42
42
42
42
42
Stationery & Postage
142
142
142
142
142
142
Labour & Other Staff Costs
Housekeeping
Management/Administration Sales & Marketing Bonus Payments
Recruitment Training & Development
Other HR Establishment & Administration
Repairs & Renewals Maintenance Contracts
Telephone
Plants & Flowers
433
433
433
433
433
433
0
0
0
0
0
0
0
0
0
0
0
0
267
267
267
267
267
267
0
0
0
0
0
0
Audit & Accountancy
500
500
500
500
500
500
Legal Fees
208
208
208
208
208
208
Motor & Travel Exps.
583
583
583
583
583
583
Bank Charges & Overdraft Int.
250
250
250
250
250
250
Bad Debt Provision
0
0
0
0
0
0
Other Expenses
0
0
0
0
0
0
5,133
5,133
5,133
5,133
5,133
5,133
4,167
4,167
4,167
4,167
4,167
4,167
4,167
4,167
4,167
4,167
4,167
4,167
Rent
0
0
0
0
0
0
Loan Interest
0
0
0
0
0
0
Lease Interest
0
0
0
0
0
0
Depreciation
0
0
0
0
0
0
Directors Expenses
0
0
0
0
0
0
Refurbishment
0
0
0
0
0
0
Other non operating costs
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Crockery,cutlery,glassware Tea/Coffee Supplies Laundry & Dry Clean Cleaning&Bathroom Supplies
Selling Costs Commissions Credit card charges Advertising & Promotions
Operating Profit Non Operating Costs
Net Profit/(Loss)
July
August
eptembe October
ovemberDecember
Total
0 0 0 0 0 0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
7,987
7,987
7,987
7,987
7,987
7,987
95,840
0
0
0
0
0
0
0
667
667
667
667
667
667
8,000
8,653
8,653
8,653
8,653
8,653
8,653
103,840
0
0
0
0
0
0
0
833
833
833
833
833
833
10,000
146
146
146
146
146
146
1,750
520
520
520
520
520
520
6,240
0
0
0
0
0
0
0
10,153
10,153
10,153
10,153
10,153
10,153
121,830 0
833
833
833
833
833
833
10,000
0
0
0
0
0
0
0
417
417
417
417
417
417
5,000
750
750
750
750
750
750
9,000
0
0
0
0
0
0
0
375
375
375
375
375
375
4,500
0
0
0
0
0
0
0
0
0
0
0
0
0
0
333
333
333
333
333
333
4,000
42
42
42
42
42
42
500
142
142
142
142
142
142
1,700
