Skip to content

Dashboard templates

Manufacturing · IT

Make-to-order factory whose IT team runs MES, ERP, the shop-floor network, shop-floor PCs and label printers. Output, OEE and machine downtime, plus incidents, SLA, failed changes, service availability and the estimated output value affected when systems go down.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For factory IT teams running MES, ERP, the shop floor network and label printers. The "IT and production" dashboard estimates the output value affected by IT outages and compares IT outage minutes with machine downtime minutes. The "IT incidents and support" and "Availability and changes" dashboards cover service availability, P1 incidents, MTTR, SLA breaches and change failure rate, and the downtime dashboard shows which stops came from machines and which from systems. Needs machine, item, production order, machine shift, IT service catalog and IT ticket data.

Use this template to

  • Quantify the output value lost to MES outages to justify a redundancy budget.
  • Separate IT-caused downtime from equipment-caused downtime.
  • Review MES changes that had to be rolled back and tighten the release process.

6 ready-made dashboards

IT and production

Estimated output value affected by MES and plant network outages, and IT outage minutes versus machine downtime minutes.

  • Estimated output value affected by IT outages
  • Share of output value affected by IT outages
  • IT outage minutes to machine downtime ratio
  • Service availability
  • Affected output by service
  • Weekly affected output
  • Monthly IT outages vs machine downtime

IT incidents and support

Tickets, P1 incidents, response and resolution times, and SLA breach rate by service and resolver team.

  • Incidents
  • P1 incidents
  • Mean time to resolve (MTTR, hours)
  • SLA breach rate
  • By service
  • SLA breach rate by work type
  • Response time by resolver team
  • Weekly tickets

Availability and changes

Availability, outage time and change failure rate for each IT service.

  • Service availability
  • Outage minutes
  • Changes deployed
  • Change failure rate
  • Availability by service
  • Outage minutes by criticality
  • Weekly outage minutes

Output and OEE

Good output, output value and OEE broken into availability, performance and quality rate by workshop, machine and shift.

  • Good output
  • Output value
  • OEE (overall equipment effectiveness)
  • Scrap rate
  • OEE by machine
  • Weekly OEE by workshop
  • Performance by shift
  • Weekly good output by workshop

Downtime

Machine downtime by reason, machine and workshop; unplanned downtime drags availability down.

  • Downtime minutes
  • Unplanned downtime share
  • Availability
  • Downtime minutes by reason
  • Downtime minutes by machine
  • Weekly downtime minutes by workshop

Quality and production orders

Scrap and inspection defects by item and defect type; completed production orders and on-time rate.

  • First pass yield (FPY)
  • Inspection defect rate
  • Completed work orders
  • On-time completion rate
  • Quality by item
  • Defect rate by defect type
  • On-time rate by workshop
  • Monthly on-time rate

Ask Si as soon as the build finishes

  • “How did estimated output value affected by IT outages change compared with last month?”
  • “What is driving share of output value affected by IT outages this quarter?”
  • “Show IT outage minutes to machine downtime ratio by month for the last six months.”
  • “Where is service availability highest this month, and why?”

29 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Estimated output value affected by IT outagesFor each outage: outage minutes divided by 1,440, times good output value (at standard selling price) on the day the outage started, times the share of production that depends on that service. Summed over all outages in the period.Currency
Share of output value affected by IT outagesEstimated output value affected by IT outages divided by good output value in the period.= Estimated output value affected by IT outages / Output valueRatio (%)
IT outage minutes to machine downtime ratioTotal outage minutes across all IT services in the period divided by total production machine downtime minutes in the same period; shows how much IT is down relative to machinery.= Outage minutes / Downtime minutesRatio (%)
Service availabilityOne minus outage minutes divided by the service's planned operating minutes in the period.= 1 - Outage minutes / it_planned_minutesRatio (%)
Change failure rateFailed changes (failed or rolled back) divided by changes deployed in the period.= Failed changes / Changes deployedRatio (%)
Changes deployedNumber of IT changes deployed in the period, by deployment date.Count
Failed changesNumber of changes deployed in the period with a failed or rolled-back outcome.Count
Average first response time (hours)Average hours from ticket creation to first response, across all tickets opened in the period.= it_response_hours_total / IT support ticketsNumber
IncidentsNumber of incident-type tickets opened in the period, by open date.Count
Mean time to resolve (MTTR, hours)Average hours from open to resolution for incidents resolved in the period.= it_incident_hours_total / Resolved incidentsNumber
Outage minutesTotal minutes a service was down or disrupted, counted on the day the outage started.Number
P1 incidentsNumber of highest-priority incidents (P1, critical) opened in the period.Count
Resolved incidentsNumber of incidents resolved in the period, by resolution date.Count
SLA breach rateTickets breaching SLA divided by tickets opened in the period.= SLA breaches / IT support ticketsRatio (%)
SLA breachesTickets opened in the period that were resolved after the SLA deadline (resolution hours greater than the SLA target).Count
IT support ticketsNumber of IT support tickets (incidents and requests) opened in the period, by open date.Count
AvailabilityRun minutes divided by planned minutes. The first component of OEE.= mfg_run_minutes / mfg_planned_minutesRatio (%)
Completed work ordersWork orders completed in the period, by completion date.Count
Inspection defect rateDefective samples divided by inspected samples across the inspection lots in the period.= mfg_defect_qty / mfg_inspected_qtyRatio (%)
Downtime minutesTotal machine downtime minutes recorded in the period, for every reason (including changeovers and scheduled maintenance).Number
First pass yield (FPY)Good output divided by total output. The quality component of OEE.= Good output / Total outputRatio (%)
OEE (overall equipment effectiveness)Availability x performance x first pass yield, computed on the period totals.= (mfg_run_minutes / mfg_planned_minutes) * (Total output / mfg_ideal_output) * (Good output / Total output)Ratio (%)
On-time completion rateWork orders completed on time divided by work orders completed in the period.= mfg_on_time_work_orders / Completed work ordersRatio (%)
Good outputGood units (total output minus scrap) produced in the period's shifts, by shift date.Count
Output valueGood output multiplied by the item's standard selling price, by machine shift date.Currency
PerformanceTotal output divided by the ideal output for the run time. The second component of OEE.= Total output / mfg_ideal_outputRatio (%)
Total outputTotal units produced in the period's shifts, including both good units and scrap.Count
Scrap rateScrap units (total output minus good output) divided by total output.= (Total output - Good output) / Total outputRatio (%)
Unplanned downtime shareUnplanned downtime minutes divided by total downtime minutes.= mfg_unplanned_downtime_minutes / Downtime minutesRatio (%)

Data you need

Required

machine, item, work_order, machine_shift, it_service, it_ticket

Add if you have it (unlocks more metrics)

downtime_event, quality_inspection, it_change, it_outage

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: machine, item, work_order, machine_shift, it_service, it_ticket.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 6 dashboards and 29 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Manufacturing · IT with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes