SMI suggested ship calculation details

Use the SMI Suggested Ship Calculation Details page to view the suggested quantity of the part to be shipped by the supplier. This value is calculated using the method specified on the Customer Profile page.

The suggested ship quantity is based on the SMI maximum and minimum quantity, standard pack specified for the part and the quantity of the part on-hand and in-transit.

These methods are used to calculate the suggested ship quantity of the SMI part:

  1. Method1: The result is converted to standard pack. (MAX - MIN)/2 + MIN - QOH - QIT
  2. Method2:
    • Case 1: QTY_PROD1 = ADR * DAYS_PROD1: If (QOH < QTY_PROD1) then SHIP_QTY = CEILING((QTY_PROD1 - QOH + CUR)/ STD.PCK) * STDPCK
    • Case 2: QTY_PROD2 = ADR * DAYS_PROD2: IF ((QOH + QIT - MIN - CUR) < QTY_PROD2) AND (DAYS_PROD2 < DAYS_IN_TRANS) then SHIP_QTY = QTY_PROD2 - QOH - QIT + MIN + CUR
    • Case 3: QTY_PROD2 = ADR * DAYS_PROD2: If ((QOH + QIT - MIN - CUR) < QTY_PROD2) AND (DAYS_PROD2 = > DAYS_IN_TRANS) then SHIP_QTY = QTY_PROD2 - QOH - QIT + MIN + CUR and SHIP_DATE = Second receipt day

Abbreviations used:

  • QOH = Quantity on hand
  • QIT = Quantity In-Transit
  • STDPCK = Standard Pack
  • MIN = Minimum Quantity
  • MAX = Maximum Quantity
  • CUR = Cumulative Underrun (Currently Zero)
  • ADR = Average Daily Release
  • INTR = In-transit Quantity
  • INTRDAYS = In-transit Time in days
  • Scheduled Receipt Dates (whether it is Mon to Friday or Mon to Sunday)
    • 1st Receipt date
    • 2nd Receipt date
  • DAYS_ PROD1 = Number of Production days between today and 1st receipt date including the 1st receipt date.
  • QTY_PROD1 = ADR * DAYS_ PROD1
  • DAYS_ PROD2 = Number of Production days between today and 2nd receipt date NOT including the 2nd receipt date.
  • QTY_PROD2 = ADR * DAYS_ PROD2

Review this information:

Field Name Field Description
Quantity on Hand The quantity of the part available in the inventory.
In-Transit Quantity The quantity of the part that in transit to the ship to location.
In-Transit Time (Days) The number of days required for the shipment to be delivered at the ship to location.
Supplier Managed Inventory Minimum The minimum on-hand quantity of the part permissible at the ship to location. This value is defaulted from the SMI Part page.
Supplier Managed Inventory Maximum The maximum on-hand quantity of the part permissible at the ship to location. This value is defaulted from the SMI Part page.
Standard Pack
Suggested Ship Quantity
Suggested Ship Date