Conn O'Scannlain |
|
|
|
|
|
|
|
|
|
|
|
|
|
Hotel
at Ballynaraw South |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accommodation Revenue |
January |
February |
March |
April |
May |
June |
July |
August |
September |
October |
November |
December |
Total |
Number of Rooms |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
10 |
|
Days per month |
31 |
28 |
31 |
30 |
31 |
30 |
31 |
31 |
30 |
31 |
30 |
31 |
365 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Rooms Sold |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Comp/Staff/Agent |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Corporate |
|
20 |
20 |
20 |
20 |
|
|
|
|
|
20 |
20 |
|
120 |
Meeting rooms |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
FIT |
|
|
|
|
80 |
80 |
120 |
120 |
120 |
120 |
|
|
|
640 |
Groups |
|
|
|
|
|
60 |
100 |
90 |
90 |
100 |
|
|
|
440 |
Midweek Leisure |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Promo / Package |
|
|
|
|
|
|
|
|
|
|
|
90 |
90 |
Cookery School |
30 |
120 |
120 |
30 |
|
|
|
|
|
120 |
120 |
|
540 |
Rack rate |
|
10 |
|
|
|
|
|
|
|
|
|
|
40 |
50 |
Weekend Leisure |
80 |
80 |
80 |
80 |
100 |
80 |
100 |
100 |
80 |
100 |
60 |
|
940 |
|
|
140 |
220 |
220 |
210 |
240 |
300 |
310 |
310 |
300 |
240 |
200 |
130 |
2,820 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Room Rate |
|
|
|
|
|
|
|
|
|
|
|
|
|
Comp/Staff/Agent |
|
|
|
|
|
|
|
|
|
|
|
|
#DIV/0! |
Corporate |
|
198.23 |
198.23 |
198.23 |
198.23 |
|
|
|
|
|
198.23 |
198.23 |
|
198.23 |
Meeting rooms |
|
|
|
|
|
|
|
|
|
|
|
|
#DIV/0! |
FIT |
|
|
|
|
198.23 |
198.23 |
198.23 |
198.23 |
198.23 |
198.23 |
|
|
|
198.23 |
Groups |
|
|
|
|
|
176.21 |
176.21 |
176.21 |
176.21 |
176.21 |
|
|
|
176.21 |
Midweek Leisure |
|
|
|
|
|
|
|
|
|
|
|
|
#DIV/0! |
Promo / Package |
|
|
|
|
|
|
|
|
|
|
|
242.29 |
242.29 |
Cookery School |
198.23 |
198.23 |
198.23 |
198.23 |
|
|
|
|
|
198.23 |
198.23 |
|
198.23 |
Rack rate |
|
330.39 |
|
|
|
|
|
|
|
|
|
|
330.39 |
330.39 |
Weekend Leisure |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
242.29 |
|
|
232.85 |
214.25 |
214.25 |
215.01 |
211.08 |
202.64 |
206.05 |
206.05 |
202.64 |
216.59 |
211.45 |
269.40 |
213.2303546 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Comp/Staff/Agent |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Û0 |
Corporate |
|
3,965 |
3,965 |
3,965 |
3,965 |
0 |
0 |
0 |
0 |
0 |
3,965 |
3,965 |
0 |
Û23,788 |
Meeting rooms |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Û0 |
FIT |
|
0 |
0 |
0 |
15,858 |
15,858 |
23,788 |
23,788 |
23,788 |
23,788 |
0 |
0 |
0 |
Û126,867 |
Groups |
|
0 |
0 |
0 |
0 |
10,573 |
17,621 |
15,859 |
15,859 |
17,621 |
0 |
0 |
0 |
Û77,532 |
Midweek Leisure |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Û0 |
Promo / Package |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
21,806 |
Û21,806 |
Cookery School |
5,947 |
23,788 |
23,788 |
5,947 |
0 |
0 |
0 |
0 |
0 |
23,788 |
23,788 |
0 |
Û107,044 |
Rack rate |
|
3,304 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
13,216 |
Û16,520 |
Weekend Leisure |
19,383 |
19,383 |
19,383 |
19,383 |
24,229 |
19,383 |
24,229 |
24,229 |
19,383 |
24,229 |
14,537 |
0 |
Û227,753 |
|
|
32,599 |
47,135 |
47,135 |
45,153 |
50,660 |
60,792 |
63,876 |
63,876 |
60,792 |
51,981 |
42,290 |
35,022 |
Û601,310 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Rooms Available |
310 |
280 |
310 |
300 |
310 |
300 |
310 |
310 |
300 |
310 |
300 |
310 |
3,650 |
Rooms Sold |
140 |
220 |
220 |
210 |
240 |
300 |
310 |
310 |
300 |
240 |
200 |
130 |
2,820 |
Occupancy |
45.2% |
78.6% |
71.0% |
70.0% |
77.4% |
100.0% |
100.0% |
100.0% |
100.0% |
77.4% |
66.7% |
41.9% |
77.3% |
Room Rate |
Û232.85 |
Û214.25 |
Û214.25 |
Û215.01 |
Û211.08 |
Û202.64 |
Û206.05 |
Û206.05 |
Û202.64 |
Û216.59 |
Û211.45 |
Û269.40 |
Û213.23 |
Sleepers |
|
259 |
385 |
385 |
368 |
420 |
525 |
543 |
543 |
525 |
420 |
350 |
228 |
4,949 |
Rate per Sleeper |
Û125.86 |
Û122.43 |
Û122.43 |
Û122.87 |
Û120.62 |
Û115.79 |
Û117.74 |
Û117.74 |
Û115.79 |
Û123.76 |
Û120.83 |
Û153.94 |
Û121.50 |
Rev Par |
|
Û105.16 |
Û168.34 |
Û152.05 |
Û150.51 |
Û163.42 |
Û202.64 |
Û206.05 |
Û206.05 |
Û202.64 |
Û167.68 |
Û140.97 |
Û112.97 |
Û164.74 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cost of Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Loss on Hotel Bookouts (Value) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Overheads based on Rooms / Revenue: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Housekeeping Staff |
|
|
|
|
|
|
|
|
|
|
|
|
|
rate per room sold |
Û9.50 |
1,330 |
2,090 |
2,090 |
1,995 |
2,280 |
2,850 |
2,945 |
2,945 |
2,850 |
2,280 |
1,900 |
1,235 |
26,790 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Linen Supplies: |
|
|
|
|
|
|
|
|
|
|
|
|
|
rate per room sold |
Û4.20 |
588 |
924 |
924 |
882 |
1,008 |
1,260 |
1,302 |
1,302 |
1,260 |
1,008 |
840 |
546 |
11,844 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Commissions: |
|
|
|
|
|
|
|
|
|
|
|
|
|
as a % of rooms revenue |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Credit Card Charges: |
|
|
|
|
|
|
|
|
|
|
|
|
|
% of rev taken by C/C |
85.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
Rooms Div C/C Charges |
2.00% |
725 |
1,292 |
1,292 |
967 |
977 |
1,173 |
1,232 |
1,232 |
1,173 |
1,385 |
1,198 |
676 |
13,321 |
F&B Div C/C Charges |
2.00% |
527 |
875 |
875 |
858 |
1,059 |
1,187 |
1,279 |
1,279 |
1,187 |
847 |
706 |
409 |
11,087 |
Total Credit Card Charges |
1,251 |
2,166 |
2,166 |
1,825 |
2,036 |
2,360 |
2,512 |
2,512 |
2,360 |
2,232 |
1,904 |
1,085 |
24,408 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|