Real-time KPI Manufacturing Dashboard

Overview

A real-time performance monitoring platform built for PT. Nihon Seiki Indonesia, centralizing Key Performance Indicators (KPIs) from multiple manufacturing departments — IT, Maintenance, Purchasing, and Quality — into one internal dashboard.

Problem

• Each department tracked its own numbers separately, with no shared, real-time view for leadership.
• Machine downtime, sparepart requests, and quality issues moved between departments manually, causing delays.
• Leadership needed a single, trustworthy source of truth to make faster decisions.

Solution

• Executive summary dashboard giving leadership a live, consolidated view across every department.
• Maintenance module tracking machine status and downtime in real time, automatically flagging machines waiting on spare parts.
• Purchasing module that picks up those flags automatically, so procurement starts without anyone having to chase it down.
• Quality module monitoring defect rates and inspection results across production shifts.
• Role-based access so each department sees the tools relevant to them, while leadership sees everything.

Architecture

flowchart TB
    subgraph Client["Client"]
        FE["React / Next.js dashboard<br/>per-department + executive views"]
    end
    subgraph Backend["Backend API (Laravel)"]
        AUTH["Auth & role-based access"]
        API["Module APIs<br/>Maintenance · Purchasing · Quality"]
    end
    DB[(MySQL)]

    FE -->|REST| AUTH --> API --> DB
    API -->|live KPI data| FE

Cross-Department Flow: Downtime → Procurement

flowchart LR
    A[Machine goes down] --> B[Maintenance logs downtime<br/>+ reason]
    B --> C{Needs spare part?}
    C -- Yes --> D[Flag raised automatically]
    D --> E[Purchasing module picks up flag]
    E --> F[Procurement request created<br/>no manual handoff]
    F --> G[Spare part ordered]
    G --> H[Maintenance notified on arrival]
    H --> I[Machine repaired, downtime closed]
    C -- No --> J[Repaired directly, downtime closed]

Role-based access controls which module each user sees: Maintenance and Purchasing staff work in their own module, Quality tracks defects/inspections independently, while leadership's executive dashboard aggregates KPIs across all three in real time.

Key Impact

• Replaced scattered spreadsheets and manual reporting with one real-time system.
• Cut the delay between a machine going down and spare parts being ordered, by connecting Maintenance and Purchasing directly.
• Gave leadership a single live view of production health across all departments.