NATIONAL WORKSHOP ON MIS FOR NREGA Dr MCR HRD Institute, Hyderabad MINISTRY OF RURAL DEVELOPMENT GOVERNMENT OF INDIA

1. NATIONAL WORKSHOP ON MIS FOR NREGADr MCR HRD Institute, HyderabadMINISTRY OF RURAL DEVELOPMENTGOVERNMENT OF INDIA

2. Presentation Highlights • MIS Basics • Information Flow in NREGS • MIS Subsystems in NREGS • MIS Designing Illustrated

3. Definition Of Information System A set of tools, procedures and technology that generates information and communicates it to the user.

4. Management Information System A refined orientation of available sources of information which enables managers to tie planning and control procedures to operational systems of implementation.

5. Significance of Computerized MIS Assists managerial decisional process and control Enables access to right information on time that results in right decisions Manual information systems are difficult to be maintained, result in tedious paper work, needs more clerical time, causes disjointedness in information flows. Enables decision-making based on facts not on subjectivity. Obliterates the over dependency of expertise of any particular executive in an organization.

6. To Management Systems Input Processor Output Information Recorded Stored Retrieved Processed Summarized Classified To Planning, Operating, Controlling Systems Information Reports Decisions Feedback MIS Communication Process

7. Pillars of C-MIS: 4 Cs C-MIS Connectivity Computers Competencies Content

8. Steps in MIS Planning & Design Determination of Users’ needs Identification of inputs and users interface Determination of the Scope of the system Budgets Scheduling

9. Phases of MIS Design & Development Study and Analysis Phase Design Phase Implementation Phase

10. Study and Analysis Phase Study organizational goals and problems Analyze available resources and opportunities Analyze technological and human resources capabilities Evaluate the MIS design project using cost benefit analysis

11. Design Phase Determine requirements of subsystems Evaluate and define the proposed sub-systems Determine the degree of computerization Create database Establish input and output forms Feedback from all levels of users Develop applications prototype Document

12. Implementation Phase Organize computer infrastructure Train users on basic operations Develop applications Train users on application modules Feedback from all levels of users Modify modules based on user feedback Debug the test application modules Test the complete system

13. Implementation Phase…Continued Feedback on complete system Debug the complete system Evaluate the complete system Document Switch to new MIS system Evaluate periodically System maintenance Establish plans for future MIS

14. Software Development Life Cycle Feasibility Study (Preliminary investigation) Systems (Requirements) Analysis Systems Design (Inputs, Process, Output) Development (Software writing) Testing (Debugging) Implementation (Installation at user’s place) Maintenance (Adapting to changing needs)

15. DBMS Components Database (Fields, records, files, relationships) Database Administrator Database Users Database Programs

16. NREGA MIS – A Stylized View To Management Systems Input Process Output • Admin Unit • Receipt of Funds • Application for JC/Work • Opening of Projects • Allocation of Employment • Social Audit Notice • Complaint Receipt Variance Reports on • Employment provided • Wages paid • Expenditure • Works completed • Complaints disposed • Social audit completed Application processing, Family Registration, Measurement, MR, Payment, Accounting Recorded Stored Retrieved Processed Summarized Classified To Planning, Operating, Controlling Systems Feedback

18. NREGS Sub-Systems COMPLAINTS DATE COMPLAINANT ACTION TAKEN LABOUR MANAGEMENT REGISTRATION WORK APPS WORK ACKN WORK ALLOCATION WORK PERFORMANCE WAGES PAYMENT SOCIAL AUDIT NOTICE PARTICIPATION DOCUMENTS SCRUTINY OBJECTIONS SETTLEMENT REPORT PLANNING LABOUR BUDGET EXPENDITURE BUDGET FINANCIAL MANAGEMENT DEMAND FOR FUNDS ALLOCATION OF FUNDS EXPENDITURE TRACKING ACCOUNTING AUDIT PROJECT MANAGEMENT SHELF OF PROJECTS ESTIMATION, TS, AA PROCUREMENT EXECUTION CLOSURE MAINTENANCE

19. Planning • Expenditure Budget • Wages • Materials • Salary • Travel • Stationary • Training • IEC • Other office expenses • Labour Budget • Areawise • Monthwise • Forecast of labour demand • Forecast of wage rate payable • Forecast of mandays to be provided

20. Financial Management Demand for funds Allocation of funds Expenditure tracking Collection of UCs Accounting Audit Compliance to Audit Proposal for release of funds

21. Accounting Receipts Opening Balance Amount received during the year (Center and State) Miscellaneous Payments Unskilled Wages Semi-skilled and skilled wages Materials Administrative Expenses (salary, forms, stationery, travel, electricity, telephones, AMC, worksite facilities, etc)

22. Labour Management • Application for Registration • Issue of Job Cards • Application for works • Issue of Dated Acknowledgment Receipt • Issue of work allocation letter • Joining of workers on project site and their orientation, group formation, etc. • Selection of Mates and Supervisors • Entry of work done in Muster rolls • Payment of wages

23. Project Management • Shelf of projects – Estimation, TS and AA • Selection of Mates and Supervisors • Materials Procurement and Payment • Preparation of work calendar for projects • Workers motivation • Work performance and measurement • Billing and Muster Roll preparation • Payment of wages • Inspection of projects • Maintenance of project and asset register • Submission of UC and work closure • Maintenance of Project

24. Job Card Holder - Job Applicant Funds (Cash Book) Project Management Polygon Project Muster Roll (Bill) Preparation Attendance on Muster Roll Measurement in Measurement Book

25. Job Card Register Job Card code (State/District/Block/GP/Village) Caste Category – SC, ST, OBC, Others, Minority Household Members’ Details – name, age, sex, relation with the head of household. Details of Payment – Name of member, member code, days worked, dates (From and To), Amount paid, MR Code, Project Code, Mode of payment (bank, PO, cash)

26. Employment Register Date of application Applicant’s name Job Card No Work Demand Dates (From & To) Work Allocation Details – Letter No, Date. Project Code (in which work allocated) No of Days worked Amount Paid Unemployment Allowance Paid.

27. Project Ledger Project code Project name Project Type Project Description Sanction Order No. and Date Location Estimate Expenditure Material Labour Supervisory Officers Details Measurement Details Muster Roll Details Payment Details

28. Asset Register Asset Code Name Description Type Location Date of creation Historical Cost (Rs lakhs) Project Code Useful Life (End Date) Benefits

29. Measurement Book M.B. No. Project Code Muster Roll Code Dates Measurement Check Measurement Quantity of work Measurement Check Measurement Name of engineers Measured by Check measured by

30. Muster Roll Muster Roll Code Project Code Job Card Holders’ code Distance within 5 Km – (Y/N) Days worked Standard Output Actual Output Rate – amount per unit of output Amount – individual and total Acknowledgement Certification by Sarpanch, Engineers, VMC members, etc. Date of Verification by Social Audit

31. Complaints and Grievances Details of Complainant Name, address, whether worker, IA, citizen, VIP Date of complaint Brief Particulars Action Taken Details, Date Status – Pending, Disposed Remarks

32. Social Audit Issue of public notice for Gram Sabha Participation by workers, officials, members, etc. Records production by GPs Scrutiny and objections by GS Settlement of Objections Report

33. MIS Designing – An Illustration LABOUR MANAGEMENT

34. FINISH