← Back to Marketing Analytics Consultants

Case study · Seasonal operations and pricing

Setting a rate before you know the demand

One driver, one rented vehicle, eleven weekends, and a group of international staff paying out of their own pockets to see the region. What looks like a scheduling problem turns out to be a pricing problem with a scheduling problem inside it.

1. A small operation with a lot of constraints

A seasonal residential program needed weekend transportation for its international staff — day trips, coastal outings, and longer runs to two major cities. One driver, one rented vehicle, roughly eleven weekends, and a staff who mostly could not drive themselves and were paying out of their own pockets.

What looks like a scheduling problem is really a pricing problem with a scheduling problem inside it.

11weekends in the season
6–7seats per vehicle including the driver
8documents in the operating package
~24Kwords of procedure and destination detail

2. Model the constraints before quoting anything

Figure 1

The geometry of the operation

Three fixed points, none of them in the same place Home base the driver Rental depot the vehicle The site the passengers ~45 min ~30 min ~35–40 min direct, but the vehicle is not at either end Every trip carries about two and a half hours of unbilled positioning before a passenger boards.

The driver’s base, the rental depot and the site are three separate locations. The vehicle has to be collected before any trip begins and returned after it ends.

Figure 2

What the rate has to cover

What an hourly rate has to absorb before it is income Vehicle for the weekend ~$537 Fuel at cost Positioning time unbilled Payment processing 5.6% on international A rate quoted without these is not a rate. It is a guess that loses money on the third weekend.

Vehicle hire is a fixed weekend cost regardless of how many trips run. Fuel is reimbursed at cost. Positioning time is real work that no passenger is in the vehicle for. Payment processing differs by nationality.

Why two rates were modeled, not one

Both a lower and a higher hourly rate were built out fully, with the fixed costs, the positioning time and the processing fees carried through each. The recommendation went to the higher rate — not as a preference but as the arithmetic. At the lower one, a weekend with two short trips does not cover the vehicle.

3. Rules, so the schedule does not have to be negotiated every week

With one driver and one vehicle, every trip competes with every other trip. Deciding that weekly by conversation is exhausting for everyone and produces resentment. So the operation runs on published rules instead.

RuleWhat it prevents
Short trips may run Saturday or Sunday; the group chooses by WednesdayTwo groups discovering on Friday that they wanted the same day
All longer trips are Sunday onlyA long trip eating a weekend that could have carried two short ones
The furthest destination departs a day earlyA trip that cannot physically fit in a weekend being booked as one
Payment due Wednesday at three; Tuesday for the long tripChasing money after the vehicle has already been hired
Overnight accommodation is included in the trip priceAn unrecovered cost that only appears after the season ends
A published standby procedureA cancellation leaving a paid-for vehicle idle
Why the rules are in the handbook, not the driver’s head

The staff are seasonal, international, and largely unfamiliar with the distances involved. Written rules that they read before they book remove every argument before it starts. The rule that matters most is the Wednesday cutoff, because it is the point at which a weekend stops being hypothetical and becomes a committed cost.

4. The package that makes it run without the operator

DocumentWho it is for
Transportation analysis with both rate scenariosThe program director deciding whether to endorse it
Staff handbookStaff, before they book anything
Transport guideAnyone needing to know how a trip actually works
Trip planning guideA group organizing an outing themselves
Destination guideDeciding where to go and what is worth the drive
Administration manualWhoever runs the program next
Standby addendumThe cancellation and backfill procedure
Season calendar fileEveryone, on their own phone

Every guide was produced twice — a document version for the office, and a phone-formatted version, because the people who need the transport guide are standing in a parking lot in another country holding a phone.

The piece that turns it into a business

A booking and cash-flow tool covering the season overview, trips and bookings, an actual expenses ledger, a cash flow statement, cost settings and reports. Without it the operator finds out in September whether the season made money. With it, they know on the Thursday of week three — while there is still time to change the rate.

5. What this case is meant to show

The usual approachWhat was done here
Pick an hourly rate that sounds fairModel the fixed costs and unbilled time, then let the arithmetic pick the rate
Sort out the schedule each weekPublish rules that decide it in advance
One documentEight, each written for a specific reader, in two formats
Reconcile at the end of the seasonA live ledger and cash flow from week one
Where this applies

Any small operation with a fixed asset, a short season and variable demand — equipment hire, seasonal tours, mobile services, event logistics. The pattern is always the same. The fixed cost is known, the demand is not, and the rate has to be set before either is certain. That is a modeling problem, and almost nobody treats it as one.

Marketing Analytics Consultants

Setting a rate before you know the demand?

We model the fixed costs, the unbilled time and the awkward edges — then write the rules and the ledger that keep the operation honest with itself while the season is still running.

Prefer email? info@marketinganalyticsconsultants.com