Conn O'Scannlain |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Hotel
at Ballynaraw South |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Non-Rooms Revenue & COS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
January |
February |
March |
April |
May |
June |
July |
August |
September |
October |
November |
December |
Total |
Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Office Rentals (Value) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Total Office Rental Revenue |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Meeting Rooms Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
Number of Meeting Rooms Sold |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Average Meeting Room Rate |
|
|
|
|
|
|
|
|
|
|
|
|
#DIV/0! |
Total Meeting Rooms
Revenue |
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Equipment Hire (Value) |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
Total Equipment Hire Revenue |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Breakfast Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% of Sleepers |
|
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
|
Average spend (net) |
|
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
Û11.00 |
|
Inhouse Breakfasts |
|
2,849 |
4,235 |
4,235 |
4,043 |
4,620 |
5,775 |
5,968 |
5,968 |
5,775 |
4,620 |
3,850 |
2,503 |
54,439 |
Passerby Breakfasts
(Value) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Total Breakfast Revenue |
|
2,849 |
4,235 |
4,235 |
4,043 |
4,620 |
5,775 |
5,968 |
5,968 |
5,775 |
4,620 |
3,850 |
2,503 |
54,439 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Lunch Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% of Sleepers |
|
20% |
20% |
20% |
20% |
20% |
20% |
20% |
20% |
20% |
20% |
20% |
20% |
|
Average spend (net) |
|
Û17.62 |
Û17.62 |
Û17.62 |
Û17.62 |
Û17.62 |
Û17.62 |
Û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 |
1,912 |
1,912 |
1,850 |
1,480 |
1,233 |
802 |
17,440 |
Passerby Lunches (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Total Lunch Revenue |
|
913 |
1,357 |
1,357 |
1,295 |
1,480 |
1,850 |
1,912 |
1,912 |
1,850 |
1,480 |
1,233 |
802 |
17,440 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dinner Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% of Sleepers |
|
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
|
Average spend (net) |
|
Û57.26 |
Û57.26 |
Û57.26 |
Û57.26 |
Û57.26 |
Û57.26 |
Û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 |
31,064 |
31,064 |
30,062 |
24,049 |
20,041 |
13,027 |
283,380 |
Passerby Dinners (Value) |
|
2,290 |
6,871 |
6,871 |
7,444 |
11,452 |
9,162 |
11,452 |
11,452 |
9,162 |
3,436 |
2,863 |
|
2,290 |
Total Dinners Revenue |
|
17,121 |
28,916 |
28,916 |
28,487 |
35,501 |
39,223 |
42,516 |
42,516 |
39,224 |
27,485 |
22,904 |
13,027 |
365,834 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beverage Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% of Sleepers |
|
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
100% |
|
Rate |
|
Û20.25 |
Û20.25 |
Û20.25 |
Û20.25 |
Û20.25 |
Û20.25 |
Û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 |
10,986 |
10,986 |
10,631 |
8,505 |
7,088 |
4,607 |
100,217 |
Passerby Beverage (Value) |
|
810 |
2,430 |
2,430 |
2,633 |
4,050 |
3,241 |
4,050 |
4,050 |
3,241 |
1,215 |
1,013 |
|
29,162 |
Total Beverage Revenue |
|
6,055 |
10,226 |
10,226 |
10,074 |
12,555 |
13,872 |
15,036 |
15,036 |
13,872 |
9,720 |
8,100 |
4,607 |
129,379 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Telephone Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
Rate per sleeper |
Û0.00 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Guest Laundry (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Car Transfer Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
Amount per month (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Site Visit Revenue |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Amount per month (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cookery School Fee |
|
4,950 |
19,800 |
19,800 |
4,950 |
|
|
|
|
|
19,800 |
19,800 |
|
89,100 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cost of Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Equipment Hire Costs
(Value) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Food |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Breakfast Cost |
25.0% |
712 |
1,059 |
1,059 |
1,011 |
1,155 |
1,444 |
1,492 |
1,492 |
1,444 |
1,155 |
963 |
626 |
13,610 |
Lunch Cost |
25.0% |
228 |
339 |
339 |
324 |
370 |
463 |
478 |
478 |
463 |
370 |
308 |
200 |
4,360 |
Dinner Cost |
25.0% |
4,280 |
7,229 |
7,229 |
7,122 |
8,875 |
9,806 |
10,629 |
10,629 |
9,806 |
6,871 |
5,726 |
3,257 |
91,459 |
Overall Cost of Sales
Food |
|
5,221 |
8,627 |
8,627 |
8,456 |
10,400 |
11,712 |
12,599 |
12,599 |
11,712 |
8,396 |
6,997 |
4,083 |
109,428 |
Overall Cost % |
|
25% |
25% |
25% |
25% |
25% |
25% |
25% |
25% |
25% |
25% |
25% |
25% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beverage |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beverage Cost |
30.0% |
1,816 |
3,068 |
3,068 |
3,022 |
3,767 |
4,162 |
4,511 |
4,511 |
4,162 |
2,916 |
2,430 |
1,382 |
38,814 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Cost of Sales |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Telephone Costs (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Guest Laundry (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Car Parking Costs (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Masts |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
Other Cost of Sales (Value) |
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
|
|
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Non-Rooms Revenue |
|
31,887 |
64,534 |
64,534 |
48,849 |
54,156 |
60,720 |
65,430 |
65,430 |
60,721 |
63,105 |
55,887 |
20,938 |
656,193 |
Total Cost of Sales |
|
7,037 |
11,695 |
11,695 |
11,478 |
14,167 |
15,874 |
17,109 |
17,109 |
15,874 |
11,312 |
9,427 |
5,465 |
148,242 |
Total Non-Rooms Contribution |
|
24,850 |
52,839 |
52,839 |
37,370 |
39,989 |
44,847 |
48,321 |
48,321 |
44,847 |
51,793 |
46,461 |
15,473 |
507,951 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|