Skip to content

Dashboard templates

Manufacturing · Sales

A make-to-order factory with a B2B sales team selling to OEMs, distributors and projects. Output, OEE, downtime and quality plus opportunities, win rate, quota attainment and book-to-bill (new contracts versus output).

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

For factory B2B sales teams selling to OEMs, distributors and projects. The "Contracts and output" dashboard shows the book-to-bill ratio, so you know whether new orders are enough to keep the factory running. The "Opportunities and quota" dashboard tracks opportunities, win rate, average contract value, sales cycle and quota attainment, with the output, OEE and quality dashboards alongside. Needs machine, item, production order, machine shift and sales opportunity data.

Use this template to

  • Know whether this month's new contracts cover factory output.
  • Track win rate by opportunity source.
  • Warn production early when the sales cycle gets longer.

5 ready-made dashboards

Contracts and output

Contract value closed by the sales team versus factory output value (book-to-bill), plus the on-time work order completion rate.

  • Book-to-bill ratio
  • Won amount
  • Output value
  • On-time completion rate
  • Monthly book-to-bill
  • Monthly won contract value
  • Monthly output value
  • Won contract value by team

Opportunities and quota

New opportunities, win rate, closed value and quota attainment of the sales team.

  • Won amount
  • Win rate
  • Open pipeline value
  • Average sales cycle (days)
  • Results by salesperson
  • Quota attainment by team
  • Win rate by opportunity source
  • Monthly closed value by region

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 book-to-bill ratio change compared with last month?”
  • “What is driving average deal size this quarter?”
  • “Show average sales cycle (days) by month for the last six months.”
  • “Where is lost opportunities highest this month, and why?”

24 defined metrics

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

MetricDefinitionUnit
Book-to-bill ratioValue of contracts won in the period divided by output value (at standard selling price) in the same period. Above 1 means sales is booking more than the plant produces and the order backlog grows; below 1 means the plant will soon run short of work.= Won amount / Output valueRatio (%)
Average deal sizeWon amount divided by the number of won opportunities.= Won amount / Won opportunitiesCurrency
Average sales cycle (days)Average days from creation to win for opportunities won in the period.= won_cycle_days_total / Won opportunitiesNumber
Lost opportunitiesNumber of opportunities lost, by close date.Count
New opportunitiesSales opportunities created in the period (by creation date), including open, won and lost ones.Count
Open pipeline valueTotal value of opportunities created in the period that are still open (neither won nor lost).Currency
Sales targetTotal sales targets of sales reps. Targets are set monthly and recorded on the first day of the month.Currency
Quota attainmentWon amount divided by sales target. Above 100% means the target is exceeded.= Won amount / Sales targetRatio (%)
Win rateWon opportunities divided by all closed opportunities (won plus lost) in the period. Open opportunities are excluded.= Won opportunities / (Won opportunities + Lost opportunities)Ratio (%)
Won amountTotal value of won opportunities, by close date.Currency
Won opportunitiesNumber of opportunities won, by close 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, opportunity

Add if you have it (unlocks more metrics)

downtime_event, quality_inspection, sales_rep, sales_target

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

  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 5 dashboards and 24 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 · Sales with your own data

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