Simple Calculator: How to Calculate Profit Margin on Every Booking
After all the articles in which we discussed pricing group trips, private tours, and transfers, there is a fundamental question you must be able to answer quickly at any time: "What is the actual profit margin on this booking?". This article provides a simple formula you can apply to any booking in one minute, instead of needing to open a complicated spreadsheet every time.
The Basic Formula
Profit Margin = ((Selling Price − Total Cost) ÷ Selling Price) × 100
The difference between this method and simply doing "selling price minus cost" is that the percentage gives you a benchmark to compare bookings of different sizes, rather than just an absolute number.
Step One: Add Up All Total Cost Items
As we explained in detail in the article on calculating true cost, total cost must include:
- Direct costs (vehicle, tour guide, entrance tickets, meals)
- Payment gateway or intermediary commission if applicable
- An estimated share of the expected cancellation rate
- Any additional fees (insurance, permits)
Step-by-Step Calculated Example
Let's assume a private van tour booking for 6 people:
| Item | Amount (EGP) |
|---|---|
| Agreed selling price | 2,400 |
| Vehicle and driver cost | 1,200 |
| Fuel and distance | 250 |
| Entrance tickets (6 people × 100) | 600 |
| Payment gateway commission (2.5%) | 60 |
| Total cost | 2,110 |
Profit Margin = ((2,400 − 2,110) ÷ 2,400) × 100 = (290 ÷ 2,400) × 100 ≈ 12%
This number is crucial because it shows you that the booking is indeed profitable, but the margin is narrower than expected if you had only calculated "2,400 minus vehicle cost" without accounting for the remaining items.
Use a "Minimum Acceptable Margin" as a Red Line
Set a specific percentage (for example, 15% or 20% depending on your business nature) as the minimum acceptable margin for any booking. If a specific booking yields a margin below this threshold (like the example above, where 12% is lower than an assumed 15% threshold), this is a signal that you need to review either the price or the cost before repeating the same terms in other bookings.
Calculate the Margin for Each Trip Type Separately
An appropriate margin is not a single fixed figure across all types of services. As we discussed in previous articles, long-distance trips can accept a lower relative margin but with a higher absolute value, whereas day tours require a higher relative margin to compensate for the smaller total value.
Monitor the Average Margin on a Monthly Level, Not Just per Booking
A single booking with a low margin is not a disaster if the rest of your bookings have healthy margins. The key is to track your average profit margin across the month or season and ensure it stays above the minimum acceptable threshold you set for yourself.
Signs That Your Profit Margin Is Eroding Overall
- Frequent increases in input costs (fuel, tickets) without a corresponding adjustment in prices
- Too many discounts agreed upon during phone calls without a calculated floor
- Intermediary commissions taking a large chunk without being factored into the base price from the start
If you notice any of these signs repeatedly, revisit previous pricing articles in this series and review each item in detail.
Track Your Margin Automatically Rather Than Manually
Calculating the margin manually for every booking is tedious and prone to error, especially when you are occupied with many other operational details. With Easy Trips, you can log the cost of each trip and its packages once, and the system gives you a clear picture of your bookings' performance without needing manual calculations every time you book a new trip.
If you want to start managing your pricing and profit margin professionally and systematically, you can register here.