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.

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"

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.

MY FIGURES
On-time orders: __________
In-full orders: __________
On-time-in-full orders: __________
On-time-in-full rate (%): __________

MY REVIEW NOTE
________________________

METHOD
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.

REFERENCE ANSWERS — try first
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%.

Using delivered units as the denominator changes an order-service measure into a quantity measure, and can let an overdelivery hide a failed order.

Specify promised dates, partial-shipment rules and review cutoffs when extending this calculation. Those definitions determine the order-level flags.

Occupational context: O*NET 31.0 Database, USDOL/ETA, Task 8937, occupation 13-1081.00. https://www.onetcenter.org/dl_files/database/db_31_0_csv/task_statements.csv
CC BY 4.0: https://creativecommons.org/licenses/by/4.0/
Original practice material and adaptations by Skill Workbench. USDOL/ETA has not approved, endorsed or tested these additions. O*NET is a trademark of USDOL/ETA.