Seasonal Inventory Planner

Help me plan inventory for an upcoming season/event:

Event: [e.g., Black Friday, Christmas, Summer Sale, Back to School, Valentine’s Day]
Event dates: [Start - End]
Lead time needed: [How many weeks before event to have stock ready]

Based on my store data, help me:


  Historical analysis:
    
      What sold best during this period last year?
      What was the sales uplift compared to normal periods?
      Which products went out of stock (missed revenue)?
    
  
  Demand forecast:
    
      Projected sales by product for the event period
      Recommended stock levels (with buffer for higher-than-expected demand)
      Products likely to see highest demand increase
    
  
  Action plan:
    
      Products to order now (with quantities and deadlines)
      Products to promote during the event
      Products to discount to clear before new season
      Budget estimate for inventory investment
    
  
  Risk assessment:
    
      What happens if demand is 20% higher than projected?
      What happens if demand is 20% lower?
      Backup plan for supply delays
    
  


Create a week-by-week timeline leading up to the event.