Introduction

Estimation is a valuable skill in product management as a quick analysis can be used to scope out solutions and reach semi-accurate conclusions. There are different ways to estimate solutions and each method comes with certain limitations. Two methods for solving the problem below are outlined:


How many bicycles are required to start a ride sharing scheme in a large metropolitan area?


Method 1: The detailed operation
  1. Estimate the total population of the core city area where the bike scheme is most likely to be implemented (total addressable market).
    1. Calculate the average number of people in each age bracket for this core population.
  2. Determine which groups of people are most likely to use the bicycle sharing scheme and for what activity e.g. commuting, tourist activities, miscellaneous activities.
    1. Estimate the percentage of people from each age bracket (1.a) that are likely to be interested in using a bike rental scheme for an activity identified in (2.) e.g. commuting.
    2. Estimate the percentage of people from (2.a) that are likely to not own a bike (the available market for each activity group).
    3. Estimate the percentage of people from (2.a) that are likely to not own a bike (the available market for each activity group).
    4. Repeat steps (2.a) to (2.c) for each of the activity groups identified in (2).
  3. Calculate the total amount of bike ride activity per day by adding up the time estimates of all groups involved.
  4. Determine what percentage of the market that you think could be obtained within the first 12 months (target market) e.g. 10% of the total identified market in (2.a). Multiply this percentage by the total hours in (3.) to work out a new estimate for the total number of activity hours per day.
  5. Decide on a bike utilisation rate (what percentage of bikes should be in use at any one time on average). For a 50% bike utilisation rate between the hours of 8am and 12am (16-hour window), each bike needs to be in use for 8 hours.
  6. Calculate the total number of bikes required. Divide the total rider activity per day from (4.) by the utilisation window in (5.).

Example: A bike sharing operation in London
  1. London has a downtown population of 9 Million.
    1. Assume that the average number of people in an age bracket of 1 year is uniform and the age range is between 0 and 80 (both very unlikely, but used for a simple analysis):
    2. 9MM / 80 ~ 112k per age bracket
  2. Focusing on a single activity group of bike users: Commuters
    1. E.g. 20% of all people in age brackets between 18 and 60 might be interested in commuting by bike.
    2. 0.2 * 112k * 42 ~ 1MM biking commuters
    3. Of the 1MM biking commuters, approximately 30% of the people may not own or have regular access to a bike:
    4. 0.3 * 1M = 300k potential users
    5. Using an average commute time of 20mins by bike and 2 commuting sessions per day:
    6. 0.33 Hours * 2 Sessions/day ~ 0.66 hours of bike usage per person per day
  3. The total amount of bike rider activity per day for commuters is therefore:
  4. 0.66 hours * 300k riders ~ 200k hours per day of bike usage
  5. To obtain a 10% market share over the first 12 months of the bike scheme we need to obtain:
  6. 0.1 * 200k hours per day ~ 20k hours per day of bike usage
  7. For a 50% utilisation rate of bikes during the 16-hour window of people using the bikes for commuting between 8am and 12am.
  8. The total number of bikes required to implement this scheme would be:

Method 2: Peak usage (+ Example)
This method is slightly different and estimates the number of bikes required based on peak usage of the system. This analysis will focus on one of the busiest times is the evening commute (5pm to 7pm).

  1. Follow steps 1. and 2. from Method 1 and estimate the percentage of people from each activity group that are likely to be interested in using a bike rental scheme for commuting, tourist activities and misc activities between the hours of 5pm to 7pm.
  2. Calculate the average time that each group uses the bike for during this period e.g. 20 mins for commuter, 60 mins for tourist and 30 mins for misc activities.
  3. Using the information gathered above calculate the total number of hours that the bikes are in use for during this period.
  4. Group Total Pop Activity Time Bike Usage
    Commuters 300k 0.33 Hours 100k Ride Hours
    Tourists 20k 1 Hour 20k Ride Hours
    Misc Activities 50k 0.5 Hours 25k Ride Hours

    Overall, there is an estimated: 145k hours of bike usage.
  5. If a 10% market share is targeted as in the example above, this leads to 14.5k hours of bike usage. A 100% utilisation rate over the two-hour period requires:

Analysis and Comments
  1. Ask more questions– It is important to clarify the scope of the problem to understand the requirements and reduce the number of unknowns.
    1. The geography of a city– This has important implications on the uptake of a bike rental systems. The location of train stations, popular business areas, bike lanes should be factored into the decisions process for trailing bike stations.
    2. Churn Rate– What percentage of users do we expect to retain with each use of the scheme? How will this rate the target uptake in the first year? How will this affect the number of bikes required over time?
    3. The number of bike stations– The number of bike stations, the size of them, their frequency and popularity within the city needs to be considered. The overall demand has been calculated in this analysis, but the supply side of the problem presents numerous challenges e.g. bike location matching the demand of stations over time.
  2. Define the problem – Although the question has already been determined here, in reality it would be important to understand what the underlying problem actually is. Is current public transport overcrowded, late, expensive? These questions are important when considering the price and location of a bike rental system.
  3. Cross analyse results – The two methods used calculate a different number of bikes required for the operation when considering commuters only. This doesn’t mean that either solution is wrong but identifies weaknesses in using certain methods and assumptions.
  4. Limit the number of estimations – As the number of estimations increases the accuracy of the model is degraded (particularly estimations that are hard to verify) unless data can be found as justification. However, for the task rough approximations are expected to be used.
  5. Assumptions can be problematic – This disregards the need for having extra bikes at a station to incentivise new customers into the bike scheme. In addition, a sudden increase in the number of users in the scheme (e.g. start of tourist season) will risk a bike shortage.
  6. Try an MVP operation – The questions states the number of bikes required for an operation. However before commencing this project, a smaller test that places a small number of bikes at popular commuter locations and records data on uptake would be incredibly valuable before scaling to a city-wide operation. Perhaps two further questions that should be looked into are:
    1. How many bikes are needed to start a rental operation?
    2. How many bikes tare needed to make the scheme successful/profitable.