The Bus Trip Calculator: Price Your Next Trip in 10 Minutes (Google Sheets)

Stop guessing. Type your costs into the yellow cells, and this calculator tells you exactly what to charge for your bus trip to hit a 20% profit margin at 70% sellout. Plus tiered pricing, deposit schedules, and a full post-trip P&L tracker. Built on Shanteria's exact pricing formulas.

Full Product Description

Here's how most travel agents price a bus trip:

"Umm... $99 sounds about right?"

Then the motor coach comes back at $4,200 instead of $4,000. The gas surcharge is real. The welcome gifts cost $280 because you wanted the nice tote bags. The driver tip is $200, not $100. You need to feed the driver.

By the time the trip leaves the parking lot, you've made $47 in profit. For six weeks of work. You tell yourself "next time I'll price higher," and then you do the exact same thing next time.

The Bus Trip Calculator ends that.

This is the same pricing framework Shanteria teaches inside the Bus Trips Masterclass, built into a Google Sheet that does the math for you. Type your real numbers into the yellow cells. The calculator tells you exactly what to charge. Every time.

What's Inside (6 Tabs)

1. Start Here Welcome, how to use each sheet, and the color key. Read this once and you're done.

2. Trip Cost Calculator The hero sheet. Plug in your fixed costs (motor coach, driver tip, marketing, welcome gifts) and your variable costs (hotel, meals, attractions, snacks). The calculator instantly gives you:

• Your break-even price per seat

• Your ticket price based on a 70% sellout and 20% minimum margin

• Your projected profit at 70% capacity

• Your bonus profit if you sell every seat

3. Tiered Pricing Automatically builds your Early Bird, Regular, and Last-Minute prices based on your base ticket price. Creates urgency in your launch without you having to do any math.

4. Deposit & Payment Schedule Tells you how much deposit to collect, when each installment is due, and what your projected cash flow looks like at booking. No more guessing how to structure payments.

5. Post-Trip P&L After your trip runs, drop your actual numbers into the blue column. See projected vs. actual side-by-side. Know the truth about what you really made. Use those lessons to price your next trip smarter.

6. Legal & Terms Disclaimer, license terms, and a reminder to get your own insurance and attorney review before running trips.

What Makes This Different

• Based on real formulas, not made-up advice. 70% capacity rule, 20% minimum margin, rounded to the nearest $5. These are the numbers Shanteria built Travel Divas on.

• Connects every sheet. Change your base price once on the Calculator tab, and your tiered pricing, deposit schedule, and P&L all update automatically.

• Actually teaches you. Every yellow input cell has a note next to it explaining what the number should be and why. You'll know more about trip pricing in 10 minutes than 90% of travel agents will ever know.

Who This Is For

• Travel agents planning their first bus trip

• Agents who've run trips but aren't sure if they're making real profit

• Anyone who watched the Bus Trips Masterclass and wants the math to do itself

• New travel business owners who want to start with the easiest, most profitable trip type

Who This Is NOT For

• Anyone who wants to keep guessing their prices

• Anyone who doesn't plan to actually run a bus trip

Format

Google Sheets template. Instant delivery. Copy to your Google Drive, plug in your numbers, use for every bus trip you run from here to forever. No subscription. No expiration.

One trip. One price you would have under-charged by $50 per seat. That's $1,950 in missed profit on a single trip. This calculator pays for itself 100 times over on your first trip.