Markdown Optimization Calculator

A product that's still far from its sell-through target after 12 weeks has little selling season left to recover organically, so the calculator shifts from closing a modest share of the gap to closing up to 90% of it. Waiting even longer to markdown a genuinely slow-moving item usually just means liquidating it later at an even steeper discount anyway.

The caps prevent the formula from recommending an extreme markdown purely because the gap is large, which protects margin in situations where a milder discount might still be enough to meaningfully accelerate sales. The caps grow looser at each later stage, reflecting that deeper discounts become more justified as the selling window shrinks.

When the gap is zero or negative — meaning you've already hit or beaten your target sell-through — the calculator recommends no markdown at all, since discounting a product that's already selling at the desired pace would just give up margin unnecessarily. Full price is the right call as long as sell-through velocity is on track.

The calculator's weeks-to-target estimate assumes velocity increases in proportion to the discount, but real customer response to markdowns varies — a shallow discount on a product with no underlying demand issue may barely move the needle, while the right discount on a genuinely price-sensitive item can accelerate sales more than the formula projects. Treat the weeks-remaining estimate as directional rather than precise.

The margin figure shows exactly how much profit cushion remains between the discounted price and your cost, which lets you judge whether the recommended markdown still leaves room for a healthy return or pushes the item close to breakeven. A recommendation that erodes margin to near zero is worth weighing against simply accepting slower sell-through instead.