| 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 |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|