Retail and e-commerce
Some stores hold too much stock while others run out. One plan links your demand forecast, replenishment and markdowns to fix both.
- Free 30-minute call
- No commitment
- You own the code
Typical problems in retail and e-commerce.
One store marks down winter jackets while the store across town has none left. Each quarter ends in discounts, and nobody sees the sales you lost.
Wrong stock, wrong place
Your biggest store sells out of the blue jacket by Saturday. A full rail of it hangs unsold in a store with fewer customers.
Markdowns mask the problem
Every quarter, you discount what didn’t sell. The discount hides a mistake made months earlier: the forecast was wrong, or the stock went to the wrong stores.
Lost sales you cannot see
A customer finds an empty shelf and buys elsewhere. No report records the sale that never happened.
Each team plans on its own
Forecasting, buying and pricing each run their own spreadsheet. Each team improves its part, and the parts work against each other.
In short: A retail inventory optimisation decides how much of each product every store holds, when to reorder and when to discount. It links three things in one plan: the demand forecast, reordering and markdowns. Markdowns are price cuts on products that sell slowly.
Stockouts and excess stock are one problem
On Saturday afternoon, the shelf for the best-selling jacket in your busiest store is empty. Across town, a quieter store has the same jacket on a full rail. In three weeks it’ll be marked down. That’s a planning failure. You see it every quarter in three places: markdowns, lost sales and write-offs, the goods you can’t sell at all any more.
The lost sales hurt most, because no report ever shows them. Most retailers fix three things separately: demand planning (how much will sell), replenishment (when and how much each store reorders) and markdowns. Each fix helps a little and works against the others. Excess stock and stockouts look like two problems, so they get two projects, although both come from the same plan.
What retail inventory optimisation changes
Today, you order from last year’s sales and gut feeling, and markdowns come at season end. Our model starts from your demand forecast and works out how much each store should reorder. Stock goes to the stores that will sell it. If a store still has more stock than it will sell by season end, the model proposes a markdown for that store. It does so as soon as your sales figures show it, not only at season end.
You see how your forecast turns into orders and markdowns, store by store, so you use it instead of overruling it. Excess stock and stockouts show up on one page, in the same numbers.
Demand, replenishment and markdown as one system
Everything starts with your demand forecast. Inventory optimisation then sets how much to hold and when to reorder, for each product and store. Markdown optimisation is the last step. It uses price elasticity: how much more you sell at each step of discount. So each week gets the discount that fits, instead of one flat cut on the whole product group.
Is one forecast number enough?
For stock, the uncertainty around a forecast matters more than it looks. How much to hold depends on the spread of demand, not just its middle. Inventory optimisation picks the order quantity from the whole spread of demand. It uses the ratio between what a lost sale costs and what an unsold item costs (the newsvendor model). So your forecast should give a range, not a single figure. The inventory and markdown use cases below show each step.
How a project runs.
Each of the three phases ends with something you can check before we go any further.
-
Understand
We start with your operation. What do you plan, where does it go wrong, and what would a better week look like? Then we tell you straight whether optimisation can help, and sometimes the answer is no.
- A written assessment
- A clear go or no-go
-
Model
We write your decisions, goals and rules into a mathematical model, which is just a precise description of how your operation works. Then we run it on your own data. You see side by side what each plan costs and what it delivers, and pick the one that fits your priorities.
- A documented model
- Results on your own data
-
Implement
We test with your data and go through the results with your team. Once they trust it, we connect the model to your systems, so it runs every day without anyone stepping in by hand.
- Source code and documentation
- Training for your team
Common questions.
Something else? Ask us directly.
As soon as the stock in a store won’t sell at full price before the season ends. A markdown model works out two things for each store: how much you’d probably sell at 10, 20 or 30 percent off, and how much stock is left there. Sometimes a small early discount brings in more than a deep late one. Which is better depends on how strongly your customers react to a lower price. This is called price elasticity. The model shows that trade-off store by store.
No till records a sale that didn’t happen, so you estimate it. Compare sales on days with stock against days when the shelf ran empty, for the same product and store. The gap gives a rough figure for lost demand. Feeding it back into your forecast also stops it from reading empty shelves as low demand.
It depends on the problem, so we agree the timeline with you up front. Every project starts with a diagnostic, a short look at how you plan today. It shows which data, how much time and what budget a model for daily use needs. Only then do you decide.
No. We connect to your ERP, your warehouse management system or your planning spreadsheet. We build the model only for the planning that gives you trouble today. Your systems keep running as before.
Almost nobody’s data is clean. The diagnostic shows what the model needs and what’s missing. Then we build the model to cope with messy data.
Off-the-shelf tools are built for many companies at once, so they don’t know your special rules. We build a model that follows exactly your rules. Then we hand it over, and your team owns it.
Similar pages.
Tell us what you’re planning.
In a free 30-minute call with a specialist, you find out whether optimisation can help.
- Free, no commitment
- You talk to a specialist directly
- A clear go or no-go