SUPPLIER PERFORMANCE MONITORING WORKFLOW

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

[ ] Fetch Active Suppliers: Retrieve all entries from the Supplier Data Model that are currently marked as 'Active'.
[ ] Fetch Recent Delivery Logs: Retrieve all delivery entries associated with the selected supplier from the last 90 days.
[ ] Calculate Average Lead Time: Calculate the average number of days between 'Order Date' and 'Delivery Date' from delivery logs.
[ ] Calculate Defect Rate: Calculate the percentage of rejected items versus total items received from the quality logs.
[ ] Compute Performance Score: Apply a weighted formula combining Lead Time variance, Defect Rate, and Price Stability to generate a 0-100 score.
[ ] Update Supplier Rating: Update the 'Performance Score' and 'Last Audit Date' fields in the Supplier Data Model.
[ ] Create Performance Audit Entry: Create a new record in the 'Audit History' data model containing the calculated metrics and score.
[ ] Assign Corrective Action Task: Create a task for the Procurement Manager if the Performance Score falls below a predefined threshold.
[ ] Schedule Annual Review: Create a recurring task for the Quality Assurance team to perform a physical site inspection.
[ ] Notify Supplier of Low Score: Send an automated email to the Supplier Contact Person detailing the performance decline and required improvements.
[ ] Internal Stakeholder Alert: Send an email to the Head of Supply Chain regarding suppliers who have entered 'Critical' status.
[ ] Generate Monthly Supplier Scorecard: Generate a PDF report summarizing the performance of all suppliers for the management monthly review.
[ ] Log Supplier Probation: Create an entry in the 'Supplier Sanctions' data model if the score remains below threshold for two consecutive periods.
[ ] Urgent Delivery Alert: Send an SMS to the Warehouse Manager if a high-priority supplier fails a critical quality check.
[ ] Archive Obsolete Supplier Logs: Remove/Archive delivery entries older than 5 years from the system to maintain performance.

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