|
|
Performa SoP 014: Statement Showing the ATC losses,
collection |
|
|
|
|
|
efficiency
and Billing Efficiency |
|
|
|
|
|
|
| Name of Circle |
Quarter |
Months |
Units input |
Units Billed (MUs) |
Billing Efficiency |
Revenue Billed (Rs.
Lacs) |
Revenue Collected
(Rs. Lacs) |
Collection Efficiency % |
Business Efficiency |
ATC Loss% |
| (MUs) |
| A |
B |
C
= (B/A)*100 |
D |
E |
F = (E/D)*100 |
G
= (C*F)/100 |
H
= 100 - G |
| |
I |
April |
2337.15 |
1669.78 |
71.45 |
83923.00 |
78961.00 |
94.09 |
67.22 |
32.78 |
| May |
2313.14 |
1752.07 |
75.74 |
91779.08 |
89997.35 |
98.06 |
74.27 |
25.73 |
| June |
2329.66 |
1785.69 |
76.65 |
92808.23 |
95588.91 |
103.00 |
78.95 |
21.05 |
| |
6979.95 |
5207.54 |
74.61 |
268510.31 |
264547.26 |
98.52 |
73.51 |
26.49 |
| II |
July |
2118.21 |
1722.27 |
81.31 |
93241.67 |
92579.44 |
99.29 |
80.73 |
19.27 |
| August |
1923.93 |
1633.35 |
84.90 |
88146.70 |
96865.80 |
109.89 |
93.29 |
6.71 |
| September |
2124.90 |
1706.69 |
80.32 |
89795.55 |
88179.75 |
98.20 |
78.87 |
21.13 |
| |
6167.04 |
5062.31 |
82.09 |
271183.92 |
277624.99 |
102.38 |
84.04 |
15.96 |
| III |
October |
|
|
#DIV/0! |
|
|
#DIV/0! |
#DIV/0! |
#DIV/0! |
| November |
|
|
#DIV/0! |
|
|
#DIV/0! |
#DIV/0! |
#DIV/0! |
| December |
|
|
#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 |
January |
|
|
#DIV/0! |
|
|
#DIV/0! |
#DIV/0! |
#DIV/0! |
| February |
|
|
#DIV/0! |
|
|
#DIV/0! |
#DIV/0! |
#DIV/0! |
| March |
|
|
|
|
|
|
|
|
| |
0.00 |
0.00 |
#DIV/0! |
0.00 |
0.00 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
| TOTAL UPTO THE QUARTER |
13146.99 |
10269.86 |
78.12 |
539694.23 |
542172.25 |
100.46 |
78.47 |
21.53 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
11022.09 |
8563.16 |
77.69 |
449898.68 |
453992.50 |
100.91 |
78.40 |
21.60 |
|
|
|
11022.09 |
8563.16 |
77.69 |
458766.23 |
559516.31 |
|
|
|
|
|
|
0.00 |
0.00 |
0.00 |
-8867.55411 |
-105523.811594900 |
100.91 |
78.40 |
21.60 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|