Apr 03 2019 11:46 AM
Hello everyone,
I am currently working on an occupancy rate up model. Here is the scenario
I have a hotel with occupancy rate of 70% and ramp up 6 months
I need to calculate the EOM occupancy rate and average occupancy rate
EOM occupancy rate = 70%/6 = 0..7/6 = 0.1167 = 11.67%
while the average rate = (previous EOM occupancy rate + current EOM occupancy rate)/2
For a 10 year plan, with the above function, the values will exceed 100% and in reality an hotel won't have 150% occupancy rate.
I need to modify the function so that when EOM occupancy rate reaches 95%, it remains there. It won't exceed 100% even the plan is 100 years. Thank you
Apr 03 2019 12:48 PM
SolutionApr 03 2019 01:00 PM
Apr 03 2019 01:08 PM
Thank you for your reply. Much appreciated!
Yes however there is an provision for business analysts to change the occupancy rate as well as occupancy ramp values...
Do you have any suggestion regarding that?
Apr 03 2019 01:09 PM
Apr 03 2019 07:26 PM
Apr 04 2019 07:16 AM
Thank you for your response. I design a model for hotel occupancy.
The minimum value of occupancy rate is usually 50-70% while the ramp up is usually 6 months.
I have a challenge with this formula
If I put the value as occupancy rate = 50%, the forecast rate stops at 50% ... The proposed design is to take 100% then =MIN(D13, 1) keeps it at 100%. I attached a file for more clarity.
Regards
Apr 04 2019 07:55 AM
Apr 03 2019 12:48 PM
Solution