Transcript CEO meeting - NREGS-MP

MGNREGS MIS Operationalisation
&
Business process re-engineering
MIS operationalisation.
• Basic requirements :
– Sufficient operators as per data entry volume
– Per day entry capacity of a operator (Avg. 3000
mandays or 50 bill vouchers)
– Timely data availability.
– Offline software version 06 for GP
– Power supply – Gen-Set.
– Broadband connectivity
– SWAN connectivity at Janpad Panchayat.
MIS operationalisation.
• Updation Master database
– Villages/GP/agencies/bank branch.
– NPD code mapping with nrega-soft.
• Offline & online data difference.
• Worker Management
– Updation of Job-cards & jobcards holders profile.
– Updation & frozen of beneficiary bank /PO accounts
– Updation of national panchayat directory code.
• Works Management
–
–
–
–
–
–
Updation of work registration including structure ,TS/AS
Works agency mapping.
Updation of work convergence –Panch Parmeshwar ,Maryada
Works expenditure – muster rolls , material vouchers.
Muster roll issue and muster roll used system.
Work completion – Partial closure & completion current year works.
MIS operationalisation.
• Fund Management - ZP/JP/Agencies
–
–
–
–
–
–
Updation of OB – Cash-book /CA audit ,MIS based (CB as OB)
Releases, revert , borrow , refund, other receipt, available fund.
Expenditure in Wages,semi skilled,skilled,material
Administrative Expenditure
Payment dues .
e-payment using e-FMS
Process re-engineering for MIS
Problems
• Reverse engineering process of employment.
• MIS : After payment
– Parking of fund
– Crisis for fund.
– Poor Programme management
– Poor performance of a programme.
Process Re-Engineering
• Printed Muster roll / e-Muster roll by System
–
–
–
–
–
–
Advanced Demand & work allocation Pre-Populated Musterroll print by system
Muster roll tracking - Valuation & payment
Advanced Planning for Funds & valuation
Elimination of Fast track in near future
Real-time attendance & measurement at worksite
using GPS based Mobile devices.
– Payment/wage list Generation.
• Worker account frozen
• Reducing burden
– Data validation
e-FMS
• Electronics Payment
– Dedicated district level e-FMS account
– All account would be closed
– No Fund crisis.
– fund transfer by Bank/PO
– DDO of line Department & Janapad CEO and AAO
JP would be forward the FTO to e-FMS account.
Programme performance review
• Reports –
– Employment pattern
– Employment performance.
– Financial performance
– worker Payment details
– works Expenditure details
– Administrative expenditure.
– works status report
• Alerts
– delayed payment /un-employment payment
– Absence of basic process .
MIS for planning
Labour Budget Vs Achievement
Performance against Labour Budget
Household Provided Employment
Till Sep - 2012
FY 2012-13 : Labour Budget Vs Achievement
Households Provided Employment-I
120000
103,280
104,398
102,916
103,090
98,988
100000
94,593
93,564
92,683
84,450
81,757
80000
78,384
82,364
78,409
73,414
81,435
75,853
63,730
63,322
60000
58,980
57,128
58,624
58,139
54,815
53,005
49,521
44,880 45,454
40000
47,342
35,061 31,876
30,86032,013
19,170
20000
0
Projection
Achievement
33,271
FY 2012-13 : Labour Budget Vs Achievement
Households Provided Employment -II
160000
145,748
140000
120000
100000
79,249
80000
71,340
70,021
53,001
60000
57,864
53,267
50,803
47,096
41,908
42,667
40000
20000
51,719
43,799
35,529
32,401
29,697
19,939
13,386 12,627
59,229
58,047
54,679
54,538
45,619
37,243
34,186
19,520
8,226 7,672
11,657
7,757
0
Projection
Achievement
11,153
14,173
8,338
FY 2012-13 : Labour Budget Vs Achievement
Households Provided Employment - III
70000
61,363
60,408
58,554
60000
54,805
49,610
50000
44,278
39,180
40000
38,674
35,104
34,157
32,903
28,626
30000
22,761
17,570
20000
18,226
30,551
28,716
26,692
26,328
23,352
25,216
22,405
26,618
23,504
19,120
18,185 18,466
14,698
14,423
10,877
9,728 9,454
10000
0
Projection
Achievement
Persondays Generated
Till Sep - 2012
FY 2012-13 : Labour Budget Vs Achievement
Personday Generation in lakh - I
70
61
60
50
47
45
42
42
40
37
37
34
30
29
28
30
28
27
26
24
23
20
22
21
20
19
17
16
22
19
19
20
16
14
10
10
11
11
6
0
Projection
Achievement
12
10
FY 2012-13 : Labour Budget Vs Achievement
Personday Generation in lakh - II
60
51
50
38
40
31
30
27
26
24
24
23
23
19
20
20
17
17
16
16
13
12
13
11
10 10
10
8
10
10
8
5
5
3
2
3
2
0
Projection
Achievement
3 3
5
FY 2012-13 : Labour Budget Vs Achievement
Personday Generation in lakh - III
30
26
25
21
21
21
19
20
18
17
15
15
15
15
13
13
12
11
10
10
9
10
9
8
8
8
7
6
5
9
6
4 4
4
3
0
Projection
Achievement
9
9
9
Expenditure
Till Sep - 2012
FY 2012-13 : Labour Budget Vs Achievement
Expenditure in lakh - I
16000
14,250
14000
12000
10,920
10,447
10000
9,813
9,712
8,667
8,577
7,843
8000
7,027
6,282 6,466
5,984
6,528
6,441
6000
6,033
5,833
5,157
5,057
4,914
4,296
4,416 4,260
4,484
3,892
4000
4,377
4,131
4,583
3,794
3,401
2,730
2,479
1,562
2000
0
Projection
Achievement
2,564
2,972
FY 2012-13 : Labour Budget Vs Achievement
Expenditure in lakh - II
14000
12,004
12000
10000
8,893
8000
7,339
6,295
6,150
5,619
6000
5,342
5,572
4,656
5,284
4,487
4,632
4,191
3,741
4000
3,575
3,573
3,128
2,788 2,701
2000
1,857
1,353
2,924
3,304
2,718
2,226
2,068
1,2711,303
636
499
675
551
0
Projection
Achievement
767
625
FY 2012-13 : Labour Budget Vs Achievement
Expenditure in lakh - III
7000
6,030
6000
5,067
4,862
5000
4,811
4,419
4,094
4000
3,586
3000
2,637
2000
1,720
3,403
3,130
2,880
2,716
2,224
2,164
2,173
1,891
1,638
992
879
2,039
1,792
1,708
990
764
0
Projection
2,628
2,437
2,349
1,295
1000
4,027
Achievement
2,130
2,115
FY 2012-13 : Labour Budget Vs Achievement
Households Completed 100 days - III
1200
1,039
1000
765
800
571
600
513
525
492
477
521
409
400
343
251
244
174
200
71
342
311
44
263
256
38
71
256
210
189
115
99
309
278
79
68
37
66
0
Projection
Achievement
147
105
Important Indicators
Material expenditure exceeded 60%
S.No
District
Material
Expenditur
e (41%60%)
Material
Expenditur
e (61%80%)
Panchayat
Panchayat
1
REWA
217
2
CHHATARPUR
255
3
4
5
6
7
8
9
10
11
12
CHHINDWARA
JHABUA
DHAR
KHARGONE
PANNA
SATNA
UJJAIN
SAGAR
RAJGARH
BETUL
13
14
15
16
17
TIKAMGARH
DEWAS
VIDISHA
SIDHI
BALAGHAT
83
Material
Expenditu
re (81%100%)
Total
Panchayat panchayat
29
329
53
3
311
179
237
212
235
181
217
164
204
143
199
94
45
56
40
82
49
60
46
63
31
30
16
24
10
17
9
44
11
33
3
303
298
292
285
280
275
268
261
239
233
167
145
161
139
119
45
55
42
53
62
14
17
13
23
23
226
217
216
215
•
204
•
Work-wise
Location wise
Poor performance – higher rate of spill-over works since inception
Progress of Work Execution in Financial year 2012-2013
Spill Over Works
S.N
o
1
District
2
1
2
3
4
5
6
7
8
9
10
11
12
13
from Fin.
Year 20092010 and
earlier
from Fin.
from Fin.
Year 2010- Year 20112011
2012
5
Total
6
Work Completed In Current
Year
Spill Over
Work
Work
Take Up Complete
d in
current
In
Current
year
Current
Year
works
Total
Year
7
8
9
10
3
4
MANDLA
DINDORI
DHAR
EAST NIMAR
BALAGHAT
BETUL
CHHINDWARA
JHABUA
SEONI
41476
31262
20621
15543
14767
13668
12607
12494
11415
14082
3387
6190
4862
7695
1253
4484
3342
2651
14793
7969
9030
4879
8113
8260
10025
3767
5247
70351
42618
35841
25284
30575
23181
27116
19603
19313
2234
2013
1407
3865
2751
2102
1597
1136
1523
391
4365
22011
8790
12790
7270
4169
7042
2113
525
559
153
1905
902
151
260
5
299
916
4924
22164
10695
13692
7421
4429
7047
2412
CHHATARPUR
SHAHDOL
SIDHI
SATNA
11273
10143
9576
8888
3759
3149
1916
4514
4367
3626
3229
1902
19399
16918
14721
15304
373
432
569
1012
1872
2731
2421
6146
78
92
113
224
1950
2823
2534
6370
Poor work completion in current year
Work completion in Financial year 2012- 2013
S.No
District
1
2
MANDSAUR
MANDLA
PANNA
DATI A
BARWANI
NEEMUCH
SAGAR
SHI VPURI
I NDORE
HARDA
HOSHANGAB
BHI ND
UJJAI N
BHOPAL
SHAJAPUR
SHEOPUR
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
RATLAM
St at e Tot al
Work C ompleted In C urrent Year
Spill Over
Work
C omplete
d in
current
C urrent
year
Year
works
Total
8
966
391
914
765
716
704
660
634
547
605
470
540
422
417
298
309
259
142344
9
1
525
0
34
21
16
58
17
102
5
115
42
66
12
119
8
10
967
916
914
799
737
720
718
651
649
610
585
582
488
429
417
317
0
10685
259
153029
Weekly Mustroll Valuation by JE
(Sub Eng.)
State Avg : 13
District
Umaria
Seoni
Sehore
Mandla
Betul
AlirajPur
Neemuch
Dindori
Bhopal
Jhabua
Ratlam
Burhanpur
Ujjain
Anuppur
Chhindwara
No. of Mustroll Fed (FY Avg Mustroll Per JE (FY 12-13
No of JE Posted
12-13 Till Sep)
Till Sep)
Avg weekly Mustroll
measurement by a JE
State Avg :13
20
25448
1272.40
53
16
17203
1075.19
45
18
14317
795.39
33
47
33028
702.72
29
59
33174
562.27
23
18
9910
550.56
23
8
4399
549.88
23
35
18713
534.66
22
8
3753
469.13
20
31
14334
462.39
19
30
13435
447.83
19
20
7529
376.45
16
17
6254
367.88
15
25
8359
334.36
14
91
31612
347.38
14
District
Shivpuri
Harda
Bhind
Datia
Morena
Narsinghpur
Singrauli
Satna
Sidhi
Rewa
Ashok Nagar
Guna
Rajgarh
Gwalior
Hoshangabad
No. of Mustroll Fed (FY Avg Mustroll Per JE (FY 12-13
No of JE Posted
12-13 Till Sep)
Till Sep)
Avg weekly Mustroll
measurement by a JE
State Avg :13
58
5539
95.50
4
15
1455
97.00
4
19
1704
89.68
4
19
2224
117.05
5
38
5180
136.32
6
37
5240
141.62
6
29
4343
149.76
6
81
13146
162.30
7
30
5226
174.20
7
48
8048
167.67
7
16
3078
192.38
8
37
7232
195.46
8
50
9039
180.78
8
19
3814
200.74
8
23
4153
180.57
8
Payment Delayed (Period wise)
State Avg : 37% Delay
Delayed in Days (State Avg 37% Delay)
60 - 90 Days
S.No
District
Greater 90 Days
Total
Total Wage % amount
Expenditure
Paid
No. Of Muster
Delayed
Amount
Amount (In Lakhs)
Rolls
No. Of
Muster
Rolls
Amount
No. Of
Muster
Rolls
1 INDORE
2
0.20
0
0.00
36
7.66
1022.48
0.75
2 GWALIOR
19
3.26
17
2.61
126
24.59
802.35
3.07
3 RATLAM
115
24.96
20
3.20
409
72.28
1660.81
4.35
2
0.71
7
2.48
201
26.77
503.41
5.32
5 JABALPUR
141
27.85
60
10.42
602
107.41
1768.12
6.08
6 VIDISHA
91
5.09
42
0.93
526
85.72
1197.46
7.16
7 DEWAS
142
20.34
47
21.62
1183
179.00
2009.23
8.91
8 GUNA
43
24.49
31
22.65
423
240.37
2206.02
10.90
9 SEHORE
290
48.46
53
9.08
1536
224.30
1925.13
11.65
10 DHAR
301
67.12
239
48.80
2428
637.98
3982.64
16.02
11 EAST NIMAR
643
81.05
300
40.65
3517
486.37
2849.91
17.07
12 DATIA
9
3.60
0
0.00
128
48.66
277.66
17.52
13 REWA
320
81.23
160
41.57
1668
398.46
2022.16
19.71
14 HARDA
16
1.43
11
1.00
356
67.22
337.93
19.89
15 RAJGARH
679
146.98
447
99.14
2505
712.99
2835.36
25.15
4 HOSHANGABAD
Delayed in Days(State Avg 37% Delay)
60 - 90 Days
S.No
District
No. Of
Muster
Rolls
Amount
Greater 90 Days
No. Of
Amount
Muster Rolls
Total
No. Of
Muster
Rolls
Amount
Total Wage % amount
Expenditure (In
Paid
Lakhs)
Delayed
1
SAGAR
3467
571.88
2488
390.26
12637
2085.79
3120.70
66.84
2
UMARIA
3525
200.08
1406
74.61
20128
1135.71
1760.42
64.51
3
ALIRAJPUR
1235
167.79
635
95.21
7592
959.18
1515.26
63.30
4
MANDSAUR
1521
209.97
1031
139.34
5673
750.73
1290.06
58.19
5
JHABUA
2335
401.54
1006
190.57
10998
2149.25
3795.39
56.63
6
SATNA
1021
164.32
488
79.51
8592
1155.15
2049.29
56.37
7
NEEMUCH
764
50.00
208
22.47
3814
276.77
492.52
56.20
8
BALAGHAT
2180
399.39
1759
279.71
10763
2144.42
3849.20
55.71
9
TIKAMGARH
1260
172.74
763
147.93
7468
1073.02
1927.02
55.68
10 SINGRAULI
564
167.16
577
172.45
2876
792.17
1532.85
51.68
11 SHAHDOL
1555
196.74
792
94.38
7493
894.56
1778.63
50.30
12 RAISEN
604
112.21
278
46.33
2702
497.75
1015.76
49.00
13 KATNI
991
133.41
368
32.06
6217
880.33
1817.26
48.44
14 SHEOPUR
236
54.05
85
20.89
2609
442.55
917.29
48.25
15 CHHATARPUR
1002
166.57
337
50.75
6836
1079.02
2274.07
47.45
No employment demands
• No demand in last six month
Convergence work updation status
S.N
o.
Districts
1
JABALPUR
2
RAJGARH
3
BHOPAL
4
SATNA
5
VIDISHA
6
NARSINGHPUR
7
BALAGHAT
8
ALIRAJPUR
9
BARWANI
10
BHIND
11
DATIA
12
INDORE
13
RAISEN
14
SHEOPUR
15
SIDHI
16
ANUPPUR
17
ASHOK NAGAR
18
GWALIOR
19
KATNI
20
KHARGONE
21
MANDSAUR
22
RATLAM
23
REWA
24
SAGAR
25
26
SHAJAPUR
SINGRAULI
State Total
No of works under
convergence
ongoing complete
works
d works
193
0
109
0
91
1
82
0
82
0
80
0
48
6
1
0
1
0
1
0
1
0
1
0
1
0
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1171
0
11
Total works
(ongoing+
completed)
193
109
92
82
82
80
54
1
1
1
1
1
1
1
1
0
0
0
0
0
0
0
0
0
0
0
1182
lekIr