Examples
Examples
Try the starting example
- Incoming batches: batch ID, SKU, arrival date, units; or none
- B1,A,2026-10-22,3 B2,A,2026-10-25,3
- Orders: order ID, SKU, units, priority number ascending, promise date
- O1,A,4,1,2026-10-23 O2,A,3,2,2026-10-25
- Projected complete-allocation date by order
- O1: 2026-10-25; O2: Incomplete
- Unallocated units by order
- O1: 0; O2: 1
- Days beyond promise for fully allocated orders
- O1: 2; O2: Unknown: incomplete
- Total units allocated
- 6
- Batch allocation trace
- O1 ← B1: 3; O1 ← B2: 1; O2 ← B2: 2
Try another scenario
- Incoming batches: batch ID, SKU, arrival date, units; or none
- B1,A,2026-10-22,3 B2,A,2026-10-25,3
- Orders: order ID, SKU, units, priority number ascending, promise date
- O1,A,3,1,2026-10-23 O2,A,3,2,2026-10-25
- Projected complete-allocation date by order
- O1: 2026-10-22; O2: 2026-10-25
- Unallocated units by order
- O1: 0; O2: 0
- Days beyond promise for fully allocated orders
- O1: 0; O2: 0
- Total units allocated
- 6
- Batch allocation trace
- O1 ← B1: 3; O2 ← B2: 3
Calculation method
Calculation method
Projected complete-allocation date by order
Process lower priority numbers first, tie by order input; consume same-SKU batches in arrival/input order. Completion is the last assigned batch date, or Incomplete when short.
Unallocated units by order
Order quantity−allocated quantity, without reallocating another order.
Days beyond promise for fully allocated orders
max(0,completion−promise), or explicitly unknown for an incomplete order.
Total units allocated
Sum allocated units across orders.
Batch allocation trace
Show order/batch unit assignments, allowing an order to span multiple incoming batches.
Symbols and units
- a
- Incoming batches: batch ID, SKU, arrival date, units; or none
- b
- Orders: order ID, SKU, units, priority number ascending, promise date
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A deterministic projected allocation from supplied arrival dates and priorities. It does not reserve stock, send orders, predict supplier delivery or infer a lawful customer priority.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Google Merchant Center: product-data terminology and consistency background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.