ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

CMMS Software System Analysis Tools

Updated on November 10, 2017
Cost of equipment maintenance displayed in a table form makes it obvious where efforts should be focused.
Cost of equipment maintenance displayed in a table form makes it obvious where efforts should be focused. | Source

What Analysis Features Should You Expect to Have in a CMMS?

The basic components of a computerized maintenance management system are: work orders, preventive maintenance, inventory management, purchasing management and equipment downtime tracking. All of these basic components should have a corresponding analysis and reporting module. Charting data obtained from the CMMS gives the user a quick view of trouble spots in the maintenance system.

It makes sense to be able to import analysis data into another application such as Excel. By using Excel to further analyze analysis data the maintenance manager leverages the usefulness of the original analysis data. Additionally Excel is an OLE automation server that exposes advanced capabilities to the reporting software enabling sophisticated data presentation.

Equipment Failure Tracking and Analysis

With regards to downtime analysis some of the more advanced systems also offer reliability analysis and other equipment failure analysis tools. Overall Equipment Effectiveness (OEE) leverages downtime data to generate three useful KPIs:

  • Quality: reflects the percentage of defective units produced. Often defects can be attributed to equipment issues and should be logged as equipment downtime.
  • Availability: Is a measure of planned vs. unplanned (downtime) stoppages. This is basically a measurement of the ratio of potential production time compared to actual production time.
  • Performance: This KPI measures how close to the equipment's expected product output is to its actual output. Lagging performance also may indicate downtime. Although an equipment item is still running, if not running at capacity due to an equipment problem then this should be logged as downtime.

Reliability analysis is another useful tool for determining equipment reliability and therefore effectiveness of operation. Few CMMS software programs actually implement reliability analysis. Integrating reliability metrics such as, Mean Time Between Failures (MTBF), into the preventive maintenance system is a powerful way to determine how well labor resources are being used. Mean Time Between Failure (MTBF) guides the maintenance manager towards optimized preventive maintenance intervals by examining the downtime interval and comparing it to the maintenance interval. In some cases this means adding labor in other cases labor may be reduced for a particular preventive maintenance item. Either way efficiencies are optimized.

Work Order and Preventive Maintenance Analysis

Analyzing work performed provides the maintenance manager with the information needed to allocate resources properly and efficiently. Below are several useful Key Performance Indicators (KPIs).

  • Percentage completion of assigned preventive maintenance tasks by technician.
  • Percentage completion of assigned preventive maintenance tasks by equipment item.
  • Overdue work orders by technician, work order type, work order priority or status.
  • Overall cost of preventive maintenance labor and parts by equipment item.
  • Average late days (for completion of preventive maintenance tasks) by technician.

Some of the above KPIs referred to late completion or overdue assignments. This is useful information, however your CMMS should have the ability to remind technicians if their work is behind schedule. These timely reminders should be automated and issued by email or text message.

Purchasing and Inventory Analysis

Basic inventory management software capabilities typically include:

  • Physical inventory variance audit.
  • Notifying under stock.
  • Inter-Plant inventory search, transfer request and transfer approval process.
  • Adequate user-defined fields to enhance the software flexibility.
  • Basic fields such as: restocking quantity, restocking level, minimum and maximum stock.
  • Capability for pictures or better yet file attachments linking to each inventory item if needed.

Reporting by cost center, account, equipment and who requisitioned inventory are basic reports needed by most maintenance or inventory management users. Cost reports, restocking lists, over/under stock reports and audit reports are useful as well. These reports guide the user towards optimum stock levels and timely restocking of critical spare parts.

Top 10 Downtime Instances
Top 10 Downtime Instances | Source

What are Best Practices for to CMMS Analysis Reporting?

CMMS software guides the maintenance manager to where labor and other assets should be allocated. Having a selection of various analysis tools offers a better chance to have the correct tool for increasing maintenance efficiencies. All this analysis data if useful, but only if this data may be reported on easily and through various shareable formats. At the very least analysis data should be available in the following shareable formats so that users who do not have the software application may still be informed.

  • Web Page (.html)
  • Adobe Acrobat (.pdf)
  • Excel (.xls)
  • Microsoft Word
  • Picture formats (.jpg, .png, .tiff, .bmp)

Additionally reporting is best automated by using a built-in report scheduler. Report schedulers are only useful if the reports use a floating date range. The reason for this is that once date sensitive report is defined it should report only on date-appropriate information. This saves the maintenance manager the time and trouble of editing the report definition and truly automates the reporting process.

In short, planning now for CMMS software data analysis later should be a high priority. Let your software reward you with answers that improve your maintenance operation through thoughtful planning of data analysis and reporting.

OLAP (data cube analysis)

OLAP provides a simple drag and drop interface for creating customized analysis scenarios.
OLAP provides a simple drag and drop interface for creating customized analysis scenarios. | Source

CMMS Software Feature List

What Do You Think is the Most Important Feature of CMMS Software?

See results


    0 of 8192 characters used
    Post Comment

    No comments yet.


    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at:

    Show Details
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
    CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the or domains, for performance and efficiency reasons. (Privacy Policy)
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
    ClickscoThis is a data management platform studying reader behavior (Privacy Policy)