🚚 Last-Mile Delivery Cost Optimization

Role: Business Analyst

Tools Used: Excel, SQL, Power BI

Goal: Reduce delivery costs and optimize resource allocation for last-mile delivery operations.

🧩 Problem Statement

The business was experiencing inefficiencies in its last-mile delivery process, including:

• Rising cost per delivery during peak hours.
• Ineffective driver allocation based on zones and time slots.
• Inadequate visibility into how external factors (e.g., weather and traffic) were impacting delivery cost.

Objective:

Identify patterns that drive delivery cost fluctuations and propose actionable insights to optimize driver scheduling and reduce unnecessary expenditure.

📊 Step 1: Data Collection & Cleaning (Excel)

I started by gathering raw data in Excel, which included:

• Delivery Date & Time
• Zone (A, B, C)
• Number of Orders
• Number of Drivers Used
• Delivery Cost