TCO Petrol and Diesel

Shared by: hedongchenchen
Categories
Tags
-
Stats
views:
13
posted:
8/14/2012
language:
English
pages:
5
Document Sample
scope of work template
							                  Cost of         Cost of                       Days in a    Distance
                  Vehicle -       Vehicle -                     working      per
                  Petrol          Diesel    Distance Per day    Month        month
                  832000.00       732000.00                  24           20         0
Mileage of
Vehicle                12.00           17.00
Calculated
Value                                                              24             480




                  Cost            Cost           Savings Bank
Year              Petrol          Diesel.        interest
              1            62.2             45                  4.00%
              2              67             45                  4.00%
              3              67             45                  4.00%
              4              67             82                  4.00%
              5             100             82                  4.00%
              6             100             82                  4.00%
              7             100             82                  4.00%
              8             100             82                  4.00%
              9             100             82                  4.00%
             10             100             82                  4.00%
Distance
Per year
         0



     5760
                           Petrol Vehicle
                                            Filters (petrol,oil
Year        Service    tyres    Battery            etc)           Total
        1       2000        0         0                       0     2000
        2       6000        0         0                       0     6000
        3       6000        0         0                       0     6000
        4       6000    20000      5000                       0    31000
        5       9000        0         0                       0     9000
        6       6000        0         0                       0     6000
        7       6000        0         0                       0     6000
        8       9000    20000      5000                       0    34000
        9       6000        0         0                       0     6000
       10       6000        0         0                       0     6000
                                                                  112000



                           Diesel Vehicle
                                            Filters (petrol,oil
Year        Service    tyres    Battery            etc)           Total
        1       2000        0         0                       0     2000
        2     12000         0         0                       0    12000
        3     12000         0         0                       0    12000
        4     16000     20000      9000                       0    45000
        5     12000         0         0                       0    12000
        6     12000         0         0                       0    12000
        7     12000         0         0                       0    12000
        8     16000     20000      9000                       0    45000
        9     12000         0         0                       0    12000
       10     12000         0         0                       0    12000
                                                                  176000
                                                                                                     Petrol Vehic

                          Bank Interest Amount if in                   Distance         Distance Per day(
Year        Amount        4%            Bank               petrol cost travelled (Year) 20 day Month)

        1     832000.00           4.00%        865280.00         62.20             5760.00               24.00
        2     865280.00           4.00%        899891.20         67.00             5760.00               24.00
        3     899891.20           4.00%        935886.85         67.00             5760.00               24.00
        4     935886.85           4.00%        973322.32         67.00             5760.00               24.00
        5     973322.32           4.00%       1012255.21        100.00             5760.00               24.00
        6    1012255.21           4.00%       1052745.42        100.00             5760.00               24.00
        7    1052745.42           4.00%       1094855.24        100.00             5760.00               24.00
        8    1094855.24           4.00%       1138649.45        100.00             5760.00               24.00
        9    1138649.45           4.00%       1184195.43        100.00             5760.00               24.00
       10    1184195.43           4.00%       1231563.25        100.00             5760.00               24.00
                                                                                     57600



                                                                                                     Diesel Vehic

                          Bank Interest Amount if in                   Distance              Distance Per day(
Year        Amount        4%            Bank               Diesel cost travelled             20 day Month)

        1  732000.00              4.00%        761280.00         45.00             5760.00               24.00
        2  761280.00              4.00%        791731.20         45.00             5760.00               24.00
        3  791731.20              4.00%        823400.45         45.00             5760.00               24.00
        4  823400.45              4.00%        856336.47         82.00             5760.00               24.00
        5  856336.47              4.00%        890589.92         82.00             5760.00               24.00
        6  890589.92              4.00%        926213.52         82.00             5760.00               24.00
        7  926213.52              4.00%        963262.06         82.00             5760.00               24.00
        8  963262.06              4.00%       1001792.54         82.00             5760.00               24.00
        9 1001792.54              4.00%       1041864.25         82.00             5760.00               24.00
       10 1041864.25              4.00%       1083538.82         82.00             5760.00               24.00
                                                                                     57600
Petrol Vehicle
                                                                                         Diff Between
                                                                                         Petrol and Diesel
     Distance                                                                            (Tco Petrol -TCO
     Travelled in a                                                                      Diesel) - negative
     Month                Mileage Liters      Fuel Cost    Service charge TCO            means cheaper

                 480.00      12.00   480.00     29856.00          2000.00    897136.00            118608.94
                 480.00      12.00   480.00     32160.00          6000.00    938051.20            119072.94
                 480.00      12.00   480.00     32160.00          6000.00    974046.85            123399.34
                 480.00      12.00   480.00     32160.00         31000.00   1036482.32            107362.33
                 480.00      12.00   480.00     48000.00          9000.00   1069255.21            138881.76
                 480.00      12.00   480.00     48000.00          6000.00   1106745.42            140748.37
                 480.00      12.00   480.00     48000.00          6000.00   1148855.24            145809.65
                 480.00      12.00   480.00     48000.00         34000.00   1220649.45            146073.38
                 480.00      12.00   480.00     48000.00          6000.00   1238195.43            156547.65
                 480.00      12.00   480.00     48000.00          6000.00   1285563.25            162240.90
                                                                   112000



Diesel Vehicle
                                                                                         Diff Between
                                                                                         Petrol and Diesel
     Distance                                                                            (Tco Diesel -TCO
     Travelled in a                                                                      Petrol) - negative
     Month                Mileage Liters      Fuel Cost    Service charge TCO            means cheaper

                 480.00      17.00   338.82     15247.06          2000.00    778527.06            -118608.94
                 480.00      17.00   338.82     15247.06         12000.00    818978.26            -119072.94
                 480.00      17.00   338.82     15247.06         12000.00    850647.51            -123399.34
                 480.00      17.00   338.82     27783.53         45000.00    929120.00            -107362.33
                 480.00      17.00   338.82     27783.53         12000.00    930373.45            -138881.76
                 480.00      17.00   338.82     27783.53         12000.00    965997.05            -140748.37
                 480.00      17.00   338.82     27783.53         12000.00   1003045.59            -145809.65
                 480.00      17.00   338.82     27783.53         45000.00   1074576.07            -146073.38
                 480.00      17.00   338.82     27783.53         12000.00   1081647.78            -156547.65
                 480.00      17.00   338.82     27783.53         12000.00   1123322.35            -162240.90
                                                                   176000

						
Related docs
Other docs by hedongchenchen
Donley PE 10.8-10.19
Views: 577  |  Downloads: 0
DoMN YOG Rego form 2 pilgrims
Views: 206  |  Downloads: 0
Donchian
Views: 367  |  Downloads: 0
Donation Requests 101006f
Views: 0  |  Downloads: 0
Donation_Request
Views: 376  |  Downloads: 0
Donalyn-Miller-Book-list
Views: 0  |  Downloads: 0
don't judge
Views: 0  |  Downloads: 0
Domestic Service Groups
Views: 363  |  Downloads: 0
domainsandmeasuresnovember2012_tcm77-286624
Views: 0  |  Downloads: 0
domainsandmeasuresfinal_tcm77-287743
Views: 0  |  Downloads: 0