NREGA MIS Workshop

1. NREGA MIS Workshop

2. Definition of Information System A set of tools, procedures and technology that generatesinformation and communicates it to the user.

3. 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.

4. Significance of Computerized MIS • Assists managerial decisional process and control • Enables access to right information timely 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.

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

6. Pillars of C-MIS 4-Cs • Computers • Content • Connectivity • Competencies

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

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

9. 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

10. 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

11. 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 • 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

12. 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)

13. Database Management System (DBMS) Components • Database (Fields, records, files, relationships) • Database Administrator • Database Users • Database Programs

14. NREGA MIS – A Stylized View To Management Systems Input Processor 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,FamilyRegistration, Measurement, MR, Payment, Accounting Recorded Stored Retrieved Processed Summarized Classified To Planning, Operating, Controlling Systems Feedback

16. NREGS Critical Activities 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

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

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

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

20. 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

21. 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

22. Receipt of Funds and Payment of Wages, Cost of Materials, Administrative Overheads (Cash Book) Job Card Holder - Job Applicant Processes for Project Management Project Muster Roll (Bill) Preparation Measurement in M.B. Attendance on MR

23. 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)

24. 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.

25. 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

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

27. 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

28. 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

29. 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

30. 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

31. FINISH