Safety Stock calculations:

Safety Stock: Past 12 months of Sales ÷ 12.

(Only for class 1 or 2 items; Item status = ‘A’.)

Runs on first day of each month.

Smart PO Requirements calculations:

Available Quantity: Total quantity on-hand + Total quantity Allocated (Allocated Quantity + Quantity Short + Quantity Backordered from IBRBIN file.).

Current Pos: Total Open PO quantity + Total Combined Inbound PO quantity – Total Combined Outbound PO quantity.

Transfers In: Total Open Transfers In quantity + Total Pool Transfers In quantity.

Total Available: Available + Current Pos + Transfers In.

Safety Stock: (Safety Stock Quantity ÷ Days in current month) * Lead Time.

(Lead Time from Buying Controls file IBRGG – 4310; or Lead Time Exceptions file POSMARTLT).

Projected Sales: Sum of Sales Quantities (for Projected Sales months on detail screen) –

Prorated Sale quantity for Current month for last year. ((Sales quantity ÷ Days in current month) * Current day).

Future Orders: Total quantity of Open, Warehouse, Type ‘F’ orders.

Orders with Future Date from Current date to next 9 months.

Total Required: Safety Stock quantity (Class 1 items, and Use Safety Stock flag (from file VNDUDD only) = ‘Y’ +

Projected Sales quantity (Class 1 and 2 items only) +

Future Orders quantity.

Quantity Short: Total Required - Total Available.

Days of Inventory: Available quantity (Safety Stock quantity ÷ 20). 20 = Daily Average.

Suggested Quantity: Same as Quantity Short (this field can be user overridden).

PO UOM Quantity: Suggested quantity converted to PO Unit of measure.

AND rounded up to next full PO Unit of measure quantity, if necessary.

AND rounded up to Buying Increment, if necessary.

AND increased to Minimum Order quantity, if necessary.

Order by Date: Calculate number of Days to order: Days of Inventory – Lead Time. (Maximum 365 days).

Calculate Order Date: Current Date + Days to order.

(If Order by date is older than 1 month before today, force to 1 month before today.)

(If Available quantity is Negative, force Order By date to Current date)

Deliver by Date: Order by Date + Lead Time.