Skip to content

Dashboard templates

Manufacturing · HR

Make-to-order factory with shift workers in three workshops, a maintenance crew, QC, warehouse and office. Output, OEE and machine downtime, plus average headcount, terminations, payroll cost, overtime, recruiting and labor productivity (output per employee, payroll cost per unit).

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

For factory HR teams with shift workers, maintenance, QC and warehouse crews. The "Labor productivity" dashboard shows good output per employee, payroll cost per good unit and overtime hours per 1,000 good units. The "Headcount and attrition" and "Payroll cost and recruiting" dashboards track attrition, absence, payroll cost and time to hire, while the output, OEE and downtime dashboards explain productivity swings. Needs machine, item, production order, machine shift and employee data.

Use this template to

  • See which workshop works the most overtime per 1,000 units and rearrange shifts.
  • Track payroll cost per unit month over month.
  • Measure time to hire for hard technical roles such as maintenance.

6 ready-made dashboards

Labor productivity

Good output against average headcount, and payroll cost and overtime per unit at the factory.

  • Good output per employee
  • Payroll cost per good unit
  • Overtime hours per 1,000 good units
  • Average headcount
  • Monthly payroll cost per good unit
  • Monthly overtime hours per 1,000 units
  • Overtime hours by department
  • Attrition rate by department

Headcount and attrition

Average headcount, new hires, leavers and attrition rate by department.

  • Average headcount
  • New hires
  • Terminations
  • Turnover rate
  • Headcount movement by department
  • Attrition rate by department
  • Monthly leavers by department

Payroll cost and recruiting

Payroll, overtime, absence costs and recruiting effectiveness.

  • Payroll cost
  • Overtime hours
  • Absence rate
  • Offer acceptance rate
  • Monthly payroll cost by department
  • Weekly overtime hours by department
  • Recruiting by department

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 good output per employee change compared with last month?”
  • “What is driving overtime hours per 1,000 good units this quarter?”
  • “Show payroll cost per good unit by month for the last six months.”
  • “Where is absence days highest this month, and why?”

31 defined metrics

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

MetricDefinitionUnit
Good output per employeeGood output (net of scrap) of the plant in the period divided by average headcount for the period (all departments).= Good output / Average headcountNumber
Overtime hours per 1,000 good unitsTotal employee overtime hours in the period times 1,000 divided by good output in the same period; a rise means the plant needs more overtime to produce the same volume.= Overtime hours * 1000 / Good outputNumber
Payroll cost per good unitTotal payroll cost (salary, allowances, overtime, employer-paid insurance) for the period divided by good output in the same period.= Payroll cost / Good outputCurrency
Absence daysNumber of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other).Count
Absence rateAbsence days divided by scheduled working days.= Absence days / hr_scheduled_daysRatio (%)
ApplicantsNumber of candidates who applied in the period (by application date).Count
Average headcountAverage number of active employees per day in the period.= hr_headcount_days / hr_snapshot_daysNumber
Average monthly cost per employeePayroll cost divided by the number of payslips (one employee-month each).= Payroll cost / hr_payslipsCurrency
New hiresNumber of employees with a start date in the period.Count
Offer acceptance rateOffers accepted divided by offers sent in the period.= hr_offers_accepted / Job offers sentRatio (%)
Job offers sentNumber of candidates sent a job offer in the period (by offer date).Count
Overtime hoursTotal overtime hours recorded in timesheets.Number
Payroll costTotal employer cost of personnel: base salary, allowances, overtime pay and employer-paid insurance. Payroll is recorded monthly, on the first day of the month.Currency
TerminationsNumber of employees whose last working day falls in the period, both voluntary and involuntary.Count
Average time to hire (days)Average number of days from application to offer date for hired candidates, by offer date.= hr_hire_days_total / hr_offers_acceptedNumber
Turnover rateTerminations in the period divided by average headcount for the period.= Terminations / Average headcountRatio (%)
Voluntary terminationsNumber of employees who resigned, with their last working day in the period.Count
Voluntary turnover rateVoluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcountRatio (%)
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, hr_employee

Add if you have it (unlocks more metrics)

downtime_event, quality_inspection, hr_payroll, hr_attendance, hr_candidate

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, hr_employee.

  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 31 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 · HR with your own data

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