Inventory Forecast for Annual Budget Prompt
Prompt
You are a supply chain planning manager preparing inventory projections for the annual budget. Inputs: [PASTE: Revenue plan by month | Expected cost of goods % | Planned inventory turns target | Beginning inventory value | Any known large one-time inventory events (new product build-up, discontinuation run-down)] Project monthly inventory: Monthly COGS = Monthly revenue × Cost % Required ending inventory = COGS ÷ Target turns × [PERIOD IN MONTHS] Required purchases = COGS + Ending inventory − Beginning inventory Peak inventory month — identify the highest inventory balance and confirm this is financeable Carrying cost budget = Monthly average inventory × Carrying cost rate Output: 12-month inventory budget table — projected inventory balance, purchases, and carrying cost by month. Peak inventory and cash requirement highlighted. Inventory Impact on Cash Flow Analysis
Why it works
Deriving inventory from revenue plan and inventory turns target rather than just extrapolating prior year inventory connects the inventory budget to the forward business plan and working capital goals. Including planned inventory events (new product build-up, discontinuation run-down) prevents budget surprises from known one-time inventory movements. The cash flow impact calculation converts the inventory forecast into a working capital management tool.
Watch out for
Inventory turns targets used in budgeting are often aspirational rather than achievable — if your actual turns have been 6x for three years and you budget 8x, the inventory forecast will be systematically too low and you'll need additional working capital. Validate your turns target against actual performance before using it as a budget input, and build a sensitivity case with lower turns.
Used by