Tour Operator Package Pricing: Per-Person Costing, Minimum Group Sizes, Single Supplements, Currency Buffers, Deposits & Departure P&L
Price group trips and package tours so that each departure makes money. You will split fixed group costs per person, find the minimum group size, set single supplements and room-sharing prices, add a currency buffer, choose between margin and markup, plan deposits and cancellation income, and run a season's departures P&L, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you price a fictional tour operator's group trips in a spreadsheet, step by step. You split a cost sheet into fixed group costs and per-person costs, build the cost-per-traveller curve and find the break-even and minimum viable group. You price twin, triple and single rooms and work out the single supplement, cost foreign land services with a currency buffer and find the exchange rate where the margin disappears. You compare margin and markup, round to brochure price points with CEILING, deduct discounts and agent commission, set balance dates with EDATE, look up a fictional cancellation scale and finish with a season P&L and a chart.
Lessons
- The Package Cost Sheet: Fixed Group Costs vs Per-Person Costs Pro
- Per-Person Cost by Group Size and the Minimum Viable Group Pro
- Room Sharing: Twin, Triple and Single Prices and the Single Supplement Pro
- Currency Buffers: Costing Foreign Land Costs and the Rate Where the Margin Disappears Pro
- Margin vs Markup: Selling Prices and Brochure Price Points Pro
- Early-Booking Offers and Agent Commission: Net Revenue per Seat Pro
- Deposits, Balance Dates and Cancellation Scales Pro
- The Season P&L: Fill Rates, Guaranteed and Cancelled Departures Pro