Transcript Slide 1

NREGA MIS Workshop
Dr MCR HRD
Institute,
Hyderabad
MORD,
New Delhi
Definition of Information
System
A set of tools, procedures and
technology that generates
information and communicates it
to the user.
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.
Significance of Computerized
MIS
1.
2.
3.
4.
5.
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.
MIS Communication Process
To
Input
Processor
Output
Management
Systems
Information
Recorded
Information
To
Stored
Reports
Retrieved
Decisions
Processed
Summarized
Classified
Feedback
Planning,
Operating,
Controlling
Systems
Pillars of C-MIS
1.
2.
3.
4.
Computers
Content
Connectivity
Competencies
4-Cs
Steps in MIS Planning & Design
1.
2.
3.
4.
5.
Determination of Users’ needs
Identification of inputs and users interface
Determination of the Scope of the system
Budgets
Scheduling
Phases of MIS Design &
Development
1.
2.
3.
Study and Analysis Phase
Design Phase
Implementation Phase
Study and Analysis Phase
1.
2.
3.
4.
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
Design Phase
1.
2.
3.
4.
5.
6.
7.
8.
Determine requirements of subsystems
Evaluate and define the proposed subsystems
Determine the degree of computerization
Create database
Establish input and output forms
Feedback from all levels of users
Develop applications prototype
Document
Implementation Phase
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
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
Software Development Life
Cycle
1.
2.
3.
4.
5.
6.
7.
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)
Database Management System
(DBMS) Components
1.
2.
3.
4.
Database (Fields, records, files, relationships)
Database Administrator
Database Users
Database Programs
NREGA MIS – A Stylized View
To
Input
•
•
•
•
•
•
•
Admin Unit
Receipt of
Funds
Application for
JC/Work
Opening of
Projects
Allocation of
Employment
Social Audit
Notice
Complaint
Receipt
Processor
Application processing,
Family Registration,
Measurement, MR,
Payment, Accounting
Recorded
Stored
Retrieved
Processed
Summarized
Classified
Feedback
Output
Variance
Reports on
•Employment
provided
•Wages paid
•Expenditure
•Works
completed
•Complaints
disposed
•Social audit
completed
Management
Systems
To
Planning,
Operating,
Controlling
Systems
Information, Education and Communication (IEC), Registration and Disposal of Complaints and Grievances, Internal & External Flow of
Information (Reporting and Disclosure), Monitoring, Evaluation and Review
Formulation of Schemes by States
and of Rules by Central and State
Governments under NREG Act and
Establishment of Central and State
Employment Guarantee Funds
Flow of funds from Center and States
to DPCs, from DPCs to POs and from
POs to Gram Panchayats
Demand for
Job Cards by
Rural
Households
Issue of Job
Cards to Rural
Households by
GPs / POs
I.E.C.
Campaign
Expenditure Budget
(Capital Budget,
Revenue Budget)
and Scheduling
by Govts, DPCs, POs, GPs
NATIONAL RURAL
EMPLOYMENT
GUARANTEE ACT, 2005:
BOX DIAGRAM
Administrative & Technical Strengthening
Staffing
(Assessment of staff requirement,
Engagement, Training, Deployment,
Appraisal and Remuneration of internal or
external personnel including outsourcing
of services)
Office Development and Management
(Creation of office space, Procurement of
goods and services, ICT functionality )
Labour Budget Planning by DPCs and its submission in
District Panchayats (M onthly forecast areawise of
expected employment demand for the coming year)
Project Planning by DPCs, POs, GPs
(Seasonwise and Areawise Selection of Sites and Works,
Cost Estimation, Technical Sanction and Administrative
Approval of Projects, Approval by Gram Sabha, GPs,
Intermediate and District Panchayats, M aterials Planning,
Empanelment of M ates or Work Supervisors, etc.)
Employment
Demand by
Individuals and
Groups
Issue of Dated
Acknow ledgement
receipt by GPs /
POs to Applicants
Opening of Works, Assets-LIvelihood Creation
(Orientation of workers, model pit construction,
creche, shade, drinking water, and signboard with
NREGA Logo; performance and measurement of
work, payment to workers and suppliers,
integration with banks and post offices, entry in
measurement book, muster roll, job cards,
employment register, asset register, works register,
cash book, entry in M IS, inspections and quality
control, UCs, work closure)
Accounting; CAG Audit; Audit by Chartered
Accountants and submission of Audit Report to
Central Government by DPCs for release of funds
No Matching of
Work Demand &
Provision
Payment of
Unemployment
Allow ance to w ork
applicants w ho are
not provided w ork
w ithin 15 days as
per the Act
Matching of Work Demand & Provision
Procurement of
materials at approved
rates from approved
suppliers
Reporting to
w orksite by
Applicants
Issue of Work
Allocation Letters
to individual
applicants for
w ork
Organization of
Vigilance and
Monitoring Committees
Social Audit by Gram Sabha : Production of
records and registers by GP in Gram Sabha on
completion of work, objections & their settlement
NREGS Critical Activities
COMPLAINTS
DATE
PLANNING
LABOUR
BUDGET
EXPENDITURE
BUDGET
LABOUR
COMPLAINANT
FINANCIAL
MANAGEMENT
ACTION TAKEN
MANAGEMENT
REGISTRATION
PROJECT
DEMAND FOR
WORK
APPS
FUNDS
MANAGEMENT
ALLOCATION OF
FUNDS
EXPENDITURE
TRACKING
WORK ACKN
WORK
ALLOCATION
ACCOUNTING
WORK
PERFORMANCE
AUDIT
WAGES PAYMENT
SOCIAL AUDIT
NOTICE
PARTICIPATION
DOCUMENTS
SHELF OF
PROJECTS
SCRUTINY
ESTIMATION, TS,
AA
SETTLEMENT
PROCUREMENT
EXECUTION
CLOSURE
MAINTENANCE
OBJECTIONS
REPORT
Planning
•Labour Budget
•Expenditure Budget
•Areawise
•Wages
•Monthwise
•Materials
•Forecast of labour
demand
•Salary
•Forecast of wages
payable
•Forecast of mandays
to be provided
•Travel
•Stationary
•Training
•IEC
•Other office expenses
Financial Management
1.
Demand for funds
1.
Accounting
2.
Allocation of funds
2.
Audit
3.
Expenditure tracking
3.
Compliance to Audit
4.
Collection of UCs
4.
Proposal for release
of funds
Accounting

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)
Labour Management
1. Application for Registration
2. Issue of Job Cards
3. Application for works
4. Issue of Dated Acknowledgment Receipt
5. Issue of work allocation letter
6. Joining of workers on project site and their orientation,
group formation, etc.
7. Selection of Mates and Supervisors
8. Entry of work done in Muster rolls
9. Payment of wages
Project Management
1.
Shelf of projects – Estimation, TS and AA
2.
Selection of Mates and Supervisors
3.
Materials Procurement and Payment
4.
Preparation of work calendar for projects
5.
Workers motivation
6.
Work performance and measurement
7.
Billing and Muster Roll preparation
8.
Payment of wages
9.
Inspection of projects
10. Maintenance of project and asset register
11. Submission of UC and work closure
12. Maintenance of Project
Receipt of Funds and Payment
of Wages, Cost of Materials,
Administrative Overheads
(Cash Book)
Job Card
Holder - Job
Applicant
Processes for
Project
Management
Project
Attendance
on MR
Measurement in
M.B.
Muster Roll (Bill)
Preparation
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)

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.

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
Asset Register
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Asset Code
Name
Description
Type
Location
Date of creation
Historical Cost (Rs lakhs)
Project Code
Useful Life (End Date)
Benefits
Measurement Book




M.B. No.
Project Code
Muster Roll Code
Dates



Quantity of work



Measurement
Check Measurement
Measurement
Check Measurement
Name of engineers


Measured by
Check measured by
Muster Roll
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
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
Complaints and Grievances
1.
Details of Complainant
Name, address, whether worker, IA, citizen, VIP
2.
3.
4.
Date of complaint
Brief Particulars
Action Taken
Details, Date
5.
6.
Status – Pending, Disposed
Remarks
Social Audit
1.
2.
3.
4.
5.
6.
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
FINISH