Complete AI Training

AI agent for demand planners

Product Phase-Out Run-Down Agent

The old product sells out close to the replacement's start, with minimal leftover stock and no gap.

Product Phase-Out Run-Down Agent: what goes in, what the agent does and what you get

What it does

A product is being retired, and the team either buys too much and writes it off or runs out two months before the new version ships. For each product being retired, this agent sets a last buy date and last production date from demand, open orders and supplier terms. It checks whether the replacement item is ready, with a date and stock. Each week it recalculates the run-down against actual sales and moves the plan if stock will run out early or late. It prepares purchase, customer notice and write-off proposals with numbers. The planner approves purchases, notices and write-offs. Edge case: the replacement slips by 4 weeks, so the retiring item needs a bridge buy.

How it works

Follow the arrows from top to bottom. The orange dashed arrow is the loop: when a check fails, the agent goes back and tries again.

Start and resultWhat it doesA check on its own workWaits for your OKGoes back and retries
Yes, continueApprovedYes, continueApprovedNoNo 1 STARTS WHEN Product flagged for phase-out 2 USES A TOOL Pull stock, open orders, supplier terms and forecast 3 DOES Set the last buy and last production dates 4 USES A TOOL Check the replacement's readiness date and stock 5 CHECKS THE RESULT Does the run-down end within 2 weeks of thereplacement start? If not: adjust the last buy dates or propose a bridgebuy or a markdown. Back to step 3. 6 YOU APPROVE Planner approves purchases and notices 7 DOES Each week, compare actual sales with the plan 8 CHECKS THE RESULT Is projected stock-out within 2 weeks of the plan? If not: recalculate and propose new dates or actions.Back to step 3. 9 DOES Draft customer notices and write-off proposals forleftovers 10 YOU APPROVE Planner approves write-off proposals 11 RESULT Product retired with final stock reported
Read the steps as a list
  1. Product flagged for phase-out
  2. Pull stock, open orders, supplier terms and forecast
  3. Set the last buy and last production dates
  4. Check the replacement's readiness date and stock
  5. Does the run-down end within 2 weeks of the replacement start?If not: adjust the last buy dates or propose a bridge buy or a markdown. Back to step 3.
  6. Planner approves purchases and noticesThe agent waits here for your OK.
  7. Each week, compare actual sales with the plan
  8. Is projected stock-out within 2 weeks of the plan?If not: recalculate and propose new dates or actions. Back to step 3.
  9. Draft customer notices and write-off proposals for leftovers
  10. Planner approves write-off proposalsThe agent waits here for your OK.
  11. Product retired with final stock reported

How it decides

It plans to reach zero stock within 2 weeks of the replacement start and revises when projected stock-out moves by more than 2 weeks.

  • Aim for zero stock within 2 weeks of the replacement start.
  • Propose a bridge buy when the replacement slips more than 3 weeks.
  • Propose a markdown when stock exceeds 6 weeks of demand near the end.
  • Recalculate weekly from actual sales.

Make it yours

Every agent is a starting point. You choose these settings for your own situation.

  • Run-down tolerance (default 2 weeks)
  • Bridge buy threshold (default 3 weeks)
  • Markdown rules
  • Review day

What keeps you in control

It always asks you first

  • Planner approves purchases and notices
  • Planner approves write-off proposals

Hard limits

  • Never place purchase orders itself
  • Show the numbers behind every dates change

It stops when

  • Done: stock sold through and product retired.
  • Stop: replacement cancelled, so the planner reviews the phase-out.

Set it up

We guide you through the set-up, step by step

Members get the full set-up guide for this agent. No technical skills needed: you copy, paste and upload.

10 minto set it up in your AI
5 AIsChatGPT, Claude, Copilot, Gemini, Grok
  • One set of instructions to paste into your AI, with the clicks for ChatGPT, Claude, Microsoft 365 Copilot, Gemini and Grok
  • The agent then walks you through connecting your own data, one source at a time
  • A downloadable copy with the flow chart, the rules and the full guide
Get access to this agent

An example run

What happensA retiring model had 5,400 units and weekly demand of 600, with the replacement due November 18. The first plan set the last buy for September 30. In week 4 the replacement slipped to December 16, so the check failed. The agent proposed a 1,800 unit bridge buy and a customer notice. The planner approved the buy and the plan was reset.

More agents for demand planners