Inventory control fields
Field definitions for inventory control fields.
| Field name | Description | Usage information |
|---|---|---|
| Actual P/Order Lines | Average Total Purchase Order lines per year | The average number of unique purchase order line items in a year calculated over the last 2 years, based on the purchase order date field for Supplier ("SUP") lead-times. |
| Current P/O Lines | Expected Annual Number of Purchase Order Lines based on current reorder levels | The number of orders per year based on the average order quantity and the forecast annual usage. |
| Current Safety Units | Current Safety Stock in units | Calculated based on the Current Min or ROP. |
| Current Turnover | Current Stock Turnover Ratio | This value is calculated as Forecast Usage Value over Stock Holding Value. |
| Intransit SOH | In transit Stock | On Hand Extracted from the ERP - Quantity of Stock on Hand in-transit. |
| Lead Time Code. | Lead Time Code. | Used to designate which lead time value is adopted and displayed. For example, "A - Average" or "S - Stated". |
| Lead Time Sigma. | Lead Time Standard Deviation. | The number of units of an item that can be expected to be used during the time period represented by the lead time variability. |
| Lead Time Variance % Supplier. | Lead Time Variance %. | A measure of the degree of variability in the Supplier Lead Times. |
| OOB Reorder Point | Optimal/Optimal/Best Reorder Point (ROP) | Reorder Point based on "Optimal" Reorder Level Methods and "Best" Forecast Method. |
| OOB Reorder Quantity | Optimal/Optimal/Best Reorder Quantity (ROQ) | Reorder Quantity based on "Optimal" Reorder Level Methods and "Best" Forecast Method. |
| Overshoot | Average Reorder Point (ROP) | Overshoot When Stock on Hand falls below the Reorder Point due to a goods issue. |
| P/Order Lines | Expected Annual Number of Purchase Order Lines | Value based on the solution Recommended Reorder Point and Reorder Quantity. |
| Recommended AOQ | MIO Inventory Optimization Average Reorder Quantity (considers pack size) | Value based on the solution Recommended Reorder Point and Reorder Quantity. |
| Review Lead Time. | Administrative Review (Internal) Lead Time (days) | Clients defined lead time to take into account time taken to review a material requirement and process to a purchase order. |
| ROM | Reorder Method | The Reorder Method (ROM) field is used to determine what values are passed between the ERP and the solution during the Import and Export phases. |
| ROP Method | Reorder Order Point calculation Method. | A drop-down list of selectable parameters for example optimal, hold zero, hold one, define. |
| ROP Parameter | Re-Order Point calculation Parameter | User-defined parameter entered when using some of the non-optimal methods. |
| ROQ Method | Reorder Order Quantity Calculation Method. | A drop-down list of selectable parameters for example optimal, hold zero, hold one, define. |
| ROQ Parameter | Order Quantity Calculation Method Parameter | User-defined parameter entered when using some of the non-optimal methods. |
| Smoothed SOH | Smoothed Average Stock on Hand | This field allows the average stock holding to be tracked by smoothing the past and current stock holding. |
| Stock On Hand | Current Stock On Hand (SOH) | Extracted from the ERP. |
| Total Lead Time | Total Lead Time (days) | Calculated as Review + Selected lead time + Delivery leadtime. |
| Turnover Expected | Stock Turnover ratio | This value is calculated as Forecast Usage Value over Stock Holding Value based on Recommended Reorder Point and Reorder Quantity. |