Transcription
Maximo’s Key Performance Indicators (KPIs)Presenter: Craig MackenzieMay 12, 2009www.ontracksconsulting.com
Agenda What is a KPI?Types of KPIsCommon Maintenance & Materials KPIsBuilding and Using KPIs in Maximowww.ontracksconsulting.com
Key Performance IndicatorsDefinition: Key Performance Indicators (KPIs) arequantifiable measurements, agreed to beforehand,that reflect critical business success factors (of thecompany, department, project, etc.)KPIs can be:Management dashboardsReports run adhocSimple calculations or queries of dataScheduled reports sent to specific individualswww.ontracksconsulting.com
Types of KPI’sLeading (how we’re performing now)For Example:-Current Backlog Labour Hours-# of Work Orders Completed Today- Actual Costs vs. Budget Costs (current)Lagging (how we’ve performed in the past)For Example:-Work Order Backlog Trend-Mean Time To Repair (MTTR)-Mean Time Between Failures (MTBF)www.ontracksconsulting.com
LaggingLeadingSample Maintenance KPI’sMeasurementUnitsFrequencyDefinitionNew Work OrdersNumberWeek to weekrunningThe total number of new work orders/requests generated weeklyPast Due Work OrderNumberWeek to weekrunningTotal number of work orders that are past their scheduled startdates.Current BacklogLabourHoursWeekly or DailyTotal labour hours required for all remaining work orders.Percent of Planned HoursPercentPlanned hours vs. total hours in schedule.Job Plans UsedPercentPercent of work orders that are using a job plan.MeasurementUnitsFrequencyDefinitionSchedule CompliancePercentDaily / WeeklyWork orders planned to be started divided by the actual workorders started in a week (or defined period)Estimating AccuracyCurveMean Time BetweenFailuresNumberQuarterlyAverage time between failures on a particular asset or asset class.Work Type DistributionPie ChartWeeklyDistribution of Corrective, Breakdown, Capital Projects, Predictiveand Preventive Work Orders.Follow-up to PM ratioPercentMonthlyMeasure the effectiveness of PM inspection programs.A distribution curve of actual vs. estimated time/cost by selectedgroupings.www.ontracksconsulting.com
LaggingLeadingSample Supply Chain/Materials KPI’sMeasurementUnitsFrequencyDefinitionTotal Value of InventoryStockDollarWeekly /MonthlyThe Total dollar value of maintenance materials in stock(excludes process chemicals & fuels). Used to demonstrateeffective stock utilization.Number of InventoryReservationNumberDaily / WeeklyTotal number of inventory reservations made in a given day /week.Items Above itionInventory TurnsNumberMonthlyValue of Inventory issued divided by the average inventory forthe period.Stocks Outs (akaBackorder)PercentMonthlyThe percentage of inventory request that could not befulfilled with inventory items in stock.Potentially ObsoletePartsNumberMonthlyThe number of inventory items that could be potentiallyobsolete.Vendor Lead TimeCompliancePercentMonthlyA vendor analysis metric that shows the actual lead timecompliance compared to the promised lead time.Number of items above their Maximum level in the system.www.ontracksconsulting.com
Three Major Areas for KPIs in Maximo1. Result Set – Pie/Bar Charts2. KPI Manager3. ReportsThe focus of this Webcast is on #2www.ontracksconsulting.com
Maximo’s KPI Manager Introduced January 2004 for Maximo 5.2 and beyondCan be downloaded from IBM Support Online (with activesupport) for Maximo 5.2, included in 6.x and 7.x.Allows users to create KPIs on the fly using a query in anapplication or simple SQLComes with 13 KPIs out-of-the-box (MAXDEMO database)Can be used as both Lists & Graphs on the Start Centerwww.ontracksconsulting.com
Demonstration1. Using KPI’s on the Start Center2. Creating KPI’s using a query3. Creating KPI’s using SQLwww.ontracksconsulting.com
Maximo's KPI Manager www.ontracksconsulting.com Introduced January 2004 for Maximo 5.2 and beyond Can be downloaded from IBM Support Online (with active support) for Maximo 5.2, included in 6.x and 7.x. Allows users to create KPIs on the fly using a query in an application or simple SQL
