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