Scenario: Inventory allocation for the same item across multiple order lines or same-node assignments
The Optimization service supports the same item or SKU across multiple lines in an order. Support is also provided for the same item with different ship dates across multiple, same-node assignments. This scenario applies to orders that, for example, can't be fulfilled from a single node and are rescheduled. This results in the same item being split into multiple order lines or assignments. If the split results in the item being assigned to the same node, either from the same or different lines, the node's available inventory is shared across assignments.
Inventory allocation for the same item in multiple order lines
The following scenarios describe how the Optimization service processes the orders that contain the same item across multiple order lines. These rescheduled orders contain the same SKU or item across multiple order lines. To fulfill these orders optimally, the Optimization service considers the inventory that is available, the shipping costs, the stockouts avoidance costs, or additional optimization parameters.
Scenario 1: Sufficient inventory to fulfill both order lines
In this example, the Optimization service processes a rescheduled order for two order lines of shoes that are available in a store in New York for fulfillment. There is enough inventory available to fulfill this order across each order line separately or across both order lines together.
Order line | SKU | Node | Assigned quantity | Requested quantity | Available quantity | Allocated quantity |
---|---|---|---|---|---|---|
Line 1 | Shoes | NY store | 3 | 3 | 8 | 3 |
Line 2 | Shoes | NY store | 4 | 4 | 4 |
In processing this order, the Optimization service considers the following requested and available quantity:
- Line 1: Requested quantity = 3
- Line 2: Requested quantity = 4
- Line 1 and Line 2: Available quantity = 8 (Shared across both lines)
- Line 1: Allocated quantity = 3
- Line 2: Allocated quantity = 4
Scenario 2: Insufficient inventory to fulfill both order lines
Order line | SKU | Node | Assigned quantity | Requested quantity | Available quantity | Allocated quantity | Shortage |
---|---|---|---|---|---|---|---|
Line 1 | Dress | Chicago store | 3 | 3 | 5 | 3 - 1 = 2 | 2 |
Line 2 | Dress | Chicago store | 4 | 4 | 4 - 1 = 3 |
In processing this order, the Optimization service considers the following requested and available quantity for each order line:
- Line 1: Requested quantity = 3
- Line 2: Requested quantity = 4
- Line 1 and Line 2: Available quantity = 5 (Shared across both lines)
- Line 1: Allocated quantity = 3 - 1 = 2
- Line 2: Allocated quantity = 4 - 1 = 3
Results: For both Line 1 and line 2 order lines for the store, 7 dresses are requested for processing by the Optimization service to fulfill the order. However, there is only a quantity of 5 dresses available. As a result, there is a shortage of 2 dresses to fulfill the order.
In this example, the allocated quantity is calculated by adding the assigned quantity amount across both order lines: (3 + 4) and reducing this by the shortfall amount of 2: (3 + 4) -2 to match the quantity that is available, which is 5. We assume that the shortage of 2 units is evenly distributed between both lines (1 unit per line). For each order line, the allocation reduction amount varies according to shipping costs, stockouts avoidance costs, or additional optimization parameters. As a result, a shortage can be applied to one order line, or distributed across multiple order lines.