Construction Material Procurement Workflow

Start of the Workflow/Process.

Fetch all active vendors from the Vendor Data Model that meet the qualification criteria.

Retrieve the specific material request details entered by the Project Manager.

Generate a new entry in the Purchase Requisition Data Model based on the material request.

Assign a task to the Procurement Officer to review the requisition for accuracy and budget availability.

Retrieve the current project budget and allocated funds from the Project Budget Data Model.

Sum the unit prices and quantities from the requisition to calculate the total estimated expenditure.

Subtract the estimated cost from the remaining project budget to check for overruns.

Create a task for the Procurement Clerk to contact selected vendors and obtain formal quotes.

Create a new entry in the Quotes Data Model for each quote received from vendors.

Aggregate the entries in the Quotes Data Model to find the Minimum price among all received quotes.

Assign a task to the Construction Manager to approve or reject the selected vendor/quote.

Update the status of the original Purchase Requisition to 'Approved' or 'Rejected'.

Create a new entry in the Purchase Order Data Model containing the finalized terms and vendor info.

Send an email to the selected vendor with the attached Purchase Order details.

Create a task for the Site Supervisor to monitor the arrival of the materials.

Retrieve the digital delivery note/manifest from the Logistics Data Model.

Update the Material Inventory Data Model to increase the stock count for the received items.

Create an entry in the GRN Data Model to document the successful arrival and inspection of goods.

Send an email to the Finance Department that a new GRN is available for invoice matching.

Generate a monthly report summarizing total spend, vendor performance, and procurement lead times.

End of the Workflow/Process.