Cruise Shore Excursion Capacity, Tour Operator Revenue Share, Cancellation Risk & Port-Day Profitability Tool
Cruise Shore Excursion Capacity, Tour Operator Revenue Share, Cancellation Risk & Port-Day Profitability Tool
Find the excursion mix that pays after operator commissions, berth-side capacity limits, guest refunds and missed-port risk. Compare actual departure windows, operator guarantees and seasonal call economics without counting cancelled tours as delivered revenue.
Model boundaries & economic treatment
Cancelled port calls refund 100% of excursion sales in this model; refunds reverse gross receipts and are not an additional P&L cost. Operator revenue share is deducted only once from fulfilled tour sales. Guaranteed minimum payouts are reconciled against percentage commissions, not added to them. Cancellation fees and unrecoverable costs are separate cash expenses. This is not a passenger-safety or dispatch authorization system.
Glossary and model methodology
Port-day contribution: retail ticket sales minus operator settlement, cruise processing, guest-service expense and fixed port-day cost. Expected contribution: probability-weighted cash profit across mutually exclusive outcomes. Tour capacity: seats eligible under the departure, operator and ship return limits. Demand: guests indicating excursion interest. Guest cancellations: lost interest before final embarkation. Recapture: fraction of unmet guest demand willing to switch to another available excursion. Revenue share: percentage of completed retail sales payable to the local operator. Minimum guarantee: contractual floor on ordinary-day operator payout. Stranded cost: nonrecoverable cash outlay when a call is missed. Refund exposure: estimate of gross guest retail refunds upon a missed call, not an additional operating expense. All-aboard buffer: time reserved before the ship's published all-aboard deadline. Conditional records: pending items excluded from approved projections. Monthly load: seasonality adjustment to guest count. Critical gate: contract or operations requirement needing independent verification.
Advanced tour cancellation factors multiply the default cancellation percentage: 100% is unchanged, 120% is 20% higher risk. Dispatch slots are screened in 30-minute blocks, not modeled as a certified transportation or tender schedule.
Shore-side commercial decision intelligence
SIMPLE · LIVEPort-day earnings waterfall
Typical operating-call sales, operator settlement, terminal operating costs and resulting cruise-line contribution.
Seasonal cash contribution
Risk-weighted contribution by month, accounting for planned port calls.
Capacity & conversion
Demand, bookable capacity, completed excursion guests and unused / missed demand.
Tour portfolio profitability
Cleared operators and verified departure capacity feed the operating model. Conditional products are not counted.
Departure capacity & all-aboard gate
Ship-time departure windows, duration, 30-minute dispatch limits and return buffer determine eligible slots. This is a planning screen, not a live excursion manifest.
Tour operator settlement
Percentage payout versus any contractual minimum guarantee. Canceled-call vendor fees are shown separately.
Cancellation and disruption outcomes
Exclusive scenarios are probability-weighted. A missed call produces no fulfilled tour revenue, with full guest refunds assumed.
25-scenario demand × disruption stress
Expected profit per scheduled port call. Choose a cell for its underlying guest-demand and risk assumptions; original inputs remain unchanged.