Last-Mile Delivery Economics: Cost per Drop, Routes & Failed Deliveries
Model a courier depot in Excel: drops per hour, cost per drop, route capacity, failed deliveries, lockers vs doorstep, gig vs employed drivers, zone pricing and peak-season vans, every cell checked as you go.
The first lesson is free — no account needed.
About this course
A last-mile delivery economics course that models one fictional courier depot in a spreadsheet, for delivery operations and logistics staff, e-commerce teams and students. You measure stops per hour and stop density on six routes, build cost per drop from driver time, the van's fixed cost and fuel, work out how many stops fit into a van's delivery window and how many vans each zone needs, find the true cost of failed first attempts and value a pre-alert scheme, compare a parcel locker with a doorstep drop in dollars and CO2 per parcel, compare employed drivers with per-drop gig couriers and find the break-even rate, price zones and a free-delivery threshold against the cost to serve and plan peak-season vans and drivers. The driver comparison is a cost model, not legal or employment advice. The first lab is free.
Lessons
- Drops per Hour & Stop DensityFree
- Cost per Drop: Driver, Vehicle and Fuel Pro
- Route Capacity: Time Window, Service Time and Max Stops Pro
- Failed-Delivery Rate & Re-delivery Cost Pro
- Parcel Lockers vs Doorstep: Cost and CO2 per Parcel Pro
- Gig vs Employed Drivers: Cost per Drop Compared Pro
- Delivery Pricing: Zones and Free-Shipping Threshold Economics Pro
- Peak Season Capacity Planning: Vans and Drivers Needed Pro