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