Inventory Turnover Analysis Dashboard

What This Sidekick Query Does

Create a comprehensive inventory turnover analysis for my Shopify store covering the period [START_DATE] to [END_DATE]. I want to understand how efficiently my inventory is being managed.

Please analyze and present:


  Overall inventory turnover ratio:
    
      Formula: Cost of Goods Sold divided by Average Inventory Value.
      Calculate for the entire store and by product category: [CATEGORY_LIST].
      Compare to industry benchmark of [BENCHMARK_RATIO] turns per year for [INDUSTRY_TYPE].
    
  
  Days Sales of Inventory (DSI):
    
      How many days on average does it take to sell through current stock?
      Break down by category, vendor, and individual top-selling SKUs.
      Flag items with DSI exceeding [MAX_DSI] days as slow-moving.
    
  
  ABC analysis based on turnover:
    
      A items: top [A_PERCENT] percent by revenue, what is their turnover rate?
      B items: next [B_PERCENT] percent by revenue.
      C items: remaining [C_PERCENT] percent.
      Recommend different management strategies for each tier.
    
  
  Turnover trends over time:
    
      Monthly turnover ratios for the past [MONTHS] months.
      Identify improving and declining product lines.
      Correlate turnover changes with promotions, price changes, or seasonal factors.
    
  
  Cash conversion cycle:
    
      Days of inventory plus days of receivables minus days of payables.
      Recommend actions to shorten the cycle.
    
  
  Action items:
    
      Specific products to reorder more frequently (high turnover, risk of stockout).
      Specific products to discount or discontinue (low turnover, tying up capital).
      Target turnover ratio improvement from [CURRENT_RATIO] to [TARGET_RATIO].
    
  


Please present this as a dashboard-style report with clear metrics and recommendations.

Expected Output

Tips to Improve Results