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