Bike & Scooter Sharing Economics: Trips per Vehicle-Day, Ride Pricing, Charging & Rebalancing, Damage Write-Offs and Unit Economics

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn a week of fleet data into vehicle-days, pooled trips per vehicle-day, the deployment rate of the owned fleet and a count of trips by time band with COUNTIFS: the utilisation facts every sharing business starts from.
• Price a trip from an unlock fee and a per-minute rate, add up a month of revenue over trip-length bands with SUMPRODUCT, and work out the weighted average revenue per trip, trip length and revenue per minute.
• Measure how many trips come from monthly pass holders, what a pass trip really earns once the pass price is spread over the trips, and how many trips a rider needs before the pass is cheaper than paying per ride.
• Turn trips and battery range into the number of battery swaps per day and the staff shifts they need, then price one swap from labour, van, energy and battery wear and compare it with the charging cost per trip when staff are paid for whole shifts.
• Compare where the vehicles stand with where the morning demand will be, count how many vehicles must be moved, turn the moves into van runs and van hours, and price each vehicle moved.
• Pool six months of write-offs and thefts into a monthly loss rate, turn it into an expected vehicle life, spread the vehicle price over all the trips of that life and flag the months with unusually high losses.
• Build the profit of one vehicle for one day from revenue per trip, payment fees, per-trip costs and per-day costs, and work out how many trips per vehicle-day are needed to break even.
• Size next summer's fleet from forecast demand, a target utilisation and the share of vehicles out of service, run low, base and high scenarios for the profit per vehicle-day and per month, and show them in a column chart.