SUPPLIER LEAD TIME TRACKING WORKFLOW

Created by ChecklistGuro (https://checklistguro.com)

[ ] Fetch Supplier Master Data: Retrieve supplier contact details and baseline lead time agreements from the Supplier Data Model.
[ ] Get Recent Delivery Records: Retrieve the last 5 completed delivery entries for the specific supplier to establish historical context.
[ ] Calculate Historical Average Lead Time: Calculate the mean duration between 'Order Date' and 'Arrival Date' from retrieved delivery records.
[ ] Calculate Variance Margin: Aggregate the difference between 'Contracted Lead Time' and 'Actual Lead Time' to identify delays.
[ ] Create Audit Task: Late Delivery Investigation: Assign a task to the Procurement Officer to investigate if recent delays are due to logistics or production issues.
[ ] Create Lead Time Deviation Entry: Generate a new record in the 'Lead Time Deviation Log' to document the identified discrepancy.
[ ] Update Supplier Risk Score: Update the 'Risk Rating' field in the Supplier Master Data based on the calculated variance.
[ ] Notify Supplier of Performance Deviation: Send an automated email to the supplier's account manager detailing the recent lead time delays.
[ ] Create Supplier Feedback Task: Create a task for the Supplier to submit a corrective action plan (CAP) via the platform.
[ ] Update Contractual Lead Time Baseline: If the deviation is permanent, update the 'Standard Lead Time' field in the Supplier Data Model.
[ ] Generate Monthly Supplier Performance Report: Generate a summary report containing aggregated lead time metrics for all suppliers for the current month.
[ ] Alert Procurement Manager: Send an internal email alert to the Manager if a supplier's risk score exceeds a predefined threshold.

--- END OF TEMPLATE ---
Transform this text into a digital, automated, and trackable mobile app!
Visit: https://checklistguro.com/workflow-templates/inventory-management/supplier-lead-time-tracking-workflow
(Click "Install Template" to launch your digital inspection tool immediately)