Monthly Transportation Cost Analysis Report

Track and analyze transportation costs, carrier performance, and route efficiency across the discount store supply chain network to identify cost optimization opportunities and maintain service levels.

Report Objective

Monitor and analyze monthly transportation costs, carrier performance metrics, and route efficiency indicators to optimize supply chain operations and control costs while maintaining service levels for discount store distribution network.

Transportation Cost Trends

Line chart showing total shipping costs and fuel cost per mile trends

Questions to Consider:

Mar 2024Apr 2024May 2024month$200,000$400,000$600,000$800,000$1,000,000total_shipping_cost vs. fuel_cost_per_miletotal_shipping_costfuel_cost_per_mileHow are Monthly Transportation Costs Trending?Total shipping costs and fuel costs showing month-over-month variations

  • What is the month-over-month change in total shipping costs?

  • How do fuel cost changes impact overall transportation expenses?

  • Are cost increases aligned with changes in shipping volume?

Carrier Performance Analysis

Bar chart comparing carrier performance metrics

Questions to Consider:

  • Which carriers consistently meet on-time delivery targets?

  • How much variation exists in carrier performance?

  • Are there specific carriers requiring performance improvement plans?

FastFreightRegionalCarriersPrimeLogisticsXPress Transportcarrier_name0.0%500.0%1000.0%1500.0%2000.0%sum(on_time_delivery_rate)sum(on_time_delivery_rate)How Does On-Time Delivery Performance Compare Across Carriers?Carrier performance showing variation in delivery reliability

FastFreightRegionalCarriersPrimeLogisticsXPress Transportcarrier_name$0$2,000$4,000$6,000sum(cost_per_delivery)sum(cost_per_delivery)What are the Cost Variations by Carrier?Cost per delivery analysis across carrier network

  • Which carriers offer the most competitive rates?

  • How do delivery costs correlate with service levels?

  • Are premium rates justified by superior performance?

Route Efficiency Metrics

Table showing key route efficiency metrics by distribution center

Questions to Consider:

  • Which distribution centers demonstrate best practices in route optimization?

  • Are there significant regional variations in delivery efficiency?

  • What factors contribute to differences in utilization rates?

monthdistribution_centertruck_utilization_ratemiles_per_delivery
Feb 2024Eastern DC82.0%145
Feb 2024Central DC81.5%145
Feb 2024Western DC81.7%150
Feb 2024Eastern DC81.3%148
Feb 2024Central DC81.1%153
Feb 2024Western DC81.6%153
Feb 2024Eastern DC80.7%150
Feb 2024Central DC80.4%156
Feb 2024Western DC81.1%150
Feb 2024Eastern DC80.7%150