Need a Template: B2B Rate Sheet & Pricing Calculator for FIT (Day Trips & Multi-Day)
Hi everyone,
I am putting together our B2B rate sheets for the upcoming season and need a template or a solid framework. I am trying to build an Excel/Google Sheets calculator that handles both Day Trips and Multi-Day FIT/Private tours on a tiered pricing scale (from Solo to X Pax).
For B2B, I need to easily calculate:
Our Net/Cost Price per tier.
The Gross/Retail Price (incorporating a travel agent commission of 15–20%).
Multi-day variables (hotel room configurations like Single Supplement vs. Twin/Double sharing).
If anyone has a blank template, a link to a B2B costing matrix, or advice on how to structure a multi-day tiered rate sheet, I would be incredibly grateful!
Thanks!