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