All tools

Stockout Cost Calculator

Estimate direct revenue and gross profit at risk under your assumptions

Your typical order value
Average orders per day
Share of otherwise expected orders assumed unfilled on stockout days
Days affected within the month being modeled (0–31)
Your gross profit margin

This is a scenario, not a measurement of lost sales. Use expected orders without a stockout, not an already reduced order count. Defaults are illustrative. The affected percentage applies only to the stockout days entered. Orders recovered through a substitute, another location, a backorder or a later purchase are not necessarily lost.

Your Stockout Impact

Monthly Lost Revenue

$0

Monthly Lost Profit

$0

Lost Customers

0

Annual Impact

$0

Cost Breakdown (Estimates)

Direct lost sales (missed orders) -$0
Gross profit at risk (revenue × margin) -$0
Unfilled orders in this scenario -$0
Churn, brand and emergency restocking costs ~$0

Revenue and gross profit are different views of the same scenario; do not add them together. Annual Impact repeats the modeled month 12 times and is not a seasonal forecast. Customer churn, brand damage, emergency freight, substitution and delayed purchases are not estimated here.

What This Means

Review the assumptions and compare the scenario with actual unavailable-product and order records before making an inventory decision.

How stockout cost is calculated

The calculator multiplies daily orders by the share of orders affected and the days out of stock to get affected orders, multiplies those by average order value for lost revenue, and applies your gross margin for lost gross profit. Annual impact is the monthly figure times 12.

It leaves out lost customer lifetime value, ad spend wasted on out-of-stock products, and emergency restocking costs, so the real cost can be higher.

Worked example: 40 orders a day, 10% of orders affected and 5 days out of stock gives 20 affected orders. At a $60 average order value that is $1,200 of lost revenue, and at a 40% gross margin, $480 of lost gross profit for the month.

Stockout rate

One common way to measure stockout rate is orders that could not be filled because an item was out of stock, divided by total orders, times 100.

Related: what a stockout is, safety stock and the safety stock calculator.

Prevent Stockouts Before They Happen

Forthcast provides Shopify demand forecasts and replenishment recommendations, with draft purchase orders for merchant review. The plan is $19.99 per month with a 14-day free trial; approve Shopify billing to access the app. Forecasting does not guarantee that stockouts will be avoided.

Try Forthcast Free for 14 Days
Powered by Forthsuite | Free tools for Shopify merchants