How an item's status is determined

It is important to understand how the status gets assigned to each item
 

Read the tutorial

In this tutorial I am going to explain how an item gets identified as a stock-out, potential stock-out, surplus order, or excess item.

 

Identify and exclude “new” items

Click to enlarge the image

First we identify and exclude “new” items, as there is no way to accurately determine the status that should be assigned.

Stocked items are categorised as new:

  • that have stock on hand or stock on order
  • for which there is no demand (yellow highlight)
  • an age less than or equal to 12 (the orange circle)
  • and no manual forecast overrides (no snowflake in the red circle)

Click to enlarge the image

The status units is calculated as stock on hand plus stock on order.

For every status, the status value is computed as the status units multiplied by average cost.

 

The status assigned is prioritised

Click to enlarge the image

After the exclusion of new items, the status assigned to remaining items is prioritised based on the impact on your business.

 

Priority 1: stock-outs

Click to enlarge the image

If an item is stocked-out, it impacts your fill ratehurts customer service and may result in lost sales – so stock-outs are priority number one.

Click to enlarge the image

Stocked items are flagged as a “stock-out” when your available stock is zero or negative.

Click to enlarge the image

The status units is the potential lost sales over the shorter of the lead time days or the days until the first purchase order is due (the 480 in the dark green box).

Click to enlarge the image

Non-stocked items are flagged as a “stock-out” when your net stock is negative.

The status units is the quantity required to get your net stock back to zero.

 

Priority 2: potential stock-outs

Click to enlarge the image

Potential stock-outs are your early warning signal of future fill rate and customer service issues, giving you time to avoid a stock-out.

So, priority number two are those items that are not out of stock right now (blue circle) but are predicted to run out of stock (dark red shading) before either the next order arrives or an order you place today can be received.

The status units is the potential lost sales over the predicted stock-out period.

 

Priority 3: surplus orders

Click to enlarge the image

Priority three are those items where you have too much on order, your early warning signal of potential future excess.

To determine whether you have surplus orders, the App computes an order to be placed today, ignoring all existing purchase orders.

If what is currently on order within the lead time is more than this computed recommended order, the item is flagged as having surplus orders and the quantity is set to the difference.

 

Priority 4: excess

Click to enlarge the image

Priority four are items with excess stock, and typically you would not do much about these on a daily basis.

A monthly focus on the top 10 or 20 items with excess, along with excess reduction targets and actions is more likely.

Click to enlarge the image

For stocked items, the difference between available stock and the order up to level is the number of units that are in excess.

Click to enlarge the image

For non-stocked and obsolete items, any positive available stock is set as the excess quantity.

 

“OK” items

Click to enlarge the image

Any items not categorised as new, stock-out, potential stock-out, surplus orders or excess will be flagged as OK.

 

Items with more than one issue

Click to enlarge the image

It is important to note that an item may have multiple issues.

For example: this item is flagged as a potential stock-out as it is predicted to run out before the next order arrives. However, the next order is way too big and so the item could also be flagged as a surplus order item.

Each item may only ever have one status – the highest priority status based on the impact to your business. While investigating the options to avoid the potential stock-out, you would see that the order is too big and try to bring part of the order forward to avoid stocking out.

 

And that’s it for my tutorial on status determination

Click to enlarge the image

Remember:

  • New items are identified and excluded
  • A priority based on the impact to your business is used when determining the status to assign to each item
  • An item could actually have more than one issue, so look out for this when reviewing items
  • Watch the “How to action my …” series of tutorials for more information on the possible actions to take for each status