Performa SoP 014: Statement Showing the ATC losses, collection 
Efficiency and Billing Efficiency YEAR 2018-19
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%
A B C = (B/A)*100 D E  F = (E/D)*100 G = (C*F)/100 H = 100 - G
PGVCL I APR 2903.86 2388.66 82.26 129096.25 114564.31 88.74 73.00 27.00
MAY 2895.86 2329.01 80.43 139011.50 134366.56 96.66 77.74 22.26
JUN 3054.73 2396.58 78.45 139007.23 138722.74 99.80 78.29 21.71
  8854.45 7114.25 80.35 407114.98 387653.61 95.22 76.51 23.49
II JUL 2602.33 2362.84 90.80 140463.49 138124.05 98.33 89.29 10.71
AUG 2920.83 2324.10 79.57 142360.23 136249.26 95.71 76.15 23.85
SEP     #DIV/0! 139716.41 134011.16 95.92 #DIV/0! #DIV/0!
  5523.16 4686.94 84.86 422540.14 408384.47 96.65 82.02 17.98
III OCT     #DIV/0!     #DIV/0! #DIV/0! #DIV/0!
NOV     #DIV/0!     #DIV/0! #DIV/0! #DIV/0!
DEC     #DIV/0!     #DIV/0! #DIV/0! #DIV/0!
  0.00 0.00 #DIV/0! 0.00 0.00 #DIV/0! #DIV/0! #DIV/0!
IV JAN     #DIV/0!     #DIV/0! #DIV/0! #DIV/0!
FEB     #DIV/0!     #DIV/0! #DIV/0! #DIV/0!
MAR     #DIV/0!     #DIV/0! #DIV/0! #DIV/0!
  0.00 0.00 #DIV/0! 0.00 0.00 #DIV/0! #DIV/0! #DIV/0!
TOTAL UPTO THE QUARTER 14377.61 11801.18 82.08 829655.12 796038.08 95.95 78.75 21.25