Create intermediate Works with: Any AI

Seasonal Stock Planning Worksheet

Table output

Plan buying for peaks and quiet periods.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Create a seasonal stock planning worksheet. Last year's sales by month and product group: [SALES_HISTORY]. Lead times and minimum orders: [LEAD_TIMES]. Cash available for stock: [CASH].

Build a worksheet with expected demand per month using last year's data and my adjustments, stock to order, order dates, cash needed per month, and risk notes. Include scenarios (cautious, expected, strong), a plan for unsold stock (markdown, bundle, storage), and a review of the previous season. Warn about over-reliance on a single year and about cash flow constraints. Use only my figures, mark assumptions clearly, and avoid forecasting beyond what the data supports.

Also add a worked example for one invented product group with last year's monthly sales and my adjustments, showing order quantities, labelled as an illustration.

Treat any wage, tax or licensing statement as unverified until a qualified person confirms it. Mark such points [VERIFY] for [JURISDICTION] and keep the practical advice separate so it stays useful either way.

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.

• retail