Tabellab
Business & Operations Intermediate

Running a Coach & Bus Charter Business: Cost per Hour and km, Dead Mileage, Driver Duty Limits, Quote Building & Fleet Utilisation

Price and run group transport profitably: build cost rates per hour and kilometre, add empty positioning kilometres, check trips against fictional driver duty limits, quote day trips, transfers and multi-day tours, choose the right coach per job and measure utilisation and profit per vehicle, with every cell checked as you go.

8 lessons 8 labs 2.1 h Certificate

One-time payment ยท lifetime access ยท lessons, labs, exam and certificate included ยท no subscription.

About this course

This course follows a fictional coach and bus charter operator through the numbers behind every quote. You build the cost base of a coach, turn it into rates per kilometre and per hour, cost a typical day trip and apply a minimum charge, add the empty kilometres to and from the depot, check planned duties against an invented rule set with IF and AND, quote day trips, transfers and multi-day tours with driver nights and seat prices, choose the smallest suitable vehicle with MINIFS and XLOOKUP, count overlapping bookings and partner hire, and finish with profit and utilisation per vehicle and a monthly chart.

Lessons

  1. The Cost Base: Fixed Costs per Coach, Cost per km and Driver Cost per HourLab14 min Pro
  2. Cost Rates: per Hour and per km, the Cost of a Typical Job and the Minimum ChargeLab15 min Pro
  3. Dead Mileage: Live vs Empty Kilometres and the Cost of PositioningLab15 min Pro
  4. Driver Duty: Duty Time, Driving Time and Breaks Against a Fictional Rule SetLab16 min Pro
  5. Building Quotes: Day Trips, Transfers, Multi-Day Tours and the Price per SeatLab16 min Pro
  6. Vehicle Choice: the Cheapest Suitable Vehicle per Job with MINIFS and XLOOKUPLab16 min Pro
  7. Fleet Planning: Jobs per Day, Overlapping Bookings, Peak Days and Partner HireLab16 min Pro
  8. Profit per Vehicle and Season: Vehicle P&L, Utilisation, the Monthly Picture and a ChartLab18 min Pro