Monthly Distribution Inventory Position Review - Textiles & Leather

Track and analyze inventory positions, movements, and efficiency metrics across distribution centers for textiles and leather goods, focusing on stock levels, turnover rates, and order fulfillment performance to optimize inventory management and distribution operations.

Report Objective

Monitor and evaluate the inventory health across distribution centers for textiles and leather goods, focusing on stock levels, aging inventory, turnover metrics, and order fulfillment efficiency to ensure optimal inventory positioning while maintaining service levels and minimizing holding costs.

Inventory Levels and Aging Analysis

Stacked bar chart showing inventory value by age category and location

Questions to Consider:

Atlanta DCChicago DCDallas DCLos Angeles DCdc_location$0$5,000,000$10,000,000$15,000,000$20,000,000sum(inventory_value)0-30 days31-60 days61-90 days90+ daysHow is inventory distributed across age buckets by DC?Aged inventory (90+ days) represents 15% of total value, with higher concentrations inwestern DCs

  • Which DCs show concerning aged inventory levels?

  • How has the distribution of inventory age changed month-over-month?

  • Are there seasonal patterns in inventory aging?

  • Is aged inventory growing or decreasing over time?

  • What is driving changes in aged inventory levels?

  • How do aging patterns vary by season?

Mar 2024Apr 2024May 2024report_date$600,000$700,000$800,000$900,000$1,000,000$1,100,000sum(inventory_value) vs. age_bucketsum(inventory_value)age_bucketWhat is the trend in aged inventory value?Total aged inventory value increased 8% month-over-month

Inventory Turnover and Efficiency

Line chart tracking inventory turnover rates and days of supply

Questions to Consider:

Mar 2024Apr 2024May 2024report_date4.44.64.85.05.25.4sum(turnover_rate) vs. product_categorysum(turnover_rate)product_categoryHow are inventory turnover rates trending by category?Casual Wear shows highest turnover at 8.5x, while Formal Wear lags at 2.1x

  • Which categories show improving or declining turnover?

  • How do turnover rates compare to industry benchmarks?

  • Are there seasonal patterns in turnover rates?

  • Which categories have excess inventory positions?

  • How do current days of supply align with targets?

  • What is the impact on working capital?

Casual WearFormal WearLeather GoodsWork WearAccessoriesproduct_category0200400600800sum(days_of_supply)sum(days_of_supply)What are the days of supply across product categories?Work Wear showing elevated inventory levels at 120 days of supply

Order Fulfillment Performance

Bar chart showing fill rates and stockout incidents

Questions to Consider:

Atlanta DCChicago DCDallas DCLos Angeles DCdc_location0.0%500.0%1000.0%1500.0%2000.0%sum(fill_rate)Atlanta DCChicago DCDallas DCLos Angeles DCHow are fill rates performing across distribution centers?Fill rates range from 82% to 99%, with western DCs showing lower performance

  • Which DCs are meeting fill rate targets?

  • What is driving variations in fill rates?

  • How do stockout incidents correlate with fill rates?