Design an optimized, multi-depot distribution plan for [CompanyName] in [Region] over [Timeframe], honoring strict customer time windows defined by [TimeWindowPolicy] and a mixed fleet profile [FleetMix]. Incorporate driver hours-of-service limits, vehicle capacities, and service-level objectives of [ServiceLevelTarget]. Use historic stop durations and traffic priors to estimate ETAs and variability. Optimize for total cost (distance, time, tolls) while producing a secondary objective to minimize late arrivals.
Output strictly as:
“Routes” table (CSV-like text): route_id, sequence_no, order_id, depot_id, vehicle_id, driver_id, planned_departure, ETA_local, time_window_start, time_window_end, service_minutes, distance_km, drive_minutes, slack_minutes, expected_co2_kg.
“KPI Summary” table: total_stops, on_time_pct, total_km, total_hours, vehicles_used, avg_drop_time_min, late_stops, cost_estimate, co2_kg_per_drop.
“Exceptions” list: order_id, constraint_violation, suggested_fix (swap, split, re-time).
Include a brief rationale explaining trade-offs (e.g., longer routes to consolidate).