Perfect Order Rate Calculator
A perfect order is one that arrives on time, complete, undamaged and with correct paperwork. Customers do not experience your four averages separately, they experience each order as a whole, which is why the combined rate is harsher than any single KPI.
Your numbers
Against the customer promise or request date, per your own rule.
All lines at the ordered quantity within tolerance.
Invoice, packing list, certificates and labels correct first time.
Expedite freight, rework, credit memos and admin time.
Your results
Multiplying rates assumes failures are independent. If your system reports a true order-level perfect order flag, use that instead because overlapping failures make the real rate higher.
Perfect order rate vs on-time rate
Sweeps Orders delivered on time from 50 to 100, holding your other inputs fixed.
Order-level perfect order flag from your ERP
Optional: see how delivery, shortage and document data could be joined into one view.
Optional. The tool and every export work without this. No spam.
How to use the calculator
Enter the four component rates for the same period and order population. The tool multiplies them, then prices the imperfect orders using your own average cost. The chart sweeps the on-time rate so you can see how much headroom you gain by improving delivery alone. Define on-time and in-full the same way across plants, or the combined figure means nothing.
- Decide whether on-time is against request date or promise date
- State your tolerance for in-full, such as plus or minus 2%
- Count orders, not order lines, for the rate
The formula
Perfect order rate = on-time % x in-full % x damage-free % x document-accurate %. With 92, 96, 99 and 97 percent, the result is about 84.8 percent, so roughly one order in seven has some defect. This multiplicative view is the standard SCOR-style definition, and it shows why four good-looking numbers combine into a mediocre outcome.
Reading the result
Start with the weakest component, then check whether failures cluster in a few customers, lanes or product families. If your ERP can tag an order-level flag, the measured rate will usually be higher than the multiplied estimate, because some orders fail on several counts. Use the cost output to build a business case for fixes such as better ATP promising or pack verification.
Common mistakes
Teams often measure on-time at line level but in-full at order level, or ignore partial shipments that the customer accepted. Another trap is moving the promise date after the order is placed. Lock the baseline date at order entry, or report both the original and revised dates.
- Do not exclude customer-caused delays without a written rule
- Include documentation errors, since they delay payment
- Track the cost per imperfect order by cause
Frequently Asked Questions
Is perfect order rate the same as OTIF?
No. OTIF covers only on-time and in-full. Perfect order rate also requires damage-free delivery and accurate documents, so it is always equal to or lower than OTIF for the same population.
What is a good perfect order rate?
Many manufacturers sit between 80 and 95 percent, depending on definitions. Best-in-class operations publish rates above 95 percent, but definitions vary widely, so trend against yourself first.
Why multiply the rates instead of averaging?
An order is perfect only if every condition holds, so the probability is the product, assuming independence. Averaging would hide the fact that an order failing any one test counts as imperfect.
How do I estimate the cost per imperfect order?
Add expedite freight, rework or replacement, credit memos, extra customer service and billing time for a sample of failed orders, then average. Many firms land between 50 and several hundred dollars depending on order size.
If order-level delivery data is spread across the ERP and the carrier portal, we can show how a read-only agent could assemble a perfect order flag by customer.
Related Tools
Order Backlog Coverage and Book-to-Bill Calculator
Convert backlog into weeks of coverage, compute book-to-bill and project where the backlog goes if orders and shipments stay on trend.
Costing & FinanceKPI Target Attainment Scorecard Worksheet
An editable scorecard that calculates attainment for each KPI, whether higher or lower is better, with an owner and an ERP data source on every row.
Costing & FinanceCash Conversion Cycle Calculator
Combine days inventory, days sales outstanding and days payable into one cash conversion cycle, and see how many days and how much cash each lever is worth.
Industry TemplatesMonthly Operations Review Meeting Pack Template
A ready-to-fill monthly operations review document covering results, KPI table, variances, risks, actions and approvals.
More Supply Chain & Inventory tools
See all- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator
- EOQ with Vendor Minimum Order Calculator