Bike & Scooter Sharing Economics: Trips per Vehicle-Day, Ride Pricing, Charging & Rebalancing, Damage Write-Offs and Unit Economics
Run the numbers of a fictional shared bike and e-scooter fleet: trips per vehicle per day, unlock and per-minute pricing, passes, charging and rebalancing operations, damage and vehicle life, city fees and the profit per vehicle-day, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course turns a fictional shared e-bike and e-scooter fleet into spreadsheet work you can check. You pool vehicle-days into trips per vehicle-day, count trips by time band with COUNTIFS and price rides from an unlock fee and a per-minute rate with SUMPRODUCT over trip-length bands. You compare monthly passes with pay-per-ride, size battery swaps and staff shifts with ROUNDUP, cost the morning rebalancing by van, turn damage and theft into a vehicle life and depreciation per trip, and build the profit per vehicle-day with its break-even trips. A scenario table and a column chart finish the fleet plan.
Lessons
- Fleet & Utilisation: Vehicle-Days, Trips per Vehicle-Day and Busy Hours Pro
- Ride Revenue: Unlock Fee, Per-Minute Rate and Trip-Length Bands Pro
- Passes vs Pay-per-Ride: Subscriber Share, Revenue per Pass Trip and the Rider Break-Even Pro
- Charging Operations: Battery Range, Swaps per Day and Cost per Swap Pro
- Rebalancing: Surplus and Deficit Zones, Van Hours and Cost per Vehicle Moved Pro
- Damage, Theft & Vehicle Life: Loss Rates and Depreciation per Trip Pro
- Unit Economics per Vehicle-Day: Revenue, Ops Costs, Depreciation and the City Fee Pro
- Fleet Sizing & Dashboard: Vehicles Needed, Scenarios and the Monthly Profit Chart Pro