Notifies when PO created for Item(s) considered potentially obsolete
Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview:
Looks at Purchase Orders for items considered at risk of becoming obsolete based on decreasing volume trends for the model associated with the item (per ID500). Indication that you may be carrying more inventory than you should be.
Run Schedule: Every 30-Minutes
Type of Output: Email
* * *
Sample
* * *
Variables
Variable W: Minimal On Hand Inventory Value to Consider (no decimals please)
Variable X: Line item Order Threshold (alert disregards items where line item cost (quantity * price) does not exceed this amount)
Variable Y: Maximum inventory turns (alert disregards items if you're turning the item more than Y times/year)
Variable Z: Branch Numbers to trigger on, separated by comma, or blank for all. Please note, even though the POs triggered on can be tied back to Branch, the actual data on approaching-obsolescence is company-wide and we won't be doing that at a branch level anytime soon.
* * *
Alert Functionality
-Please note, even though the POs triggered on can be set to only report for specific Branch (set via VariableZ), the actual data on approaching-obsolescence is company-wide and we won't be doing that at a branch level anytime soon.
-You must be subscribed to and running alert ID500 in order for ID543 to provide any data/results. ID500 includes an On Demand SSRS Report, so you'd likely find it very helpful to use as well.
Alert Output Columns Explained:
OrderQty: Quanity of Item on PO
Price: Cost for Item on PO
ItemOrderAmountCutOff: per your VariableX value
CurrentInventory: Current OnHand Quantity across ALL Warehouse, ALL Branches
Ordered+QOH: Quantity ordered on PO + Total Current OnHand Quantity across ALL Warehouse, ALL Branches
Used6Mos: Quantity of this item used over last 6-completed months (does not include current month)
ItemTrend: Indicates if inventory value for that Model/Item association is trending up (been adding more to stock) or down (been liquidating).
Options:
Down = Inventory Value is trending down (lowering stock)
Up = Inventory Value is trending up (increasing stock)
EstimatedTurns: Estimated turns over historical 12-months
Inventory turns are calculated using your inventory value against sales and service usage quantities. Inventory transfers , adjustments, etc are not used to calculate your turns score, only sales order and service call transactions are considered as usage.
Models: All Models this Item has been used on
* * *
Best Practices & Tips
-Please note, even though the POs triggered on can be set to only report for specific Branch (set via VariableZ), the actual data on approaching-obsolescence is company-wide and we won't be doing that at a branch level anytime soon.
-When you receive this alert, the first thing you should do is check to see if the item can be transferred from another warehouse. If it can, then cancel the item on the PO. Also research to see if the items being ordered are restock items. If they are then it's possible the items min/max need to be updated. The clicks for this model are decreasing so the inventory stock has to also. Why pay for something that you may have to sell off the remainder of your stock anyway?
-The alert doesn't consider recent usage, it's looking at inventory level trends compared to clicks-on-contract trends at the model level, and letting you know of items where overall inventory levels for those models are already too high in comparison. You're always going to have outliers where current usage is running high because more of your MIF are hitting yield or PM thresholds, but the purpose of the alert is 'inventory levels high, use existing if you can find it.'
-because even though the POs triggered on can be tied back to Branch the actual data on approaching-obsolescence is company-wide and we won't be doing that at a branch level anytime soon
* * *
Related Alerts
ID500 - Items in stock at risk of becoming Obsolete due to Model Population/Volume decrease (required for ID543)
ID806 - Inventory Turns On Demand SSRS Report
* * *
0 Comments