Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Quantitative Management-1 Business Analysis: Bike Rental in US

    Uploaded by

    Raghavendra Naduvinamani
    The document summarizes bike rental data from several major US cities. It finds that Wednesday is the peak day for trips and May is the peak month. Most trips are taken by customers aged 23-38. Over 70% of total trip duration is accounted for by the 23-38 age group. Seasonality analysis shows higher ridership in Q2 and Q3. Forecasting predicts over 1.2 million trips in 2019 based on prior year trends.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Quantitative Management-1 Business Analysis: Bike Rental in US

    Uploaded by

    Raghavendra Naduvinamani
    33 views9 pages
    The document summarizes bike rental data from several major US cities. It finds that Wednesday is the peak day for trips and May is the peak month. Most trips are taken by customers aged 23-38. Over 70% of total trip duration is accounted for by the 23-38 age group. Seasonality analysis shows higher ridership in Q2 and Q3. Forecasting predicts over 1.2 million trips in 2019 based on prior year trends.

    Original Title

    QMM-1 Project

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document summarizes bike rental data from several major US cities. It finds that Wednesday is the peak day for trips and May is the peak month. Most trips are taken by customers aged 23-38. Over 70% of total trip duration is accounted for by the 23-38 age group. Seasonality analysis shows higher ridership in Q2 and Q3. Forecasting predicts over 1.2 million trips in 2019 based on prior year trends.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    33 views9 pages

    Quantitative Management-1 Business Analysis: Bike Rental in US

    Uploaded by

    Raghavendra Naduvinamani
    The document summarizes bike rental data from several major US cities. It finds that Wednesday is the peak day for trips and May is the peak month. Most trips are taken by customers aged 23-38. Over 70% of total trip duration is accounted for by the 23-38 age group. Seasonality analysis shows higher ridership in Q2 and Q3. Forecasting predicts over 1.2 million trips in 2019 based on prior year trends.

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    of 9

    Quantitative Management-1

    Business Analysis : Bike Rental in US

    GROUP 3 PRESENTATION: EMP OCT 2018 BATCH


    Background : Bike Rental Services

    Hypothesis , Ho: Price 3 $ per 30 mins


    Ha: Price 3 $ per 30 mins is less

    Why we chosen this project?


    Forecast
    Which Tools we have used?
    Methodology adopted
    Two Objectives
    Business Decision taken
    Inferential statistics
    Rental Bike : No of Trips
    Total Trips
    Trips Breakup

    174,103

    85,573
    10% 133,770
    250,125 101,539
    28% 11% 109,835

    93,967
    10% 76,022
    66,798 67,015
    61,803 58,176
    53,691
    200,785 168,011
    22% 19% 31,882 34,741 32,164

    January February March April May June

    Chicago New York


    January February March April May June

    City Selected Chicago for Analysis


    Pareto Analysis : Trip counts vs Stations
    100% 100%
    98%
    361590 94%
    87%
    TOP 10 Stations
    78% (contributing 50% of Total Trips)

    1. Streeter Dr & Grand Ave


    63%
    2. Pershing Square North
    205745 3. Clinton St & Washington Blvd
    4. Lake Shore Dr & Monroe St
    5. E 17 St & Broadway
    40%
    130682 6. Broadway & E 22 St
    7. W 21 St & 6 Ave
    88791 8. West St & Chambers St
    58496 9. Clinton St & Madison St
    36142 10. W 20 St & 11 Ave
    16162
    2392
    1-152 153-304 305-456 457-608 609-760 761-912 913-1064 1065-1216

    No of Trips Rel. Cum Freq.


    Peak Day & Peak Month
    Peak Day & Peak Month ( No of Trips) Revenue $ M per day
    100000 0.35

    90000
    0.30
    80000

    70000 0.25

    60000
    0.20
    50000

    40000 0.15

    30000
    0.10
    20000
    0.05
    10000

    0 -
    Sunday Monday Tuesday Wednesday Thursday Friday Saturday Monday Tuesday Wednesday Thursday Friday Saturday Sunday

    January February March April May June 0-30 30-60 60-90 90-120 Beyond 2 Hrs

    Peak Day : Wednesday


    Peak Month : May
    Peak Time
    Peak Time (No of Trips) Peak Time (Revenue $ M)

    0.52

    0.36 0.37

    0.30 0.30

    154,499

    103,004 111,025
    95,734
    86,927 0.12

    35,110 0.03 0.02


    7,702 5,999
    12 AM- 3 AM 3 AM- 6 AM 6 AM- 9 AM 9 AM -12 PM 12 PM- 3 PM 3 PM - 6 PM 6 PM- 9 PM 9 PM- 12 PM 12 AM- 3 AM 3 AM- 6 AM 6 AM- 9 AM 9 AM -12 PM 12 PM- 3 PM 3 PM - 6 PM 6 PM- 9 PM 9 PM- 12 PM
    Age vs Trip Duration Analysis
    Customer Base
    Sum of Total trip duration (hrs)
    5,000,000

    4,000,000

    3,000,000
    Customer
    575967211 Subscriber
    48% 619612296 2,000,000
    52%

    1,000,000

    -
    15-22 23-30 31-38 39-46 47-54 55-62 63-70 71-78

    Age group from 23- 38 yr actually taken 70% of overall trips


    Seasonality
    No of Trips Seasonality Check
    1600000 1600000

    1400000 1400000

    1200000 1200000

    1000000
    1000000

    800000
    800000
    600000
    600000
    400000
    400000
    200000
    200000
    0
    Q1 Q2 Q3 Q4
    0
    2013 2014 2015 2016 2017 2018
    Forecast 2019: No of Trips
    Forecast of No of Trips

    1600000
    Actual Forecast

    1200000

    800000

    400000

    You might also like