Seasonal Stock Planning Calendar

What This Sidekick Query Does

Help me create a seasonal stock planning calendar for my Shopify store. I sell [PRODUCT_TYPE] and my business is affected by the following seasonal patterns and events:
[SEASONAL_EVENTS_LIST]

Please build a comprehensive planning calendar:


  Historical demand analysis:
    
      Pull monthly sales data for the past [YEARS] years.
      Identify seasonal peaks and valleys for each product category.
      Calculate the seasonal index (percentage above or below average) for each month.
      Note any year-over-year growth trends to factor into projections.
    
  
  Create a 12-month purchasing calendar showing:
    
      Month-by-month demand forecast adjusted for seasonality.
      Order placement dates accounting for [LEAD_TIME_DAYS] days supplier lead time.
      Stock arrival target dates (when inventory should be in warehouse).
      Pre-season buildup targets (quantity needed before each peak).
      Post-season markdown and clearance windows.
    
  
  Key event planning for [CURRENT_YEAR]:
    
      
      
      
    
  
  Budget allocation by quarter:
    
      Recommended inventory investment per quarter based on seasonal demand.
      Cash flow timeline showing when payments are due versus when revenue arrives.
    
  
  Risk mitigation:
    
      Plan for supplier delays during peak ordering seasons.
      Identify backup suppliers for critical items: [CRITICAL_ITEMS].
      Set maximum order quantities to limit exposure if a trend does not materialize.
    
  
  Post-season review template to compare actual versus planned and improve next year.


Please generate the calendar in a format I can share with my team and suppliers.

Expected Output

Tips to Improve Results