Netting inventory commitments

The following example describes demand netting of inventory commitments.

Example 3 : Inventory commitments netted against demand orders

Similar to Example 2, after you receive the second purchase order, but now with three pieces on hand available and a received quantity of nine pieces.

An inventory commitment can exist for one specifc demand. For example, an inventory commitment exists for sales order S3 of two pieces. The actual shortage for this sales order is not 10 in this case, but eight. The shortage for S3, however, still appears as 10.

The on-hand quantity is the quantity on hand that is available. This includes the inventory commitment for demand as displayed in the session. The inventory commitments for demand that does not appear in the session is not included in this on-hand quantity.

Note

You must respect the inventory commitment per demand line. As a result, the following applies:

  • The quantity assignments made for a demand line in the DMS session must at least meet the committed inventory for the demand line.
  • The sum of assigned received quantity and assigned on-hand quantity must at least be equal to the committed quantity.

The received quantity is within the force cross-docking range, therefore, first the received quantity is assigned, and then the on-hand quantity.

ItemX
WarehouseWH1
Received Quantity9 pcs.
Inventory on Hand3 pcs.

 

Distribution in the DMS session is as follows:

PriorityDateDemandWHShortageAssigned Received QuantityAssigned InventoryCross-dock Orders
10614-4-2005Sales S4222CD4: 7 pcs. - Planned
20311-4-2005Sales S111071
20513-4-2005 Sales S3252
21215-4-2005 Transfer T215
50020-4-2005Forecast F1220

 

Despite the fact that 12 pieces must be divided, you cannot fulfill demand S1 of 10 pieces, because of an inventory commitment for demand S3.

The available received quantity to be assigned per demand line is calculated as:

received qty - assigned received qty

The available on-hand quantity to be assigned per demand line is calculated as:

on hand - (committed to other demand + commitment to other demand covered by assignments) - on hand assigned to other demand

Calculation of the assigned quantities is as follows:

DemandShortageAvailable received calculationAvailable receivedAvailable on hand calculationAvailable on handAssigned receivedAssigned on hand
S429 - 092
S1109 - 273 - (2 + 10) - 0171
S359 - 903 - (0 + 0) - 122
T25
F120____
Total93

 

The received quantity is outside the force cross-docking range, therefore, first the on-hand quantity is assigned, and then the received quantity.

Distribution in the DMS session is as follows:

PriorityDateDemandWHShortageAssigned Received QuantityAssigned InventoryCross-dock Orders
10614-4-2005Sales S42211CD4: 7 pcs. - Open
20311-4-2005Sales S111080
20513-4-2005 Sales S3252
21215-4-2005 Transfer T215
50020-4-2005Forecast F1220

 

Calculation of the assigned quantities is as follows:

DemandShortageAvailable received calculationAvailable receivedAvailable on hand calculationAvailable on handAssigned receivedAssigned on hand
S429 - 093 - (2 + 0) - 0111
S1109 - 183 - (2 + 0) - 0080
S359 - 1 - 803 - (0 + 0) - 122
T253 - (0 + 0) - 1 - 20
F120____
Total93