Case study · Snorkel and boat tours

Departures for a tour company, with the profit on every boat known before it leaves.

Blue Reef Tours · Departures and profit per trip

4 channels
two booking sites, hotel desks and direct bookings, on one manifest.
1 seat, sold once
A seat sold on one channel comes off the others.
Per trip
profit after commission, guide, skipper and fuel, before the boat leaves.

Blue Reef Tours knew how full each boat was. It didn't know which trips made money.

The problem

A team of six runs two boats and up to six departures a day. Bookings arrive from two booking sites, three hotel desks, chat and walk-ins, and the manifest is a sheet the office rebuilds every evening. Each channel takes a different cut, so a full boat could still lose money, and nobody knew which until the accountant's quarterly figures.

What we noticed

Every booking already carried its price and its channel. Add each trip's fixed costs, the guide, the skipper and the fuel, and a departure has a profit the moment a seat is sold, not three months later.

What we built
  • One manifest

    Bookings from every channel land on one list per departure, with names, group sizes and waivers. A seat sold anywhere comes off everywhere.

  • Profit per departure

    Each trip shows its takings after commission, minus guide, skipper and fuel. Trips heading for a loss are flagged the evening before.

  • Move or merge

    When two half-empty trips would both lose money, the office offers the guests on one the other departure, in one message.

What the owner sees
Margin on each departure last Saturday, after commission and every cost of running the trip.
  • 13:00 Snorkel · Lost money: five guests, all from booking sites
What changed
  • The quiet slot

    The early-afternoon snorkel trip lost money on most weekdays. It now runs only when six seats are sold by the evening before.

  • No seat sold twice

    The evening rebuild of the manifest stopped; the office works from one list.

  • Channels, judged by profit

    The site that brought the most guests also brought the thinnest trips, so the team gave its best departures to the hotel desks.

What we chose not to do

We chose not to cancel loss-making trips automatically. A guest may have one day for this trip, so the office decides, with the numbers in front of it.

How we know
Trips run at a loss each month
Also watching
Seats sold twice; bookings and margin by channel
Must not get worse
Guests moved to another departure who then cancel
First release, then next
  1. First

    One manifest for both booking sites and direct bookings, with profit per departure.

  2. Next

    Hotel desks booking straight in, and waivers signed on the phone.

See all 5 cases

Have a tool like this in mind?

Book a free call to talk it through, or start with a free check of your website.