A B C D E F G H 1 You are creating your budget for next year. Everything points to an 2 occupancy increase of 8% and an ADR increase of 3% Below are your 3 last year numbers for August and to the right are the dates of August for 4 this year. Your hotel has 100 rooms. Where will you finish this year in revenue? 6 Last August Occ ADR Revenue This August 1 Sunday 75% $ 179.00 $ 13,425 1 Monday 8 2 Monday 80% $ 189.00 15,120 2 Tuesday 9 3 Tuesday 85% $ 189.00 16,065 3 Wednesday 10 4 Wednesd 92% $ 189.00 $ 17,388 4 Thursday 1 1 5 Thursday 95% $ 199.00 S 18,905 5 Friday 12 6 Friday 100% $ 259.00 $ 25,900 6 Saturday 13 7 Saturday 100% $ 259.00 $ 25,900 7 Sunday 14 8 Sunday 78% $ 179.00 $ 13,962 8 Monday 15 9 Monday 88% $ 189.00 $ 16,632 9 Tuesday 16 10 Tuesday 93% $ 189.00 S 17,577 10 Wednesday 17 11 Wednesd 95% $ 189.00 $ 17,955 11 Thursday 18 12 Thursday 99% $ 199.00 $ 19,701 12 Friday 19 13 Friday 100% $ 259.00 25,900 13 Saturday 20 14 Saturday 100% $ 259.00 25,900 14 Sunday 21 15 Sunday 65% $ 179.00 S 11,635 15 Monday 22 16 Monday 70% $ 189.00 13,230 16 Tuesday 23 17 Tuesday 88% $ 189.00 S 16,632 17 Wednesday 24 18 Wednesd 92% $ 189.00 S 17,388 18 Thursday 25 19 Thursday 97% $ 199.00 S 19,303 19 Friday 26 20 Friday 100% $ 259.00 S 25,900 20 Saturday 27 21 Saturday 100% $ 259.00 S 25,900 21 Sunday 28 22 Sunday 74% $ 179.00 S 13,246 22 Monday 29 23 Monday 79% $ 189.00 S 14,931 23 Tuesday 30 24 Tuesday 83% $ 189.00 S 15,687 24 Wednesday 31 25 Wednesd 88% $ 189.00 16,632 25 Thursday 32 26 Thursday 96% $ 199.00 $ 19,104 26 Friday 33 27 Friday 100% $ 259.00 S 25,900 27 Saturday 34 28 Saturday 100% $ 259.00 $ 25,900 28 Sunday 35 29 Sunday 55% $ 179.00 9,845 29 Monday 86 30 Monday 60% $ 189.00 S 11,340 30 Tuesday 37 31 Tuesday 68% $ 189.00 $ 12,852 31 Wednesday 38 Total $ 565,755 39