EN
Inventory and Products

How Do You Calculate Stockout Cost? A Guide to Lost Sales, Indirect Losses, Losses by Product Class, the Extra Stock Decision, the Early Warning Rule and Loss Containment

How do you calculate the cost of stockouts? Lost sales, indirect loss, loss by product class, the extra stock decision and an early warning rule: an 8-lesson guide with examples.

Contents 14 sections
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why is a stockout an invisible loss?
  3. Lesson 2: How are lost sales and direct loss calculated?
  4. Lesson 3: Indirect loss: do sales stay down after a stockout?
  5. Lesson 4: What is the total cost of stockouts by product class?
  6. Lesson 5: Extra stock or lost sales? Which costs more?
  7. Lesson 6: How do you set up a rule that warns you before stock runs out?
  8. Lesson 7: How do you limit losses on a stockout day?
  9. Lesson 8: How do you monitor the cost of stockouts?
  10. What are the most common mistakes in calculating the cost of stockouts?
  11. How does NetKasam make inventory tracking easier?
  12. Mini quiz: Test what you have learned
  13. Conclusion: Find out which products were out of stock this month and for how many days
  14. Frequently Asked Questions About the Cost of Stockouts

Having too much stock shows up in the accounts: it sits in the warehouse, ties up capital and is cleared one day. Having no stock shows up in no record at all. No invoice is issued for a product that could not be sold, and no expense is booked for a customer who walked away; all that is left at the end of the month is a feeling that "it could have been better". Yet every day spent out of stock is a calculable loss of profit, and in most businesses it is larger than the cost of excess stock.

This article is not a lecture but an 8-lesson hands-on course. We will answer how to calculate the cost of stockouts using a business with three product classes (A, B, C): calculating lost sales, indirect effects such as lost ranking on marketplaces, total loss by class, comparing the cost and benefit of extra stock, an early warning rule, limiting losses with a waiting list and substitute products, and monitoring indicators. At the end there is a mini quiz with an answer key. We explained at what level stock should be kept in the article how to calculate safety stock; this article shows in money terms why that stock is needed.

What will you be able to do by the end of this training?

In short: You will calculate the monetary loss of stockout days, set priorities by product class, see whether extra stock pays for itself and set up a rule that warns you before stock runs out.

Course mapSix steps to managing the cost of stockouts
  1. 01
    SeeRecord stockout days by product.
  2. 02
    CalculateConvert missed demand into contribution.
  3. 03
    ClassifySee the total by class A, B and C.
  4. 04
    ComparePut the cost and benefit of extra stock side by side.
  5. 05
    WarnPlace an order when days of stock remaining drop to the threshold.
  6. 06
    LimitReduce losses with a waiting list and substitute products.

The course's 8 lessons: (1) why stockouts are invisible, (2) calculating lost sales, (3) indirect loss, (4) total cost by class, (5) extra stock or lost sales, (6) an early warning rule, (7) limiting losses on a stockout day, (8) monitoring indicators.

Lesson 1: Why is a stockout an invisible loss?

In short: A product that could not be sold does not appear as a line in any report; that is why stockouts are ignored unless they are measured.

Sample business: a business with a total of 100 products in three classes, selling on its own site and on marketplaces. The inventory report says "0 units of product X" but does not say "this product could not be sold for 6 days last month". The sales report shows only the sales that happened. As long as the two reports are not read together, the loss looks like normal sales fluctuation.

Stockouts go unnoticed for four reasons: (1) missed demand is not recorded, (2) if the product listing is closed, nobody searches for it, (3) responsibility gets lost between purchasing and sales, (4) an inventory count only knows the quantity on hand, not past days at zero. The solution is simple: at the end of the month, the number of days each product was out of stock is pulled as a separate column. Inventory management records provide a sufficient basis for tracking inventory movements and the last movement date.

Lesson 2: How are lost sales and direct loss calculated?

In short: Direct loss is the lost portion of demand on stockout days multiplied by the unit contribution.

FormulaFour steps of direct stockout loss
  1. Missed demand = Average daily demand × Number of stockout days
  2. Lost sales = Missed demand × Loss rate
  3. Direct loss = Lost sales × Unit contribution
  4. Total loss = Direct loss × (1 + Indirect loss rate)

Prepared with sample values. Unit contribution is the amount left after deducting product cost, commission, shipping and packaging from the selling price.

Sample product: selling price ₺500, purchase cost ₺300, unit contribution ₺140, average daily demand 20 units. The product was out of stock for 6 days this month.

StepAccountResult
Missed demand20 × 6120 units
Lost sales (70%)120 × 0,7084 units
Direct loss84 × 14011.760 ₺

Not all missed demand is lost: some customers wait for the product to arrive or choose another product. You can find the loss rate with your own data rather than assumptions: compare sales in the two weeks after stock returns with the two weeks before the stockout; the slower the recovery, the higher the loss rate. The example uses 70%. For how unit contribution is calculated, see the article how to calculate profit margin.

Product pageFree Bookkeeping Software

Lesson 3: Indirect loss: do sales stay down after a stockout?

In short: On marketplaces, a listing that goes out of stock can lose visibility; even when stock returns, sales do not get back to their previous level for a short while. This loss is added to the direct loss as a rate.

In the example, indirect loss is taken as 25% of the direct loss: 11,760 × 0.25 = ₺2,940. Total loss is 11,760 + 2,940 = ₺14,700. The same result is found with the loss factor: daily contribution 20 × 140 = ₺2,800; 2,800 × 6 days × 0.875 = ₺14,700. Indirect loss has three components: ranking loss, the "sold out" label on the product page reducing trust, and the promotional spend that starts once stock arrives.

Type of lossHow it is measuredIn the example
DirectLost sales × unit contribution11.760 ₺
IndirectTwo-week sales drop after restocking2.940 ₺ (%25)
TotalDirect + indirect14.700 ₺

Measure the indirect rate with your own data as well; start with one product and take the average of several. If you do not have a measured rate, using 25% as a starting assumption is far better than not counting it at all. We explained how to keep stock information consistent across marketplace channels in the article how to do marketplace stock synchronization.

Recommended readingHow to Calculate Inventory Turnover?

Lesson 4: What is the total cost of stockouts by product class?

In short: Total loss is the product of each class's number of products, daily contribution and number of stockout days; the biggest loss does not always come from the best-selling product class.

Products were divided into three classes by sales velocity. For how to do the classification, see the article how to do an ABC analysis.

ClassProductDaily contribution (per product)Stockout days/monthMonthly loss
A102.800 ₺373.500 ₺
B30900 ₺370.875 ₺
C60250 ₺452.500 ₺
Total100196.875 ₺

Calculation: for A, 10 × 2,800 × 3 × 0.875 = ₺73,500; for B, 30 × 900 × 3 × 0.875 = ₺70,875; for C, 60 × 250 × 4 × 0.875 = ₺52,500. Total loss is ₺196,875, ₺2,362,500 a year. Class A has only 10 products, yet its loss is almost the same as class B's: class B is the sum of small losses across a larger number of products. That is why monitoring only the best-selling products is not enough.

ChartMonthly stockout loss by class: all three classes carry a large share
  • Class A₺73,50037.3%
  • Class B₺70,87536%
  • Class C₺52,50026.7%

Prepared with sample values.

Lesson 5: Extra stock or lost sales? Which costs more?

In short: The cost of extra stock is the monthly cost of the capital tied up; its benefit is the value of fewer stockout days. You cannot decide without putting the two side by side.

Goal: reduce stockout days by 2 days in each class (from 3 to 1 for A and B, from 4 to 2 for C). To do this, extra stock equal to 2 days of demand is held for each product. Purchase costs: A ₺300 (daily demand 20), B ₺200 (daily demand 10), C ₺250 (daily demand 2). The inventory holding cost is taken as 30% a year, or 2.5% a month.

ClassExtra stockCapital tied upMonthly holding costMonthly gainClear
A40 units × 10 products120.000 ₺3.000 ₺49.000 ₺46.000 ₺
B20 units × 30 products120.000 ₺3.000 ₺47.250 ₺44.250 ₺
C4 units × 60 products60.000 ₺1.500 ₺26.250 ₺24.750 ₺
Total300.000 ₺7.500 ₺122.500 ₺115.000 ₺

Benefit calculation: for A, 10 × 2,800 × 2 × 0.875 = ₺49,000; for B, 30 × 900 × 2 × 0.875 = ₺47,250; for C, 60 × 250 × 2 × 0.875 = ₺26,250. The loss drops from ₺196,875 to ₺74,375.

ChartThe drop in the cost of stockouts: from ₺196,875 to ₺74,375
  1. Starting monthly loss₺196,875
  2. Class A: from 3 days to 1 day−₺49,000
  3. Class B: from 3 days to 1 day−₺47,250
  4. Class C: from 4 days to 2 days−₺26,250
  5. Remaining monthly loss₺74,375

Prepared with sample values. Total: 196,875 − 49,000 − 47,250 − 26,250 = ₺74,375. After separately deducting the ₺7,500 monthly cost of the extra stock, the net gain is ₺115,000.

Tying up ₺300,000 of capital earns ₺122,500 at a monthly cost of ₺7,500: the gain is more than 16 times the cost. The calculation does not come out the same for every product; extra stock is more expensive for products with irregular demand, long lead times or a short life. Alongside this calculation, do not forget the risk of dead stock: extra stock ages in products whose demand is falling; for ways to clear it, see the article how to clear dead stock. Instead of applying the same number of days to every product, holding extra stock for products with high contribution and steady demand is more efficient.

Lesson 6: How do you set up a rule that warns you before stock runs out?

In short: Days of stock remaining is found by dividing stock on hand by daily sales. An order is placed when it drops to the sum of lead time and the safety margin.

FormulaTwo formulas for the rule that warns before stock runs out
  1. Days of stock remaining = Stock on hand ÷ Average daily sales
  2. Order threshold (days) = Lead time + Safety margin

The threshold shows that an order should be placed when days of stock on hand drop to this value. Prepared with sample values.

ProductInventoryDaily salesDays remainingLead time + safetySituation
Product 1 (A)1802097 + 2 = 9Place order
Product 2 (A)40020207 + 2 = 9Comfortable
Product 3 (B)5010510 + 3 = 13Too late
Product 4 (C)3021514 + 4 = 18Place order

The Product 3 example matters: 5 days of stock remaining, 10-day lead time. Even if the order is placed now, the product will be out of stock for at least 5 days; the loss has already begun. So instead of waiting to drop below the threshold, sort the list by days remaining every day (or at least twice a week) and start with the smallest values. Setting the critical stock level on the product card automates this sorting; for details, see the inventory management page.

ChartDays of stock remaining: Product 3 is below lead time, Product 2 is comfortable
  1. Product 19 days
  2. Product 220 days
  3. Product 35 days
  4. Product 415 days

Prepared with sample values.

In the threshold calculation, lead time is not the time the supplier quotes but the actual time from order to shelf; measure it from the last five orders. For how to monitor suppliers' on-time delivery, see the article how to measure supplier performance.

Lesson 7: How do you limit losses on a stockout day?

In short: A waiting list and redirecting to a substitute product win back part of the lost sales; both are free but require discipline.

Recall the sample product from lesson 2: 84 of the 120 units of missed demand were lost. Suppose two measures are taken on stockout days:

PreventionRecoveredUnit contributionGain
Waiting list (notify when back in stock)18 units140 ₺2.520 ₺
Redirect to a substitute product24 units110 ₺2.640 ₺
Total42 units5.160 ₺

The direct loss was ₺11,760; with ₺5,160 recovered, it drops to ₺6,600. The substitute product's unit contribution is lower (₺110), because a redirected customer usually chooses a cheaper or lower-margin product. The waiting list conversion is taken as 15% (18 ÷ 120) and the substitution rate as 20% (24 ÷ 120).

Both measures have the same prerequisite: deciding in advance which product will substitute for the one that is out of stock. Choose a substitute product for every A and B product, and redirect customers to it in the listing description or customer message. For how to handle order cancellations and customer notifications, see the articles how to cancel an order and how to notify customers about orders. None of these measures is as effective as extra stock, but you can start at zero cost.

Recommended ReadingHow Do You Plan Seasonal Product Inventory?

Lesson 8: How do you monitor the cost of stockouts?

In short: Monitor four indicators at month-end and weekly: stockout day rate, days of stock remaining, monthly loss and return on extra stock.

IndicatorHow it is calculatedSample target
Stockout day rateStockout product-days ÷ (Number of products × Days)Below 3% for A
Days of stock remainingInventory ÷ Daily salesAbove lead time + safety
Monthly stockout lossDaily contribution × Stockout days × 0.875Below ₺74,375
Return on extra stockGain ÷ Monthly holding costPositive and above 3 times
Takeaways from the exampleFour numbers from the cost of stockouts example
  • ₺14,7006-day loss of a product with a daily contribution of ₺2,800
  • ₺196,875total monthly stockout loss across three classes
  • ₺115,000monthly net gain with ₺300,000 of extra stock
  • ₺5,160contribution recovered with a waiting list and substitutes

If the stockout day rate is good but the loss is high, the problem is concentrated in a small number of high-contribution products; look at those products first. If days of stock remaining are short but the rate is good, lead time has grown longer. If the return on extra stock is falling, more stock than necessary is being held for products whose demand is declining. To add these four indicators to your weekly management summary, you can use the table in the article how to prepare a weekly management report.

What are the most common mistakes in calculating the cost of stockouts?

  1. Counting only excess stock as a cost. Because stockout losses are not measured, they are assumed to be zero.
  2. Not counting stockout days while the listing is closed. The loss never shows up in the report.
  3. Counting all missed demand as lost. Customers who wait or choose a substitute are not taken into account.
  4. Ignoring indirect loss. Sales are expected to return to their previous level as soon as stock arrives.
  5. Monitoring only class A. The total loss of classes B and C is often of a similar size.
  6. Taking lead time at the supplier's word. The actual time is often longer.
  7. Applying extra stock at the same rate to every product. The risk of dead stock increases for products with irregular demand.

How does NetKasam make inventory tracking easier?

  • Stock movements and reorder levels. You track stock movements on one screen and set reorder quantities (inventory management).
  • Marketplace and e-commerce integration. Orders are collected in a single panel; you track stock and sales status across channels (marketplace integration).
  • Orders on a single screen. You filter orders in one place to see sales velocity by product (order management).
  • Stock by warehouse and branch. You track stock separately by warehouse and branch (branch and warehouse management).
  • Saved reports. You save inventory and sales reports, export them to Excel and build the month-end stockout table (reports).
  • Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.

Mini quiz: Test what you have learned

In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.

  1. A product with daily demand of 20 units was out of stock for 6 days. How many units of demand were missed?
  2. If the loss rate is 70% and the unit contribution is ₺140, what is the direct loss?
  3. If indirect loss is 25% of direct loss, what is the total loss?
  4. If 30 products with a daily contribution of ₺900 are out of stock for 3 days, what is the monthly loss with a loss factor of 0.875?
  5. For a product with 50 units in stock, daily sales of 10 units, a lead time of 10 days and a safety margin of 3 days, would an order placed now be on time?

Answer key:

  1. 20 × 6 = 120 units.
  2. 120 × 0.70 = 84 units; 84 × 140 = ₺11,760.
  3. 11.760 × 1,25 = 14.700 ₺.
  4. 30 × 900 × 3 × 0,875 = 70.875 ₺.
  5. Days remaining 50 ÷ 10 = 5; threshold 10 + 3 = 13 days. Days remaining are below the threshold; the order is late and the product will be out of stock for at least 5 days.

Frequently Asked Questions About the Cost of Stockouts

What is the cost of stockouts?

It is the profit lost from sales missed because a product was out of stock and from the loss of visibility that follows; it does not appear in the accounting records but can be calculated.

How is the cost of stockouts calculated?

Average daily demand is multiplied by the number of stockout days, then by the loss rate and the unit contribution, and the indirect loss rate is then added.

How is the loss rate found?

Sales in the two weeks after stock returns are compared with sales in the two weeks before the stockout; the slower the recovery, the higher the loss rate.

What is indirect loss?

It is when a listing that went out of stock sells less for a while after stock arrives because of lost ranking and trust; it is added to the direct loss as a rate.

Is holding extra stock always right?

No. For products with high contribution and steady demand, it usually pays for itself; for products with irregular demand or a short life, extra stock increases the risk of dead stock.

How are days of stock remaining calculated?

Stock on hand is divided by average daily sales. When the result drops to the sum of lead time and the safety margin, an order should be placed.

How do I reduce losses on a stockout day?

A waiting list and redirecting customers to a predetermined substitute product win back part of the lost sales.

How does NetKasam help with stockout tracking?

It shows inventory movements on a single screen, lets you set a critical stock level, and offers saved reports and Excel export; bookkeeping is free.

Conclusion: Find out which products were out of stock this month and for how many days

The most useful thing you can do today is to pull the number of days each product was out of stock from last month's inventory movements and calculate the loss for the five products with the largest daily contribution. When you compare the resulting amount with the monthly cost of extra stock, you will see where your inventory decisions generate profit and where they generate losses. The next step is to turn the days-of-stock-remaining list into a weekly habit.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeFree Bookkeeping Software

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools