Monthly Logistics Cost Analysis - Home Furnishings Distribution

Track and analyze key logistics cost drivers and operational efficiency metrics across the home furnishings distribution network, focusing on shipping costs, warehouse operations, and delivery performance to optimize overall distribution costs while maintaining service levels.

Report Objective

Monitor and evaluate monthly logistics costs across the home furnishings distribution network, identifying cost-saving opportunities while maintaining delivery performance. Focus on warehouse operations efficiency, transportation costs, and inventory carrying costs to support data-driven decisions for operational optimization.

Transportation Cost Analysis

Line and bar charts showing shipping costs and volume metrics

Questions to Consider:

Mar 2024Apr 2024May 2024month$300,000$310,000$320,000total_shipping_costtotal_shipping_costHow are Total Shipping Costs Trending?Monthly shipping costs showing seasonal patterns with recent cost increases

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

  • How do current costs compare to historical seasonal patterns?

  • Are cost increases aligned with volume changes?

  • How strong is the correlation between fuel surcharges and unit costs?

  • Which months show the most efficient cost-to-surcharge ratio?

  • What other factors might be affecting unit costs?

9.5%10.0%10.5%11.0%fuel_surcharge$15.00$15.50$16.00cost_per_unitWhat is the Impact of Fuel Surcharges on Cost per Unit?Cost per unit correlation with fuel surcharge rates

Warehouse Operations Efficiency

Bar charts comparing warehouse productivity and cost metrics

Questions to Consider:

AtlantaChicagoSeattlewarehouse_location$0.00$50.00$100.00$150.00sum(cost_per_unit_handled)AtlantaChicagoSeattleHow do Warehouse Costs Compare Across Locations?Cost per unit handled varies significantly by location

  • Which warehouse shows the best cost efficiency?

  • What factors contribute to cost variations between locations?

  • Are there best practices that can be shared across facilities?

  • Does higher labor cost correlate with better handling efficiency?

  • Which locations show the best labor cost optimization?

  • Are there opportunities for labor cost optimization?

$25.00$25.50$26.00$26.50sum(labor_cost_per_hour)$4.20$4.40$4.60$4.80sum(cost_per_unit_handled)AtlantaChicagoSeattleWhat is the Relationship Between Labor Costs and Unit Handling Costs?Labor costs show varying impact on unit handling efficiency

Delivery Performance vs. Cost

Scatter plot and table showing delivery metrics and associated costs

Questions to Consider:

$140.00$150.00$160.00$170.00sum(average_delivery_cost)91.0%92.0%93.0%94.0%sum(on_time_delivery_rate)Zone 1Zone 2Zone 3Zone 4Zone 5How do Delivery Costs Impact On-Time Performance?Higher delivery costs generally correlate with better on-time performance

  • Which zones achieve the best balance of cost and performance?

  • Is there an optimal cost point for delivery reliability?

  • How do zone characteristics affect the cost-performance relationship?

  • Which zones require immediate attention for cost or performance improvements?

  • Are there consistent patterns in zone performance?

  • How can we optimize routing and zone assignments?

delivery_zonemonthon_time_delivery_rateaverage_delivery_cost
Zone 1Feb 202492.0%$150.00
Zone 2Feb 202491.4%$148.43
Zone 3Feb 202491.4%$152.59
Zone 4Feb 202491.4%$145.09
Zone 5Feb 202491.5%$145.22
Zone 1Feb 202491.5%$152.72
Zone 2Feb 202491.4%$149.51
Zone 3Feb 202491.5%$147.66
Zone 4Feb 202491.6%$155.16
Zone 5Feb 202491.9%$147.66