Root Cause of Spike in DC Cycle Times

Describe how you would identify the root cause of a sudden spike in distribution center cycle times at Apple.

Translate the investigation into a query that compares a spike date with the preceding seven-day baseline for each distribution center and process step. Include only completed events and identify positive increases with an existing baseline.

Output

1. One row per distribution center and process step contributing to the spike
2. Columns: dc_code, dc_name, process_step, spike_avg_cycle_minutes, baseline_avg_cycle_minutes, avg_increase_minutes, and spike_event_count
3. Sort by avg_increase_minutes descending, then dc_code and process_step ascending