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:

  1. Our Net/Cost Price per tier.

  2. The Gross/Retail Price (incorporating a travel agent commission of 15–20%).

  3. 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!