Appendix 01: Detailed Calculation
Quantity                       Total
                                     Average
                          of                        running      Quantity of   Quantity of    Quantity of   Quantity of
                                   running time
                       Generato                     time per      oil filter    fuel filter    air filter     bugi
                                      per day
                           r                          year
1. DG Lister Petter          677                                       5,976          3,344        1,672  
1.1. Grid sites              550                                       4,043          2,310        1,155  
a. Lister Peter 5kVA         437              4.3        1,570         3,212          1,835          918  
b. Lister Peter 8kVA        113                                          831            475          237  
1.2. Off grid sites          37                                         894             466          234  
a. Lister Peter 5kVA         25             15.7        5,731            604            315          158     
b. Lister Peter 8kVA         12                                          290            151           76     
1.3. Solar sites             90                                        1,039            568          283     
a. Lister Peter 5kVA         55              6.9        2,519            635            347          173     
b. Lister Peter 8kVA         35                                          404            221          110     
2. DG KIBI                  341                                        5,237          2,798        1,397  
2.1. Grid sites             129                                         948             542          270  
a. KBI 8kVA                 114                                         838             479          239  
                                             4.3        1,570
b. KBI 12kVA                 14                                         103              59           29  
c. KBI 20kVA                  1                                           7               4            2  
2.2. Off grid sites         146                                        3,526          1,840          920  
a. KBI 8kVA                 138                                        3,333          1,739          869     
                                            15.2        5,548
b. KBI 12kVA                  6                                          145             76           38     
c. KBI 20kVA                  2                                           48             25           13     
2.3. Solar sites             66                                          763            416          207     
                                             7.5        2,738
a. KBI 8kVA                  63                                          728            397          198     
b. KBI 12kVA            3                           35      19       9    
c. KBI 20kVA            0                            0       0       0    
3. DG Cummins         356                        4,461   2,287   1,249    
3.1. Grid sites       202                        1,273     636     424    
a. Cummins 12kVA      139                          876     438     292    
b. Cummins 20kVA       27      3.7       1,351     170      85      57    
c. Cummins 30kVA       34                          214     107      71    
d. Cummins 50kVA        2                           13       6       4    
3.2. Off grid sites   108                        2,608   1,361     680    
a. Cummins 12kVA       67                        1,618     844     422    
b. Cummins 20kVA       28     15.6       5,694     676     353     176    
c. Cummins 30kVA       13                          314     164      82    
d. Cummins 50kVA        0                            0       0       0    
3.3. Solar sites       46                          580     290     145    
a. Cummins 12kVA       45                          567     284     142    
b. Cummins 20kVA        1      7.9       2,898      13       6       3    
c. Cummins 30kVA        0                            0       0       0    
d. Cummins 50kVA        0                            0       0       0    
4. DG GEKO            106                          668     334     223    
4.1. Grid sites       106                          668     334     223    
                               3.7       1,351
a. GEKO 8kVA          106                          668     334     223    
4.2. Off grid sites     0                            0       0       0    
                                              
a. GEKO 8kVA            0                            0       0       0    
4.3. Solar sites        0                            0       0       0    
                                              
a. GEKO 8kVA            0                            0       0       0    
5. DG Yanmar           84                        1,319     704     351    
5.1. Grid sites        31                          228     130      65    
                               4.5       1,643
a. Yanmar 8kVA         31                          228     130      65    
5.2. Off grid sites                             38                                                              918                      479                   239     
                                                                      15.7                5,731
a. Yanmar 8kVA                                  38                                                              918                      479                   239     
5.3. Solar sites                                15                                                              173                       95                    47     
                                                                       7.4                2,701
a. Yanmar 8kVA                                  15                                                              173                       95                    47     
TOTAL:                                       1,564                                                           17,661                    9,467                 4,892                      0
6. Gasoline Generator                                                                                                                                                  
6.1. To rescue                                 75                      1.3                  475                236                      158                    158                 158
                                                                                                             Quantit        Quantit
                                                                                              Quantit           y           y need      Reamainin            Reamainin     Quantit
               Description                               Type of power                        y for 12       months         to buy      g Dodoma             g Branches    y need
N                                                                                             months         need to         for 14     Warehouse            Warehouse     to buy
o                                                                                                             buy           months
     Type
                                     5kV       8kV       12kV   20kV     30kV        50kV
       of              Model          A         A          A      A        A           A
     filter
A   DG Lister Petter                                                                                                                                                          
      Air                            1,24                                                              1,6          1           1,9                     1             3      1,45
1                    757-27890                 423                                     
     filter                            9                                                          72           4              51           25                   70           6
                                     4,45                                                              4,4          1           5,1                                  1,2     3,96
2                     201-55370                                                        
      Oil                              1                                                          51           4              93               1                32           0
     filter
                                              1,52                                                     1,5          1           1,7                                          1,69
3                     328-21600                                                                                                                          -
                                                5                                                 25           4              80                                81           9
     Fuel                            2,49                                                              3,3          1           3,9                     6             2      2,97
4                     751-18100                847                                     
     filter                            7                                                          44           4              02           30                   94           8
                                     5kV       8kV       12kV   20kV     30kV        50kV
B   DG KIBI                           A         A          A      A        A           A
                                                                                                                                                                               
                                                                                                       1,3          1           1,5                     5
              M008G0A001006FAA0254            1306                                                                                                                                840
      Air                                                                                         06           4              24           92                   92
1
     filter   M008G0A001006FAA025                                                                                   1              1
                                                          76     15                                                                                      -                        107
                       S                                                                          91           4              07                                 -
                                                                                                       4,8          1           5,7                    2,1            2      3,36
              M008G0A001006FLC0532            4899                                     
      Oil                                                                                         99           4              16           14                   42           0
2
     filter   M008G0A001006FLCO91                                                                       3           1              3
                                                         283     55                                                                                      -                        349
                       1                                                                          38           4              95                                46
                                                                                         2,6       1     3,0          9          2    1,87
              M008G0A001006FDC1004               2615                          
                                                                                    15         4       51       76         01         4
     Fuel
3
     filter                                                                               1        1        2
              M008G0A001006FLFC110                      154     29                                                                        113
                                                                                    83         4       14       75         26
                                           5kV   8kV    12kV   20kV   30kV   50kV
C   DG Cummins                              A     A       A      A      A      A
                                                                                                                                       
                                                                                         1,0       1     1,2                     5
                      AF25904                           856    236                                                                        666
                                                                                    92         4       74       17         91
      Air                                                                                 1        1        1
1                     AF26044                                         153                                              -          -       179
     filter                                                                         53         4       79
                                                                                                   1
                      AF26094                                                 4                                        -          -        5
                                                                                    4          4       5
                                                                                         4,4       1     5,1                    1,7   3,48
                      LF16087                           3061   859    528                                              -
      Oil                                                                           48         4       90                  02         8
2
     filter                                                                                        1        1        1,5
                      LF16061                                                 13                                                  -        -
                                                                                    13         4       6        39
                                                                                         2,2       1     2,6                    1,6   1,03
                       FS1275                           1566   444    271                                              -
                                                                                    81         4       62                  23         9
     Fuel
3
     filter                                                                                        1
                      FS19652                                                 6                                        -          -        7
                                                                                    6          4       7
                                           5kV   8kV    12kV   20kV   30kV   50kV
D   DG GEKO                                 A     A       A      A      A      A
                                                                                                                                       
      Air     can be used for Mitsubishi                                                  2        1        2                    1
1                                                223                                                                                      88
     filter       diesel L3E engine                                                 23         4       61       2          71
              can be used for Mitsubishi
      Oil                                                                                 6        1        7                    2
2                 diesel L3E engine              668                                                                                      555
     filter                                                                         68         4       80       1          24
                   (26300-02501)
     Fuel
     filter   can be used for Mitsubishi
                                                                                          3        1        3
3     (has        diesel L3E engine              334                                                                   -                  311
                                                                                    34         4       90                  79
     water         (31945-44000)
    sensor)
     Fuel
     filter   can be used for Mitsubishi                                                  3        1        3
4                                                334                                                                   -          -       390
    (Inline       diesel L3E engine                                                 34         4       90
        )
                                           5kV   8kV    12kV   20kV   30kV   50kV
E   DG Yanmar                               A     A       A      A      A      A                                                                                                                                       
      Air          119802-12500                                                        3        1        4        1        1
1                                             351                                                                                  102
     filter    P55821575 (Donaildson)                                            51         4       10       80       28
      Oil          129150-35152               1,31                                    1,3       1     1,5         7        2
2                                                                                                                                  477
     filter     P550162 (Donaldson)             9                                19         4       39       76       86
     Fuel          119000-55600                                                        7        1        8                 1
3                                             704                                                                 -                650
     filter     P550048 (Donaldson)                                              04         4       22                72
                                        5kV   8kV    12kV   20kV   30kV   50kV
F   Gasoline Generator KIBI              A     A       A      A      A      A
                                                                                                                                
      Air                                                                              1        1        1
1             M008G0A001006FAA7037            158                                                                 -        -       185
     filter                                                                      58         4       85
      Oil     M008G0A001006FLCO41                                                      2        1        2
2                                             236                                                                 -        -       276
     filter            9                                                         36         4       76
     Fuel     M008G0A001006FDHN02                                                      1        1        1
3                                             158                                                                 -        -       185
     filter            7                                                         58         4       85
                                                                                       1        1        1
4    Bugi          98079-5587G                158                                                                 -        -       185
                                                                                 58         4       85