Operations · Original fictional case
Calculate on-time-in-full performance by order
A logistics reviewer needs an order-level delivery score. Keep timeliness and completeness separate before counting orders that satisfy both.
Related work: Logisticians · O*NET task 8937.
Your source data
| order | requested units | delivered units | on time |
|---|---|---|---|
| A | 10 | 10 | yes |
| B | 5 | 5 | no |
| C | 8 | 6 | yes |
| D | 4 | 4 | yes |
| E | 2 | 3 | yes |
The rules
- Each row is one complete order record at the review cutoff. All five orders belong in the denominator.
- In full means delivered_units ≥ requested_units. Extra units do not earn extra credit.
- On-time-in-full requires both on_time = yes and the in-full condition. Report percentages by order, not by units.
A method you can reuse
- A, C, D and E are on time. A, B, D and E are in full. Each individual rate is four out of five.
- Intersect the two sets: only A, D and E satisfy both, giving three qualifying orders.
- Calculate 3/5 × 100 = 60%. Do not multiply the two 80% rates: these are observed joint outcomes, not independent probabilities.
A common wrong turn
Using delivered units as the denominator changes an order-service measure into a quantity measure, and can let an overdelivery hide a failed order.
Use it in a handoff
Specify promised dates, partial-shipment rules and review cutoffs when extending this calculation. Those definitions determine the order-level flags.
Check your calculation
Enter numbers without currency or percent symbols. A matching result confirms this exercise’s calculation; keep the method in your review note.
See the worked answer
On-time orders: 4
All except B are on time.
In-full orders: 4
Only C is short.
On-time-in-full orders: 3
A, D and E meet both conditions.
On-time-in-full rate (%): 60
3 of 5 orders = 60%.
Source and practice material
Occupational context uses the O*NET® 31.0 Database from the U.S. Department of Labor, Employment and Training Administration, under CC BY 4.0. View the occupation.
Skill Workbench selected and adapted the occupational information and added its own fictional cases, calculations, guidance and worksheets. USDOL/ETA has not approved, endorsed or tested these additions. O*NET® is a trademark of USDOL/ETA.