How to Calculate Hotel Markup vs Margin: Formulas & Travel Agency Examples
Stop losing money due to confused terminology. This guide clarifies the exact mathematical difference between Markup % and Gross Margin %, with formulas, conversion tables, and real agency pricing scenarios.
The Critical Distinction
Markup is the percentage added ON TOP of the supplier cost to determine the selling price.
Margin is the percentage of the final SELLING PRICE that remains as gross profit.
Because Markup is calculated off a smaller number (Cost) and Margin is calculated off a larger number (Revenue), a 20% Markup will NEVER equal a 20% Margin.
1. The Markup Formula & Mechanics
When an agency applies a markup, it multiples the supplier net cost by (1 + Markup %).
Markup Calculation Example
- 1Supplier Net Cost: $600.00
- 2Markup Applied: 20% (0.20)
- 3Markup Amount: $600 × 0.20 = $120.00
- 4Selling Price = $600 + $120 = $720.00
- 5Resulting Margin % = $120 ÷ $720 = 16.67%
2. The Target Margin Formula & Mechanics
When an agency has a target gross margin percentage (e.g. 20% of top-line revenue), dividing by (1 - Margin %) calculates the correct selling price.
Target Margin Calculation Example
- 1Supplier Net Cost: $600.00
- 2Target Margin: 20% (0.20)
- 3Selling Price = $600 ÷ (1 - 0.20) = $600 ÷ 0.80 = $750.00
- 4Gross Profit = $750 - $600 = $150.00
- 5Resulting Margin % = $150 ÷ $750 = Exactly 20.00%
3. The Markup-to-Margin Conversion Matrix
Use this lookup table to convert between desired gross margins and required markups.
| Markup % on Cost | Resulting Gross Margin % | Multiplier |
|---|---|---|
| 10.0% | 9.09% | 1.100 |
| 15.0% | 13.04% | 1.150 |
| 20.0% | 16.67% | 1.200 |
| 25.0% | 20.00% | 1.250 |
| 30.0% | 23.08% | 1.300 |
| 33.3% | 25.00% | 1.333 |
| 50.0% | 33.33% | 1.500 |
| 100.0% | 50.00% | 2.000 |
4. The $10,000 Agency Quotation Mistake
A mid-sized tour operator selling $500,000 of packaged hotel accommodation annually budgeted for a 20% gross margin ($100,000 profit). However, their sales agents applied a 20% markup in their pricing spreadsheet instead of target margin.
At a 20% markup, they generated $600,000 in gross sales with $100,000 in gross profit, resulting in only 16.67% margin. To achieve a true 20% gross margin on $500,000 cost, their gross sales needed to be $625,000 with $125,000 profit — a $25,000 profit shortfall due purely to terminology confusion!
Frequently Asked Questions
Should travel agencies use Markup or Margin in their pricing software?
Professional travel CRM systems like TourVilo allow you to configure pricing rules either by Markup % on cost OR by Target Margin % on selling price. You should choose Target Margin % if you budget your agency's financial targets based on top-line revenue percentages.
Related TourVilo Platform Features
More Guides in Hotel Rate Management
Start Automating Hotel Rates & Travel Proposals
Join travel agencies worldwide saving hundreds of hours on manual calculations with TourVilo.