Work Management System Implementation at

1
Work Management System Implementation at
2
Owen Electric Cooperative

• 60,000 Services Covering 9 Counties in Northern
  Kentucky (Urban in North, Rural in the South)
• 132 Employees
• Contract Out R-O-W, Pole Treatment, Work Plan
  Jobs
• 2400 Connects Per Year, 3000 plus Work Orders per
  year
• 8 Million Dollar per Year Work Plan
  (Distribution, no subs or transmission)
• OEC IT Systems (Entire Company on WAN, HQ and
  four satellites)
• SEDC (Billing and Plant Accounting)
• Milsoft Engineering
• Milsoft Outage
• UAI Staking and GIS
• QEI SCADA
• Porche/Telelink IVR Call Command
• Motorola AVL
• Homemade Software Solutions
• Cannon AMI

3
Owen Electric Cooperative

• Why on Gods green earth did OEC get involved in
  designing its own Work Management System?
• Strategically, OEC staff felt it was necessary to
  have a system to improve our Work Order/Work
  Request Process.
• None of OECs existing vendors had a solution or
  where not planning one.

4
Work Management System
Why? Because that is where all our money is
going (outside of the power bill)
5
Work Management System
Dollars are tied up first in Overheads and Labor
and the Material and Transportation
6
Where Were WeAccess/SQL Programs

• Electrical Inspections
• Survey Orders
• Maintenance Orders
• Assessment Database
• Various Spreadsheets (Work Plan Subdivisions,
  Sectionalizing, etc.)

7
Electrical Inspections
8
Survey Orders
9
Maintenance Orders
10
Work Management Systems

• Most of the focus of Academia and/or software
  companies is and has been in the following
  industries..
• Hospitals
• Airlines
• Transportation (RRs/Trucking/Shipping)
• Utility Industry at the IOU level

Thats where the money is until now
11
What was Out There..

• MDSI MDSI-Avantex.com
• SPL World Group
• Logica logicacmg.com
• UAI (Outage)
• SEDC - (Service Orders)
• NISC iVUE (All Areas)
• Some good work at various coops in WMS databases
  (Warren, Motherlode)

12
NISC
13
Motherlode www.motherlode.biz
Coops in upper Midwest, originally focused on
data side
14
WMS Your Definition ???

• WMS can mean many things to many people
• Project Management
• Data Management
• Asset Management
• Work Force Management
• Workflow Management
• Workload Management

15
Owen Electric Cooperative

• Goals and Objectives of System
• All Information about work requests and work
  orders in one location
• System to enhance the work flow process
• System must allow OEC to schedule work
• System must be user friendly and stable
• System must be integrated with existing software
  systems, no stand alone.

16
Work Management System

• Safety First All procedures and actions
• Process Analysis Including
• Work Order Process
• Crew Man Power Allocation
• Inventory/Material Process
• Scheduling Process
• Assessments/Work Load is known upfront, use
  common base (man hours per task)
• Historical Cost/Time Information
• Experience
• Contractor Bids/Work Plan Contracts
• Time and Motion Studies
• Share Information w/ Other Utilities

17
Work Management System

• Organize all work functions
• Capital Work Orders
• R-O-W Contractors or In-House
• Maintenance Service Orders
• Start small.Schedule one crew for one week and
  then expand
• Review all the processes to make adjusts to them
  are your experience grows and the learning curve
  shortens

18
Owen Electric Cooperative

• The result is ComLogic
• ComLogic is divided up into three areas
• Work Request
• Job Orders
• Scheduling

19

• Locate any account by multiple search
  capabilities

• Customer Location Information auto-populates the
  work request

20

• Any employee can create the work request and
  routes the Work Request to the proper warehouse.

21
The Service Planner field surveys the work
request and if field work is necessary, a
maintenance or job order will be assigned to the
work request.
22
The Service Planner will open the assigned job
order in ComLogic and add all the information
needed to the job to be worked by a crew.
23
Specific details concerning the job can be added
under the various categories (tabs).
All Job Order Header information is
automatically transferred to OECs system. The
job can now be staked in the GIS system.
24
The GIS system, using the information from
ComLogic, prepares the staking sheets and
material sheets for the job
25

• The job is staked in the GIS system and
  printed to the proper warehouse. The Work Order
  Scheduler uses the ComLogic System to schedule
  the job along with the other work that has been
  released.

26
Through the scheduling system, jobs can be
sorted and searched in a number of ways. The
Scheduler individually schedules each job.
27
The job is assigned to crew and a date it is
scheduled.
28
The calendar displays the scheduled jobs and
they are automatically removed when the job is
complete.
29
The map portion in the scheduling system gives a
graphic representation of the work available and
shows other jobs scheduled/unscheduled.
30
What Direction Are We Going..

• SEDC The WMS module will be coming out in
  April. WMS tabs already in place in Version 23.
  OEC will migrate to the SEDC Version based upon
  the starting features and timing of enhancements.
• Sentinel Working with Sentinel to make the
  existing ComLogic software better. No
  significant enhancements have been done by OEC
  because of SEDC implementation.

31
ComLogic

• Present Capabilities
• Enhancements
• Future Direction

32
Questions?/Contact Info.

• Tim Cammack Owen Electric
• tcammack_at_owenelectric.com
• 502.563.3512
• Dan Colby Sentinel USA
• colby_at_sentinelusa.com
• 740.349.5012
• Chuck Gill Owen Electric
• cgill_at_owenelectric.com
• 502.563.3510