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)

     

Twifoo's avatar
Twifoo
Silver Contributor
Apr 03, 2019
Based on your formula, the EOM occupancy rate will be limited to a maximum of 16.67%, which is 100%/6.
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