Management Information System (MaJIs) Eng. Mutaekulwa T.K Mutegeki - - PowerPoint PPT Presentation

▶
management information system maji s
SMART_READER_LITE
LIVE PREVIEW

Management Information System (MaJIs) Eng. Mutaekulwa T.K Mutegeki - - PowerPoint PPT Presentation

Mar 28, 2024 37 likes •239 views

Management Information System (MaJIs) Eng. Mutaekulwa T.K Mutegeki EWURA Tanzania Maseru, 30 th October, 2013 19.02.2014 19.02.201410/14/13 19.02.201410/14/13 Page 1 Page 1 Seite 1 Seite 1 Contents Background Background

slide-1
SLIDE 1

19.02.201410/14/13 Seite 1 Page 1 19.02.201410/14/13 Seite 1 Page 1 19.02.2014

Management Information System (MaJI’s)

  • Eng. Mutaekulwa T.K Mutegeki

EWURA Tanzania

Maseru, 30th October, 2013

slide-2
SLIDE 2

19.02.201410/14/13 Seite 2 Page 2 19.02.201410/14/13 Seite 2 Page 2 19.02.2014

Background

  • Background
  • Users of MaJI’s
  • Data Collection, Verification and Use
  • Key Components of MaJI’s
  • Benefits
  • Challenges
  • Planned Improvements

Contents

slide-3
SLIDE 3

19.02.201410/14/13 Seite 3 Page 3 19.02.201410/14/13 Seite 3 Page 3 19.02.2014

Backgrou….nd

  • Compilation of data for performance

monitoring was introduced by the Ministry of Water in 1994 after the establishment of three semi-autonomous water utilities (Tanga, Moshi and Arusha)

  • Performance monitoring was pegged on

tracking improvement on revenue collection and expenditure. Background..

slide-4
SLIDE 4

19.02.201410/14/13 Seite 4 Page 4 19.02.201410/14/13 Seite 4 Page 4 19.02.2014

Backgrou..nd

  • In 1997
  • 19 fully autonomous water utilities were

established

  • Intensification of performance monitoring by

the Ministry of Water - 50 performance indicators

  • Data and indicators were reported in paper

form Background…

slide-5
SLIDE 5

19.02.201410/14/13 Seite 5 Page 5 19.02.201410/14/13 Seite 5 Page 5 19.02.2014

  • Management Information system (MajI’s)

was launched in 2006;

  • Software based
  • Tailor made database developed locally on

the basis of data and indicators which were reported in paper form.

  • For 19 regional water utilities, DAWASA

and DAWASCO.. Background..

slide-6
SLIDE 6

19.02.201410/14/13 Seite 6 Page 6 19.02.201410/14/13 Seite 6 Page 6 19.02.2014

  • In June, 2013, web-based MaJI’s was launched

by EWURA

  • Includes all water supply and sewerage

authorities (130 utilities).

  • Revised indicators.

Background.

slide-7
SLIDE 7

19.02.201410/14/13 Seite 7 Page 7 19.02.201410/14/13 Seite 7 Page 7 19.02.2014

User GrouUps

Users of MaJI’s..

  • EWURA
  • Ministry of Water
  • Regional Water Utilities
  • DAWASA/DAWASCO
  • Small,District Towns and National Projects

Water Utilities

  • MaJI’s is managed by EWURA

Benchmarking facilitates comparative competition.

slide-8
SLIDE 8

19.02.201410/14/13 Seite 8 Page 8 19.02.201410/14/13 Seite 8 Page 8 19.02.2014

Service Provider/util ity Data input MajIs Database

Analysis and compilation

  • f data

Service provider Ministry resp. for Water Regulator Self assessment + Reporting Monitor Policy implementation+ Investments +MDG’s Performance Monitoring +Bench- marking

Reports Customers, Government, Global Monitoring(MDG)’s, stakeholders

Users of MaJI’s

slide-9
SLIDE 9

19.02.201410/14/13 Seite 9 Page 9 19.02.201410/14/13 Seite 9 Page 9

  • Type presentation title here

2/19/2014

Data has to be entered into MajIs for each month latest by the 15th of the following month

Data Collection,Verification and Use

slide-10
SLIDE 10

19.02.201410/14/13 Seite 10 Page 10 19.02.201410/14/13 Seite 10 Page 10 19.02.2014

Key Components of MaJI’s..ey

Aspects of MAJI’s

  • Data Comparison: Data entry forms includes a comparison column showing

the values of the previous record

slide-11
SLIDE 11

19.02.201410/14/13 Seite 11 Page 11 19.02.201410/14/13 Seite 11 Page 11

Data Validation

19.02.2014

§Any figure entered in entry sheets that contain a comparison column will be compared with the previously reported figure §Deviations of more than +100% or -50% will require the user to confirm the correctness of the entered information.

Key Components of MaJI’s…

slide-12
SLIDE 12

19.02.201410/14/13 Seite 12 Page 12 19.02.201410/14/13 Seite 12 Page 12

Comment Function

19.02.2014

  • .
  • The comment allows users to view and comment
  • n the monthly record.

Key Components of MaJI’s..

slide-13
SLIDE 13

19.02.201410/14/13 Seite 13 Page 13 19.02.201410/14/13 Seite 13 Page 13

Mandatory data field

19.02.2014

  • .
  • Some of the data entry fields have been defined as mandatory data
  • fields. A record can only be locked and sent to EWURA, if

least all mandatory fields have been filled in.

Key Components of MaJI’s..

slide-14
SLIDE 14

19.02.201410/14/13 Seite 14 Page 14 19.02.201410/14/13 Seite 14 Page 14 19.02.2014

  • Identification of data inaccuracies by analyzing trends and

provide early feedback

Key Components of MaJI’s…

slide-15
SLIDE 15

19.02.201410/14/13 Seite 15 Page 15 19.02.201410/14/13 Seite 15 Page 15 19.02.2014

  • Easy to make comparative analysis and benchmarking of different

Utilities

Key Components of MaJI’s…

slide-16
SLIDE 16

19.02.201410/14/13 Seite 16 Page 16 19.02.201410/14/13 Seite 16 Page 16 19.02.2014

Key Components of MaJI’s.

slide-17
SLIDE 17

19.02.201410/14/13 Seite 17 Page 17 19.02.201410/14/13 Seite 17 Page 17 19.02.2014

  • The proper use of MAJIS allows utilities to

get away with persisting problems in:

  • Delays in submission of reports
  • Minimize calculation errors for

indicators

  • Data inconsistence
  • Main input for the preparation of Water

Utilities Performance benchmarking reports which are available at www.ewura.go.tz Benefits of MaJI’s..

slide-18
SLIDE 18

19.02.201410/14/13 Seite 18 Page 18 19.02.201410/14/13 Seite 18 Page 18 19.02.2014

  • Facilitates the utility’s internal monitoring

and planning processes.

  • Computation and analysis of requested tariff

increases.

  • To track the attainment of performance targets
  • To make realistic projections e.g. for project

proposal and loan applications Benefits of MaJI’s

slide-19
SLIDE 19

19.02.201410/14/13 Seite 19 Page 19 19.02.201410/14/13 Seite 19 Page 19 19.02.2014

Delays have been encountered in the submission of reports mainly due to:

  • Lack of dedication by CEO’s
  • Frequent change of staff knowledgeable

with MajIs.

  • In some utilities, IT staff are the ones

responsible for data entry and verification.

  • Frequent fallout of internet availability at

the Utilities. Challenges

slide-20
SLIDE 20

19.02.201410/14/13 Seite 20 Page 20 19.02.201410/14/13 Seite 20 Page 20 19.02.2014

  • To provide an additional field for all raw data

entry sheets on which service providers will be indicating their data quality in terms of accuracy and reliability. The combined effect

  • f data accuracy and reliability will give the

confidence grading of that particular data.

  • EWURA is working on a possibility for the

public to access selected data of water utilities by logging into MaJI’s website. www.majis.ewura.go.tz Planned Improvements - MaJI’s