Dashboard Excel Hotel
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Dashboard Excel Hotel as PDF for free.
More details
- Words: 6,886
- Pages: 26
Month
June
Revenues
June
Year-to-Date
Rooms
291,856.00 €
2,126,007.00 €
Food & Beverage
114,841.09 €
856,634.14 €
4,580.74 €
30,865.95 €
Other
175,104.67 €
1,332,602.86 €
Total
586,382.50 €
4,346,109.95 €
Telephone
Average Ratios ADR
173.72 €
RevPAR
137.85 €
Occupancy Rate
77%
Rooms Food & Beverage Telephone Other
Average Daily Occupancy Monday
70%
█████████████████████████
Tuesday
68%
████████████████████████
Wednesday
64%
██████████████████████
Thursday
70%
█████████████████████████
Friday
96%
██████████████████████████████████
Saturday Sunday
100% 78%
███████████████████████████████████ ███████████████████████████
███
████
Excelworld
es.excelworld.net
Daily Revenue Figures 20000 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Rooms Food & Beverage Other
300 250 200 150 100 50 0 300 250 200 150 100 50 0 300 250 200 150 100 50 0
ADR
RevPAR
Occupancy Rate
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
26 27 28 29 30
26 27 28 29 30
Rooms Posted Taxable
Rooms Posted Nontaxable
Rooms Posted Total
57 62 66 51 50 35 42 48 56 68 44 35 53 36 42 55 65 53 19 29 31 25 52 55 24 34 26 22 31 46 55 36 34 32 26 22
71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 70 70 71 71 71 71 71
57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 65 57 34 66 65 62
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 65 57 34 66 65 62
9,690.00 14,384.00 13,926.00 7,650.00 8,700.00 3,990.00 6,132.00 5,904.00 13,720.00 15,368.00 5,764.00 4,340.00 7,102.00 5,472.00 4,452.00 13,255.00 15,600.00 8,268.00 2,717.00 5,075.00 3,286.00 4,075.00 10,660.00 11,550.00 2,784.00 4,624.00 3,406.00 3,498.00 3,999.00 11,408.00 13,420.00 4,896.00 5,236.00 3,392.00 4,524.00 3,850.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 128 0 0 0 0 15 5 0
Revenue Rooms Total
Rooms Available
4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4
Revenue Rooms Adjustment
Rooms Sold
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2
Revenue Rooms Nontaxable
Week Day
1/1/2009 1/2/2009 1/3/2009 1/4/2009 1/5/2009 1/6/2009 1/7/2009 1/8/2009 1/9/2009 1/10/2009 1/11/2009 1/12/2009 1/13/2009 1/14/2009 1/15/2009 1/16/2009 1/17/2009 1/18/2009 1/19/2009 1/20/2009 1/21/2009 1/22/2009 1/23/2009 1/24/2009 1/25/2009 1/26/2009 1/27/2009 1/28/2009 1/29/2009 1/30/2009 1/31/2009 2/1/2009 2/2/2009 2/3/2009 2/4/2009 2/5/2009
Revenue Rooms Taxable
Month
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Date
2,126,007.00
9,690.00 14,384.00 13,941.00 7,655.00 8,700.00 3,990.00 6,132.00 5,904.00 13,720.00 15,536.00 5,989.00 4,340.00 7,102.00 5,648.00 4,452.00 13,255.00 15,600.00 8,283.00 2,722.00 5,075.00 3,286.00 4,075.00 10,660.00 11,550.00 2,784.00 4,752.00 3,406.00 3,498.00 4,127.00 11,408.00 13,420.00 4,896.00 5,236.00 3,407.00 4,529.00 3,850.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
2/6/2009 2/7/2009 2/8/2009 2/9/2009 2/10/2009 2/11/2009 2/12/2009 2/13/2009 2/14/2009 2/15/2009 2/16/2009 2/17/2009 2/18/2009 2/19/2009 2/20/2009 2/21/2009 2/22/2009 2/23/2009 2/24/2009 2/25/2009 2/26/2009 2/27/2009 2/28/2009 3/1/2009 3/2/2009 3/3/2009 3/4/2009 3/5/2009 3/6/2009 3/7/2009 3/8/2009 3/9/2009 3/10/2009 3/11/2009 3/12/2009 3/13/2009 3/14/2009 3/15/2009 3/16/2009 3/17/2009 3/18/2009 3/19/2009 3/20/2009 3/21/2009 3/22/2009 3/23/2009 3/24/2009
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2
43 48 13 35 43 41 46 53 60 24 34 26 22 31 46 52 16 26 32 22 22 40 48 13 34 34 32 62 66 70 29 33 28 44 35 53 69 26 35 34 35 19 69 62 30 35 35
69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71
45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34
2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
47 70 70 35 43 41 46 53 65 69 57 34 55 52 58 59 70 50 35 22 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34
9,976.00 10,416.00 1,313.00 5,985.00 5,160.00 5,535.00 7,084.00 10,812.00 13,080.00 3,480.00 3,842.00 2,704.00 4,136.00 4,433.00 9,752.00 12,636.00 2,416.00 2,860.00 5,216.00 2,574.00 2,288.00 8,960.00 11,376.00 1,911.00 5,134.00 6,562.00 5,920.00 10,664.00 14,520.00 17,500.00 3,190.00 6,072.00 4,312.00 8,492.00 6,230.00 12,349.00 16,353.00 3,276.00 3,605.00 5,032.00 4,445.00 2,622.00 15,801.00 12,586.00 4,050.00 5,250.00 4,795.00
128 64 64 64 0 0 0 0 0 0 0 0 0 0 0 128 64 64 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0
10,104.00 10,480.00 1,377.00 6,049.00 5,328.00 5,760.00 7,084.00 10,812.00 13,256.00 3,480.00 3,842.00 2,704.00 4,151.00 4,438.00 9,752.00 12,764.00 2,480.00 2,924.00 5,280.00 2,574.00 2,416.00 8,960.00 11,376.00 1,911.00 5,134.00 6,577.00 5,925.00 10,664.00 14,520.00 17,500.00 3,190.00 6,072.00 4,480.00 8,717.00 6,230.00 12,349.00 16,529.00 3,276.00 3,605.00 5,032.00 4,460.00 2,627.00 15,801.00 12,586.00 4,050.00 5,250.00 4,795.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
3/25/2009 3/26/2009 3/27/2009 3/28/2009 3/29/2009 3/30/2009 3/31/2009 4/1/2009 4/2/2009 4/3/2009 4/4/2009 4/5/2009 4/6/2009 4/7/2009 4/8/2009 4/9/2009 4/10/2009 4/11/2009 4/12/2009 4/13/2009 4/14/2009 4/15/2009 4/16/2009 4/17/2009 4/18/2009 4/19/2009 4/20/2009 4/21/2009 4/22/2009 4/23/2009 4/24/2009 4/25/2009 4/26/2009 4/27/2009 4/28/2009 4/29/2009 4/30/2009 5/1/2009 5/2/2009 5/3/2009 5/4/2009 5/5/2009 5/6/2009 5/7/2009 5/8/2009 5/9/2009 5/10/2009
3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5
3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7
28 34 65 68 34 46 41 57 34 65 68 36 26 28 35 33 59 66 35 36 42 26 28 59 62 19 35 32 39 45 62 66 49 35 36 37 46 53 66 34 28 41 26 34 62 65 36
71 71 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 70 70 70 71 70 70 71 71 71 71 71
22 34 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 34 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62
4,732.00 4,114.00 13,975.00 14,280.00 4,454.00 7,360.00 5,453.00 8,379.00 4,624.00 14,235.00 14,960.00 6,228.00 3,796.00 3,276.00 4,865.00 6,105.00 12,331.00 15,774.00 6,195.00 6,336.00 4,578.00 4,108.00 3,304.00 14,219.00 14,260.00 3,800.00 6,440.00 5,824.00 7,059.00 8,325.00 15,314.00 14,718.00 5,145.00 4,165.00 5,688.00 4,107.00 6,854.00 13,197.00 14,058.00 6,562.00 4,452.00 7,339.00 3,848.00 4,182.00 13,702.00 16,185.00 6,480.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 128 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 128 0 0 0 128 0 0 0 0 15 5 0
4,732.00 4,242.00 13,975.00 14,280.00 4,582.00 7,360.00 5,453.00 8,379.00 4,624.00 14,250.00 14,965.00 6,228.00 3,796.00 3,276.00 4,865.00 6,105.00 12,499.00 15,999.00 6,195.00 6,336.00 4,754.00 4,108.00 3,304.00 14,219.00 14,275.00 3,805.00 6,440.00 5,824.00 7,059.00 8,325.00 15,314.00 14,718.00 5,273.00 4,165.00 5,688.00 4,235.00 6,854.00 13,197.00 14,058.00 6,690.00 4,452.00 7,339.00 3,848.00 4,182.00 13,717.00 16,190.00 6,480.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
5/11/2009 5/12/2009 5/13/2009 5/14/2009 5/15/2009 5/16/2009 5/17/2009 5/18/2009 5/19/2009 5/20/2009 5/21/2009 5/22/2009 5/23/2009 5/24/2009 5/25/2009 5/26/2009 5/27/2009 5/28/2009 5/29/2009 5/30/2009 5/31/2009 6/1/2009 6/2/2009 6/3/2009 6/4/2009 6/5/2009 6/6/2009 6/7/2009 6/8/2009 6/9/2009 6/10/2009 6/11/2009 6/12/2009 6/13/2009 6/14/2009 6/15/2009 6/16/2009 6/17/2009 6/18/2009 6/19/2009 6/20/2009 6/21/2009 6/22/2009 6/23/2009 6/24/2009 6/25/2009 6/26/2009
5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5
26 28 32 33 61 66 32 36 32 26 28 59 64 22 35 29 32 38 56 66 42 35 36 37 46 68 71 56 53 49 51 53 68 69 53 56 53 43 49 65 71 56 55 50 49 51 71
69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 70 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71
45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34
3,432.00 4,312.00 5,696.00 6,468.00 13,054.00 13,332.00 5,152.00 3,636.00 3,520.00 3,588.00 3,864.00 14,278.00 13,312.00 4,378.00 5,845.00 4,901.00 4,192.00 4,446.00 11,536.00 14,982.00 4,536.00 6,300.00 6,588.00 4,329.00 7,820.00 13,668.00 16,046.00 10,136.00 9,010.00 4,949.00 6,120.00 10,441.00 14,076.00 14,835.00 5,883.00 6,104.00 9,593.00 7,740.00 8,526.00 15,665.00 16,543.00 9,856.00 8,690.00 9,850.00 5,145.00 8,721.00 17,253.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 128 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0
3,432.00 4,312.00 5,696.00 6,468.00 13,222.00 13,557.00 5,152.00 3,636.00 3,696.00 3,588.00 3,864.00 14,278.00 13,327.00 4,383.00 5,845.00 4,901.00 4,192.00 4,446.00 11,536.00 14,982.00 4,664.00 6,300.00 6,588.00 4,457.00 7,820.00 13,668.00 16,046.00 10,264.00 9,010.00 4,949.00 6,120.00 10,441.00 14,091.00 14,840.00 5,883.00 6,104.00 9,593.00 7,740.00 8,526.00 15,833.00 16,768.00 9,856.00 8,690.00 10,026.00 5,145.00 8,721.00 17,253.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
6/27/2009 6/28/2009 6/29/2009 6/30/2009 7/1/2009 7/2/2009 7/3/2009 7/4/2009 7/5/2009 7/6/2009 7/7/2009 7/8/2009 7/9/2009 7/10/2009 7/11/2009 7/12/2009 7/13/2009 7/14/2009 7/15/2009 7/16/2009 7/17/2009 7/18/2009 7/19/2009 7/20/2009 7/21/2009 7/22/2009 7/23/2009 7/24/2009 7/25/2009 7/26/2009 7/27/2009 7/28/2009 7/29/2009 7/30/2009 7/31/2009 8/1/2009 8/2/2009 8/3/2009 8/4/2009 8/5/2009 8/6/2009 8/7/2009 8/8/2009 8/9/2009 8/10/2009 8/11/2009 8/12/2009
6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 8
6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3
71 56 46 51 37 46 68 71 56 53 49 51 53 71 71 53 56 53 52 58 69 71 56 55 62 49 51 71 71 56 46 56 37 46 71 71 54 65 62 65 63 71 71 68 65 63 67
71 71 71 69 71 70 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 70 70 71 71 71 69 71 70 70 70 71 70 70 71
55 52 58 57 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 34 46 46 55 52 58 57 34 46 46 65 34 46 65 57
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
55 52 58 57 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 34 46 46 55 52 58 57 34 46 46 65 34 46 65 57
15,478.00 6,664.00 8,740.00 6,222.00 5,402.00 4,646.00 15,708.00 14,342.00 7,728.00 6,519.00 9,016.00 6,426.00 6,678.00 15,052.00 17,324.00 10,547.00 11,144.00 10,600.00 6,084.00 7,366.00 16,215.00 17,608.00 11,200.00 9,515.00 6,572.00 9,163.00 7,701.00 17,608.00 15,336.00 8,064.00 6,578.00 6,160.00 6,586.00 5,290.00 14,342.00 16,046.00 6,588.00 10,595.00 9,114.00 7,410.00 10,143.00 14,981.00 15,052.00 12,580.00 8,125.00 9,135.00 8,241.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 5 0 0 128 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 128 0 0 15 5 0 0 128 0 0 0 128 0 0 0
15,493.00 6,669.00 8,740.00 6,222.00 5,530.00 4,646.00 15,708.00 14,342.00 7,856.00 6,519.00 9,016.00 6,426.00 6,678.00 15,067.00 17,329.00 10,547.00 11,144.00 10,600.00 6,084.00 7,366.00 16,383.00 17,833.00 11,200.00 9,515.00 6,748.00 9,163.00 7,701.00 17,608.00 15,351.00 8,069.00 6,578.00 6,160.00 6,714.00 5,290.00 14,342.00 16,061.00 6,593.00 10,595.00 9,114.00 7,538.00 10,143.00 14,981.00 15,052.00 12,708.00 8,125.00 9,135.00 8,241.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
8/13/2009 8/14/2009 8/15/2009 8/16/2009 8/17/2009 8/18/2009 8/19/2009 8/20/2009 8/21/2009 8/22/2009 8/23/2009 8/24/2009 8/25/2009 8/26/2009 8/27/2009 8/28/2009 8/29/2009 8/30/2009 8/31/2009 9/1/2009 9/2/2009 9/3/2009 9/4/2009 9/5/2009 9/6/2009 9/7/2009 9/8/2009 9/9/2009 9/10/2009 9/11/2009 9/12/2009 9/13/2009 9/14/2009 9/15/2009 9/16/2009 9/17/2009 9/18/2009 9/19/2009 9/20/2009 9/21/2009 9/22/2009 9/23/2009 9/24/2009 9/25/2009 9/26/2009 9/27/2009 9/28/2009
8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9
4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1
64 71 71 61 68 62 60 58 71 71 64 66 62 63 68 71 71 64 62 63 67 64 71 71 61 68 62 60 58 71 71 64 35 36 37 46 68 71 56 53 49 51 53 68 69 53 56
71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 71 70 70 70 71 70 70 71 71 71 71 71 69
34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 65 57 34 66 65 62 45 69 69 34 43 41 46 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 65 57 34 66 65 62 45 69 69 34 43 41 46 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45
8,320.00 16,117.00 14,910.00 7,381.00 13,600.00 10,416.00 10,320.00 5,858.00 14,200.00 14,910.00 8,000.00 11,154.00 9,734.00 6,867.00 9,860.00 16,685.00 15,194.00 7,360.00 9,982.00 9,135.00 11,591.00 6,848.00 16,188.00 14,981.00 10,126.00 8,160.00 10,850.00 6,600.00 10,904.00 16,898.00 14,839.00 8,512.00 5,110.00 3,780.00 4,958.00 7,130.00 14,484.00 17,679.00 10,864.00 7,155.00 5,439.00 9,027.00 9,805.00 13,940.00 16,491.00 7,420.00 5,936.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 0 128 0 0 0 128 0 0 0 0 15 5 0 0
8,320.00 16,132.00 14,915.00 7,381.00 13,600.00 10,416.00 10,320.00 5,858.00 14,368.00 15,135.00 8,000.00 11,154.00 9,910.00 6,867.00 9,860.00 16,685.00 15,209.00 7,365.00 9,982.00 9,135.00 11,591.00 6,848.00 16,203.00 14,986.00 10,126.00 8,160.00 10,850.00 6,600.00 10,904.00 17,066.00 15,064.00 8,512.00 5,110.00 3,780.00 5,086.00 7,130.00 14,484.00 17,679.00 10,992.00 7,155.00 5,439.00 9,027.00 9,805.00 13,955.00 16,496.00 7,420.00 5,936.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
9/29/2009 9/30/2009 10/1/2009 10/2/2009 10/3/2009 10/4/2009 10/5/2009 10/6/2009 10/7/2009 10/8/2009 10/9/2009 10/10/2009 10/11/2009 10/12/2009 10/13/2009 10/14/2009 10/15/2009 10/16/2009 10/17/2009 10/18/2009 10/19/2009 10/20/2009 10/21/2009 10/22/2009 10/23/2009 10/24/2009 10/25/2009 10/26/2009 10/27/2009 10/28/2009 10/29/2009 10/30/2009 10/31/2009 11/1/2009 11/2/2009 11/3/2009 11/4/2009 11/5/2009 11/6/2009 11/7/2009 11/8/2009 11/9/2009 11/10/2009 11/11/2009 11/12/2009 11/13/2009 11/14/2009
9 9 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 11 11 11 11 11 11 11 11 11 11 11 11 11 11
2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6
53 43
71 71
69 69
0 0
69 69
10,229.00 4,687.00
0 0
0 0
10,229.00 4,687.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
11/15/2009 11/16/2009 11/17/2009 11/18/2009 11/19/2009 11/20/2009 11/21/2009 11/22/2009 11/23/2009 11/24/2009 11/25/2009 11/26/2009 11/27/2009 11/28/2009 11/29/2009 11/30/2009 12/1/2009 12/2/2009 12/3/2009 12/4/2009 12/5/2009 12/6/2009 12/7/2009 12/8/2009 12/9/2009 12/10/2009 12/11/2009 12/12/2009 12/13/2009 12/14/2009 12/15/2009 12/16/2009 12/17/2009 12/18/2009 12/19/2009 12/20/2009 12/21/2009 12/22/2009 12/23/2009 12/24/2009 12/25/2009 12/26/2009 12/27/2009 12/28/2009 12/29/2009 12/30/2009 12/31/2009
11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4
170.00 423.06 211.23 117.77 140.32 88.67 88.87 85.57 403.53 361.30 146.07 94.35 134.00 86.89 64.52 232.54 458.82 150.60 52.35 87.50 57.65 59.06 217.55 339.71 126.55 139.76 74.04 53.82 121.38 248.00 206.46 85.89 154.00 51.62 69.68 62.10
170.00 232.00 211.23 150.10 174.00 114.00 146.00 123.00 245.00 228.47 136.11 124.00 134.00 156.89 106.00 241.00 240.00 156.28 143.26 175.00 106.00 163.00 205.00 210.00 116.00 139.76 131.00 159.00 133.13 248.00 244.00 136.00 154.00 106.47 174.19 175.00
136.48 202.59 196.35 107.82 122.54 57.83 86.37 83.15 193.24 218.82 84.35 62.00 101.46 80.69 63.60 186.69 219.72 116.66 38.34 71.48 47.62 57.39 150.14 162.68 39.21 66.93 48.66 49.97 58.13 162.97 191.71 68.96 73.75 47.99 63.79 54.23
80% 87% 93% 72% 70% 51% 59% 68% 79% 96% 62% 50% 76% 51% 60% 77% 92% 75% 27% 41% 45% 35% 73% 77% 34% 48% 37% 31% 44% 66% 79% 51% 48% 45% 37% 31%
2,787.30 4,424.32 5,940.00 3,547.56 3,014.00 1,984.50 3,675.00 2,425.92 6,119.12 6,882.96 1,755.60 1,449.70 2,059.05 2,187.00 3,807.30 3,768.05 5,569.20 3,307.20 1,094.40 1,450.00 1,806.68 960.00 5,197.92 3,712.50 1,785.36 1,710.88 1,930.76 999.68 2,619.50 4,072.84 4,532.00 2,836.80 1,871.36 2,308.80 1,297.92 1,142.24
Revenue Other
Revenue Telephone
Revenue Food Beverage
Occupancy Rate
RevPAR
ADR
Rate Average Postng
856,634.14 30,865.95 1,332,602.86
92.91 138.26 396.00 191.76 205.50 132.30 147.00 191.52 0.00 163.88 92.40 38.15 166.95 97.20 77.70 121.55 309.40 137.80 27.36 58.00 116.56 0.00 106.08 247.50 83.04 138.72 41.08 93.72 0.00 321.54 0.00 0.00 58.48 187.20 66.56 25.96
3,809.31 9,401.68 7,392.00 5,465.16 4,178.50 2,910.60 5,733.00 3,894.24 6,993.28 9,013.40 3,649.80 1,564.15 4,340.70 3,159.00 5,672.10 8,143.85 6,342.70 3,169.40 1,805.76 1,537.00 3,030.56 2,220.00 5,940.48 7,548.75 2,325.12 2,959.36 2,957.76 1,811.92 3,981.64 4,501.56 8,497.50 5,106.24 2,397.68 3,432.00 2,562.56 1,791.24
214.98 149.71 19.67 172.83 123.91 140.49 154.00 204.00 203.94 50.43 67.40 79.53 75.47 85.35 168.14 216.34 35.43 58.48 150.86 117.00 71.06 194.78 175.02 33.53 151.00 99.65 91.15 172.00 322.67 253.62 46.23 178.59 104.19 212.61 135.43 233.00 254.29 47.48 63.25 148.00 81.09 50.52 272.43 220.81 58.70 107.14 141.03
234.98 218.33 105.92 172.83 123.91 140.49 154.00 204.00 220.93 145.00 113.00 104.00 188.68 143.16 212.00 245.46 155.00 112.46 165.00 117.00 109.82 224.00 237.00 147.00 151.00 193.44 185.16 172.00 220.00 250.00 110.00 184.00 160.00 198.11 178.00 233.00 239.55 126.00 103.00 148.00 127.43 138.26 229.00 203.00 135.00 150.00 137.00
146.43 147.61 19.39 85.20 75.04 81.13 101.20 154.46 189.37 49.71 54.11 38.08 58.46 62.51 137.35 184.99 34.93 41.18 74.37 36.25 34.03 128.00 162.51 26.92 72.31 92.63 83.45 150.20 210.43 246.48 44.93 85.52 63.10 122.77 89.00 176.41 236.13 46.80 50.77 70.87 62.82 37.00 222.55 182.41 57.04 73.94 67.54
62% 68% 18% 49% 61% 58% 66% 76% 86% 34% 48% 37% 31% 44% 65% 75% 23% 37% 45% 31% 31% 57% 69% 18% 48% 48% 45% 87% 96% 99% 41% 46% 39% 62% 50% 76% 99% 37% 49% 48% 49% 27% 97% 90% 42% 49% 49%
3,010.00 5,976.00 482.04 3,102.75 2,275.56 2,198.83 2,704.80 4,949.14 6,883.20 1,199.52 2,830.50 1,354.08 1,672.44 2,028.95 3,659.76 4,763.20 952.32 1,820.78 1,532.16 1,393.70 1,268.08 3,679.20 3,326.40 780.78 2,584.68 1,428.00 1,596.16 3,073.96 6,699.00 8,332.80 1,065.75 2,744.28 1,783.60 3,926.56 2,582.65 4,719.12 8,280.00 973.44 1,719.90 2,438.48 2,623.95 970.14 4,663.02 5,440.50 2,199.60 2,826.95 2,102.10
86.00 0.00 13.39 137.90 189.63 0.00 77.28 107.59 286.80 0.00 62.90 131.04 39.82 115.94 0.00 357.24 30.72 77.48 0.00 79.64 86.46 262.80 110.88 0.00 61.54 107.10 74.24 166.16 133.98 520.80 30.45 65.34 109.20 170.72 0.00 337.08 345.00 54.08 0.00 55.42 160.65 78.66 451.26 279.00 112.80 68.95 100.10
6,278.00 8,366.40 575.77 2,964.85 2,528.40 4,468.59 4,095.84 7,316.12 10,324.80 1,909.44 2,516.00 3,450.72 2,229.92 2,782.56 6,027.84 9,050.08 1,566.72 2,363.14 2,553.60 1,672.44 1,930.94 6,394.80 6,541.92 1,561.56 3,384.70 1,927.80 1,633.28 6,231.00 8,038.80 11,631.20 2,070.60 5,031.18 1,638.00 5,463.04 2,802.45 7,191.04 13,800.00 1,352.00 2,457.00 4,156.50 4,016.25 1,101.24 11,281.50 6,696.00 3,722.40 4,964.40 2,252.25
215.09 124.76 303.80 219.69 134.76 160.00 83.89 147.00 136.00 215.91 230.23 100.45 84.36 47.48 70.51 179.56 290.67 390.22 134.67 119.55 73.14 59.54 57.96 418.21 259.55 73.17 111.03 102.18 102.30 169.90 450.41 669.00 155.09 90.54 87.51 124.56 149.00 286.89 216.28 196.76 96.78 112.91 67.51 123.00 207.83 249.08 104.52
169.00 124.76 215.00 210.00 134.76 160.00 133.00 147.00 136.00 219.23 220.07 173.00 146.00 117.00 139.00 185.00 211.85 242.41 177.00 176.00 113.19 158.00 118.00 241.00 230.24 200.26 184.00 182.00 181.00 185.00 247.00 223.00 107.61 119.00 158.00 114.46 149.00 249.00 213.00 196.76 159.00 179.00 148.00 123.00 221.24 249.08 180.00
66.65 59.75 199.64 204.00 64.54 105.14 77.90 118.01 65.13 200.70 210.77 87.72 55.01 46.14 68.52 85.99 176.04 225.34 88.50 90.51 67.91 58.69 46.54 200.27 201.06 53.59 90.70 84.41 99.42 117.25 215.69 207.30 74.27 59.50 81.26 59.65 97.91 188.53 200.83 94.23 63.60 104.84 54.20 58.90 193.20 228.03 91.27
39% 48% 93% 97% 48% 66% 59% 80% 48% 92% 96% 51% 38% 39% 49% 46% 83% 93% 50% 51% 60% 37% 39% 83% 87% 27% 49% 46% 55% 63% 87% 93% 69% 50% 51% 52% 66% 76% 94% 48% 40% 59% 37% 48% 87% 92% 51%
1,251.32 1,710.88 6,323.85 5,988.08 1,606.84 2,853.84 2,539.95 3,062.04 1,848.24 4,614.35 5,386.96 2,898.00 1,415.70 1,617.00 3,290.00 2,580.60 4,672.80 7,696.92 1,837.50 2,220.84 2,191.14 1,485.90 1,844.08 5,079.90 6,361.20 937.08 3,172.75 2,083.20 1,837.68 2,111.40 4,600.40 5,773.68 2,953.72 1,512.00 2,284.56 1,657.60 3,532.80 5,978.40 5,749.92 2,427.60 1,429.68 3,198.82 2,041.00 2,618.00 7,015.92 6,259.50 1,687.32
30.52 0.00 134.55 485.52 141.78 0.00 72.57 270.18 0.00 446.55 158.44 0.00 94.38 0.00 0.00 56.10 129.80 0.00 131.25 0.00 59.22 99.06 0.00 0.00 282.72 26.03 0.00 99.20 96.72 45.90 262.88 0.00 0.00 113.40 120.24 155.40 0.00 127.20 159.72 173.40 0.00 0.00 81.64 178.50 0.00 417.30 0.00
2,227.96 3,774.00 6,458.40 7,768.32 3,733.54 6,658.96 4,281.63 4,953.30 3,029.06 11,461.45 6,971.36 4,599.00 1,730.30 3,332.00 4,620.00 3,366.00 7,398.60 7,382.76 2,843.75 3,295.44 4,204.62 2,509.52 3,887.52 8,177.40 10,177.92 1,353.56 3,302.25 3,868.80 3,481.92 2,340.90 9,989.44 7,377.48 5,101.88 1,738.80 3,426.84 2,745.40 6,359.04 6,868.80 11,819.28 3,641.40 1,243.20 3,879.42 1,673.62 4,462.50 6,405.84 10,988.90 2,746.80
76.27 62.49 82.55 190.24 307.49 330.66 112.00 68.60 56.86 52.00 67.79 419.94 242.31 84.29 100.78 85.98 60.75 90.73 339.29 681.00 137.18 136.96 101.35 131.09 170.00 297.13 246.86 301.88 195.87 76.14 107.37 307.09 213.50 228.31 94.89 135.64 139.03 112.17 250.76 368.21 408.98 214.26 163.96 154.25 74.57 153.00 507.44
132.00 154.00 178.00 196.00 216.75 205.41 161.00 101.00 115.50 138.00 138.00 242.00 208.23 199.23 167.00 169.00 131.00 117.00 206.00 227.00 111.05 180.00 183.00 120.46 170.00 201.00 226.00 183.29 170.00 101.00 120.00 197.00 207.22 215.07 111.00 109.00 181.00 180.00 174.00 243.58 236.17 176.00 158.00 200.52 105.00 171.00 243.00
49.74 38% 60.73 39% 80.23 45% 91.10 46% 186.23 86% 190.94 93% 73.60 46% 51.94 51% 52.80 46% 51.26 37% 54.42 39% 201.10 83% 187.70 90% 61.73 31% 82.32 49% 71.03 42% 59.04 45% 62.62 54% 162.48 79% 211.01 93% 65.69 59% 90.00 50% 94.11 51% 62.77 52% 111.71 66% 195.26 97% 229.23 101% 144.56 79% 128.71 76% 70.70 70% 86.20 72% 147.06 75% 198.46 96% 209.01 97% 82.86 75% 88.46 81% 135.11 75% 109.01 61% 120.08 69% 223.00 92% 236.17 100% 140.80 80% 124.14 79% 143.23 71% 73.50 70% 122.83 72% 243.00 100%
1,128.40 2,071.72 2,150.72 1,843.38 4,270.00 5,148.00 1,785.60 3,420.00 1,925.76 1,478.88 1,381.80 3,929.40 6,565.12 1,127.50 1,714.30 1,378.08 1,658.88 2,009.82 4,174.80 5,258.88 2,577.96 1,549.80 2,110.68 2,826.80 2,439.84 5,318.28 6,929.60 3,269.28 3,273.28 3,148.74 2,907.00 2,356.38 6,454.56 4,160.70 3,480.51 4,878.72 3,549.94 3,034.08 4,013.10 5,475.60 6,933.15 3,026.80 2,932.60 2,940.00 3,615.71 4,479.84 5,680.00
96.72 126.84 91.52 112.86 244.00 396.00 148.80 136.80 113.28 123.24 29.40 261.96 142.72 27.50 55.30 0.00 155.52 147.06 119.28 493.02 234.36 129.15 102.96 70.67 125.12 483.48 346.48 233.52 0.00 277.83 0.00 181.26 0.00 0.00 316.41 0.00 104.41 189.63 0.00 304.20 308.14 128.80 136.40 294.00 76.93 186.66 142.00
1,547.52 3,044.16 3,020.16 2,144.34 7,930.00 7,260.00 2,678.40 4,035.60 3,228.48 2,629.12 1,822.80 6,549.00 10,133.12 1,292.50 3,152.10 1,284.12 2,851.20 3,235.32 9,065.28 9,367.38 5,468.40 2,324.70 2,368.08 2,897.47 4,879.68 9,024.96 11,087.36 4,203.36 6,239.69 5,649.21 3,136.50 4,833.60 11,833.36 8,182.71 5,168.03 8,648.64 4,385.22 4,993.59 5,255.25 8,669.70 9,552.34 5,152.00 4,433.00 7,350.00 3,307.99 5,973.12 5,964.00
281.69 128.25 150.69 109.16 162.65 101.00 341.48 220.65 231.06 141.72 138.71 112.74 196.41 228.29 266.60 170.11 247.64 153.62 88.17 216.65 381.00 434.95 243.48 179.53 103.82 132.80 135.11 517.88 279.11 155.17 113.41 108.07 197.47 115.00 311.78 292.02 126.79 182.67 159.89 221.71 220.50 325.67 231.57 373.76 176.63 140.54 144.58
218.21 119.09 190.00 122.00 149.46 101.00 231.00 202.00 140.29 123.00 184.00 126.00 126.00 212.21 244.07 199.00 199.00 200.00 117.00 127.00 237.43 251.17 200.00 173.00 108.84 187.00 151.00 248.00 216.21 144.09 143.00 110.00 181.46 115.00 202.00 226.21 122.09 163.00 147.00 115.97 161.00 211.00 212.00 186.88 125.00 145.00 123.00
218.21 93.93 123.10 90.17 77.89 66.37 224.40 204.89 110.65 93.13 128.80 90.51 94.06 212.21 244.07 148.55 161.51 149.30 85.69 103.75 230.75 251.17 160.00 135.93 96.40 130.90 108.46 248.00 216.21 113.65 92.65 89.28 94.56 75.57 204.89 226.21 92.86 149.23 132.09 106.17 144.90 214.01 215.03 178.99 116.07 130.50 116.07
100% 79% 65% 74% 52% 66% 97% 101% 79% 76% 70% 72% 75% 100% 100% 75% 81% 75% 73% 82% 97% 100% 80% 79% 89% 70% 72% 100% 100% 79% 65% 81% 52% 66% 101% 100% 76% 92% 90% 92% 90% 101% 101% 96% 93% 90% 94%
5,476.94 3,870.72 2,260.44 2,448.00 3,150.18 1,851.96 4,974.20 5,482.62 2,494.24 2,747.52 3,946.95 2,409.75 3,148.20 4,666.12 5,731.83 4,193.36 2,704.80 2,563.08 3,575.52 3,166.80 5,536.56 7,015.51 3,468.64 1,848.00 4,620.24 3,013.01 3,462.90 6,759.20 6,590.22 3,307.92 2,221.80 3,627.68 2,368.00 4,327.68 6,756.36 7,508.25 4,111.56 2,889.25 3,892.98 4,287.40 3,538.08 5,495.40 6,718.02 5,204.72 4,066.40 4,352.67 3,891.36
144.13 80.64 115.92 102.00 146.52 168.36 426.36 498.42 220.08 114.48 0.00 107.10 0.00 0.00 440.91 182.32 128.80 197.16 297.96 150.80 325.68 0.00 91.28 57.75 100.44 70.07 0.00 0.00 0.00 200.48 148.12 0.00 0.00 0.00 173.24 159.75 0.00 82.55 299.46 126.10 98.28 152.65 176.79 0.00 358.80 177.66 235.84
9,080.19 4,515.84 2,782.08 3,213.00 4,322.34 3,760.04 9,806.28 7,974.72 4,695.04 3,491.64 6,665.96 3,213.00 6,926.04 11,891.08 7,936.38 5,013.80 3,220.00 2,694.52 7,449.00 4,976.40 9,607.56 12,833.25 5,202.96 3,638.25 5,524.20 5,395.39 4,353.36 7,773.08 8,630.05 6,214.88 4,739.84 3,804.64 2,427.20 5,740.80 13,685.96 8,786.25 5,686.20 5,200.65 6,588.12 6,052.80 5,896.80 9,616.95 12,905.67 5,930.96 8,252.40 6,751.08 7,193.12
244.71 244.42 229.46 119.05 302.22 150.96 149.57 172.29 334.14 369.15 173.91 210.45 152.46 99.52 172.98 490.74 276.53 141.63 172.10 140.54 203.35 201.41 245.50 230.55 163.32 181.33 157.25 95.65 320.71 396.88 367.41 185.04 111.09 58.15 149.59 155.00 314.87 271.98 323.29 155.54 83.68 158.37 288.38 211.44 253.78 119.68 131.91
130.00 227.21 210.07 121.00 200.00 168.00 172.00 101.00 202.37 213.17 125.00 169.00 159.84 109.00 145.00 235.00 214.21 115.08 161.00 145.00 173.00 107.00 228.21 211.07 166.00 120.00 175.00 110.00 188.00 240.37 212.17 133.00 146.00 105.00 137.46 155.00 213.00 249.00 196.29 135.00 111.00 177.00 185.00 205.22 239.07 140.00 106.00
117.18 227.21 210.07 103.96 197.10 146.70 145.35 82.51 202.37 213.17 114.29 159.34 141.57 98.10 138.87 235.00 214.21 103.73 140.59 130.50 163.25 96.45 228.21 211.07 142.62 118.26 152.82 92.96 153.58 240.37 212.17 121.60 73.00 54.00 71.63 101.86 206.91 252.56 154.82 102.21 77.70 127.14 138.10 196.55 232.34 104.51 86.03
90% 100% 100% 86% 99% 87% 85% 82% 100% 100% 91% 94% 89% 90% 96% 100% 100% 90% 87% 90% 94% 90% 100% 100% 86% 99% 87% 85% 82% 100% 100% 91% 50% 51% 52% 66% 97% 101% 79% 76% 70% 72% 75% 96% 97% 75% 81%
3,031.04 5,248.32 8,076.96 3,934.50 3,695.12 2,879.28 4,368.00 1,856.00 6,225.99 7,778.76 3,020.16 4,159.98 4,921.56 4,819.50 4,141.20 5,069.40 7,827.75 4,045.44 3,385.20 2,871.54 3,302.43 4,249.60 5,422.98 4,779.72 2,792.58 3,763.80 3,447.20 5,382.00 2,578.10 5,914.30 6,435.44 3,840.00 1,562.40 2,844.00 2,503.05 3,602.26 4,995.96 7,571.44 4,121.60 2,873.13 1,937.95 2,239.92 4,362.96 5,143.52 6,397.68 2,067.00 3,315.20
0.00 164.01 336.54 0.00 0.00 200.88 0.00 0.00 168.27 530.37 0.00 0.00 117.18 107.10 236.64 289.68 347.90 247.68 112.84 200.34 106.53 318.72 0.00 144.84 0.00 167.28 0.00 117.00 0.00 0.00 438.78 0.00 100.80 0.00 0.00 87.86 0.00 528.24 268.80 0.00 166.11 62.22 0.00 165.92 168.36 0.00 0.00
4,072.96 7,216.44 12,115.44 6,216.51 4,375.80 4,821.12 7,753.20 3,306.00 9,927.93 13,436.04 6,223.36 9,454.50 4,921.56 7,389.90 7,809.12 9,993.96 11,306.75 4,540.80 7,673.12 3,205.44 7,989.75 7,543.04 5,851.11 5,793.60 3,922.91 5,771.16 6,118.78 5,499.00 3,167.38 13,916.00 9,360.64 5,145.60 3,124.80 3,469.68 4,212.45 4,568.72 10,475.40 10,916.96 6,899.20 4,125.52 3,488.31 3,484.32 5,431.44 7,632.32 8,081.28 4,028.00 6,720.00
148.25 67.93
193.00 109.00
144.07 66.01
75% 61%
4,388.93 2,599.35
89.57 199.95
5,732.48 3,799.05
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181
1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2
Average Total
35 36 37 46 68 71 56 53 49 51 53 68 69 53 56 53 43 49 65 71 56 55 50 49 51 71 71 56 46 51
70 70 71 70 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69
54.6 70.5
46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57
46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57
10
11
12
RevenueRoomsTotal
RoomsPostedTotal 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9
RevenueRoomsAdjustment
8
RevenueRoomsNonTaxable
7
RevenueRoomsTaxable
6 RoomsPostedNontaxable
5
RoomsPostedTaxable
4
RoomsAvailable
30 6/1/2009 6/2/2009 6/3/2009 6/4/2009 6/5/2009 6/6/2009 6/7/2009 6/8/2009 6/9/2009 6/10/2009 6/11/2009 6/12/2009 6/13/2009 6/14/2009 6/15/2009 6/16/2009 6/17/2009 6/18/2009 6/19/2009 6/20/2009 6/21/2009 6/22/2009 6/23/2009 6/24/2009 6/25/2009 6/26/2009 6/27/2009 6/28/2009 6/29/2009 6/30/2009
3
RoomsSold
Day
2009 6
Day
Year Month
6300 6588 4329 7820 13668 16046 10136 9010 4949 6120 10441 14076 14835 5883 6104 9593 7740 8526 15665 16543 9856 8690 9850 5145 8721 17253 15478 6664 8740 6222
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 128 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0
6300 6588 4457 7820 13668 16046 10264 9010 4949 6120 10441 14091 14840 5883 6104 9593 7740 8526 15833 16768 9856 8690 10026 5145 8721 17253 15493 6669 8740 6222
290991
0
865
291856
52.6
1 2
December
3 4 5 6 7
136.956521739 101.353846154 131.088235294 170 297.130434783 246.861538462 301.882352941 195.869565217 76.1384615385 107.368421053 307.088235294 213.5 228.307692308 94.8870967742 135.644444444 139.028985507 112.173913043 250.764705882 368.209302326 408.975609756 214.260869565 163.962264151 154.246153846 74.5652173913 153 507.441176471 281.690909091 128.25 150.689655172 109.157894737
180 183 120.459459459 170 201 226 183.285714286 170 101 120 197 207.220588235 215.072463768 111 109 181 180 174 243.584615385 236.169014085 176 158 200.52 105 171 243 218.211267606 119.089285714 190 122
90 94.1142857143 62.7746478873 111.714285714 195.257142857 229.228571429 144.563380282 128.714285714 70.7 86.1971830986 147.056338028 198.464788732 209.014084507 82.8591549296 88.4637681159 135.112676056 109.014084507 120.084507042 223 236.169014085 140.8 124.142857143 143.228571429 73.5 122.830985915 243 218.211267606 93.9295774648 123.098591549 90.1739130435
0.5 0.5142857143 0.5211267606 0.6571428571 0.9714285714 1.0142857143 0.7887323944 0.7571428571 0.7 0.7183098592 0.7464788732 0.9577464789 0.9718309859 0.7464788732 0.8115942029 0.7464788732 0.6056338028 0.6901408451 0.9154929577 1 0.8 0.7857142857 0.7142857143 0.7 0.7183098592 1 1 0.7887323944 0.6478873239 0.7391304348
198.683116765 173.720413618 137.847265428
0.7742796878
0.7004677339
December
0.6828361473
17
18
19
RevenueOther
RevenueTelephone
RevenueFoodBeverage
16
OccupancyRate
15
RevPAR
14
ADR
RateAveragePostng
13
1549.8 2110.68 2826.8 2439.84 5318.28 6929.6 3269.28 3273.28 3148.74 2907 2356.38 6454.56 4160.7 3480.51 4878.72 3549.94 3034.08 4013.1 5475.6 6933.15 3026.8 2932.6 2940 3615.71 4479.84 5680 5476.94 3870.72 2260.44 2448
129.15 102.96 70.67 125.12 483.48 346.48 233.52 0 277.83 0 181.26 0 0 316.41 0 104.41 189.63 0 304.2 308.14 128.8 136.4 294 76.93 186.66 142 144.13 80.64 115.92 102
2324.7 2368.08 2897.47 4879.68 9024.96 11087.36 4203.36 6239.69 5649.21 3136.5 4833.6 11833.36 8182.71 5168.03 8648.64 4385.22 4993.59 5255.25 8669.7 9552.34 5152 4433 7350 3307.99 5973.12 5964 9080.19 4515.84 2782.08 3213
114841.09
4580.74
175104.67
0.6362676056 0.7030181087 0.961167002 0.9965291751 0.7809859155
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0
January February March April May June July August September October November December █ Rooms 291,856.00 Food & Bev 114,841.09 Telephone 4,580.74 Other 175,104.67
Follow the steps to enable your Hotel Dashboard. >>
This template is prepared for keeping track of the daily room and revenue data and analyzing the performance of the hotel with the h
1)
This template may store and analyze the data for a year. Enter the year that you want to use the template for:
Year 2) >> >> 5)
6)
7) >> >>
2009
Data sheet contains sample data. Delete the sample data and start entering your daily informaton.
erformance of the hotel with the help of a dashboard.
June
Revenues
June
Year-to-Date
Rooms
291,856.00 €
2,126,007.00 €
Food & Beverage
114,841.09 €
856,634.14 €
4,580.74 €
30,865.95 €
Other
175,104.67 €
1,332,602.86 €
Total
586,382.50 €
4,346,109.95 €
Telephone
Average Ratios ADR
173.72 €
RevPAR
137.85 €
Occupancy Rate
77%
Rooms Food & Beverage Telephone Other
Average Daily Occupancy Monday
70%
█████████████████████████
Tuesday
68%
████████████████████████
Wednesday
64%
██████████████████████
Thursday
70%
█████████████████████████
Friday
96%
██████████████████████████████████
Saturday Sunday
100% 78%
███████████████████████████████████ ███████████████████████████
███
████
Excelworld
es.excelworld.net
Daily Revenue Figures 20000 18000 16000 14000 12000 10000 8000 6000 4000 2000 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Rooms Food & Beverage Other
300 250 200 150 100 50 0 300 250 200 150 100 50 0 300 250 200 150 100 50 0
ADR
RevPAR
Occupancy Rate
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
26 27 28 29 30
26 27 28 29 30
Rooms Posted Taxable
Rooms Posted Nontaxable
Rooms Posted Total
57 62 66 51 50 35 42 48 56 68 44 35 53 36 42 55 65 53 19 29 31 25 52 55 24 34 26 22 31 46 55 36 34 32 26 22
71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 70 70 71 71 71 71 71
57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 65 57 34 66 65 62
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 65 57 34 66 65 62
9,690.00 14,384.00 13,926.00 7,650.00 8,700.00 3,990.00 6,132.00 5,904.00 13,720.00 15,368.00 5,764.00 4,340.00 7,102.00 5,472.00 4,452.00 13,255.00 15,600.00 8,268.00 2,717.00 5,075.00 3,286.00 4,075.00 10,660.00 11,550.00 2,784.00 4,624.00 3,406.00 3,498.00 3,999.00 11,408.00 13,420.00 4,896.00 5,236.00 3,392.00 4,524.00 3,850.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 128 0 0 0 0 15 5 0
Revenue Rooms Total
Rooms Available
4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4
Revenue Rooms Adjustment
Rooms Sold
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2
Revenue Rooms Nontaxable
Week Day
1/1/2009 1/2/2009 1/3/2009 1/4/2009 1/5/2009 1/6/2009 1/7/2009 1/8/2009 1/9/2009 1/10/2009 1/11/2009 1/12/2009 1/13/2009 1/14/2009 1/15/2009 1/16/2009 1/17/2009 1/18/2009 1/19/2009 1/20/2009 1/21/2009 1/22/2009 1/23/2009 1/24/2009 1/25/2009 1/26/2009 1/27/2009 1/28/2009 1/29/2009 1/30/2009 1/31/2009 2/1/2009 2/2/2009 2/3/2009 2/4/2009 2/5/2009
Revenue Rooms Taxable
Month
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
Date
2,126,007.00
9,690.00 14,384.00 13,941.00 7,655.00 8,700.00 3,990.00 6,132.00 5,904.00 13,720.00 15,536.00 5,989.00 4,340.00 7,102.00 5,648.00 4,452.00 13,255.00 15,600.00 8,283.00 2,722.00 5,075.00 3,286.00 4,075.00 10,660.00 11,550.00 2,784.00 4,752.00 3,406.00 3,498.00 4,127.00 11,408.00 13,420.00 4,896.00 5,236.00 3,407.00 4,529.00 3,850.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
2/6/2009 2/7/2009 2/8/2009 2/9/2009 2/10/2009 2/11/2009 2/12/2009 2/13/2009 2/14/2009 2/15/2009 2/16/2009 2/17/2009 2/18/2009 2/19/2009 2/20/2009 2/21/2009 2/22/2009 2/23/2009 2/24/2009 2/25/2009 2/26/2009 2/27/2009 2/28/2009 3/1/2009 3/2/2009 3/3/2009 3/4/2009 3/5/2009 3/6/2009 3/7/2009 3/8/2009 3/9/2009 3/10/2009 3/11/2009 3/12/2009 3/13/2009 3/14/2009 3/15/2009 3/16/2009 3/17/2009 3/18/2009 3/19/2009 3/20/2009 3/21/2009 3/22/2009 3/23/2009 3/24/2009
2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3
5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2
43 48 13 35 43 41 46 53 60 24 34 26 22 31 46 52 16 26 32 22 22 40 48 13 34 34 32 62 66 70 29 33 28 44 35 53 69 26 35 34 35 19 69 62 30 35 35
69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71
45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34
2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 2 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
47 70 70 35 43 41 46 53 65 69 57 34 55 52 58 59 70 50 35 22 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34
9,976.00 10,416.00 1,313.00 5,985.00 5,160.00 5,535.00 7,084.00 10,812.00 13,080.00 3,480.00 3,842.00 2,704.00 4,136.00 4,433.00 9,752.00 12,636.00 2,416.00 2,860.00 5,216.00 2,574.00 2,288.00 8,960.00 11,376.00 1,911.00 5,134.00 6,562.00 5,920.00 10,664.00 14,520.00 17,500.00 3,190.00 6,072.00 4,312.00 8,492.00 6,230.00 12,349.00 16,353.00 3,276.00 3,605.00 5,032.00 4,445.00 2,622.00 15,801.00 12,586.00 4,050.00 5,250.00 4,795.00
128 64 64 64 0 0 0 0 0 0 0 0 0 0 0 128 64 64 64 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0
10,104.00 10,480.00 1,377.00 6,049.00 5,328.00 5,760.00 7,084.00 10,812.00 13,256.00 3,480.00 3,842.00 2,704.00 4,151.00 4,438.00 9,752.00 12,764.00 2,480.00 2,924.00 5,280.00 2,574.00 2,416.00 8,960.00 11,376.00 1,911.00 5,134.00 6,577.00 5,925.00 10,664.00 14,520.00 17,500.00 3,190.00 6,072.00 4,480.00 8,717.00 6,230.00 12,349.00 16,529.00 3,276.00 3,605.00 5,032.00 4,460.00 2,627.00 15,801.00 12,586.00 4,050.00 5,250.00 4,795.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
3/25/2009 3/26/2009 3/27/2009 3/28/2009 3/29/2009 3/30/2009 3/31/2009 4/1/2009 4/2/2009 4/3/2009 4/4/2009 4/5/2009 4/6/2009 4/7/2009 4/8/2009 4/9/2009 4/10/2009 4/11/2009 4/12/2009 4/13/2009 4/14/2009 4/15/2009 4/16/2009 4/17/2009 4/18/2009 4/19/2009 4/20/2009 4/21/2009 4/22/2009 4/23/2009 4/24/2009 4/25/2009 4/26/2009 4/27/2009 4/28/2009 4/29/2009 4/30/2009 5/1/2009 5/2/2009 5/3/2009 5/4/2009 5/5/2009 5/6/2009 5/7/2009 5/8/2009 5/9/2009 5/10/2009
3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 5 5 5 5 5 5 5 5 5 5
3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7
28 34 65 68 34 46 41 57 34 65 68 36 26 28 35 33 59 66 35 36 42 26 28 59 62 19 35 32 39 45 62 66 49 35 36 37 46 53 66 34 28 41 26 34 62 65 36
71 71 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 70 70 70 71 70 70 71 71 71 71 71
22 34 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
22 34 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62
4,732.00 4,114.00 13,975.00 14,280.00 4,454.00 7,360.00 5,453.00 8,379.00 4,624.00 14,235.00 14,960.00 6,228.00 3,796.00 3,276.00 4,865.00 6,105.00 12,331.00 15,774.00 6,195.00 6,336.00 4,578.00 4,108.00 3,304.00 14,219.00 14,260.00 3,800.00 6,440.00 5,824.00 7,059.00 8,325.00 15,314.00 14,718.00 5,145.00 4,165.00 5,688.00 4,107.00 6,854.00 13,197.00 14,058.00 6,562.00 4,452.00 7,339.00 3,848.00 4,182.00 13,702.00 16,185.00 6,480.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 128 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 128 0 0 0 128 0 0 0 0 15 5 0
4,732.00 4,242.00 13,975.00 14,280.00 4,582.00 7,360.00 5,453.00 8,379.00 4,624.00 14,250.00 14,965.00 6,228.00 3,796.00 3,276.00 4,865.00 6,105.00 12,499.00 15,999.00 6,195.00 6,336.00 4,754.00 4,108.00 3,304.00 14,219.00 14,275.00 3,805.00 6,440.00 5,824.00 7,059.00 8,325.00 15,314.00 14,718.00 5,273.00 4,165.00 5,688.00 4,235.00 6,854.00 13,197.00 14,058.00 6,690.00 4,452.00 7,339.00 3,848.00 4,182.00 13,717.00 16,190.00 6,480.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
5/11/2009 5/12/2009 5/13/2009 5/14/2009 5/15/2009 5/16/2009 5/17/2009 5/18/2009 5/19/2009 5/20/2009 5/21/2009 5/22/2009 5/23/2009 5/24/2009 5/25/2009 5/26/2009 5/27/2009 5/28/2009 5/29/2009 5/30/2009 5/31/2009 6/1/2009 6/2/2009 6/3/2009 6/4/2009 6/5/2009 6/6/2009 6/7/2009 6/8/2009 6/9/2009 6/10/2009 6/11/2009 6/12/2009 6/13/2009 6/14/2009 6/15/2009 6/16/2009 6/17/2009 6/18/2009 6/19/2009 6/20/2009 6/21/2009 6/22/2009 6/23/2009 6/24/2009 6/25/2009 6/26/2009
5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 5 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6 6
1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5
26 28 32 33 61 66 32 36 32 26 28 59 64 22 35 29 32 38 56 66 42 35 36 37 46 68 71 56 53 49 51 53 68 69 53 56 53 43 49 65 71 56 55 50 49 51 71
69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 71 70 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71
45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 69 49 34 22 34 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34
3,432.00 4,312.00 5,696.00 6,468.00 13,054.00 13,332.00 5,152.00 3,636.00 3,520.00 3,588.00 3,864.00 14,278.00 13,312.00 4,378.00 5,845.00 4,901.00 4,192.00 4,446.00 11,536.00 14,982.00 4,536.00 6,300.00 6,588.00 4,329.00 7,820.00 13,668.00 16,046.00 10,136.00 9,010.00 4,949.00 6,120.00 10,441.00 14,076.00 14,835.00 5,883.00 6,104.00 9,593.00 7,740.00 8,526.00 15,665.00 16,543.00 9,856.00 8,690.00 9,850.00 5,145.00 8,721.00 17,253.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 0 0 128 0 0 128 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0
3,432.00 4,312.00 5,696.00 6,468.00 13,222.00 13,557.00 5,152.00 3,636.00 3,696.00 3,588.00 3,864.00 14,278.00 13,327.00 4,383.00 5,845.00 4,901.00 4,192.00 4,446.00 11,536.00 14,982.00 4,664.00 6,300.00 6,588.00 4,457.00 7,820.00 13,668.00 16,046.00 10,264.00 9,010.00 4,949.00 6,120.00 10,441.00 14,091.00 14,840.00 5,883.00 6,104.00 9,593.00 7,740.00 8,526.00 15,833.00 16,768.00 9,856.00 8,690.00 10,026.00 5,145.00 8,721.00 17,253.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
6/27/2009 6/28/2009 6/29/2009 6/30/2009 7/1/2009 7/2/2009 7/3/2009 7/4/2009 7/5/2009 7/6/2009 7/7/2009 7/8/2009 7/9/2009 7/10/2009 7/11/2009 7/12/2009 7/13/2009 7/14/2009 7/15/2009 7/16/2009 7/17/2009 7/18/2009 7/19/2009 7/20/2009 7/21/2009 7/22/2009 7/23/2009 7/24/2009 7/25/2009 7/26/2009 7/27/2009 7/28/2009 7/29/2009 7/30/2009 7/31/2009 8/1/2009 8/2/2009 8/3/2009 8/4/2009 8/5/2009 8/6/2009 8/7/2009 8/8/2009 8/9/2009 8/10/2009 8/11/2009 8/12/2009
6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 8
6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3
71 56 46 51 37 46 68 71 56 53 49 51 53 71 71 53 56 53 52 58 69 71 56 55 62 49 51 71 71 56 46 56 37 46 71 71 54 65 62 65 63 71 71 68 65 63 67
71 71 71 69 71 70 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69 71 70 70 71 71 71 69 71 70 70 70 71 70 70 71
55 52 58 57 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 34 46 46 55 52 58 57 34 46 46 65 34 46 65 57
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
55 52 58 57 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57 34 46 46 55 52 58 57 34 46 46 65 34 46 65 57
15,478.00 6,664.00 8,740.00 6,222.00 5,402.00 4,646.00 15,708.00 14,342.00 7,728.00 6,519.00 9,016.00 6,426.00 6,678.00 15,052.00 17,324.00 10,547.00 11,144.00 10,600.00 6,084.00 7,366.00 16,215.00 17,608.00 11,200.00 9,515.00 6,572.00 9,163.00 7,701.00 17,608.00 15,336.00 8,064.00 6,578.00 6,160.00 6,586.00 5,290.00 14,342.00 16,046.00 6,588.00 10,595.00 9,114.00 7,410.00 10,143.00 14,981.00 15,052.00 12,580.00 8,125.00 9,135.00 8,241.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
15 5 0 0 128 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 128 0 0 15 5 0 0 128 0 0 0 128 0 0 0
15,493.00 6,669.00 8,740.00 6,222.00 5,530.00 4,646.00 15,708.00 14,342.00 7,856.00 6,519.00 9,016.00 6,426.00 6,678.00 15,067.00 17,329.00 10,547.00 11,144.00 10,600.00 6,084.00 7,366.00 16,383.00 17,833.00 11,200.00 9,515.00 6,748.00 9,163.00 7,701.00 17,608.00 15,351.00 8,069.00 6,578.00 6,160.00 6,714.00 5,290.00 14,342.00 16,061.00 6,593.00 10,595.00 9,114.00 7,538.00 10,143.00 14,981.00 15,052.00 12,708.00 8,125.00 9,135.00 8,241.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
8/13/2009 8/14/2009 8/15/2009 8/16/2009 8/17/2009 8/18/2009 8/19/2009 8/20/2009 8/21/2009 8/22/2009 8/23/2009 8/24/2009 8/25/2009 8/26/2009 8/27/2009 8/28/2009 8/29/2009 8/30/2009 8/31/2009 9/1/2009 9/2/2009 9/3/2009 9/4/2009 9/5/2009 9/6/2009 9/7/2009 9/8/2009 9/9/2009 9/10/2009 9/11/2009 9/12/2009 9/13/2009 9/14/2009 9/15/2009 9/16/2009 9/17/2009 9/18/2009 9/19/2009 9/20/2009 9/21/2009 9/22/2009 9/23/2009 9/24/2009 9/25/2009 9/26/2009 9/27/2009 9/28/2009
8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9
4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1
64 71 71 61 68 62 60 58 71 71 64 66 62 63 68 71 71 64 62 63 67 64 71 71 61 68 62 60 58 71 71 64 35 36 37 46 68 71 56 53 49 51 53 68 69 53 56
71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 71 70 70 70 71 70 70 71 71 71 71 71 69
34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 65 57 34 66 65 62 45 69 69 34 43 41 46 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 65 57 34 66 65 62 45 69 69 34 43 41 46 46 65 34 46 46 65 34 46 65 57 34 66 65 62 45
8,320.00 16,117.00 14,910.00 7,381.00 13,600.00 10,416.00 10,320.00 5,858.00 14,200.00 14,910.00 8,000.00 11,154.00 9,734.00 6,867.00 9,860.00 16,685.00 15,194.00 7,360.00 9,982.00 9,135.00 11,591.00 6,848.00 16,188.00 14,981.00 10,126.00 8,160.00 10,850.00 6,600.00 10,904.00 16,898.00 14,839.00 8,512.00 5,110.00 3,780.00 4,958.00 7,130.00 14,484.00 17,679.00 10,864.00 7,155.00 5,439.00 9,027.00 9,805.00 13,940.00 16,491.00 7,420.00 5,936.00
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 0 128 0 0 0 128 0 0 0 0 15 5 0 0
8,320.00 16,132.00 14,915.00 7,381.00 13,600.00 10,416.00 10,320.00 5,858.00 14,368.00 15,135.00 8,000.00 11,154.00 9,910.00 6,867.00 9,860.00 16,685.00 15,209.00 7,365.00 9,982.00 9,135.00 11,591.00 6,848.00 16,203.00 14,986.00 10,126.00 8,160.00 10,850.00 6,600.00 10,904.00 17,066.00 15,064.00 8,512.00 5,110.00 3,780.00 5,086.00 7,130.00 14,484.00 17,679.00 10,992.00 7,155.00 5,439.00 9,027.00 9,805.00 13,955.00 16,496.00 7,420.00 5,936.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
9/29/2009 9/30/2009 10/1/2009 10/2/2009 10/3/2009 10/4/2009 10/5/2009 10/6/2009 10/7/2009 10/8/2009 10/9/2009 10/10/2009 10/11/2009 10/12/2009 10/13/2009 10/14/2009 10/15/2009 10/16/2009 10/17/2009 10/18/2009 10/19/2009 10/20/2009 10/21/2009 10/22/2009 10/23/2009 10/24/2009 10/25/2009 10/26/2009 10/27/2009 10/28/2009 10/29/2009 10/30/2009 10/31/2009 11/1/2009 11/2/2009 11/3/2009 11/4/2009 11/5/2009 11/6/2009 11/7/2009 11/8/2009 11/9/2009 11/10/2009 11/11/2009 11/12/2009 11/13/2009 11/14/2009
9 9 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 11 11 11 11 11 11 11 11 11 11 11 11 11 11
2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6
53 43
71 71
69 69
0 0
69 69
10,229.00 4,687.00
0 0
0 0
10,229.00 4,687.00
### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ### ###
11/15/2009 11/16/2009 11/17/2009 11/18/2009 11/19/2009 11/20/2009 11/21/2009 11/22/2009 11/23/2009 11/24/2009 11/25/2009 11/26/2009 11/27/2009 11/28/2009 11/29/2009 11/30/2009 12/1/2009 12/2/2009 12/3/2009 12/4/2009 12/5/2009 12/6/2009 12/7/2009 12/8/2009 12/9/2009 12/10/2009 12/11/2009 12/12/2009 12/13/2009 12/14/2009 12/15/2009 12/16/2009 12/17/2009 12/18/2009 12/19/2009 12/20/2009 12/21/2009 12/22/2009 12/23/2009 12/24/2009 12/25/2009 12/26/2009 12/27/2009 12/28/2009 12/29/2009 12/30/2009 12/31/2009
11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 11 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12 12
7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4
170.00 423.06 211.23 117.77 140.32 88.67 88.87 85.57 403.53 361.30 146.07 94.35 134.00 86.89 64.52 232.54 458.82 150.60 52.35 87.50 57.65 59.06 217.55 339.71 126.55 139.76 74.04 53.82 121.38 248.00 206.46 85.89 154.00 51.62 69.68 62.10
170.00 232.00 211.23 150.10 174.00 114.00 146.00 123.00 245.00 228.47 136.11 124.00 134.00 156.89 106.00 241.00 240.00 156.28 143.26 175.00 106.00 163.00 205.00 210.00 116.00 139.76 131.00 159.00 133.13 248.00 244.00 136.00 154.00 106.47 174.19 175.00
136.48 202.59 196.35 107.82 122.54 57.83 86.37 83.15 193.24 218.82 84.35 62.00 101.46 80.69 63.60 186.69 219.72 116.66 38.34 71.48 47.62 57.39 150.14 162.68 39.21 66.93 48.66 49.97 58.13 162.97 191.71 68.96 73.75 47.99 63.79 54.23
80% 87% 93% 72% 70% 51% 59% 68% 79% 96% 62% 50% 76% 51% 60% 77% 92% 75% 27% 41% 45% 35% 73% 77% 34% 48% 37% 31% 44% 66% 79% 51% 48% 45% 37% 31%
2,787.30 4,424.32 5,940.00 3,547.56 3,014.00 1,984.50 3,675.00 2,425.92 6,119.12 6,882.96 1,755.60 1,449.70 2,059.05 2,187.00 3,807.30 3,768.05 5,569.20 3,307.20 1,094.40 1,450.00 1,806.68 960.00 5,197.92 3,712.50 1,785.36 1,710.88 1,930.76 999.68 2,619.50 4,072.84 4,532.00 2,836.80 1,871.36 2,308.80 1,297.92 1,142.24
Revenue Other
Revenue Telephone
Revenue Food Beverage
Occupancy Rate
RevPAR
ADR
Rate Average Postng
856,634.14 30,865.95 1,332,602.86
92.91 138.26 396.00 191.76 205.50 132.30 147.00 191.52 0.00 163.88 92.40 38.15 166.95 97.20 77.70 121.55 309.40 137.80 27.36 58.00 116.56 0.00 106.08 247.50 83.04 138.72 41.08 93.72 0.00 321.54 0.00 0.00 58.48 187.20 66.56 25.96
3,809.31 9,401.68 7,392.00 5,465.16 4,178.50 2,910.60 5,733.00 3,894.24 6,993.28 9,013.40 3,649.80 1,564.15 4,340.70 3,159.00 5,672.10 8,143.85 6,342.70 3,169.40 1,805.76 1,537.00 3,030.56 2,220.00 5,940.48 7,548.75 2,325.12 2,959.36 2,957.76 1,811.92 3,981.64 4,501.56 8,497.50 5,106.24 2,397.68 3,432.00 2,562.56 1,791.24
214.98 149.71 19.67 172.83 123.91 140.49 154.00 204.00 203.94 50.43 67.40 79.53 75.47 85.35 168.14 216.34 35.43 58.48 150.86 117.00 71.06 194.78 175.02 33.53 151.00 99.65 91.15 172.00 322.67 253.62 46.23 178.59 104.19 212.61 135.43 233.00 254.29 47.48 63.25 148.00 81.09 50.52 272.43 220.81 58.70 107.14 141.03
234.98 218.33 105.92 172.83 123.91 140.49 154.00 204.00 220.93 145.00 113.00 104.00 188.68 143.16 212.00 245.46 155.00 112.46 165.00 117.00 109.82 224.00 237.00 147.00 151.00 193.44 185.16 172.00 220.00 250.00 110.00 184.00 160.00 198.11 178.00 233.00 239.55 126.00 103.00 148.00 127.43 138.26 229.00 203.00 135.00 150.00 137.00
146.43 147.61 19.39 85.20 75.04 81.13 101.20 154.46 189.37 49.71 54.11 38.08 58.46 62.51 137.35 184.99 34.93 41.18 74.37 36.25 34.03 128.00 162.51 26.92 72.31 92.63 83.45 150.20 210.43 246.48 44.93 85.52 63.10 122.77 89.00 176.41 236.13 46.80 50.77 70.87 62.82 37.00 222.55 182.41 57.04 73.94 67.54
62% 68% 18% 49% 61% 58% 66% 76% 86% 34% 48% 37% 31% 44% 65% 75% 23% 37% 45% 31% 31% 57% 69% 18% 48% 48% 45% 87% 96% 99% 41% 46% 39% 62% 50% 76% 99% 37% 49% 48% 49% 27% 97% 90% 42% 49% 49%
3,010.00 5,976.00 482.04 3,102.75 2,275.56 2,198.83 2,704.80 4,949.14 6,883.20 1,199.52 2,830.50 1,354.08 1,672.44 2,028.95 3,659.76 4,763.20 952.32 1,820.78 1,532.16 1,393.70 1,268.08 3,679.20 3,326.40 780.78 2,584.68 1,428.00 1,596.16 3,073.96 6,699.00 8,332.80 1,065.75 2,744.28 1,783.60 3,926.56 2,582.65 4,719.12 8,280.00 973.44 1,719.90 2,438.48 2,623.95 970.14 4,663.02 5,440.50 2,199.60 2,826.95 2,102.10
86.00 0.00 13.39 137.90 189.63 0.00 77.28 107.59 286.80 0.00 62.90 131.04 39.82 115.94 0.00 357.24 30.72 77.48 0.00 79.64 86.46 262.80 110.88 0.00 61.54 107.10 74.24 166.16 133.98 520.80 30.45 65.34 109.20 170.72 0.00 337.08 345.00 54.08 0.00 55.42 160.65 78.66 451.26 279.00 112.80 68.95 100.10
6,278.00 8,366.40 575.77 2,964.85 2,528.40 4,468.59 4,095.84 7,316.12 10,324.80 1,909.44 2,516.00 3,450.72 2,229.92 2,782.56 6,027.84 9,050.08 1,566.72 2,363.14 2,553.60 1,672.44 1,930.94 6,394.80 6,541.92 1,561.56 3,384.70 1,927.80 1,633.28 6,231.00 8,038.80 11,631.20 2,070.60 5,031.18 1,638.00 5,463.04 2,802.45 7,191.04 13,800.00 1,352.00 2,457.00 4,156.50 4,016.25 1,101.24 11,281.50 6,696.00 3,722.40 4,964.40 2,252.25
215.09 124.76 303.80 219.69 134.76 160.00 83.89 147.00 136.00 215.91 230.23 100.45 84.36 47.48 70.51 179.56 290.67 390.22 134.67 119.55 73.14 59.54 57.96 418.21 259.55 73.17 111.03 102.18 102.30 169.90 450.41 669.00 155.09 90.54 87.51 124.56 149.00 286.89 216.28 196.76 96.78 112.91 67.51 123.00 207.83 249.08 104.52
169.00 124.76 215.00 210.00 134.76 160.00 133.00 147.00 136.00 219.23 220.07 173.00 146.00 117.00 139.00 185.00 211.85 242.41 177.00 176.00 113.19 158.00 118.00 241.00 230.24 200.26 184.00 182.00 181.00 185.00 247.00 223.00 107.61 119.00 158.00 114.46 149.00 249.00 213.00 196.76 159.00 179.00 148.00 123.00 221.24 249.08 180.00
66.65 59.75 199.64 204.00 64.54 105.14 77.90 118.01 65.13 200.70 210.77 87.72 55.01 46.14 68.52 85.99 176.04 225.34 88.50 90.51 67.91 58.69 46.54 200.27 201.06 53.59 90.70 84.41 99.42 117.25 215.69 207.30 74.27 59.50 81.26 59.65 97.91 188.53 200.83 94.23 63.60 104.84 54.20 58.90 193.20 228.03 91.27
39% 48% 93% 97% 48% 66% 59% 80% 48% 92% 96% 51% 38% 39% 49% 46% 83% 93% 50% 51% 60% 37% 39% 83% 87% 27% 49% 46% 55% 63% 87% 93% 69% 50% 51% 52% 66% 76% 94% 48% 40% 59% 37% 48% 87% 92% 51%
1,251.32 1,710.88 6,323.85 5,988.08 1,606.84 2,853.84 2,539.95 3,062.04 1,848.24 4,614.35 5,386.96 2,898.00 1,415.70 1,617.00 3,290.00 2,580.60 4,672.80 7,696.92 1,837.50 2,220.84 2,191.14 1,485.90 1,844.08 5,079.90 6,361.20 937.08 3,172.75 2,083.20 1,837.68 2,111.40 4,600.40 5,773.68 2,953.72 1,512.00 2,284.56 1,657.60 3,532.80 5,978.40 5,749.92 2,427.60 1,429.68 3,198.82 2,041.00 2,618.00 7,015.92 6,259.50 1,687.32
30.52 0.00 134.55 485.52 141.78 0.00 72.57 270.18 0.00 446.55 158.44 0.00 94.38 0.00 0.00 56.10 129.80 0.00 131.25 0.00 59.22 99.06 0.00 0.00 282.72 26.03 0.00 99.20 96.72 45.90 262.88 0.00 0.00 113.40 120.24 155.40 0.00 127.20 159.72 173.40 0.00 0.00 81.64 178.50 0.00 417.30 0.00
2,227.96 3,774.00 6,458.40 7,768.32 3,733.54 6,658.96 4,281.63 4,953.30 3,029.06 11,461.45 6,971.36 4,599.00 1,730.30 3,332.00 4,620.00 3,366.00 7,398.60 7,382.76 2,843.75 3,295.44 4,204.62 2,509.52 3,887.52 8,177.40 10,177.92 1,353.56 3,302.25 3,868.80 3,481.92 2,340.90 9,989.44 7,377.48 5,101.88 1,738.80 3,426.84 2,745.40 6,359.04 6,868.80 11,819.28 3,641.40 1,243.20 3,879.42 1,673.62 4,462.50 6,405.84 10,988.90 2,746.80
76.27 62.49 82.55 190.24 307.49 330.66 112.00 68.60 56.86 52.00 67.79 419.94 242.31 84.29 100.78 85.98 60.75 90.73 339.29 681.00 137.18 136.96 101.35 131.09 170.00 297.13 246.86 301.88 195.87 76.14 107.37 307.09 213.50 228.31 94.89 135.64 139.03 112.17 250.76 368.21 408.98 214.26 163.96 154.25 74.57 153.00 507.44
132.00 154.00 178.00 196.00 216.75 205.41 161.00 101.00 115.50 138.00 138.00 242.00 208.23 199.23 167.00 169.00 131.00 117.00 206.00 227.00 111.05 180.00 183.00 120.46 170.00 201.00 226.00 183.29 170.00 101.00 120.00 197.00 207.22 215.07 111.00 109.00 181.00 180.00 174.00 243.58 236.17 176.00 158.00 200.52 105.00 171.00 243.00
49.74 38% 60.73 39% 80.23 45% 91.10 46% 186.23 86% 190.94 93% 73.60 46% 51.94 51% 52.80 46% 51.26 37% 54.42 39% 201.10 83% 187.70 90% 61.73 31% 82.32 49% 71.03 42% 59.04 45% 62.62 54% 162.48 79% 211.01 93% 65.69 59% 90.00 50% 94.11 51% 62.77 52% 111.71 66% 195.26 97% 229.23 101% 144.56 79% 128.71 76% 70.70 70% 86.20 72% 147.06 75% 198.46 96% 209.01 97% 82.86 75% 88.46 81% 135.11 75% 109.01 61% 120.08 69% 223.00 92% 236.17 100% 140.80 80% 124.14 79% 143.23 71% 73.50 70% 122.83 72% 243.00 100%
1,128.40 2,071.72 2,150.72 1,843.38 4,270.00 5,148.00 1,785.60 3,420.00 1,925.76 1,478.88 1,381.80 3,929.40 6,565.12 1,127.50 1,714.30 1,378.08 1,658.88 2,009.82 4,174.80 5,258.88 2,577.96 1,549.80 2,110.68 2,826.80 2,439.84 5,318.28 6,929.60 3,269.28 3,273.28 3,148.74 2,907.00 2,356.38 6,454.56 4,160.70 3,480.51 4,878.72 3,549.94 3,034.08 4,013.10 5,475.60 6,933.15 3,026.80 2,932.60 2,940.00 3,615.71 4,479.84 5,680.00
96.72 126.84 91.52 112.86 244.00 396.00 148.80 136.80 113.28 123.24 29.40 261.96 142.72 27.50 55.30 0.00 155.52 147.06 119.28 493.02 234.36 129.15 102.96 70.67 125.12 483.48 346.48 233.52 0.00 277.83 0.00 181.26 0.00 0.00 316.41 0.00 104.41 189.63 0.00 304.20 308.14 128.80 136.40 294.00 76.93 186.66 142.00
1,547.52 3,044.16 3,020.16 2,144.34 7,930.00 7,260.00 2,678.40 4,035.60 3,228.48 2,629.12 1,822.80 6,549.00 10,133.12 1,292.50 3,152.10 1,284.12 2,851.20 3,235.32 9,065.28 9,367.38 5,468.40 2,324.70 2,368.08 2,897.47 4,879.68 9,024.96 11,087.36 4,203.36 6,239.69 5,649.21 3,136.50 4,833.60 11,833.36 8,182.71 5,168.03 8,648.64 4,385.22 4,993.59 5,255.25 8,669.70 9,552.34 5,152.00 4,433.00 7,350.00 3,307.99 5,973.12 5,964.00
281.69 128.25 150.69 109.16 162.65 101.00 341.48 220.65 231.06 141.72 138.71 112.74 196.41 228.29 266.60 170.11 247.64 153.62 88.17 216.65 381.00 434.95 243.48 179.53 103.82 132.80 135.11 517.88 279.11 155.17 113.41 108.07 197.47 115.00 311.78 292.02 126.79 182.67 159.89 221.71 220.50 325.67 231.57 373.76 176.63 140.54 144.58
218.21 119.09 190.00 122.00 149.46 101.00 231.00 202.00 140.29 123.00 184.00 126.00 126.00 212.21 244.07 199.00 199.00 200.00 117.00 127.00 237.43 251.17 200.00 173.00 108.84 187.00 151.00 248.00 216.21 144.09 143.00 110.00 181.46 115.00 202.00 226.21 122.09 163.00 147.00 115.97 161.00 211.00 212.00 186.88 125.00 145.00 123.00
218.21 93.93 123.10 90.17 77.89 66.37 224.40 204.89 110.65 93.13 128.80 90.51 94.06 212.21 244.07 148.55 161.51 149.30 85.69 103.75 230.75 251.17 160.00 135.93 96.40 130.90 108.46 248.00 216.21 113.65 92.65 89.28 94.56 75.57 204.89 226.21 92.86 149.23 132.09 106.17 144.90 214.01 215.03 178.99 116.07 130.50 116.07
100% 79% 65% 74% 52% 66% 97% 101% 79% 76% 70% 72% 75% 100% 100% 75% 81% 75% 73% 82% 97% 100% 80% 79% 89% 70% 72% 100% 100% 79% 65% 81% 52% 66% 101% 100% 76% 92% 90% 92% 90% 101% 101% 96% 93% 90% 94%
5,476.94 3,870.72 2,260.44 2,448.00 3,150.18 1,851.96 4,974.20 5,482.62 2,494.24 2,747.52 3,946.95 2,409.75 3,148.20 4,666.12 5,731.83 4,193.36 2,704.80 2,563.08 3,575.52 3,166.80 5,536.56 7,015.51 3,468.64 1,848.00 4,620.24 3,013.01 3,462.90 6,759.20 6,590.22 3,307.92 2,221.80 3,627.68 2,368.00 4,327.68 6,756.36 7,508.25 4,111.56 2,889.25 3,892.98 4,287.40 3,538.08 5,495.40 6,718.02 5,204.72 4,066.40 4,352.67 3,891.36
144.13 80.64 115.92 102.00 146.52 168.36 426.36 498.42 220.08 114.48 0.00 107.10 0.00 0.00 440.91 182.32 128.80 197.16 297.96 150.80 325.68 0.00 91.28 57.75 100.44 70.07 0.00 0.00 0.00 200.48 148.12 0.00 0.00 0.00 173.24 159.75 0.00 82.55 299.46 126.10 98.28 152.65 176.79 0.00 358.80 177.66 235.84
9,080.19 4,515.84 2,782.08 3,213.00 4,322.34 3,760.04 9,806.28 7,974.72 4,695.04 3,491.64 6,665.96 3,213.00 6,926.04 11,891.08 7,936.38 5,013.80 3,220.00 2,694.52 7,449.00 4,976.40 9,607.56 12,833.25 5,202.96 3,638.25 5,524.20 5,395.39 4,353.36 7,773.08 8,630.05 6,214.88 4,739.84 3,804.64 2,427.20 5,740.80 13,685.96 8,786.25 5,686.20 5,200.65 6,588.12 6,052.80 5,896.80 9,616.95 12,905.67 5,930.96 8,252.40 6,751.08 7,193.12
244.71 244.42 229.46 119.05 302.22 150.96 149.57 172.29 334.14 369.15 173.91 210.45 152.46 99.52 172.98 490.74 276.53 141.63 172.10 140.54 203.35 201.41 245.50 230.55 163.32 181.33 157.25 95.65 320.71 396.88 367.41 185.04 111.09 58.15 149.59 155.00 314.87 271.98 323.29 155.54 83.68 158.37 288.38 211.44 253.78 119.68 131.91
130.00 227.21 210.07 121.00 200.00 168.00 172.00 101.00 202.37 213.17 125.00 169.00 159.84 109.00 145.00 235.00 214.21 115.08 161.00 145.00 173.00 107.00 228.21 211.07 166.00 120.00 175.00 110.00 188.00 240.37 212.17 133.00 146.00 105.00 137.46 155.00 213.00 249.00 196.29 135.00 111.00 177.00 185.00 205.22 239.07 140.00 106.00
117.18 227.21 210.07 103.96 197.10 146.70 145.35 82.51 202.37 213.17 114.29 159.34 141.57 98.10 138.87 235.00 214.21 103.73 140.59 130.50 163.25 96.45 228.21 211.07 142.62 118.26 152.82 92.96 153.58 240.37 212.17 121.60 73.00 54.00 71.63 101.86 206.91 252.56 154.82 102.21 77.70 127.14 138.10 196.55 232.34 104.51 86.03
90% 100% 100% 86% 99% 87% 85% 82% 100% 100% 91% 94% 89% 90% 96% 100% 100% 90% 87% 90% 94% 90% 100% 100% 86% 99% 87% 85% 82% 100% 100% 91% 50% 51% 52% 66% 97% 101% 79% 76% 70% 72% 75% 96% 97% 75% 81%
3,031.04 5,248.32 8,076.96 3,934.50 3,695.12 2,879.28 4,368.00 1,856.00 6,225.99 7,778.76 3,020.16 4,159.98 4,921.56 4,819.50 4,141.20 5,069.40 7,827.75 4,045.44 3,385.20 2,871.54 3,302.43 4,249.60 5,422.98 4,779.72 2,792.58 3,763.80 3,447.20 5,382.00 2,578.10 5,914.30 6,435.44 3,840.00 1,562.40 2,844.00 2,503.05 3,602.26 4,995.96 7,571.44 4,121.60 2,873.13 1,937.95 2,239.92 4,362.96 5,143.52 6,397.68 2,067.00 3,315.20
0.00 164.01 336.54 0.00 0.00 200.88 0.00 0.00 168.27 530.37 0.00 0.00 117.18 107.10 236.64 289.68 347.90 247.68 112.84 200.34 106.53 318.72 0.00 144.84 0.00 167.28 0.00 117.00 0.00 0.00 438.78 0.00 100.80 0.00 0.00 87.86 0.00 528.24 268.80 0.00 166.11 62.22 0.00 165.92 168.36 0.00 0.00
4,072.96 7,216.44 12,115.44 6,216.51 4,375.80 4,821.12 7,753.20 3,306.00 9,927.93 13,436.04 6,223.36 9,454.50 4,921.56 7,389.90 7,809.12 9,993.96 11,306.75 4,540.80 7,673.12 3,205.44 7,989.75 7,543.04 5,851.11 5,793.60 3,922.91 5,771.16 6,118.78 5,499.00 3,167.38 13,916.00 9,360.64 5,145.60 3,124.80 3,469.68 4,212.45 4,568.72 10,475.40 10,916.96 6,899.20 4,125.52 3,488.31 3,484.32 5,431.44 7,632.32 8,081.28 4,028.00 6,720.00
148.25 67.93
193.00 109.00
144.07 66.01
75% 61%
4,388.93 2,599.35
89.57 199.95
5,732.48 3,799.05
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181
1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2 3 4 5 6 7 1 2
Average Total
35 36 37 46 68 71 56 53 49 51 53 68 69 53 56 53 43 49 65 71 56 55 50 49 51 71 71 56 46 51
70 70 71 70 70 70 71 70 70 71 71 71 71 71 69 71 71 71 71 71 70 70 70 70 71 71 71 71 71 69
54.6 70.5
46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57
46 65 34 46 46 65 34 46 65 57 34 66 65 62 45 69 69 34 43 41 46 53 65 69 57 34 55 52 58 57
10
11
12
RevenueRoomsTotal
RoomsPostedTotal 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9
RevenueRoomsAdjustment
8
RevenueRoomsNonTaxable
7
RevenueRoomsTaxable
6 RoomsPostedNontaxable
5
RoomsPostedTaxable
4
RoomsAvailable
30 6/1/2009 6/2/2009 6/3/2009 6/4/2009 6/5/2009 6/6/2009 6/7/2009 6/8/2009 6/9/2009 6/10/2009 6/11/2009 6/12/2009 6/13/2009 6/14/2009 6/15/2009 6/16/2009 6/17/2009 6/18/2009 6/19/2009 6/20/2009 6/21/2009 6/22/2009 6/23/2009 6/24/2009 6/25/2009 6/26/2009 6/27/2009 6/28/2009 6/29/2009 6/30/2009
3
RoomsSold
Day
2009 6
Day
Year Month
6300 6588 4329 7820 13668 16046 10136 9010 4949 6120 10441 14076 14835 5883 6104 9593 7740 8526 15665 16543 9856 8690 9850 5145 8721 17253 15478 6664 8740 6222
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 128 0 0 0 128 0 0 0 0 15 5 0 0 0 0 0 168 225 0 0 176 0 0 0 15 5 0 0
6300 6588 4457 7820 13668 16046 10264 9010 4949 6120 10441 14091 14840 5883 6104 9593 7740 8526 15833 16768 9856 8690 10026 5145 8721 17253 15493 6669 8740 6222
290991
0
865
291856
52.6
1 2
December
3 4 5 6 7
136.956521739 101.353846154 131.088235294 170 297.130434783 246.861538462 301.882352941 195.869565217 76.1384615385 107.368421053 307.088235294 213.5 228.307692308 94.8870967742 135.644444444 139.028985507 112.173913043 250.764705882 368.209302326 408.975609756 214.260869565 163.962264151 154.246153846 74.5652173913 153 507.441176471 281.690909091 128.25 150.689655172 109.157894737
180 183 120.459459459 170 201 226 183.285714286 170 101 120 197 207.220588235 215.072463768 111 109 181 180 174 243.584615385 236.169014085 176 158 200.52 105 171 243 218.211267606 119.089285714 190 122
90 94.1142857143 62.7746478873 111.714285714 195.257142857 229.228571429 144.563380282 128.714285714 70.7 86.1971830986 147.056338028 198.464788732 209.014084507 82.8591549296 88.4637681159 135.112676056 109.014084507 120.084507042 223 236.169014085 140.8 124.142857143 143.228571429 73.5 122.830985915 243 218.211267606 93.9295774648 123.098591549 90.1739130435
0.5 0.5142857143 0.5211267606 0.6571428571 0.9714285714 1.0142857143 0.7887323944 0.7571428571 0.7 0.7183098592 0.7464788732 0.9577464789 0.9718309859 0.7464788732 0.8115942029 0.7464788732 0.6056338028 0.6901408451 0.9154929577 1 0.8 0.7857142857 0.7142857143 0.7 0.7183098592 1 1 0.7887323944 0.6478873239 0.7391304348
198.683116765 173.720413618 137.847265428
0.7742796878
0.7004677339
December
0.6828361473
17
18
19
RevenueOther
RevenueTelephone
RevenueFoodBeverage
16
OccupancyRate
15
RevPAR
14
ADR
RateAveragePostng
13
1549.8 2110.68 2826.8 2439.84 5318.28 6929.6 3269.28 3273.28 3148.74 2907 2356.38 6454.56 4160.7 3480.51 4878.72 3549.94 3034.08 4013.1 5475.6 6933.15 3026.8 2932.6 2940 3615.71 4479.84 5680 5476.94 3870.72 2260.44 2448
129.15 102.96 70.67 125.12 483.48 346.48 233.52 0 277.83 0 181.26 0 0 316.41 0 104.41 189.63 0 304.2 308.14 128.8 136.4 294 76.93 186.66 142 144.13 80.64 115.92 102
2324.7 2368.08 2897.47 4879.68 9024.96 11087.36 4203.36 6239.69 5649.21 3136.5 4833.6 11833.36 8182.71 5168.03 8648.64 4385.22 4993.59 5255.25 8669.7 9552.34 5152 4433 7350 3307.99 5973.12 5964 9080.19 4515.84 2782.08 3213
114841.09
4580.74
175104.67
0.6362676056 0.7030181087 0.961167002 0.9965291751 0.7809859155
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0
January February March April May June July August September October November December █ Rooms 291,856.00 Food & Bev 114,841.09 Telephone 4,580.74 Other 175,104.67
Follow the steps to enable your Hotel Dashboard. >>
This template is prepared for keeping track of the daily room and revenue data and analyzing the performance of the hotel with the h
1)
This template may store and analyze the data for a year. Enter the year that you want to use the template for:
Year 2) >> >> 5)
6)
7) >> >>
2009
Data sheet contains sample data. Delete the sample data and start entering your daily informaton.
erformance of the hotel with the help of a dashboard.
Related Documents
Dashboard Excel Hotel
October 2019 13
Hotel Dashboard 02
June 2020 3
Excel Speedometer Dashboard
November 2019 6
Hotel-excel-invoice1.xlsx
December 2019 13
Dashboard
May 2020 23