Home / Featured, Maintenance Excellence / Expert tips on successfully planning a CMMS project

Expert tips on successfully planning a CMMS project

A well-planned and executed computerized maintenance management system (CMMS) project can yield a maximum return on your investment (ROI). This return is realized through increased efficiency, productivity and profits. However, a poorly planned and executed CMMS project can result in a loss of revenues. These losses can be measured in terms of the overall investment in the project, as well as from wasted time and lost projected revenue forecast tied to the successful installation and implementation of a CMMS. This article will outline how to successfully plan a CMMS project.

Planning
Properly planning the CMMS implementation project is one of the key elements. In the planning phase, you determine the “what”, “why”, “who” and ‘how”.

Equipment Data
Developing a plan for equipment data is a good first step because it will provide a CMMS with a foundation of hard, verifiable data. Some maintenance departments may already employ an equipment numbering scheme that is effective; this can easily be translated into the CMMS. If there is no scheme currently in place or if the current one is flawed, it is time to develop an equipment numbering scheme.

Determining an equipment hierarchy is the next step, setting up parent/child relationships among equipment. For example, an air handler can have pumps and motors as children. If you are going to keep track of both the parent and children, the relationship must be documented. Make sure to include every piece of equipment that falls under that hierarchy scheme. Parent/child relationships also can be constructed for whole facilities (for example, a building as the parent and each floor as a child; then each room can be a child of the floor).

Information on spare parts should be tagged to the individual pieces of equipment (referred to as the bill of material, or BOM).

Finally, you need to decide what you want from your CMMS in terms of downtime monitoring. You should choose which pieces of equipment you want to monitor as well as how you want to track planned vs. unplanned downtime. Plan based on impact or loss of operation. You should have this information for each piece of equipment or at least for critical equipment.

Preventive Maintenance
The following decisions have to be made for each preventive maintenance (PM) task:

• Will the PM be performed by calendar time or run time (miles, hours etc.)?
• Will the PM follow a fixed schedule (regardless of completion date) or a schedule based on completion date?
• How often will PM work orders be generated (daily, weekly, monthly etc.)?
• What are the strategies for route-based PMs? (For example, an inspection route for all fire extinguishers in a building.)

Procedures
Procedures can be preventive maintenance, safety instructions or any other set of instructions. Each piece of equipment should have identified for it all the preventive, corrective and predictive maintenance tasks necessary to properly maintain that equipment. Along with the maintenance task, information regarding maintenance frequency, responsible craft, repair and/or consumable parts necessary to compete the maintenance task, and time estimated to compete the task are some of the additional information that will enhance the usefulness of your CMMS database. These procedures can then be applied anywhere within the CMMS.

Labor
You need information on each maintenance technician such as name, address, phone, Social Security number, etc. You also have to decide if you are going to use some sort of ID card for your technicians that can be scanned by a reader. If yes, will the cards be produced in-house or by an outside vendor?

Inventory
The following actions must be taken:

First, you have to develop a part numbering scheme. This is by and large similar to the process used for equipment numbering. There are companies that use a 20- to 30-character-long part numbering scheme. It includes every detail of that part (for example, type of part, thickness, diameter, location, etc.). With advances in CMMS and a field available for each of these details (category, dimensions, location, etc.), you don’t need a part numbering scheme to include all of the details. It just increases the potential for data entry errors.

Implicit in the development of a part numbering scheme is the need to concretely define the details of parts. The most useful in terms of work flow is defining the location of a part. Is there one or multiple stockrooms? Is there a location scheme within the stockroom (i.e. aisle, bins, shelves, etc.)?

In the data gathering phase, you will compile a list of all of the vendors from which you buy parts and services. One of them should be assigned as a primary vendor for each part. The CMMS automatically generates purchase orders to the primary vendors; that can be changed by the users, if desired. At this stage, you have to decide the criteria for selecting a primary vendor (i.e. price, delivery, overall service, etc.). Additionally, you need to track vendor/manufacturer part numbers for cross-referencing purposes. Also, you need to decide the issue units that you are going to use - metric, British or a combination of both? How are you going to handle inventory of pipes, beams, etc.? Are you going to keep track of lengths? If a piece is cut, are you going to keep track of the remaining pipe length? Once vendor and tracking information is decided upon, you also need to determine:

• Who has the authority to order parts and up to what amount?
• Beyond what amount will further approval be required?

In the overall planning of the physical inventory process, you have to make the following decisions:

• How often are you going to take the physical inventory?
• Who is going to do it?
• Is it going to be manual or using mobile technology? If it is manual, make sure your CMMS has the capability to print the appropriate forms for this purpose.

Associated with this step is development of a parts label design and bar-code label design. What information do you want to print on the parts labels? Part number, description and location are typical. If you are using bar-coding with inventory, you have to decide which information items do you want bar coded. Part number and location are typical.

If you have multiple plants/facilities, it is important that every facility is following the same schemes. Without consistency, the CMMS will not be very effective. If you are looking for a part at a different facility and if that facility is describing it differently than you are, you may not find the part even if it is in stock.

Purchasing and Accounting
You will probably need the purchasing and accounting departments involved in the planning phase for these:

• “Bill to” information
• “Ship to” information
• Sales tax rate
• Determine budget accounts and amounts

Codes
You should decide what plan and design codes will be used throughout the CMMS. During the planning phase, you need to decide on strategies as to basis of codes. Actual compilation of codes will be done during the data gathering phase. Decide on the following:

• Account codes
• Work order type
• Failure codes
• Action codes
• Repair codes
• Work order priority
• Equipment criticality
• Work order status
• Purchase order status
• Departments

Mobile Applications
If you are employing mobile applications, you need to identify each application and work on articulating the details. Some examples are: Using a hand-held remote data entry device to collect equipment meter readings, parts can be issued and/or returned using a handheld device; handheld devices can be used to count and track inventory parts.

Backup
There needs to be some decisions made regarding data backup. There needs to be an articulated backup scheme that takes into account both hardware and setup. Decide how often backup will be done (daily, weekly, etc.).

History
Plan on what kind of maintenance history you want to maintain. Your decisions should include date performed, task performed, the person(s) who performed the job, estimated and actual time to perform, equipment performed on, material used, and any outside contractor cost incurred.

Decisions
Several decisions need to be made regarding the general operation of your CMMS. These questions provide information not only for planning but evaluating current capabilities:

• Are you going to print estimated time on work orders?
• What details of reports are needed in your CMMS?
• Which reports are needed in graphics format?
• What decisions will be made based on reports analysis?
• Security issues: Who is permitted to do what?
• Field legends: Do you need to change the terms provided by your CMMS on any of the legends? If yes, be sure to document the changes.

Key Performance Indicators (KPIs)
Develop a list of KPIs for your application. At this stage, you should review them and revise, if necessary. Also determine how you would compute those KPIs. Most of the KPIs should come from CMMS reporting.

Assign Responsibilities
Plan on who will:

• Install the hardware (if necessary)
• Maintain the computer hardware, backups, etc.
• Perform archiving and merging of data
• Take care of disaster recovery
• Generate reports
• Review and analyze various reports
• Plan and schedule work orders
• Do the ongoing data entry
• Close work orders
• Be responsible for customizing, configuring, tailoring and maintaining the CMMS

Conclusion
The planning stage of a CMMS is perhaps one of the most important in ensuring success. Granted, implementation itself is not a short process, but with a well-laid-out plan where all possibilities are considered, the process will be simpler and streamlined. The major challenge in planning a CMMS is considering the entire breadth of your operation down to every last piece of equipment, part and facility, and then remaining realistic with your goals. Consider the abilities of your operation to adapt to a new technology in a manner that will not unduly disrupt workflow. With a laid-out plan, you will reap the rewards for many years.

Respond to this blog post with your questions, comments and stories related to CMMS implementation and maximization.

Related posts:

1. Skimping on the training puts your CMMS project at risk Training for users of a computerized maintenance management system (CMMS)...
2. Start the lean journey by planning the trip When I have occasion to speak with people about lean...

If you enjoyed this post, please consider leaving a comment and subscribing to the email alerts or RSS feed.

Filed Under: Featured, Maintenance Excellence    |  Tags: CMMS, inventory management, maintenance management, metrics, planning and scheduling

Comments

Trackbacks

• Public Sector Assets Blog