Safety Stock Level Monitoring Process

Начало на работния поток/процеса.

Retrieve the current stock levels for all items in the Inventory data model.

Retrieve the predefined minimum safety stock levels for each item.

Retrieve the average lead time per supplier from the Supply Chain data model.

Aggregate historical sales/usage data to find the average units consumed per day.

Execute formula: (Max Lead Time * Max Daily Usage) - (Avg Lead Time * Avg Daily Usage).

Calculate the difference between the Safety Stock Target and the Current Inventory Level.

Calculate: (Average Daily Usage * Lead Time) + Safety Stock Level.

Update the 'Status' field of the item to 'Critical' or 'Low Stock' if levels fall below threshold.

Create a task for the Purchasing Manager to initiate a replenishment order for items below the Reorder Point.

Create a task for the Warehouse Supervisor to perform a physical count if a discrepancy is detected.

Create a new entry in the 'Purchase Requisition' data model for the identified items.

Send an email alert to the procurement department with a summary of items requiring immediate reorder.

Send an SMS to the Warehouse Manager if stock levels hit 'Zero' or 'Emergency' levels.

Create a summary report showing all items currently below safety levels and total value of stock at risk.

Delete or archive old 'Stock Alert' entries that have been addressed by replenishment.

Край на работния поток/процеса.