The number of months history that we have for that item - either from the creation date of the item, or from the first date of sale.

Stock-on-hand that has been set aside and is not available for sale or issue.

Is the sum of Stock on hand - Overdue demand - Allocated stock. It is the amount of inventory available to sell or use.

The cost price of the item used to valuate the inventory.

The quantity associated with a firm sales/customer order where the expected delivery date has passed today's date.

The list of all raw material items along with their quantity needed to make a finished good item.

The categorization of item codes into volume and value based groupings (HML & ABC) depending on their contribution to total sales/forecasts.

The 3×3 square of blocks where the rows represent value based sales/forecast movement, and the columns represent volume based sales/forecast movement. Each block represents a number of stocked product codes that indicate their importance to the business based on their sales/forecast movement.

The average monthly value of sales, at cost price, over the last 12 months.

The period of time defined as Lead Time + Safety Stock + Replenishment Cycle. Also defined as the Order-up-to quantity.

The number of days that the current level of inventory will last based on forecasted demand assuming no further purchase orders arrive.

The number of days by which the safety stock has been adjusted to its current level.

The structure where branches or locations are supplied by a Distribution centre instead of external vendors. The Distribution centre is, however, supplied by external vendors.

An item whose net stock position exceeds the calculated Order-up-to or maximum level. The value of excess is defined as the amount of stock only exceeding the Order-up-to level.

The percentage stock availability measured over a historic rolling 30 day period.

The targeted stock availability percentage.

It is expressed as a percentage, which is the amount by which the location's achieved fill rate has been decreased as a result of the item’s achieved fill rate being less than 100%. For example, a fill rate impact of 2% means that the item is responsible for reducing the location's achieved fill rate by 2%. The best fill rate impact is 0% which means the item has not been out of stock recently.

The formula to calculate an item’s fill rate impact is as follows:

(100 - item achieved fill rate) * item forecast / location forecast

The level of historic over- and under-forecasting when compared with actual sales.

The percentage risk calculated due to historic forecasted demand exceeding or lagging actual sales.

The historic 12 month horizon forecasting attempts, by month, for the past 12 months.

The number of months an item sold out of the last 12.

The date on which the last set of data was extracted from the host database and processed.

The period of time from deciding to place a purchase order with a supplier, to when it is available for sale to the customer. In the case of production lead time, it is the time from when the raw stock is requested to when it is available to production.

The measurement of supplier lead time based on early or late deliveries.

The number of days worth of projected future orders to accumulate into today's order.

The value of forecasted sales to be lost due to being out of stock.

The difference between the selling price and the Average cost price.

A purchasing constraint imposed by a vendor where a minimum initial amount of stock may be ordered per order.

The average level of stock over the current replenishment cycle period that is regarded as ideal for the currently associated risk factors for the item. The Model stock level is defined as Safety Stock + 1/2 Replenishment Cycle.

The level of inventory defined as stock-on-hand minus backorders minus allocated stock plus open purchase orders.

An item not held in inventory but still on the price list for ordering should demand require it. An item that has not sold for a long time, typically a 12 month period.

An item that has not had any sales for an extended period of time, typically 24 months, and therefore no inventory is planned to be held at this time.

The quantity of open and outstanding purchase orders.

A purchasing constraint imposed by a vendor where the order amount greater than the Minimum Order Quantity must be ordered in multiples rather than in single units.

The maximum level of stock required for inventory optimization. Defined as the Lead Time + Safety Stock + Replenishment Cycle.

The quantity associated with an open and outstanding supply order where the Expected Arrival Date has passed today's date.

Where historical forecasts have exceeded actual sales. Over-forecasting leads to excess stock.

An item whose net stock position is potentially going to drop to zero before the next purchase order arrives. Action over and above placing an order based on the normal lead time is required to prevent a stock-out from happening. The Potential stock-out value is defined as the value of sales that will be lost inside the lead time when the net stock position falls to zero or less until sufficient stock arrives to raise the net stock position above zero.

The number of product codes currently associated with the vendor.

Period to Date. Defined as the period of time from the beginning of the current period to the Last Import date, typically being today.

The quantity associated with an open and outstanding supply order where the Expected Arrival Date is either today or in the future.

The unit quantity to be purchased that will result in optimal inventory levels.

The minimum level of stock required for inventory optimization. Defined as Lead Time + Safety Stock.

The amount of stock, in days, to be purchased when a recommended order is triggered. The unit quantity is calculated by looking at the future demand (Forecasts + BOM demand + Central Warehouse demand) over the replenishment cycle period.

A quantity of planned stock that provides safety against stocking-out due to unforeseen demand or risk. Otherwise known as planned dead stock. There are 5 inputs to calculating the level of safety stock, 2 are referred to as the sources of risk and they are Supply risk and Forecast risk, and the remaining 3 are referred to as risk multipliers, and they are Target Fill Rate, Replenishment Cycle and Leadtime

The price to be used to determine the average value of sales at selling price and to determine the level of margin made on an item. Selling price and Margin can be used in the classification settings.

An item held in inventory for the purpose of meeting immediate sales demand.

An item where its available stock position is currently zero or less. Action over and above ordering based on the lead time is required to prevent further lost sales. The Stocked out value is defined as the value of sales that will be lost from now until sufficient stock arrives to raise the available stock position above zero.

An item where the arrival of the open and outstanding purchase orders will result in the net stock position being greater than the order-up-to or maximum stock level. The value of Surplus orders will be the portion of the order resulting in the net stock position exceeding the order-up-to level.

Stock Turns

Stock turns is a measure of how many times you will sell your stock on hand value over the next 12 months. It can be seen as the inverse of Days on hand.

Stock turns = 365 / Days on hand

The measurement of supply based on whether the vendor over or under delivered in terms of quantity.

The percentage risk calculated due to a supplier delivering early or late based on historic deliveries.

A manually set level/number to be reached.

The number of times in a 12 month period, that the current level of inventory is expected to be rotated.

Where sales have exceeded historical forecasts. Under-forecasting leads to stock-outs.

The rate of units sold.

Calculated as days on hand / 365 * stock value. Items with the largest days on hand and corresponding stock value will have the biggest impact on stock turns.

A variation of a non-stocked item, most useful for make-to-order finished goods. Like a non-stocked item, a zero policy item won't be held in inventory. However, a zero policy item will allow its sales forecast to flow down to raw materials and components to influence their purchasing recommendations.