Model price increases and supply failures in advance
Companies simulate scenarios such as a price increase or a supply failure before they decide
Fits: Leaders & strategy · Sales · Finance & accounting · Purchasing
Before the decision, you see what a price increase or a failing supplier could mean for sales volume, contribution margin and stock, in several variants rather than as a single figure. In discussions with management or the bank, you can lay out the assumptions instead of going on gut feeling.
Is this for you?
- You face a decision that can be expressed in sales volume, costs and delivery times: a price round, a change of supplier, a shortage of a component.
- Sales, cost and stock data is available in your merchandise management system, accounting or controlling.
- Today someone works through such questions once in Excel, and variants are missing.
Take one product and use the template below to work through two scenarios with rounded or disguised figures: a price increase with three different customer reactions and a supply failure over a few weeks. Recalculate one value yourself.
How to go about it
- Define the decision, scenarios and limits
- Gather sales, cost and supply data
- Have the scenarios calculated
- Check assumptions with controlling and sales
- Compare with real events
- Update assumptions after the decision
Templates to copy
The complete guide
- 6 steps explaining exactly what to do
- 3 proven templates to copy into your own AI
- Safe use: data, checking, deciding, informing
- Pitfalls, effort and how to recognise success
With the training you get all 430 guides for as long as your access runs.
Same approach, other use cases
15 more use cases follow the pattern “Designing & simulating”.
A-097 · Legal status 08.10.2026