Preventive Maintenance

This data model captures insights on maintenance events, resources, and performance metrics. It includes measures such as the count and percentage of job tickets, maintenance work order delays, quantity metrics for items used and remaining, response time for issue resolution, and costs related to machines, materials, workforce, outsourcing, and general fees. It also tracks equipment uptime and downtime, resource utilization, and maintenance-related KPIs. Views focus on equipment history, resource performance, equipment downtime, maintenance costs, and top-performing resources and equipment for targeted interventions and planning.

Benefits of This Data Model

• Improved Maintenance Efficiency: By tracking equipment downtime, response time, and expected vs. actual repair times, the data model enables identifying inefficiencies and optimizing maintenance processes.

• Enhanced Resource Allocation: Insights from top-performing resources and recurring maintenance requests allow for better resource utilization and allocation for more effective maintenance planning.

• Cost Optimization: Detailed tracking of maintenance costs related to machines, materials, workforce, and outsourcing enables identifying cost-saving opportunities and optimizing maintenance budget allocations.

• Proactive Issue Resolution: Monitoring equipment history, response times, and common maintenance requests helps in proactively addressing issues and reducing overall downtime for improved operational efficiency.

• Performance Monitoring: By analyzing equipment uptime, resource utilization, and KPIs, the data model facilitates continuous monitoring of maintenance performance to ensure optimal equipment operation and longevity.

Key Performance Indicators (KPIs)

• Number of Job Tickets: The total count of job tickets recorded within the preventive maintenance data model.
• Number of Job Tickets Percent of Total: The percentage representation of the number of job tickets out of the total within the preventive maintenance data model.
• Number of On-Time Orders: The count of maintenance work orders completed within the expected timeframe.
• Delay in Days: The total delay in days for maintenance work orders compared to the expected completion date.
• Quantity Release Qty: The quantity of maintenance items released.
• Quantity Planned: The planned quantity of maintenance items.
• Quantity Total Actual: The total actual quantity of maintenance items used.
• Quantity Actual Rejected: The quantity of maintenance items rejected during usage.
• Quantity Actual QC: The quantity of maintenance items that passed quality control checks.
• Quantity Remaining: The remaining quantity of maintenance items available.
• Response Time (Day): The average response time in days to address maintenance issues.
• Machine Cost Theoretical Forecast: The theoretical forecasted cost associated with maintenance of machines.
• Machine Cost Provisional/Release: The provisional or released cost of machine maintenance.
• Machine Cost Actual: The actual cost incurred for machine maintenance.
• Material Cost Theoretical Forecast: The theoretical forecasted cost associated with maintenance materials.
• Material Cost Provisional/Release: The provisional or released cost of maintenance materials.
• Material Cost Actual: The actual cost incurred for maintenance materials.
• Workforce Cost Theoretical Forecast: The theoretical forecasted cost associated with workforce for maintenance.
• Workforce Cost Provisional/Release: The provisional or released cost of workforce for maintenance.
• Workforce Cost Actual: The actual cost incurred for workforce in maintenance.
• Workforce Cost Expected: The expected or planned cost for workforce in maintenance.
• Workforce Cost Saved: The saved cost in terms of workforce expenses in maintenance.
• Out Sourced Cost Theoretical Forecast: The theoretical forecasted cost associated with outsourced maintenance work.
• Out Sourced Cost Provisional/Release: The provisional or released cost of outsourced maintenance work.
• Out Sourced Cost Actual: The actual cost incurred for outsourced maintenance work.
• General Fees Theoretical Forecast: The theoretical forecasted general fees for maintenance operations.
• General Fees Provisional/Release: The provisional or released general fees for maintenance.
• General Fees Actual: The actual general fees incurred for maintenance.
• Total Cost Without FG Theoretical Forecast: The theoretical forecasted total cost excluding finished goods.
• Total Cost Without FG Provisional/Release: The provisional or released total cost excluding finished goods.
• Total Cost Without FG Actual: The actual total cost incurred excluding finished goods.
• Total Cost Theoretical Forecast: The theoretical forecasted total cost of maintenance operations.
• Total Cost Provisional/Release: The provisional or released total cost of maintenance.
• Total Cost Expected: The expected or planned total cost of maintenance.
• Total Cost Actual: The actual total cost incurred for maintenance.
• Total Cost Saved: The saved cost in comparison with the expected total cost.
• Variances Cost: The cost variances between the expected and actual costs.
• Runtime Actual: The actual runtime hours for maintenance operations.
• Runtime Expected: The expected or planned runtime hours for maintenance operations.
• Runtime Hours Saved: The saved runtime hours in maintenance operations.
• Available Hours Monthly: The total available hours for maintenance on a monthly basis.
• Available Hours Weekly: The total available hours for maintenance on a weekly basis.
• Available Hours Yearly: The total available hours for maintenance in a year.
• Equipment Uptime %: The percentage of time equipment is operational.
• Equipment Uptime (hours): The total hours the equipment is operational.
• Equipment Downtime %: The percentage of time equipment is non-operational.

Available Visualizations

View Name	Description
Equipment History	Insights on maintenance events, repairs, and performance history of all equipment in the system.
Resource Utilization	Analysis of how efficiently resources are being utilized for maintenance activities.
Top 5 Resource by Utilization	Identification of the top-performing resources based on their utilization for maintenance tasks.
Equipment Downtime & Uptime hours	Tracking of equipment downtime and uptime to monitor performance and efficiency.
Top 5 Equipment by Downtime hours	Ranking of equipment with the highest downtime hours for targeted maintenance interventions.
Equipment Cost	Overview of maintenance costs associated with equipment repairs and replacements.
Top Recurring requests	Identification of the most common maintenance requests for proactive planning and resource allocation.
Job Ticket Response time	Insights into the response time for addressing maintenance requests and job tickets.
Top 10 Equipments by Response time	Ranking of equipment based on response time to prioritize maintenance efforts.
Replaced Component	Tracking of components that have been replaced during maintenance activities for inventory management.
Top 5 Replaced Component	Identification of the most frequently replaced components for strategic procurement and maintenance planning.
Expected Repair Time vs Actual	Comparison of expected vs. actual repair times to assess maintenance efficiency and performance.
Top 5 Performing Resources	Recognition of the top-performing resources based on maintenance activities and outcomes.
Top 5 Equipment by Number of Job Tickets	Ranking of equipment with the highest number of job tickets for maintenance prioritization.
Top 5 Equipment Groups by Number of Job Tickets	Analysis of equipment groups with the most frequent maintenance requirements for resource allocation.
Workforce Cost Expected vs. Actual	Evaluation of expected vs. actual workforce costs for maintenance tasks to optimize resource allocation.
KPI Equipment	Monitoring key performance indicators related to equipment maintenance and operational efficiency.