Purchase KPIs & MIS

Definition

Core measures include PR-to-PO cycle time, PO-to-receipt lead time, vendor OTIF, PPV, purchase savings, emergency purchase %, open PO ageing, rejection rate and invoice exceptions.

Objective

Control the activity so requirements are fulfilled with the required quality, quantity, timing, commercial conditions and traceability.

Required Inputs

Approved requirement; item/material master; technical specification; stock and open-order position; required date; supplier information; historical purchasing data; approval limits.

Methodology

Define the requirement → verify inputs → evaluate alternatives → obtain approval → execute → monitor → close and review.

Calculation / Control Logic

Use the relevant dates, quantities, prices and performance measures consistently; document the basis of every calculation.

Worked Industrial Example

For an industrial MRO requirement, apply the framework using the actual item specification, consumption, urgency, supplier lead time, previous purchase information and operational criticality.

Industrial Application

Apply this framework where purchasing decisions affect material availability, inventory value, supplier performance, production continuity and working capital. Connect the activity with Stores, Inventory, Planning, Quality, Finance and ERP records.

Decision Rules

• Use approved requirements and current master data.
• Prioritize critical material availability without bypassing necessary controls.
• Use comparable commercial and technical bases when evaluating alternatives.
• Document exceptions, assumptions and approvals.
• Review recurring deviations for root cause and corrective action.

Controls

Maintain authorization; approved supplier controls; specification discipline; documented commercial evaluation; segregation of duties; exception approval; complete records.

KPIs

Cycle time; supplier OTIF; price variance; quality/rejection; open-order ageing; emergency purchase percentage; compliance and exception rate.

Common Errors

• Buying without a clear technical specification.
• Comparing quotations on different commercial bases.
• Ignoring lead time and existing stock/open orders.
• Selecting suppliers only on quoted unit price.
• Allowing uncontrolled PO amendments or undocumented exceptions.

Excel / MIS Method

Recommended columns: PR/PO number, date, item code, description, supplier, quantity, rate, delivery date, receipt date, status and variance.

Related References

Inventory Management · Stores Management · Material Planning · Materials Management · ERP & MIS