Where should pending work be reviewed first?
Which of the three channels has the most unfulfilled orders at the end of the period?
| Channel | Orders | Fulfilled | Pending | Known returns |
|---|---|---|---|---|
| Counter | 597 | 563 | 34 | 33 |
| Online shop | 502 | 438 | 64 | 26 |
| Phone | 295 | 274 | 21 | 13 + ? |
Pending orders by channel
Counter: 34
Online shop: 64
Phone: 21
Common scale: 0 to 80 orders. All bars start at zero.Start by reviewing the online-shop workflow: it accounts for 64 of the 119 pending orders. This is a signal to investigate the operation, not proof of a cause.
The phone return count for week 7 is missing. Known returns are a minimum, not a complete total. This gap does not change pending counts, calculated from the complete orders and fulfilled fields.
Each order belongs to one channel and week. A return belongs to the fulfilled-order cohort; it is not added to pending orders. Figures count orders, never revenue, units sold or profit.
Answers explained
1. How many online-shop orders are pending at the end of the period?
502 orders − 438 fulfilled = 64 pending. Use the same period and channel for both fields. Returns do not enter this difference.
2. How should the unrecorded phone return count in week 7 be treated?
A blank cell does not prove that no returns occurred. Preserve the gap. The backlog question can still be answered because orders and fulfilled counts are complete.
3. Which workflow should be investigated first, using the largest pending count as the criterion?
The online shop has the largest pending count: 64. This is an investigation priority, not a conclusion about the cause or an automatic decision to expand the team.
Before and after: why does the reading change?
The “Before” example shows received orders by channel. The figures are true within this exercise, but the chart does not reveal unfinished work. Concluding that the highest volume deserves the first review would skip a step.
The “After” example uses the appropriate measure: orders minus fulfilled, aggregated over the same twelve weeks. All bars start at zero, share the same scale and state the unit — pending orders.
One possible conclusion
A useful conclusion can be short: “At the end of the twelve weeks, the online shop accounts for 64 of 119 pending orders. I propose reviewing its handoffs first and checking whether the backlog remains concentrated there.”
Add the limits: we do not have waiting times per order or an explanation for delays. One phone return figure is missing. An operational recommendation is a working hypothesis, not a guarantee of improvement.