The short answer
Production planning reports and KPIs turn a plan into evidence. The reports show what the plan decided — the demand it captured, the material it netted, the work orders and purchase requisitions it raised, and the machine load it created. The KPIs show how well the plan ran — whether the floor made what was planned, on time, using its machines well, at standard, without running short of material. A good planning system produces both from one dataset, so the report you release and the KPI you are judged on reconcile instead of contradicting each other.
The five metrics that matter most are plan attainment (actual output against planned), schedule adherence (work orders finished by their due date), machine utilization (running time against available time), efficiency (standard time earned against actual time), and OEE (Availability × Performance × Quality). Everything else — shortage incidents, requisition ageing, reorder breaches — supports those five. This guide walks each report and each KPI, gives the formula, and shows how production planning software generates them from a single run.
The reports every planning run produces
A single MRP run and its execution leave a trail of reports. Each answers a different question, and each has a natural audience — planner, buyer, or supervisor.
| Report | Answers | Read by |
|---|---|---|
| Sales / production plan report | What demand did we commit to for the horizon, exploded through the BOM? | Planner |
| RM / bought-out plan report | What is the netted buy requirement — raw material and purchased items? | Buyer |
| Component plan report (SFG / OSL) | What must we make in-house vs send out for processing? | Planner |
| Stock reservation report | Which inventory is committed to which plan, so it is not double-counted? | Planner / stores |
| Reorder-level dashboard | Which items are below reorder point right now, and what PR do they suggest? | Buyer |
| Machine loading report | Which machines are over capacity this period, and which have slack? | Planner / supervisor |
| Schedule / Gantt board | In what sequence, and on which machine, will work orders run? | Supervisor |
| Work-order history & completion | What is the status of each work order, and what has been booked complete? | Planner / supervisor |
| Plan vs actual, OEE dashboard | Did the floor make what was planned, and how effectively did machines run? | Management |
The important thing is that these are not nine separate exports stitched together in a spreadsheet. In a real planning system they are all views of the same underlying records — the plan, the netted requirement, the reservations, the work orders and their booked actuals — so the buy-side report and the plan-vs-actual dashboard cannot disagree about how much was planned. That single source is what makes the numbers trustworthy enough to act on.
The KPIs that matter, with formulas
A report is a list; a KPI is a ratio you can trend. These are the metrics worth putting on a wall board, grouped by the question they answer.
| KPI | Formula | What it tells you |
|---|---|---|
| Plan attainment | Actual good output ÷ planned output | Whether the plan was realistic and the floor delivered it |
| Schedule adherence / OTD | WOs completed by due date ÷ total WOs due | Whether sequencing and capacity are holding due dates |
| Machine utilization | Running time ÷ available time | How much of a machine's time was actually used |
| Efficiency | Standard time earned ÷ actual time taken | Whether operations ran at, above or below standard |
| OEE | Availability × Performance × Quality | Combined effectiveness of a machine or work centre |
| Rejection / rework rate | Not-OK quantity ÷ total produced | Where quality loss is eating capacity |
| Shortage / stockout incidents | Count of reorder breaches or missed material | Whether netting and reorder levels are catching demand |
| PR / WO ageing | Days from raised to actioned / closed | Whether the buy and make queues are flowing |
Plan attainment is the one every management review opens with. If it sits consistently below 100%, the plan is optimistic — it either ignored capacity or trusted standard times the floor cannot hit — and the honest fix is to correct the inputs, not to exhort the floor. Schedule adherence is its partner: a plant can attain quantity while still missing dates if the sequence is wrong, so the two are read together. Plan-vs-actual, utilization, efficiency and OEE dashboards tie them to the machine level.
Where the numbers come from
None of these KPIs are typed in. They are computed from two streams: the plan (what was intended) and the booked actuals (what happened). The plan side comes from the MRP run — planned quantities, standard cycle and setting times on each work-order operation, and due dates. The actual side comes from the shop floor booking progress against each operation.
The feedback loop in the last step is what separates a plant that improves from one that repeats its mistakes. When actual cycle times replace optimistic standards in the next run, plan attainment climbs not because the floor tried harder but because the plan finally asked for something achievable. Capturing that data cleanly needs booking at source — by barcode and machine-data capture — rather than a clerk reconstructing the shift from memory.
Utilization vs efficiency vs OEE
Three metrics get confused constantly, and confusing them sends improvement effort to the wrong place. They answer different questions about the same machine.
The practical rule: a machine that is highly utilized but inefficient is running all shift and still falling behind standard — chase setup time, tooling and speed. A machine that is efficient but under-utilized is fast when it runs but idle too often — chase material feeding, sequencing and breakdowns. OEE catches both, but you need utilization and efficiency separately to know which lever to pull. The full derivation lives on the Plan vs Actual & OEE feature page, and the companion guide on improving OEE and machine utilisation works the levers in detail.
Still assembling planning KPIs in a spreadsheet?
We can show you plan attainment, schedule adherence, utilization, efficiency and OEE computed live from your own work orders and shop-floor bookings — in 30 minutes, on your own data.
Building a planning dashboard and cadence
Most KPI programmes fail not from a shortage of numbers but from reviewing everything at the wrong frequency. Match the cadence to the decision the metric drives.
- Live / per shift — machine loading and the reorder-level dashboard. These drive an action today: level an overload, raise a PR before stock runs out. A weekly view of these is a post-mortem.
- Daily — plan attainment and schedule adherence against the running plan, so a slipping work order is re-sequenced before it drags the week.
- Weekly and monthly — utilization, efficiency, OEE and rejection trends, to see whether the plant is genuinely improving rather than reacting.
A workable dashboard shows the live metrics as a top strip that a planner glances at hourly, the daily metrics as the working middle, and the trend metrics as charts underneath for the review meeting. Alerts — WhatsApp, email and SMS — should fire on the live layer only: a machine crossing 100% loading, or an item breaching reorder. Trend metrics do not need alerts; they need a meeting.
What a tight KPI loop changes
A precision-component shop was running a monthly OEE report and little else. Machine load lived in a supervisor's head, so overloads surfaced only when a job was late, and purchasing reacted to shortages after they bit. Moving the live layer — machine loading and the reorder dashboard — to a per-shift view, and reviewing plan attainment daily against booked actuals, changed the questions the morning meeting asked. Instead of explaining last month's OEE, the planner was levelling this shift's overload and clearing a reorder breach before it stopped a line. The monthly OEE number still mattered for trend, but it was no longer the only thing anyone measured — the profile behind real automotive and precision deployments.
Job-work, OSL and India-specific reporting
For Indian manufacturers, two reporting realities sit on top of the standard KPIs. First, outsourced (OSL) and job-work planning: a large share of components are sent out for processing — plating, heat treatment, machining — and the component plan report splits the netted make requirement into in-house semi-finished (SFG) and outsourced (OSL) lines so a planner can see what is going out of the gate versus staying in. Tracking those OSL work orders is as much a planning KPI as machine load, because a delayed job-worker misses a due date just as surely as an overloaded machine.
Second, the GST and ITC-04 angle. Goods sent to a job-worker and returned are reported through the ITC-04 return, and the movement of material out and back has to reconcile with what the plan sent. A planning system that already tracks OSL work orders against the plan gives you the movement trail those filings rest on — though the return itself is a compliance task, and you should confirm the treatment and thresholds with your CA rather than treat any planning report as tax advice. Indicative INR pricing for the planning module is on the pricing page; again, confirm the commercials that apply to you.
How Fast Planning delivers these reports
Fast Planning Software — built by Improsys in Pune under the Fast Technology brand, cloud or on-premise — produces every report and KPI above from one planning run, because the report and the metric read the same records.
Frequently asked questions
What are the most important production planning KPIs?
The core production planning KPIs are plan attainment (actual output against the planned quantity), schedule adherence or on-time completion (work orders finished by their due date), machine utilization (running time against available time), efficiency (standard time earned against actual time taken), and OEE (Availability × Performance × Quality). Around them sit material metrics — shortage or stockout incidents, reorder breaches, and purchase-requisition and work-order ageing. Together they answer four questions: did we make what we planned, on time, using our machines well, at standard, without running short of material.
What is the difference between machine utilization and efficiency?
Utilization asks whether a machine's available time was used — running time divided by available time — so idle time and breakdowns pull it down. Efficiency asks how well that time was used — the standard time earned by good output divided by the actual time taken — so a slow cycle or rework pulls it down. A machine can be highly utilized but inefficient (running all shift but slower than standard) or efficient but under-utilized (fast when it runs but idle half the day). Reading both together, alongside OEE, is what tells a planner where the real loss is.
What is plan attainment or plan-vs-actual?
Plan attainment, or plan-vs-actual, is the planned quantity, time and completion date for each work order set against what the shop floor actually produced and when. Expressed as a percentage it is actual good output divided by planned output for the period. It is the honesty check on every plan: if attainment is consistently below 100% the plan is over-optimistic — usually because it ignored capacity or used standard times the floor cannot hit — and the numbers that feed the next plan need correcting.
Which reports does an MRP run produce?
A planning run produces a sales or production plan report (demand as entered and exploded), a raw-material and bought-out plan report (the netted buy requirement), a component plan report split into semi-finished and outsourced items (the netted make requirement), a stock reservation report (what inventory is committed to which plan), and a reorder-level dashboard (items below their reorder point with suggested purchase requisitions). Execution then adds machine loading reports, a schedule or Gantt board, work-order history and completion, and plan-vs-actual, utilization, efficiency and OEE dashboards.
How often should planning KPIs be reviewed?
Match the cadence to the decision. Machine loading and the reorder dashboard are live — a planner watches them daily, or per shift, to catch overloads and shortages before they bite. Plan attainment and schedule adherence are reviewed at the end of each shift or day against the running plan. Utilization, efficiency and OEE are trended weekly and monthly to see whether the plant is improving. The mistake is reviewing everything monthly: a monthly OEE number is useful for trend, but a monthly view of machine load is a post-mortem, not a plan.