This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Vendor Performance Director at UPS. The quarterly business review needs a comprehensive carrier report showing each carrier's shipment volume, on-time delivery percentage, exception rate, and average freight cost. On-time means the shipment's delivery_date is on or before the order's promised_date. Exception rate is the ratio of total exceptions to total shipments for each carrier.
You are a Vendor Performance Director at UPS. The quarterly business review needs a comprehensive carrier report showing each carrier's shipment volume, on-time delivery percentage, exception rate, and average freight cost. On-time means the shipment's delivery_date is on or before the order's promised_date. Exception rate is the ratio of total exceptions to total shipments for each carrier.