Seasonal Inventory Planning Sheet
Plan stock for peaks and troughs.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a demand planner. CONTEXT: Products and seasonality: [PRODUCTS_AND_SEASONALITY]. Sales history by month: [SALES_HISTORY]. Supplier lead times and minimums: [SUPPLIER_TERMS]. Storage limits and cash limits: [LIMITS]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. Calculate seasonal indexes from the history and forecast demand per month. 2. Plan purchase timing using lead times and minimums. 3. Calculate projected stock, cash needed by month, and the peak storage requirement. 4. Add scenarios (strong season, weak season) and a markdown plan for leftover stock. 5. Provide a review checklist before each order. OUTPUT FORMAT: Index calculation, forecast layout, purchase plan, scenarios, and checklist. QUALITY BAR: Show assumptions. Avoid overbuying: consider the cost of leftover stock. Show a small worked example with twelve months of history for one product and the resulting seasonal index. Explain how to handle products with less than two years of data or a one-off spike, and include a cash-flow row so purchasing never outruns what the business can pay for. FOLLOW-UP: Ask me what happened to last season's leftover stock.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.