DG Calculation Sheet
Month    AMC cost 3 DG   Diesel Cost   R & M Cost    Misc. Exps.        Net Cost
Apr-23      9180             65,656      32,335.00     6000                   113,171.20
May-23      9180            228,447      32,335.00     6000                   275,962.00
Jun-23      9180            411,476      32,335.00     6000                   458,990.50
Jul-23      9180            337,725      32,335.00     6000                   385,239.70
Aug-23      9180            326,033      32,335.00     6000                   373,548.00
Sep-23      9180            112,925      32,335.00     6000                   160,440.00
Oct-23      9180            133,561      32,335.00     6000                   181,076.00
Nov-23      9180             30,580      32,335.00     6000                    78,095.00
Dec-23      9180            148,851      32,335.00     6000                   196,366.00
Jan-24      9180            144,354      32,335.00     6000                   191,869.00
                                                      AMC
        Service                          AMC
    180 38180*2=76360     180 KVA       30279
    365 75829*2=151658    365 KVA       35038
    500 80000*2=160000    500 KVA       44840
                           Total        110157
                         Per month         9179.75
n Sheet
          Unit Collection   Load Fix Charge   Total Collection      Deficit
                 0             104550                   104,550         (8,621)
              14357            104550                   118,907      (157,055)
            62656.7            104850                   167,507      (291,484)
            99160.5            104850                   204,011      (181,229)
              42150            104850                   147,000      (226,548)
                213            104850                   105,063       (55,377)
                850            104850                   105,700       (75,376)
                 0             104850                   104,850        26,755
               1251            104850                   106,101       (90,265)
               1017            104850                   105,867       (86,002)
                                                          Service
                                               haly yearly         yearly cost
                               180 KVA           38180               76360
                               365 KVA           75829               151658
                               500 KVA           80000               160000
                                               Yearly total          388018
                                               Per month         32334.83333333