On Time Completion

This metric tracks the vendors ability to meet the SLA for the completion of a Purchase Order. This is set as the Complete By date in the Purchase Order.

Purpose / Metric Definition:

Measures whether the Purchase Order was completed on or before the priority expected completion date.

Category:

Performance

Logic / Formula:

CASE WHEN PO.CompletionDate <= PO.priority_expectedcompletiondate      
    THEN 1      
    ELSE 0 
END AS Performance_OnTimeCompletion

Scoring Rules:

• 100% → Vendor completed before or on the priority expected completion date

• 0% → Vendor completed after the priority expected completion date

Notes / Exceptions (optional):

• If no completion date exists, the metric will not be scored.

Links to Dashboards/Reports that use this metric:

• Vendor Scorecard