For our application the following would be helpful in the dashboard.
1. Active SKU's which are at risk of stockout and NOT on order with a supplier. This would include items with no sales velocity (such as a new SKU recently added), with a stock quantity of zero.
2. Purchase orders which are 100% (or greater) filled and not closed / in a completed status. This would help clearn up the list of open PO's. In our case we have 170+ open PO's. If I spent 20 minutes to open all of them, I would likely find a few that I could close out.
3. Open Purchase orders which have been open past the set supplier lead time, or a user set number for the dashboard - this allows a quick reference as to which supplier we should follow up with without having to go back into each PO or pull a backorder report.
Please sign in to leave a comment.