Performa SoP 014: Statement Showing the ATC losses, collection 
Efficiency and Billing Efficiency YEAR 2017-18
Name of Circle Quarter Months Units input
(Mus)
Units Billed (Mus) Billing Efficiency Revenue Billed (Rs. Lacs) Revenue Collected (Rs. Lacs)  Collection Efficiency % Business Efficiency ATC Loss% Revenue Billed (Rs.CORES) Revenue Collected (Rs. CORES)
A B C = (B/A)*100 D E  F = (E/D)*100 G = (C*F)/100 H = 100 - G D E 
PGVCL I APR 2775.12 2176.60 78.43 118238.89 110851.11 93.75 73.53 26.47 598.53 21.57 1182.39 1108.51
MAY 2776.57 2259.93 81.39 128470.89 123317.46 95.99 78.13 21.87 516.65 18.61 1284.71 1233.17
JUN 2676.99 2242.30 83.76 137853.29 130411.02 94.60 79.24 20.76 434.70 16.24 1378.53 1304.11
  8228.69 6678.82 81.16 384563.08 364579.60 94.80 76.95 23.05 1549.87 18.84 3845.63 3645.80
II JUL 2018.77 2043.83 101.24 136216.95 130446.01 95.76 96.95 3.05 -25.06 -1.24 1362.17 1304.46
AUG 2335.67 1977.44 84.66 128186.23 116772.76 91.10 77.12 22.88 358.23 15.34 1281.86 1167.73
SEP 2741.88 2177.80 79.43 118144.51 123691.97 104.70 83.16 16.84 564.07 20.57 1181.45 1236.92
  7096.32 6199.07 87.36 382547.69 370910.74 96.96 84.70 15.30 897.25 12.64 3825.48 3709.11
III OCT     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
NOV     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
DEC     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
  0.00 0.00 #DIV/0! 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
IV JAN     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
FEB     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
MAR     #DIV/0!     #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
  0.00 0.00 #DIV/0! 0.00 0.00 #DIV/0! #DIV/0! #DIV/0! 0.00 #DIV/0! 0.00 0.00
TOTAL UPTO THE QUARTER 15325.01 12877.89 84.03 767110.77 735490.34 95.88 80.57 19.43 2447.13 15.97 7671.11 7354.90