Estimate direct revenue and gross profit at risk under your assumptions
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.
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.
Review the assumptions and compare the scenario with actual unavailable-product and order records before making an inventory decision.
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.
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.
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