Restock Quantity Calculator

What This Sidekick Query Does

Calculate restock quantities for my products:

Parameters:

  Target stock coverage: [30] days
  Lead time (supplier delivery): [14] days
  Safety stock buffer: [7] days extra


For my top [50] products by sales volume, calculate:

  Average daily sales (last 60 days)
  Current inventory level
  Days of stock remaining at current rate
  Reorder point (when to order)
  Recommended order quantity
  Estimated cost to restock (if cost data available)


Factor in:

  Seasonal trends (compare to same period last year if available)
  Recent sales velocity changes (trending up or down)
  Minimum order quantities if applicable


Output as a restock order sheet with:

  Products that need ordering NOW (below reorder point)
  Products that need ordering within 7 days
  Products that are well-stocked (no action needed)


Sort by urgency.

Expected Output

Tips to Improve Results