Automated Warehouse Inventory Control Process

Start of the Workflow/Process.

Retrieve all entries from the Inventory Data Model where current stock level is below the predefined reorder point.

Sum the 'Unit Price' multiplied by 'Quantity' for all items retrieved in the inventory list to determine total capital tied in stock.

Update the 'Status' field to 'Reorder Required' for all identified low-stock entries.

Create a new task for the Purchasing Manager to review the low stock list and initiate orders.

Calculate the estimated cost of replenishment by multiplying the 'Reorder Quantity' by the 'Unit Price' for each item.

Create a new entry in the Purchase Order Data Model containing the items, quantities, and total estimated cost.

Send an email notification to the Warehouse Manager containing the summary of items that reached the reorder point.

Retrieve all entries from the Incoming Shipments Data Model that are marked as 'In Transit'.

Update the 'Expected Arrival' field in the Shipment entry once the warehouse staff confirms receipt.

Create a task for the Quality Control team to inspect the contents of incoming shipments.

Update the 'Quantity on Hand' in the Inventory Data Model based on the verified quantities from the incoming shipment.

Delete or move entries from the active Inventory Data Model to the 'Disposed/Scrapped' model if they fail inspection.

Create a comprehensive report summarizing stock movements, value of stock, and pending orders for the weekly management review.

Send an SMS alert to the Operations Head if an item reaches a stock level of zero.

End of the Workflow/Process.