Newsvendor Calculator
The math behind a one-time buy: too few costs you margin and customers, too many costs you the E&O meeting. Enter both costs and this gives the order quantity that maximises expected profit, plus the trade-off curve it sits on.
Built for buyers, category managers and demand planners at mid-size distributors and manufacturers — HVAC and seasonal equipment, sanitary and building materials, technical distribution (valves, fittings, components), electrical components and professional equipment. It is aimed at the new-item stocking decision: one order, no sales history, a supplier MOQ and a lead time you cannot shorten.
Your numbers
Results update as you type. Nothing is sent anywhere — the calculation runs in this browser tab.
Show the numbers
| Order | Expected profit | Stock-out risk | Expected leftover |
|---|---|---|---|
| 493 | €20,184 | 99% | 0 |
| 527 | €21,539 | 98% | 1 |
| 561 | €22,870 | 97% | 2 |
| 595 | €24,160 | 95% | 3 |
| 629 | €25,396 | 93% | 5 |
| 663 | €26,563 | 90% | 8 |
| 697 | €27,644 | 86% | 12 |
| 731 | €28,626 | 82% | 18 |
| 765 | €29,492 | 77% | 25 |
| 799 | €30,239 | 73% | 33 |
| 833 | €30,872 | 68% | 43 |
| 867 | €31,378 | 63% | 55 |
| 901 | €31,759 | 58% | 68 |
| 935 | €32,000 | 53% | 83 |
| 969 | €32,117 | 48% | 100 |
| 1,003 | €32,109 | 44% | 119 |
| 1,037 | €31,991 | 40% | 139 |
| 1,071 | €31,777 | 36% | 160 |
| 1,105 | €31,465 | 32% | 182 |
| 1,139 | €31,060 | 28% | 206 |
| 1,173 | €30,557 | 25% | 231 |
| 1,207 | €29,973 | 22% | 257 |
| 1,241 | €29,324 | 19% | 284 |
| 1,275 | €28,602 | 17% | 311 |
| 1,309 | €27,820 | 15% | 340 |
| 1,343 | €26,984 | 13% | 369 |
| 1,377 | €26,100 | 11% | 399 |
| 1,411 | €25,181 | 10% | 430 |
| 1,445 | €24,232 | 9% | 461 |
| 1,479 | €23,251 | 8% | 492 |
| 1,513 | €22,243 | 6% | 524 |
| 1,547 | €21,207 | 6% | 556 |
| 1,581 | €20,153 | 5% | 588 |
| 1,615 | €19,078 | 4% | 620 |
| 1,649 | €17,988 | 4% | 653 |
| 1,683 | €16,882 | 3% | 686 |
| 1,717 | €15,766 | 3% | 719 |
| 1,751 | €14,635 | 2% | 752 |
| 1,785 | €13,495 | 2% | 785 |
| 1,819 | €12,346 | 1% | 819 |
| 1,853 | €11,189 | 1% | 852 |
How this is calculated
| Critical ratio | 54% | Cu ÷ (Cu + Co) = €41 ÷ (€41 + €35) |
|---|---|---|
| Optimal quantity | 983 units | the demand quantile at that ratio — F⁻¹(Cu / (Cu + Co)) |
| Demand model | log-normal | 4,000 draws with your mean and spread; positive and right-skewed, the way demand behaves. Seeded, so the answer never moves on its own. |
The classic newsvendor result is a formula, not a simulation. This page simulates anyway, because the same fixed sample then produces the whole trade-off curve — and because it is the identical engine the core tool uses, so the two can never disagree.
The model in one paragraph
The newsvendor problem is the oldest question in inventory theory and still the most useful: you order once, demand is uncertain, and both mistakes cost money. Order one unit too few and you lose the underage cost — normally the gross margin you did not earn. Order one unit too many and you pay the overage cost — what the unit cost you, minus whatever you can still recover. Because the second unit you add to the order is less likely to sell than the first, there is a point where the expected gain from one more unit exactly equals the expected loss. That point is the optimum, and it is not the average demand.
The answer is a quantile, not an average. Order enough to cover demand up to its critical ratio — the underage cost divided by the sum of both costs. If a shortage costs three times what an unsold unit costs, the ratio is 75% and you deliberately plan to have stock left over most of the time. If unsold units are written off entirely while margins are thin, the ratio can fall below half, and running out regularly is the correct, profit-maximising behaviour. The counter-intuitive part is that the optimum tracks the balance of the two costs, not your comfort with either one.
In distribution, both numbers are usually worse than they look on paper. The underage cost is not only the margin on the missed line: fill rate is a top- three supplier-selection criterion for most B2B buyers, and customers who hit a stock-out cut their follow-up orders measurably. The overage cost is not just the unit price either — dead stock carries at roughly a quarter of its value per year and liquidates at ten to forty percent of cost. If you enter honest numbers for both, the optimum this page returns will usually sit higher than the quantity that feels comfortable.
Where these numbers come from
- Sector patterns are built-in assumptions — a launch curve shape and an uncertainty range per sector, written by us and visible on the page. They are not pooled customer data, and nobody else's numbers are mixed into your result.
- The economics are your inputs, applied openly — every calculation on this page is shown with its formula. There is no model that "knows better" than the numbers you entered.
- Nothing is uploaded. The calculation runs in this browser tab. If you supply your own launch history, it is parsed here and stored on this device only; there is no server to send it to, and no account to create.
FirstBuy AI simulates one from launches like yours — your own past launches if you upload them, or typical sector patterns if you have none. Same engine, same economics, applied to a real first-buy decision.
Related
- The newsvendor model explained — worked through with numbers, no calculus.
- Initial Order Quantity Calculator — the same maths applied to a product launch, demand included.