Vehicle Choice: the Cheapest Suitable Vehicle per Job with MINIFS and XLOOKUP
This lesson is part of the course
In this lesson
You find the smallest vehicle that seats each group with MINIFS, return its type and cost rates with XLOOKUP, cost each job with the right vehicle and spot the jobs that need two vehicles.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Cost Base: Fixed Costs per Coach, Cost per km and Driver Cost per Hour Locked
- Cost Rates: per Hour and per km, the Cost of a Typical Job and the Minimum Charge Locked
- Dead Mileage: Live vs Empty Kilometres and the Cost of Positioning Locked
- Driver Duty: Duty Time, Driving Time and Breaks Against a Fictional Rule Set Locked
- Building Quotes: Day Trips, Transfers, Multi-Day Tours and the Price per Seat Locked
- Vehicle Choice: the Cheapest Suitable Vehicle per Job with MINIFS and XLOOKUP Locked
- Fleet Planning: Jobs per Day, Overlapping Bookings, Peak Days and Partner Hire Locked
- Profit per Vehicle and Season: Vehicle P&L, Utilisation, the Monthly Picture and a Chart Locked