Separate confirmed business from assumptions
Begin with booked departures and known guest counts. Add expected future bookings as a separate estimate. Label the forecast date so staff know which information it includes. Avoid presenting an estimate as if it were already secured revenue.
Model the operating constraints
Available departure dates, guide capacity and vehicle limits shape what can actually be sold. Use attendance and price assumptions appropriate to each season. A forecast that exceeds delivery capacity needs an explicit expansion assumption and the costs associated with it.
Use a small number of scenarios
Create a cautious, expected and stronger-demand case. Change a few meaningful inputs, such as occupancy or cancellations, rather than many arbitrary percentages. Include cost changes where demand requires more staff or transport. Compare contribution as well as revenue.
Update with actual results
Review forecast and actual performance on the same basis. Record whether differences came from attendance, price, cancellations or costs. Improve the next forecast using what changed. The model is a planning aid; its value comes from transparent assumptions and regular revision.
A concrete example
Model an illustrative eight departures with twelve seats at three occupancy levels. Keep price and delivery costs visible so the team can see what lower demand changes beyond the sales total.
Put it to work this week
Separate booked business from assumed future demand and set a regular review date for the assumptions.