
Warehouse Reporting
Part of Fulfilment performance reporting
Measuring order cycle time by process stage
Define order cycle timestamps, calculate stage intervals and account for split, incomplete and held orders.
Measure order cycle time between defined events. Show both the total and the intervals that make it up.
Keep orders still waiting in view. A report of completed orders alone can look faster while the open queue grows.
Choose the start, end and unit
For the full customer wait before dispatch, start at order acceptance. For time the warehouse could act on an order, start when it became eligible for release.
If the measure starts only when work was released, label it as post-release time: it excludes the release wait. End at confirmed physical carrier handover where that event is available. If the record proves only ship confirmation or label creation, use that name instead.
Choose whether the unit is a customer order, fulfilment part or parcel. A split order can have one acceptance event and several handovers.
For an order-level measure of when the whole order left, use the final required part; show partial orders separately while they remain open.
When using a platform status as an endpoint, verify what event changes that status in your workflow. Distinguish a recorded fulfilment status from physical carrier handover.
Key Metrics for Order Cycle Time Reporting
- Unit of measurement
- Customer order, fulfilment part, or parcel
- Start event
- Order acceptance or eligibility for release
- End event
- Confirmed physical carrier handover (or ship confirmation if not available)
- Total cycle time
- From start to end, excluding overlapping stages
Record the stage intervals
| Interval | Start | End | Question |
|---|---|---|---|
| Release wait | Order eligible | Warehouse work released | Was work held or waiting for allocation? |
| Pick queue | Work released | Pick started | Was available work waiting to be assigned? |
| Picking | Pick started | Pick completed | Did a shortage or interruption extend the task? |
| Pack queue and pack | Pick completed | Pack completed | Did the parcel wait or need correction? |
| Dispatch wait | Pack completed | Physical handover | Was a ready parcel waiting for collection? |
Use only intervals supported by dependable events. Retain raw timestamps, time zones, source systems and IDs. Subtract start from end for each interval.
Calculate the total from its own endpoints; overlapping stage durations must not be added as if they were consecutive. Separate active work from waiting time when the records support it.
Order Cycle Time Measurement Process
- Release waitTime from order eligibility to warehouse work release
- Pick queueTime from work release to pick start
- PickingTime from pick start to pick completion
- Pack queue and packTime from pick completion to pack completion
- Dispatch waitTime from pack completion to physical carrier handover
Include open and unusual orders
Define the cohort before calculating a summary. Orders accepted during a period and orders completed during it are different populations.
For an acceptance cohort, show how many remain open at the reporting cut-off and how long they have waited. For a completion cohort, show its count and note that unresolved orders are absent.
Flag missing, duplicated or reversed timestamps. Identify planned holds, cancellations, returns to picking and reopened packs.
Decide whether an authorised hold remains in the customer-facing total and whether a separate operational measure excludes it. Preserve both definitions when both are useful.
Show the median, a slower part of the distribution and the count, rather than one average alone. Compare like order patterns.
Inspect the records behind a delay before attributing it to a stage or worker.
Best Practices for Tracking Order Cycle Time
- Define cohort before calculationUse orders accepted or completed within a reporting period
- Track open ordersShow count and waiting duration at reporting cut-off
- Flag anomaliesMissing, duplicated or reversed timestamps; holds, cancellations, returns
- Report median, not just averageInclude slower distribution segments and counts



