Pricing, itinerary and commercial model per hosted experience
Status — not started
Trip summary
The header details that flow through every tab, plus a status overview of the whole trip. Tap any row to jump to that tab.
Status overview
Identity
Commercial basis
Sets the currency symbol across every tab.
0
Blue values are inputs you edit Black values are calculated for you Highlighted = needs attention / sign-off
Commercials
A high-level budget for the entire trip. Edit COGS and margin per category; commission and totals calculate automatically. Management fees and sales commission are signed off by Emma alongside the overall commercial sign-off.
This tab
Profit & loss
Total trip value—
less Cost of goods sold—
Gross profit——
less Management fee—
less Sales commission—
Net profit——
Retail rates
Rate
Calculated
Public
COGs
Margin
Expense categories
Category
Status
COGS
Margin %
Commission
Total
Sales commission
—
—
Sales commission is Commission % of the net margin (the categories' combined markup), deducted from net profit.
Break-even (pre-launch pricing)
—
—
—
Escrow transfer — for finance
—
—
Satopia management fee
Phase / task
Days
Hours
Cost
Fee — base
—
USD
—
GBP
—
Hours = days × 8. Check the latest FX rates in the Sales Dashboard before sign-off.
Room pricing
Pre-launch, launch and last-minute price points per room category. Adjust each room against the standard rate until the full buyout matches the target. Standard rate, full buyout and trip margin pull from Commercials.
This tab
Fill in room categories to check the buyout match.
From commercials
—
—
—
—
Target = full buyout + (2 × standard rate), leaving the last 2 rooms as a bonus.
Pricing inputs
Timing windows
—
—
—
—
—
Room categories
#
Room name
Pax
Rooms
Adj to std
Partner
Pre-launch
Launch
Last min
Per-person price points
Room
Adult · pre
Adult · launch
Adult · last
Child · pre
Child · launch
Child · last
Margin & partner commission per room
Room
Margin · pre
Eff. % pre
Margin · launch
Margin · last
Partner comm.
Partner commission assumes one partner booking per room flagged “Yes”. Set room-level partner bookings on the room table above. Commission = room rate × partner commission %.
Trip itinerary
Day-by-day plan with cost build-up. Activity, transfer, accommodation and other costs roll into the total estimate — sanity-check it against the COGS budget on Commercials.
This tab
—
Activities
—
Transfers
—
Accommodation
—
Other
—
Total estimate
—
How it works: set the number of days to build the structure — each new day comes pre-set with breakfast, lunch and dinner slots, and you add activities or transfers in between — drag the ⠿ handle to reorder rows or move them between days. Set a start date and every day shows its calendar date. The total estimate includes transfers (the original sheet left those out); Commercials stays the signed-off budget.
Itinerary preview
Suppliers
Track supplier quotes and payments against each expense category budget. Budgets pull from the Commercials COGS. Do a weekly review — mark a line paid once the payment has gone out.
This tab
Total budget
—
Committed
—
Remaining
—
Opens every supplier line — payments and quote documents. Or use the ▸ link on any line to open it on its own.
Monthly payment forecast
Every scheduled payment bucketed by month — the COGS forecast for the Sales Dashboard.
How it connects: each section mirrors a Commercials expense category and pulls its COGS as the budget. Add supplier lines per section, then expand a line to schedule its payments by date. If a supplier is paid in another currency, convert before entering the amount.
First name
Last name
Company
Role
Phone
Email
Category
Status
Notes
A directory of supplier and partner contacts for this trip — who they are, what they do, and how to reach them. Kept alongside quotations so everything supplier-related lives in one place.
Marketing budget
Acquisition spend and performance. Available budget vs committed shows headroom; KPIs track cost per acquisition against the booking target.
