Performa SoP 014: Statement Showing the ATC losses, collection 
Efficiency and Billing Efficiency YEAR 2021-22
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 3537.61 2822.11 79.77 161727.29 144940.40 89.62 71.49 28.51
MAY 2937.65 2492.67 84.85 172410.07 147770.18 85.71 72.73 27.27
JUN 3055.76 2465.15 80.67 156021.32 150167.44 96.25 77.65 22.35
  9531.01 7779.92 81.63 490158.68 442878.02 90.35 73.75 26.25
II JUL 3079.61 2623.52 85.19 150464.33 166300.08 110.52 94.16 5.84
AUG 3839.40 2753.49 71.72 164766.06 158723.98 96.33 69.09 30.91
SEP 2479.97 2555.22 103.03 172510.75 184183.52 106.77 110.01 -10.01
  9398.98 7932.23 84.39 487741.14 509207.57 104.40 88.11 11.89
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 18929.99 15712.15 83.00 977899.82 952085.59 97.36 80.81 19.19