Retail Supply Chain Management

Start of the Workflow/Process.

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

Sum the total cost of all identified low stock items to determine the required budget.

Calculate the expected arrival date by adding the vendor lead time to the current date.

Create a new entry in the Purchase Order Data Model based on the low stock identified.

Assign a task to the Procurement Manager to review and approve the newly created Purchase Order.

Update the 'Last Ordered' timestamp in the Vendor Data Model.

Send an automated email to the Vendor's contact email with the Purchase Order details attached.

Create a task for the Warehouse Team to prepare for incoming shipment arrival.

Retrieve the original Purchase Order data to compare against arriving physical goods.

Update the quantity on hand in the Inventory Data Model once goods are marked as received.

Delete or archive entries from the Perishable Goods Data Model that have passed their expiry date.

Generate a summary report showing supplier accuracy, lead time deviations, and stockout incidents.

Send an SMS to the Warehouse Manager when the delivery truck is within 5km of the facility.

Aggregate the total value of all completed Purchase Orders for the current month.

Execute formula: (Cost of Goods Sold / Average Inventory) to assess stock efficiency.

End of the Workflow/Process.