Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Fuel Analysis 05052020

    Uploaded by

    peter rich
    The document summarizes payments made to three vehicles (T489 CMZ, T227 DPW, T320 DPJ) operating out of Tunduru DC for 9 days. It shows the subtotal payment and excess fuel costs for each vehicle based on distance traveled each day and excess kilometers over the agreed daily limit. The total payments and excess fuel costs for all three vehicles are provided.

    Copyright:

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

    Fuel Analysis 05052020

    Uploaded by

    peter rich
    15 views8 pages
    The document summarizes payments made to three vehicles (T489 CMZ, T227 DPW, T320 DPJ) operating out of Tunduru DC for 9 days. It shows the subtotal payment and excess fuel costs for each vehicle based on distance traveled each day and excess kilometers over the agreed daily limit. The total payments and excess fuel costs for all three vehicles are provided.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document summarizes payments made to three vehicles (T489 CMZ, T227 DPW, T320 DPJ) operating out of Tunduru DC for 9 days. It shows the subtotal payment and excess fuel costs for each vehicle based on distance traveled each day and excess kilometers over the agreed daily limit. The total payments and excess fuel costs for all three vehicles are provided.

    Copyright:

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

    Fuel Analysis 05052020

    Uploaded by

    peter rich
    The document summarizes payments made to three vehicles (T489 CMZ, T227 DPW, T320 DPJ) operating out of Tunduru DC for 9 days. It shows the subtotal payment and excess fuel costs for each vehicle based on distance traveled each day and excess kilometers over the agreed daily limit. The total payments and excess fuel costs for all three vehicles are provided.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 8

    Summary of Payments

    Reg. No. Location No. of Days @ Subtotal Excess Fuel


    1 T489 CMZ Tunduru DC 9 325,000 2,925,000 580,800
    2 T227 DPW Tunduru DC 9 325,000 2,925,000 652,800
    3 T320 DPJ Tunduru DC 9 325,000 2,925,000 669,600
    Total 8,775,000 1,903,200
    Total
    3,505,800
    3,577,800
    3,594,600
    10,678,200
    T489 CMZ Dista

    Date Out
    1 24.04 196,170.00
    2 25.04 196,960.00
    3 26.04 197,068.00
    4 27.04 197,179.00
    5 28.04 197,272.00
    6 29.04 197,345.00
    7 30.04 197,446.00
    8 1.05 197,553.00
    9 2.05 197,702.00
    Total
    Excess Km covered
    Average Fuel Use 1ltr/ 6km
    Excess Km covered 1,451.00

    Distance covered
    Excess Fuel used 1,451.00

    Fuel Price(@ltr)
    Excess Fuel Refund Claim 2,400.00
    T489 CMZ Distance/Fuel Analysis

    Distance Traveled
    Distance in Excess of Agreed
    In Distance Traveled Agreed/Day Daily Travel(Km)
    196,960.00 790.00 100 - 690.00
    197,068.00 108.00 100 - 8.00
    197,178.00 110.00 100 - 10.00
    197,272.00 93.00 100 7.00
    197,345.00 73.00 100 27.00
    197,446.00 101.00 100 - 1.00
    197,553.00 107.00 100 - 7.00
    197,702.00 149.00 100 - 49.00
    198,522.00 820.00 100 - 720.00
    Total - 1,451.00
    Excess Km covered

    Total Excess Fuel


    Average Fuel Use(1tr/6km) Used
    6.00 241.833333333333

    Total Excess Fuel Used Total(TZS)


    242.00 580,800.00
    Lin
    T227 DPW Dista

    No. of Days Date Out


    1 23.04 124,371.00
    2 24.04 125,269.00
    3 25.04 125,420.00
    4 26.04 125,574.00
    5 27.04 125,636.00
    6 28.04 125,766.00
    7 29.04 125,897.00
    8 30.04 125,972.00
    9 2.05 126,047.00
    Total

    Excess Km covered
    Average Fuel Use 1ltr/ 6km
    Excess Km covered 1,634.00

    Distance covered
    Excess Fuel used 1,634.00

    Fuel Price(@ltr)
    Excess Fuel Refund Claim 2,400.00
    Lindi DC
    T227 DPW Distance/Fuel Analysis

    Distance Traveled
    Distance in Excess of Agreed
    In Distance Traveled Agreed/Day Daily Travel(Km)
    125,269.00 898.00 100 - 798.00
    125,420.00 151.00 100 - 51.00
    125,574.00 154.00 100 - 54.00
    125,636.00 62.00 100 38.00
    125,766.00 130.00 100 - 30.00
    125,897.00 131.00 100 - 31.00
    125,972.00 75.00 100 25.00
    126,047.00 75.00 100 25.00
    126,905.00 858.00 100 - 758.00
    Total - 1,634.00

    Excess Km covered

    Total Excess Fuel


    Average Fuel Use(1tr/6km) Used
    6.00 272.333333333333

    Total Excess Fuel Used Total(TZS)


    272.00 652,800.00
    Tund
    T320 DPJ Dista

    No. of Days Date Out


    1 23.04 86,000.00
    2 24.04 86,805.00
    3 25.04 86,997.00
    4 26.04 87,213.00
    5 27.04 87,368.00
    6 28.04 87,453.00
    7 29.04 87,604.00
    8 30.04 87,695.00
    9 2.05 87,760.00
    Total

    Excess Km covered
    Average Fuel Use 1ltr/ 6km
    Excess Km covered 1,676.00

    Distance covered
    Excess Fuel used 1,676.00

    Fuel Price(@ltr)
    Excess Fuel Refund Claim 2,400.00
    Tunduru DC
    T320 DPJ Distance/Fuel Analysis

    Distance Traveled
    Distance in Excess of Agreed
    In Distance Traveled Agreed/Day Daily Travel(Km)
    86,805.00 805.00 100 - 705.00
    86,997.00 192.00 100 - 92.00
    87,213.00 216.00 100 - 116.00
    87,368.00 155.00 100 - 55.00
    87,453.00 85.00 100 15.00
    87,604.00 151.00 100 - 51.00
    87,695.00 91.00 100 9.00
    87,760.00 65.00 100 35.00
    88,576.00 816.00 100 - 716.00
    Total - 1,676.00

    Excess Km covered

    Total Excess Fuel


    Average Fuel Use(1tr/6km) Used
    6.00 279.333333333333

    Total Excess Fuel Used Total(TZS)


    279.00 669,600.00

    You might also like