Summary
The Unusual Sales screen provides insight into unusual sales in the system; this provides awareness into sales that could potentially significantly impact your forecast, and gives you the option to manage adjusting them out of the forecast, via events.
This screen is powered by StockIQ's AI model, and it considers such factors as the item's neighbors, nearby sales activity as well as the overall pattern for the product, and determines if an outlier meets the model's criteria for being considered an outlier.
This outlier detection is so robust that you can now configure the AI to auto-create events for unusual sales it detects, using the Global Unusual Sales Settings. Additionally, highly unusual and high-value unusual sales are included in an Unusual Sales Alert, visible in this screen, the Planner Dashboard, and also in the Alerts screen.
Column Descriptions
- Item Code - the item with the unusual sale.
- Site Code - the location where the sale occurred.
- Marked Excep? - indicates if it was marked exceptional or not via the data feed.
- Has Event? - indicates if an event has been entered directly against this sales order or not; this allows you to filter out unusual sales you've already dealt with via event.
- Order # - the sales order number.
- Demand Date - date of this demand/sale.
- ABC - the ABC class of the item.
- Usage Pattern - the item's usage pattern; unusual sales activity is more reliable when detected against recurring items, as there is more data available.
- Customer - the customer code for this sale, in other words, who purchased it.
- Customer Name - the name associated with the customer code.
- Quantity - the quantity purchased.
-
Item Factors - these are factors for the item-level unusual detection. The columns below are similar for the 'Item-Site' and 'Item-Customer' sections, except that the quantities are item-site or item-customer specific vs being global for that item.
- Outlier? - this line has surpassed the score to be identified as an outlier for this item.
- Auto Outlier? - this line has surpassed the score for an event to be automatically created for this item.
- Outlier Score - the score that the AI assigned to this item for how unusual this sale was overall.
- $-Weighted Outlier Score - a score, value-weighted as to how unusual this sale was, allowing you to prioritize outliers by revenue impact to the business. This is also one of the thresholds used for deciding if the outlier should be counted as an alert or not.
- Typical Order Qty - typical order quantity for this item (across all sites and customers).
- Avg Sale Quantity - lifetime average sale quantity for this item (across all sites and customers).
- Std Dev - standard deviation of sale quantities, e.g. how variable is its demand?
- # Sales - how many lifetime sales of that product StockIQ has (StockIQ's default is 4 years of history).
-
Item-Site Factors - tolerance ranges and averages at the item-site level. These are used if you enable the additional filtering options, and will tend to reduce your number of unusual sales seen (see below).
- Outlier? - this line has surpassed the score to be identified as an outlier for this item-site.
- Auto Outlier? - this line has surpassed the score for an event to be automatically created for this item-site.
- Outlier Score - the score that the AI assigned to this item-site for how unusual this sale was overall.
- $-Weighted Outlier Score - a score, value-weighted as to how unusual this sale was, allowing you to prioritize outliers by revenue impact to the business. This is also one of the thresholds used for deciding if the outlier should be counted as an alert or not.
-
Item-Customer Factors - tolerance ranges and averages at the item-customer level. These are used if you enable the additional filtering options and will tend to reduce your number of unusual sales seen (see below).
- Outlier? - this line has surpassed the score to be identified as an outlier for this item-customer.
- Auto Outlier? - this line has surpassed the score for an event to be automatically created for this item-customer.
- Outlier Score - the score that the AI assigned to this item-customer for how unusual this sale was overall.
- $-Weighted Outlier Score - a score, value-weighted as to how unusual this sale was, allowing you to prioritize outliers by revenue impact to the business. This is also one of the thresholds used for deciding if the outlier should be counted as an alert or not.
Context Menu
In the Unusual Sales screen, if you right-click on a row, the following menu will appear:
- Inventory Snapshot - provides item-site attribute information.
- Sawtooth Chart - the sawtooth diagram for this item-site.
- Item-Site Notes - notes related to this item-site.
- View All Sales - this will load the sales order detail dialog for all periods, allowing you to see all sales for that product in StockIQ.
- Create Event From Sale - loads the Event Editor dialog allowing you to easily create an event for this sale.
Detail Tabs
- Trend Chart - this is a view of the forecast for the item-site, this is similar to what you would see in the Forecast Manager, including the trend line.
- Item Outlier Chart - this chart shows unusual sales order quantities for the selected item in the grid compared to the expected quantities and the upper/lower outlier thresholds across the entire sales history for that item.
- Item-Site Outlier Chart - this chart shows unusual sales order quantities for the selected item-site in the grid compared to the expected quantities and the upper/lower outlier thresholds across the entire sales history for that item-site.
- Irem-Customer Outlier Chart - this chart shows unusual sales order quantities for the selected item-customer in the grid compared to the expected quantities and the upper/lower outlier thresholds across the entire sales history for that item-customer.