Calculators & KPIs

KPI & Calculator Pack

OEE, time study, scrap cost, capacity, ROI and a manufacturing KPI dashboard.

About this toolkit

Six working calculators, not six blank spreadsheets. The manufacturing KPI dashboard for the monthly review; OEE with availability, performance and quality broken out; a time study calculator; scrap cost; capacity planning; and an ROI calculator for justifying the improvement you want to make.

Every one shows its working. An OEE of 62% tells you nothing on its own — what you need is which of the three components lost the points and what that costs, and that is what these are built to produce.

The ROI calculator is the one that gets projects approved. It is also the one most people build badly under time pressure.

What's included

  • 6 editable templates
  • 10 editable Excel workbooks
  • 2 editable Word templates
  • 2 print-ready PDFs
  • 3 completed worked examples
  • Sections: KPI and Analytics
  • A START HERE guide and a document index

Who it is for

  • Production and CI engineers
  • Supervisors reporting line performance upward
  • Anyone asked for OEE who has no system that produces it

What people use it for

  • Reporting OEE without buying a monitoring system
  • Costing scrap so it stops being an abstraction
  • Justifying a capital request with a defensible number

What you need

  • Microsoft Excel 2016 or newer (or LibreOffice Calc)
  • Microsoft Word 2016 or newer (or LibreOffice Writer)
  • A PDF reader for the print-ready forms
  • No macros, no add-ins and no internet connection required

Specification

File formats
ZIP
Files included
1 file
Version
v1.0
Last updated
2026-09-06
Licence
Single company — Use across one company, on as many machines and by as many staff as you like. Not for resale or redistribution outside it.
SKU
VTX-KPI-09
Delivery
Instant download after payment

Questions about this product

Do these connect to our machines?

No — you enter the data. If you want automatic capture from the machines themselves, that is a system we build; get in touch.