Forum Discussion

AKP_1's avatar
AKP_1
Copper Contributor
Apr 03, 2019
Solved

Calculate a percentage increase that doesn't exceed 100%

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 o...
BI & Data Analysis
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 03, 2019

    AKP_1 , perhaps

    =MIN(<EOM formula>, 0.95)

     

AKP_1's avatar
AKP_1
Copper Contributor
Apr 03, 2019

Twifoo 

 

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?

Twifoo's avatar
Twifoo
Silver Contributor
Apr 04, 2019
What are the maximum values for each of those 2 assumptions? Regardless of what they are, the EOM occupancy rate will always be less than 100%.
  • AKP_1's avatar
    AKP_1
    Copper Contributor
    Apr 04, 2019

    Twifoo 

     

    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

Resources