• Our Product
  • Business Systems
  • AI Development & Business Automation
  • IoT & Device Integration
  • Manufacturing

Maintenance KPI Management System

One maintenance workflow, from failure records to recurrence prevention

Maintenance KPI Management System dashboard, failure entry, and similar case search screens

Challenge & Background

This system records failures and downtime in manufacturing equipment, uses an LLM to standardize inconsistent descriptions, and connects maintenance KPI visualization with improvement task tracking.

It also captures downtime events from PLCs, searches similar past cases, and provides access control and audit logs, supporting the process from on-site records to recurrence prevention.

Watch on YouTube (external site) (opens in a new tab)

What We Built

Key features of the Maintenance KPI Management System include:

View five maintenance KPIs at a glance

KPI screen showing five metrics: downtime count, total downtime, mean time to recovery, recurrence rate, and equipment availability

Metric cards show downtime count, total downtime, mean time to recovery, recurrence rate, and equipment availability. Switch line groups, fiscal years, shifts, and event categories to review KPIs for the scope you need.

Analyze downtime trends with six charts

Analysis screen comparing annual and monthly downtime trends across six charts

Overall Summary and the current year's Down Time Summary visualize annual and 12-month downtime trends. Compare six charts by assembly, molding, equipment, and event, with views that respond to the selected filters.

Spreadsheet-style failure data entry

Entry screen showing PLC-captured and manually entered failure data, LLM correction status, and standardized tags in a table

Enter and review dates, lines, equipment, events, actions, downtime, owners, and other details in a table. PLC-captured and manually entered records are distinguished, with LLM correction status and standardized tags shown in the same list.

Search similar past cases and countermeasures

Search screen for filtering past failure cases and countermeasures by keyword, standardized tag, and similarity

Filter past cases by keywords such as event, action, or equipment name, as well as by date range, line, equipment, status, owner, and standardized tag. Sort by date, similarity, or downtime, and compare events, actions, and recovery times.

Track improvement task progress and due dates

Punch List screen listing improvement task owners, priorities, due dates, and progress

Manage improvement tasks by triggering event, owner, priority, status, due date, and progress. The system flags overdue tasks and automatically creates a task when the same event recurs on the same equipment.

Manage maintenance master data in one place

Screen for managing line, equipment, tag, and user master data across tabs

Manage line, equipment, tag, and user master data in separate tabs. Search and check statuses, add, edit, or deactivate records, and import or export line data as CSV.

Manage user roles and status

Screen listing users' three access levels and approval statuses

Administrators can review user roles and statuses, create accounts, approve or reject requests, and activate or deactivate users. The system supports administrator, leader, and standard roles; roles can be assigned when approving pending users.

Track system activity in audit logs

Audit log screen showing date and time, user, action, target resource, and IP address

Review creation, update, deletion, login, and logout activity filtered by user, target resource, or date range. The list shows date and time, user, action, target, and IP address, and can be exported as CSV.

Our Scope

  • Planning
  • Design
  • Development

Results

We built seven core business screens, covering downtime records, KPI analysis, improvement tasks, and administration.

We implemented downtime event capture from PLCs and duration calculation, spreadsheet-style failure data entry, and automatic description standardization with LLM-assisted correction.

We implemented metric cards for five maintenance KPIs, an analysis screen with six downtime trend charts, and screens for automatically surfacing and searching similar past cases.

We implemented automatic creation of improvement tasks (Punch List) and a progress tracking screen.

We implemented master data management for lines, equipment, tags, and users; user management with three roles (administrator, leader, and standard user); and audit log search and CSV export.

Technologies

  • Next.js
  • OpenNext
  • React
  • TypeScript
  • Tailwind CSS
  • shadcn/ui
  • Cloudflare
  • Convex
  • Google AI
  • AWS IoT Core
  • Amazon Bedrock
  • PostgreSQL

Still figuring out what to build?

Whether you want to reduce manual work or bring a service idea to life, we’ll help clarify your goals and explore a practical path forward.

Contact us