So the formula of Markup is:
Markup = Selling Price – Net Room Rate
A common mistake made in the hotel industry is to confuse Markup with margin. This is because OTA working with a Net Rate model also use a commission in the contract or distribution agreement with hotels. If we take the example above with a Markup of €20 and a final sell rate of €100, the margin in this case would be 20% (while the Markup is 25%).
Here some more formulas to put this in perspective:
- Net Rate = sell rate / (1 + Markup) >>> €100 / 1.25 = €80
- Net Rate = sell rate x (1 – margin) >>> €100 x 0.8 = €80
- sell rate = Net Rate x (1 + Markup) >>> €80 x 1.25 = €100
- sell rate = Net Rate / (1- margin) >>> €80 / (1 – 0.2) = €80 / 0.8 = €80