CDOT ITS M i t CDOT ITS Maintenance Management System Management - - PowerPoint PPT Presentation

CDOT ITS M i t CDOT ITS Maintenance Management System Management System

Presented by B C lth CDOT ITS B h Bruce Coltharp, CDOT ITS Branch Navin Nageli, Navjoy April 3 2009

1

April 3, 2009

Presentation Structure

Overview

Need for ITS Maintenance Management System Developing Requirements & System Selection

Implementation Reporting Reporting Next Steps

2

Overview

3

Overview

• Initial ITS deployments were isolated
• Deployments began to expand and grow after benefits were being

noticed and realized

• Over $200 Million in ITS investment

Over $200 Million in ITS investment

• Field Infrastructure

– Over 1500 devices (CCTV, VMS, Blank out signs, weather stations, TTI, etc) – About 10 to 20 device installations each month

• Centers and Nodes Infrastructure

– CTMC, EJMT, HLT and 15 Nodes – Over 1000 devices (JMUX, Switchers, etc) G i d idl l i t h l – Growing and rapidly evolving technology

• Fiber Infrastructure

– Over 500 miles backbone – Growing around 10% each year 4 g y

Overview…..Cont’d

• Owners and/or Maintenance Responsibility

Si CDOT R i – Six CDOT Regions – CDOT DTD – CDOT ITS Branch CDOT ITS Branch – Tunnels: EJMT and HLT

• Materials for Maintenance

– About $1.5 to $2.5 Million in materials inventory at CTMC at CTMC – Primary store room at CTMC – 7 other CDOT locations

5

Need for ITS Maintenance M t S t Management System

6

Need for Maintenance Management System Management System

• Initial deployments did not require extensive maintenance resources

since equipment was newer since equipment was newer

• Size and growing nature of inventory
• ITS Maintenance is slightly different than roadway maintenance
• Number of stakeholders involved
• Number of stakeholders involved
• Need for consistent procedures and practices
• Need for accurate and complete ITS Inventory (Devices and

Materials)

7

Need for Maintenance Management System Cont’d Management System… Cont d

• Need for work order based maintenance system
• Ability to track expenses (labor, materials, equipment) to

a device

• Need for accurate and comprehensive reporting
• Limited funding – Need to be efficient and effective with

available resources

8

Developing p g Requirements & S t S l ti System Selection

9

Developing Functional Requirements Requirements

• Assembled ITS Working Group (Maintenance

Supervisors and ITS Steering Committee (Management) in 2005

• High Level evaluation of existing maintenance

t i 14 DOT i th US systems in 14 DOT agencies across the US

• Over 6 months, Developed functional

requirements document with input from working group

10

group

ITS Maintenance Management System System

Maintenance Activities (continuous)

Work Order Management Issue and track work orders Track expenditures Labor E i Inventory and Maintenance History (continuous) Inventory ITS Devices State Equipment Parts Materials Maintenance Protocols Preventative Repair R l P l Maintenance History Maintenance ITS Device Replacement (continuous) Life-Cycle Replacement Protocols Maintenance Plan and Budget (annual) Management ITS Device Acquisition State of Devices (remaining life) (annual)

11

Level of Service & Performance Measurement

SAP System y

• CDOT selected SAP as the enterprise system

(HR, Payroll, Accounting, etc), which was

• fficially “rolled out” in November 2006
• SAP would meet the functional requirements for

ll ITS i f t t all ITS infrastructure

• Worked with Deloitte team to configure the

system per the functional requirements

12

SAP Modules

Payroll MM HR

PM

HR FI/ CO

PM

FI/ CO PS

13

Implementation

14

Inventory - Status y

• Field Infrastructure

– 100 Percent completed – Use of Datria system – More than 50 fields of information for each device I t i t i SAP d i CDOT GIS – Inventory exists in SAP and in CDOT GIS

15

ITS Equipment Structure – IE03 or IL03 IE03 or IL03

16

ITS Equipment Master Data – IE03

General Tab

• Classification

Classification

• Inventory #
• Acquisition value

Manufacturer information

• Manufacturer information

Location Tab

• Region where equipment if physically

located

17

located

• Patrol Cost Center

ITS Equipment Master Data q p

Organization Tab Organization Tab

• Plant & work center of who is

responsible for maintaining the equipment the equipment

• Cost Center of responsible

work center

• Responsibility section of

p y master data record automatically populates responsibility section in work

• rder

18

ITS Equipment Master Data q p

Structure Tab Structure Tab

• Displays the functional

location of the route segment to which the equipment is to which the equipment is attached/located

• Displays warranty information

19

ITS Equipment Master Data q p

CDOT Organization Data Tab Data Tab

• Displays the main route

and reference point to which the equipment is which the equipment is attached/located

• Displays latitude &

longitude coordinates of g equipment location

20

ITS Equipment Master Data q p

Class/Characteristics Di l th h t i ti

• Displays the characteristics

and values associated to equipment

21

Inventory - Status y

• TMC and Nodes

– 25% completed at CTMC – Remaining by May 31, 2009

22

Materials Inventory - Status y

• CTMC Store room inventory (60%

y ( completed)

• Initial materials list exists in SAP

Initial materials list exists in SAP

• Updated materials list by May 1, 2009

R d i t

• Re-order point
• Storage locations
• Reservations

23

Materials Master – MM60

24

Work Order Process - Status Status

• Process tested and verified
• Begin usage – July 1, 2009 (FY10 fiscal

year) year)

25

Routine Work Order Process

26

Creating a Time Entry for a Routine Work Order Routine Work Order

• Rec. Order =

Work Order # 27

Reporting

28

Reporting p g

• Device life cycle graphs
• Expenses by

– Device T f D i – Type of Device – Type of functionality – Region Region – State

• Bad actors by

– Repair types

29

– Damage code – Parts

Reporting…..Cont’d p g

• Materials by

– Inventory Value/quantities – Manufacturer – Part number – Storage location Storage location – Region – State State

30

Statewide CCTV Devices

44

CCTV (PTZ) Device Age: Statewide February 2009

44 35 40 45 20 25 30

• f Devices

15 13 14 8 9 6 8 10 15 20

Number o

2 6 4 5 1 2 3 4 5 6 7 Life 8 9 10 11 12 13

31

Cycle

Age of Device (Years)

Statewide VMS Devices

VMS Device Age: Statewide

Includes Skyline and Precision Solar February 2009

66 60 70

y

47 35 40 50

Devices

11 30 22 21 22 20 30

Number of

2 11 3 6 1 2 9 1 10 1 3 5 7 9 11 13 15 Life Cycle 17 19

32

Life Cycle

Age of Device (Years)

Weather Stations by Region y g

18

Weather Station Device Age: By CDOT Region February 2009

15 16 14 16

Region 1 Region 2 Region 3 Region 4 Region 5

8 10 12

• f Devices

Region 5 Region 6

4 4 4 6 8

Number o

1 1 1 2 2 3 5 6 7 8 9 10 11 12 13

33

Life Cycle

Age of Device (Years)

Next Steps

34

Benefits of Using Maintenance Management System Management System

 Better handle on inventory and will be available in map form form.  Ability to track labor, materials and equipment to a device.  Ability to manage materials  Ability to manage materials.  Ability to move towards planned maintenance.  Ability to report on life cycles of equipment. y p y q p  Ability to report on device performance.  Ability to justify resources based on desired levels of service. service.  Proper accounting, risk management & depreciation.  Maintenance management = Saves $$$ for CDOT and tax payers and tax payers.

35

Next Steps p

• Business processes and training

p g

• Culmination of 3 years of continued effort
• Start using the system and keep it updated
• Start using the system and keep it updated

– BOMS Task list – Task list

• Using the system to make better decisions

ith h i i f ti with comprehensive information

36

Questions???

37