13.3 Order Management, Trace/Track, and KPIs
Key Takeaways
- Order management translates customer requests into promised dates, inventory reservations, picks, ships, and invoices that distribution and inventory planners must support with ATP and stock accuracy
- OTIF (On-Time In-Full) measures whether deliveries meet the committed date and complete quantity; it is a core distribution service KPI on CPIM
- The perfect order typically requires the right item, quantity, place, time, condition, and documentation—stricter than OTIF alone
- Track-and-trace provides shipment and lot/serial visibility for exception management, compliance, and recall readiness
- Warehouse KPIs such as inventory accuracy, fill rate, order cycle time, and dock-to-stock time tell planners whether execution can support the inventory plan
13.3 Order Management, Trace/Track, and KPIs
Quick Answer: Distribution success is measured by whether customer orders are promised realistically and delivered on time and in full, ideally as a perfect order, with enough track-and-trace visibility to manage exceptions. Inventory planners watch OTIF, perfect-order rate, and warehouse KPIs because poor execution destroys even a correct DRP plan.
Planning distribution (network, DRP, modes) is incomplete without order management and performance feedback. ECM Domain VIII links these execution and measurement topics to the same 8% distribution weight: CPIM candidates must know what “good” looks like and which metrics diagnose inventory versus logistics problems.
Order Management for Inventory Planners
Order management is the process from order capture through fulfillment and post-delivery. Planners care because every promise consumes ATP and every miss becomes expedite demand or lost sales.
Core flow (planner-relevant steps)
- Order entry / capture — customer request, channel (EDI, portal, sales).
- Availability check — ATP or allocation against on-hand, inbound, and rules (customer priority, fair-share).
- Promise date — based on stock location, pick/pack time, and transit; must match network capability from 13.1.
- Release to warehouse — pick wave, packing, shipping documents.
- Ship confirmation — inventory relief, carrier handoff, track events start.
- Delivery / proof of delivery — feeds OTIF and dispute resolution.
- Returns / exceptions — reverse logistics and inventory adjustment.
Planner failure modes
| Symptom | Likely planning/execution cause |
|---|---|
| High promise rate, low OTIF | Over-promising ATP; ignoring DC capacity or carrier cutoffs |
| Inventory “available” but pick fails | Inventory accuracy / location errors |
| Frequent partial shipments | Safety stock or lot rules too tight; allocation conflicts |
| Constant air expedites | DRP parameters or mode design wrong; demand spikes not in S&OP |
CPIM vignettes often ask which action fixes OTIF: sometimes inventory policy, sometimes promise logic, sometimes warehouse process—read which stage failed.
OTIF — On-Time In-Full
OTIF (also called on-time, in-full delivery) evaluates a delivery (or order line, depending on definition) against two conditions:
- On-time: delivered by the committed date/window (customer-requested or agreed promise—companies must define which).
- In-full: complete quantity of the correct items without unauthorized short ships.
Both must pass for the delivery to count as OTIF success. A shipment that arrives on the promised day at 90% quantity fails; a complete shipment two days late also fails.
| OTIF design choice | Why it matters |
|---|---|
| Line-level vs order-level | Order-level is stricter (one missing line fails the order) |
| Customer-requested vs first promise date | Changing promises can “game” on-time unless frozen |
| Delivery vs ship date | Retailers often care about delivery appointment; some score ship date |
| Tolerance windows | Same-day windows vs ±1 day change scores dramatically |
Inventory planner use: Rising OTIF problems concentrated on specific SKUs often point to forecast/DRP/safety stock. Problems across all SKUs at one DC point to labor, WMS, or carrier issues. Problems only on long-distance lanes suggest mode/transit variability.
Perfect Order
The perfect order is a stricter, multi-attribute service construct. Definitions vary by company, but ASCM/operations teaching typically includes some combination of:
- Right product (item/SKU)
- Right quantity
- Right place (ship-to / DC)
- Right time (on-time)
- Right condition (undamaged, correct temperature if applicable)
- Right documentation / invoice / labeling / compliance paperwork
| Metric | Scope | Typical relationship |
|---|---|---|
| Fill rate | Quantity available vs requested at order time | Inventory-centric |
| OTIF | Time + quantity against commitment | Service + logistics |
| Perfect order | OTIF plus quality, docs, place accuracy | End-to-end excellence |
A delivery can be OTIF yet fail perfect order if product arrives damaged or with wrong paperwork. Exam questions use perfect order to test whether you recognize broader fulfillment quality beyond inventory availability alone.
Illustrative score
Suppose 1,000 orders: 920 on-time, 940 in-full, but only 880 both on-time and in-full → OTIF = 88% if measured at order level on both criteria. If 20 of those 880 have damage or invoice errors, perfect order ≈ 86%. Planners should not celebrate fill rate alone when perfect order lags.
Track and Trace
Track-and-trace is the capability to know where a shipment or product unit is (and often where it has been) in the supply chain.
Tracking (shipment visibility)
- Carrier events: picked up, in transit, out for delivery, delivered, exception.
- Supports proactive customer communication and OTIF exception management.
- Helps planners see pipeline inventory accuracy—stock “on order” that is delayed should update expected receipts in DRP.
Tracing (product genealogy)
- Lot, batch, or serial history from supplier/plant through DC to customer.
- Critical for recalls, regulated goods, warranty, and counterfeit control.
- Inventory accuracy and lot control in the WMS enable tracing; without them, tracing is paperwork fiction.
| Need | Track | Trace |
|---|---|---|
| “Where is order 45821?” | Primary | Secondary |
| “Which customers got lot L-99?” | Secondary | Primary |
| Updating DRP for delayed TL | Primary | Rarely |
| FDA/food safety recall | Supports logistics | Essential |
For CPIM, connect visibility to planning quality: unknown delays create surprise stockouts; blind lot control creates recall chaos and write-offs.
Warehouse KPIs Relevant to Inventory Planners
Warehouse operations own many metrics; inventory/distribution planners should monitor those that validate whether the plan can be executed and whether inventory records are trustworthy.
| KPI | What it measures | Why planners care |
|---|---|---|
| Inventory accuracy (location/SKU) | System vs physical | Bad accuracy → false ATP, failed picks, phantom stock |
| Fill rate / line fill | Demand satisfied from stock | Direct service outcome of inventory policy |
| Order cycle time | Order release → ship | Long cycles inflate promised lead times |
| Dock-to-stock time | Receipt → available to promise/pick | Delayed putaway hides inventory from ATP |
| Lines picked per hour | Labor productivity | Capacity constraint on DRP-driven peaks |
| On-time ship | Orders leaving by cutoff | Upstream of delivery OTIF |
| Damage / shrinkage rate | Loss and quality | Erodes perfect order; forces extra safety stock |
| Backorder rate | Unfilled demand | Signals safety stock, supply, or allocation issues |
Diagnostic pairs
- High book inventory + low fill rate → accuracy or reservation problems.
- High fill rate + low OTIF → logistics/carrier/promise-date issues more than stockout.
- Low dock-to-stock + rising expedites → receipts not available in system when DRP expected them.
- Perfect order << OTIF → damage, docs, or labeling—not only inventory quantity.
Closing the Plan–Execute–Measure Loop
- Plan network, DRP, safety stocks, modes (13.1–13.2).
- Promise with ATP aligned to real DC and transit capability.
- Execute picks, ships, track events.
- Measure OTIF, perfect order, warehouse KPIs.
- Adjust parameters, allocations, and S&OP assumptions.
Domain VIII questions reward candidates who treat KPIs as diagnostic tools, not vanity scores. If OTIF falls after a network change, ask whether inventory fragmentation, longer dock-to-stock, or unrealistic promise logic is the cause—then fix the matching lever.
Study Focus
Know OTIF = on-time AND in-full, perfect order as a stricter multi-attribute measure, track vs trace purposes, and which warehouse KPIs prove inventory record quality and fulfillment speed. Tie every metric back to a planner action: change safety stock, ATP rules, lead times, lot sizes, or escalate warehouse process defects.
A shipment arrives on the promised delivery date with only 80% of the ordered quantity. How should OTIF treat this delivery under a standard on-time and in-full definition?
Which outcome best illustrates a perfect-order failure that might still pass a basic OTIF check?
A planner needs to know which retail customers received finished-goods lot L-220 after a quality hold. Which capability is primarily required?
Book inventory shows ample stock and ATP promises are high, yet pickers frequently cannot find product and fill rate is poor. Which warehouse KPI should the inventory planner investigate first?