Scribd Logo
Upload

Welcome to Scribd!

  • 8 views

    Project 10

    Uploaded by

    Le Huyen Vy QP0938

    Copyright:

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

    Project 10

    Uploaded by

    Le Huyen Vy QP0938
    8 views3 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    8 views3 pages

    Project 10

    Uploaded by

    Le Huyen Vy QP0938

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    TX546777

    TX565115

    TX844000

    TX181100

    TX632947

    TX309161

    TX103660

    TX588958

    TX504410

    0% 10% 20% 30% 40% 50% 60% 70% 80% 90%


    TMO Taxi
    Vehicle Cost Analysis (Jan)
    Cost Maintenance Mileage
    Vehicle ID per Mile Miles Driven Cost Cost Total Cost
    TX504410 0.89 9964 1330.194 8867.96 10198.154
    TX588958 0.88 660 87.12 580.8 667.92
    TX103660 0.21 4609 145.1835 967.89 1113.0735
    TX309161 0.91 4905 669.5325 4463.55 5133.0825
    TX632947 0.7 242 25.41 169.4 194.81
    TX181100 0.21 4662 146.853 979.02 1125.873
    TX844000 0.39 6061 354.5685 2363.79 2718.3585
    TX565115 0.87 4777 623.3985 4155.99 4779.3885
    TX546777 0.28 8484 356.328 2375.52 2731.848
    Total

    Cost Mileage
    Vehicle ID per Mile Cost Total Cost
    Maintenance
    TX504410 0.97 Miles Driven Cost 9665.08 9665.08
    TX588958 0.85 9964 1450 561 2011
    TX103660 0.96 660 84 4424.64 4508.64
    TX309161 0.86 4609 664 4218.3 4882.3
    TX632947 0.82 4905 633 198.44 831.44
    TX181100 0.76 242 30 3543.12 3573.12
    TX844000 0.82 4662 531 4970.02 5501.02
    TX565115 0.72 6061 746 3439.44 4185.44
    TX546777 0.86 4777 516 7296.24 7812.24
    8484 1094

    Average 3581.4
    Highest 4929 639 7296.24
    Lowest 9964 1449.762 198.44
    242 30
    Tax rate 8%

    Tax Complaint rate Warning


    32%
    74%
    29%
    25%
    36%
    28%
    81%
    7%
    46%
    0

    You might also like