Dynamic Arrays and What-If Analysis: Build an Inventory Reorder Planner

<p>Cairnway Outdoor keeps running out of its best-selling headlamps while cash sits in a year's worth of camp stoves, and the winter order closes on Friday. Follow inventory planner Nadia Brennan as she builds a reorder plan that finance director Owen Achebe can sign: dynamic arrays to map the data, XLOOKUP to join it, LET to turn reorder logic into formulas anyone can read, and Goal Seek, Data Tables and Scenario Manager to fit the plan to the budget. In every lesson you build it in your own generated workbook, then hand the same job to your AI and catch what it gets wrong: leading-zero SKUs that vanish from lookups, returns netted out of demand, discontinued lines reordered, orders not rounded to packs. The capstone: brief your agent to plan the second warehouse and prove its work.</p>

Tools: Dynamic Arrays (FILTER, UNIQUE, SORT), XLOOKUP, LET, Goal Seek, Data Tables, AI-assisted Excel