Medical Supply Chain and Procurement Workflow

Start of the Workflow/Process.

Retrieve all entries from the Inventory Data Model where quantity is below the safety threshold.

Create a new entry in the Procurement Requests Data Model based on identified low stock items.

Update the 'Status' field of the identified inventory items to 'Reorder Pending'.

Assign a task to the Procurement Officer to review the newly created Purchase Requisition.

Fetch pricing and lead time data from the Vendor Data Model for the required supplies.

Calculate the total cost of the requisition by multiplying unit prices by requested quantities.

Aggregate the total cost of all pending purchase requislaions to check against the monthly budget.

Create a task for the Supply Chain Manager to approve or reject the calculated order cost.

Send an email to the selected Vendor's contact address with the approved Purchase Order details.

Update the Purchase Requisition entry status to 'Ordered' once the vendor notification is sent.

Create a task for the Warehouse Team to verify the physical shipment against the digital Purchase Order upon arrival.

Retrieve the original Purchase Order data to compare against the incoming delivery note.

Increment the quantity in the Inventory Data Model by the amount received in the shipment.

Create a new entry in the Logistics Logs Data Model documenting the successful delivery.

Generate a report aggregating all completed procurement tasks and total spend for the month.

Send an SMS to the Logistics Manager if a shipment is flagged as 'Damaged' or 'Incomplete' during receiving.

End of the Workflow/Process.