Skip to content

Dashboard templates

Manufacturing · Operations

A make-to-order factory that buys steel, stainless steel, blanks, paint and packaging from suppliers, keeps materials and finished goods at the plant warehouse and delivers to B2B customers. Output, OEE, downtime and quality plus supplier on-time rate, inventory, stockouts, deliveries, material purchases and days of inventory versus output value.

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

For purchasing and warehouse managers at factories buying steel, blanks, paint and packaging and delivering to B2B customers. The "Materials and output" dashboard shows days of inventory by output value and material purchases as a share of output value. The "Purchasing and inventory" and "Warehouse deliveries" dashboards track supplier on-time delivery, fill rate, lead time, stockout days and on-time delivery. Needs machine, item, production order, machine shift and inventory snapshot data.

Use this template to

  • Cut excess material stock relative to real production needs.
  • Rank suppliers by on-time and complete delivery ahead of negotiations.
  • See which carrier has the most failed deliveries.

6 ready-made dashboards

Materials and output

Factory material purchases and inventory next to output value; stockouts by group and late suppliers.

  • Material purchases to output ratio
  • Days of inventory (output value)
  • Average inventory value
  • Output value
  • Monthly material purchases vs output value
  • Monthly days of inventory
  • Average inventory by group
  • Stockout days by group
  • On-time delivery rate by supplier

Purchasing and inventory

Purchase orders, supplier on-time and in-full delivery, lead time, average inventory and stockouts.

  • Purchase order value
  • Supplier on-time rate
  • Average inventory value
  • Stockout item-days
  • Results by supplier
  • Average inventory by item group
  • Stockout days by item group
  • Weekly average inventory by warehouse

Warehouse deliveries

Deliveries, on-time and failed delivery rates by warehouse and carrier.

  • Shipments
  • On-time delivery rate
  • Failed delivery rate
  • Failed shipments
  • Delivery results by warehouse
  • Failed delivery rate by carrier
  • Weekly failed delivery rate by warehouse

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 days of inventory (output value) change compared with last month?”
  • “What is driving material purchases to output ratio this quarter?”
  • “Show average inventory value by month for the last six months.”
  • “Where is average supplier lead time (days) highest this month, and why?”

28 defined metrics

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

MetricDefinitionUnit
Days of inventory (output value)Average inventory divided by average daily output value. With daily inventory snapshots, this equals the sum of snapshot values divided by output value for the period. Shows how many days of production the material and finished goods inventory represents.= ops_inventory_value_total / Output valueNumber
Material purchases to output ratioValue of material purchase orders placed in the period divided by output value (at standard selling price) in the same period. A spike means buying more than production needs (building material stock); a sharp drop means drawing down inventory.= Purchase order value / Output valueRatio (%)
Average inventory valueAverage end-of-day inventory value in the period = sum of snapshot values divided by the number of days with a snapshot.= ops_inventory_value_total / ops_snapshot_daysCurrency
Average supplier lead time (days)Average days from order to receipt for purchase orders received in the period.= ops_lead_days_total / Received purchase ordersNumber
Failed delivery rateFailed or returned shipments divided by all outbound shipments in the period.= Failed shipments / ShipmentsRatio (%)
Failed shipmentsOutbound shipments in the period that failed delivery or were returned to the warehouse.Count
On-time delivery rateOn-time deliveries divided by all outbound shipments in the period (by ship date).= ops_on_time_deliveries / ShipmentsRatio (%)
Purchase ordersPurchase orders placed in the period (by order date), excluding cancelled orders.Count
Purchase order valueTotal ordered value (ordered quantity times unit price) of purchase orders placed in the period, excluding cancelled orders.Currency
Received purchase ordersPurchase orders received in the period (by receipt date), including partial receipts.Count
Received goods valueTotal received quantity times unit price for purchase orders received in the period (by receipt date).Currency
ShipmentsOutbound shipments from the warehouse in the period (by ship date), any outcome.Count
Stockout item-daysInventory snapshots with zero (or negative) quantity in the period: each item out of stock at one warehouse on one day counts as 1.Count
Supplier fill rateReceived value divided by ordered value of purchase orders received in the period. 100% means delivered in full; lower means the supplier short-shipped.= Received goods value / ops_closed_po_valueRatio (%)
Supplier on-time rateOn-time PO receipts divided by received purchase orders in the period (by receipt date).= ops_on_time_receipts / Received purchase ordersRatio (%)
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, ops_inventory_snapshot

Add if you have it (unlocks more metrics)

downtime_event, quality_inspection, ops_supplier, ops_item, ops_purchase_order, ops_purchase_order_line, ops_shipment

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

  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 28 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 · Operations with your own data

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