You know the feeling. One SKU is sitting in storage longer than it should, cash is trapped in boxes, and your bestseller is suddenly too close to zero for comfort. Then an inbound shipment slips, Amazon inventory gets tight, Shopify keeps taking orders, and your team is making reorder calls based on instinct instead of math.

That’s where the days of supply formula becomes useful. It gives you a plain answer to a hard operational question: if sales keep moving at the current pace, how long will this inventory last? For a scaling e-commerce brand, that answer affects cash flow, storage planning, purchasing, FBA replenishment, and customer experience.

A lot of inventory advice still pushes one idea. Keep inventory lean at all times. In practice, that’s too simple for modern e-commerce. If you import product, depend on containers, sell across Amazon and Shopify, or run promotions that distort demand, the best strategy often isn’t the lowest possible inventory position. It’s the right one.

Beyond Guesswork Why Days of Supply Matters for Your Brand

Brands don’t usually have an inventory problem; they have a decision problem.

The issue usually shows up in two ways. Either the team buys too early and ties up cash in slow-moving stock, or they buy too late and create stockout risk on the products that pay the bills. Both errors hurt margin. They just hurt it differently.

Days of supply helps you stop managing that tension by feel. It turns inventory into a time-based metric your team can act on. Instead of asking, “Do we have a lot of stock?” you ask, “How many selling days do we have left?”

What DOS fixes in day-to-day operations

For an e-commerce operator, that changes how you run the business.

  • Cash planning gets clearer. You can spot which SKUs are overbought before they become dead weight.
  • Reorder timing improves. Buyers stop placing POs based on warehouse anxiety and start using a consistent threshold.
  • Channel management gets tighter. Amazon, Shopify, and Walmart rarely move at the same pace, so a time-based view reveals pressure sooner.
  • 3PL coordination gets easier. If your warehouse partner knows what inventory is supposed to cover, inbound scheduling and prep work become more predictable.

Practical rule: Inventory counts alone are misleading. A pallet of a slow seller and a pallet of a fast seller do not represent the same risk.

This is also why DOS belongs in the same conversation as profitability, contribution margin, and demand planning. If you’re already reviewing broader Key Performance Indicators (KPIs) for e-commerce, DOS fits naturally alongside conversion, fulfillment, and return metrics because it connects demand to working capital.

Why this matters more now

The old “lower is always better” logic breaks down when lead times are unstable.

If your freight timing shifts, receiving gets delayed, or one marketplace suddenly accelerates, a very lean inventory position can create a bigger problem than modest overstock. The operator’s job isn’t to chase the lowest possible number. It’s to hold enough inventory to keep revenue moving without letting cash sit idle longer than necessary.

That’s the value of the days of supply formula. It replaces reactive decisions with a usable operating signal.

Understanding the Core Days of Supply Formula

The standard days of supply formula is:

DSI = (Average Inventory / Cost of Goods Sold) × 365

Finance teams usually call this Days Sales of Inventory (DSI) or Inventory Days of Supply. It became popular as companies pushed for leaner inventory systems, but that old target of keeping DOS as low as possible does not hold up well when container timelines slip, receiving backs up, or Amazon demand spikes without warning.

A flowchart explaining the Days of Supply formula including definitions for current inventory and daily sales.

An analogy: miles to empty

DOS works like a fuel gauge.

Your inventory is the fuel in the tank. Your sales velocity is the burn rate. Your days of supply is the estimate of how long that inventory lasts before you run out.

That framing matters because unit counts hide risk. Ten thousand units can be a problem or a cushion depending on how fast that SKU moves, how long replenishment takes, and whether inbound freight is on schedule.

What each part means in practice

The formula has three parts that matter in different ways depending on whether you are closing the books or deciding on the next PO.

Component What it means Practical e-commerce interpretation
Average Inventory Opening inventory plus closing inventory, divided by 2 Your typical inventory value over the period
COGS Cost of goods sold The cost basis of what sold during the period
365 Days in the year Converts the ratio into a time measure

For finance, average inventory is a clean way to measure inventory across a reporting period.

For operations, the more important point is that DOS uses COGS, not revenue. That keeps the number tied to what inventory costs you to carry and replace. It avoids getting distorted by discounting, price changes, or channel mix.

Why operators also use a simpler planning version

Warehouse teams, inventory planners, and brand operators often use a faster version for day-to-day decisions:

Current Inventory / Daily Sales

That shortcut is different from the formal accounting formula, but it answers the question that matters during a live week of operations: how many selling days are left if demand holds at the current pace?

If you are placing a purchase order, booking inbound appointments, or deciding how much stock to send to FBA versus hold for Shopify orders, the planning version usually gives the better operating signal.

The accounting version helps evaluate past performance. The operational version is better for deciding what to do next.

What the formula is telling you

The days of supply formula is a time-to-risk metric.

A high reading can point to excess stock, slow-moving inventory, or cash sitting too long. It can also reflect a deliberate buffer, which is often the right call for importers and scaling DTC brands dealing with long lead times and uneven receiving windows. A low reading can look efficient on paper, then turn into a stockout the moment a container misses cutoff, Amazon checks in late, or one paid campaign lifts demand faster than forecast.

That is the trade-off operators manage every day. Good DOS is not always the lowest number. Good DOS is the number that gives your brand enough coverage to protect sales, absorb supply chain delays, and avoid tying up more cash than the business can afford.

How to Calculate Days of Supply with Worked Examples

A founder sees 12,000 units on hand and assumes inventory is safe. Then a container rolls a week late, Amazon takes longer than expected to receive, and Shopify demand stays hot after a promotion. The problem was not inventory count. The problem was coverage.

That is why DOS needs to be calculated, not guessed.

A clean historical example makes the formula easy to follow. If average inventory is $22,500 and annual COGS is $150,000, the result is 54.75 days of supply.

A person using a tablet to calculate inventory data on a wooden desk with a notebook.

Worked example using the formal formula

Use the accounting formula:

DSI = (Average Inventory / COGS) × 365

Plug in the numbers:

  • Average Inventory = $22,500
  • COGS = $150,000
  • Days in year = 365

Calculation:

DSI = ($22,500 / $150,000) × 365
DSI = 0.15 × 365
DSI = 54.75 days

That result means the business held enough inventory to cover about 54.75 days of cost flow over the period measured.

For finance, that is useful.

For operators, the bigger question is whether 54.75 days is enough once supplier lead times, port delays, drayage issues, and channel-specific receiving slowdowns are factored in. In many e-commerce businesses, especially import-heavy brands, a higher number is not sloppy inventory management. It is a deliberate buffer against expensive stockouts.

A second example that flags overbuying

Now look at a more extreme case.

A pet food business with $10,000 in average inventory and $7,000 in COGS would show 521.95 days of supply using the same formula. That is not protective stock. That is inventory sitting too long, tying up cash, increasing storage exposure, and usually pointing to weak forecasting, poor purchasing discipline, or SKU mix problems.

This is how DOS becomes a management tool instead of a finance ratio. It helps separate smart buffer stock from inventory that is not moving.

Why period averages can mislead operators

The standard method uses opening and closing balances to estimate average inventory. That works for reporting. It can miss what transpired within the period.

For seasonal or volatile businesses, using only beginning and ending balances can understate the true holding period by 15-25%, according to Netstock’s explanation of days sales of inventory.

That gap affects practical operations. If inventory spiked ahead of Prime Day, sat in overflow storage for three weeks, and dropped right before month-end, the simple average can make stock look healthier and leaner than it really was.

I see this a lot with scaling brands. Finance closes the month with a reasonable DOS number, while the warehouse just spent two weeks buried in receipts and overflow pallets.

Excel and Google Sheets example

For many teams, a simple spreadsheet is sufficient.

Cell Value or formula
A2 Opening Inventory
B2 Closing Inventory
C2 Annual COGS
D2 =(A2+B2)/2
E2 =(D2/C2)*365

If you enter:

  • A2 = 20000
  • B2 = 25000
  • C2 = 150000

Then:

  • D2 returns 22500
  • E2 returns 54.75

For active purchasing, add a live planning view:

Cell Value or formula
F2 Current Inventory
G2 Average Daily COGS
H2 =F2/G2

That gives a current days-remaining estimate. It is the version teams use during weekly replenishment calls, inbound planning, and FBA allocation decisions.

SQL example for a reporting table

If your inventory and sales data sit in an ERP, WMS, or BI warehouse, DOS can be calculated by SKU with a basic query.

SELECT
  sku,
  ((opening_inventory_value + closing_inventory_value) / 2.0) AS average_inventory,
  annual_cogs,
  (((opening_inventory_value + closing_inventory_value) / 2.0) / annual_cogs) * 365 AS days_of_supply
FROM inventory_summary;

For a more operational version using current inventory and daily sales rate:

SELECT
  sku,
  current_inventory_units,
  avg_daily_units_sold,
  current_inventory_units / NULLIF(avg_daily_units_sold, 0) AS days_remaining
FROM sku_velocity;

Use the first query for historical review and margin analysis. Use the second to decide whether to reorder, expedite, or hold.

The better operating habit

Run historical DOS monthly so finance can track inventory efficiency over time.

Run forward-looking days remaining much more often for your top SKUs. That is the number that helps prevent cash flow surprises, missed reorder windows, and stockouts caused by freight and receiving delays.

For many brands after 2025, the right answer is not chasing the lowest DOS possible. The right answer is carrying enough coverage to stay in stock through normal disruption without burying the business in slow inventory.

What Is a Good Days of Supply for E-commerce

A brand launches a promotion, sales jump, and the next container sits at the port for twelve extra days. If days of supply was set too lean, that promo turns into a stockout, an Amazon ranking drop, and a cash flow mess as the team scrambles into air freight.

That is why there is no single “good” DOS target for e-commerce. The right number depends on demand variability, lead time risk, channel penalties, and how expensive a stockout is for your brand.

A warehouse digital dashboard showing inventory levels with a graph next to rows of cardboard boxes.

Low DOS is not automatically healthy

Lean inventory looks efficient on paper. In operations, it only works when suppliers hit dates, freight moves on schedule, receiving stays clear, and demand stays close to forecast.

Many scaling DTC brands do not get that version of reality. Importers absorb vessel rollovers, customs holds, and container receiving delays. Multi-channel sellers also deal with uneven demand across Amazon, Shopify, and wholesale. A low DOS target in that environment often shifts cost instead of reducing it. The carrying cost may drop, but stockout risk, expedite spend, and lost sales rise.

Analysts at Ware2Go report that 47% of businesses now maintain 31 to 90 days of supply, and they note that 60 to 90 days can be a practical buffer for importers managing freight delays. Their analysis also points to rising stockout pressure across major e-commerce channels.

Practical target ranges by operating model

Use DOS as a working range, not a universal benchmark.

Business type Often makes sense when Practical view
High-velocity DTC SKU Demand is steady and replenishment is fast Lower coverage can work if suppliers and receiving are reliable
Importer with ocean freight exposure Lead times shift and inbound delays are common Higher DOS protects revenue and reduces expensive expedites
Amazon FBA replenishment SKU Going out of stock hurts ranking and conversion Protect in-stock performance first, then trim excess carefully
Seasonal or promo-driven SKU Demand changes sharply during short windows Static targets fail. Coverage should reflect the selling window

A good target also changes by SKU, not just by brand.

Fast movers with stable demand can often run tighter. Core products with long overseas lead times usually need more buffer. For teams that want tighter control without managing every reorder manually, a vendor-managed inventory approach for high-risk SKUs can reduce both stockouts and over-ordering.

High DOS versus low DOS

Higher DOS creates clear costs:

  • More cash tied up in inventory
  • Higher storage and handling expense
  • Greater exposure to slow-moving or aging stock
  • More pressure to discount through forecast mistakes

Lower DOS creates a different set of costs:

  • More stockouts
  • More emergency reorders and air freight
  • More strain on receiving, prep, and replenishment teams
  • More lost momentum on Amazon and missed demand on Shopify

Operators should compare those costs directly. A SKU with strong sell-through and long replacement time often justifies a higher DOS than finance would prefer at first glance.

The post-2025 view from operations

For many e-commerce brands, especially importers, “lower is better” is outdated advice.

The better question is whether your DOS covers normal disruption without trapping too much cash in weak SKUs. Strategic buffer stock is often the cheaper choice when it protects proven demand, avoids marketplace stockouts, and keeps the warehouse from lurching between drought and panic receiving. Poor buffer stock does the opposite. It hides bad forecasting and piles money into products that do not move.

Good DOS is the number that fits your supply chain risk and your channel economics. If a stockout costs more than carrying two extra weeks of inventory, the higher number is often the healthier one.

Using Days of Supply to Set Reorder Points and Safety Stock

A reorder point fails in a very predictable way. The PO goes out too late, the container misses its original sailing, receiving backs up for three days, and a top SKU goes out of stock on Amazon right when demand is there. Days of supply helps prevent that, but only if you use it to set buying triggers and buffer stock by SKU.

A creative composition featuring gear-shaped fruit slices, leaves, and potatoes with the text Optimize Inventory.

Start with the SKU, not the company average

Reorder points break down when planners rely on one blended inventory number across the business.

Fast-moving e-commerce SKUs often run on 10-25 days of supply, while broader retail businesses may sit closer to 40-60 days of supply, so reorder decisions need to happen at the SKU level, not the portfolio level, as noted by Wall Street Prep. A blended DOS can look healthy while one bestseller is five days from a stockout and another SKU is sitting on sixty days of excess stock.

That is how brands tie up cash in the wrong products and still miss sales.

Reorder point formula in plain English

The working formula is simple:

Reorder Point = Lead Time Demand + Safety Stock

Lead time demand is the unit volume you expect to sell before replacement inventory is available for sale. Safety stock is the extra coverage you hold because actual operations rarely follow the plan exactly.

For importers and scaling DTC brands, that second number matters more than many finance teams want to admit. Post-2025 supply chains still punish brands that run too lean on proven winners. A few extra days of coverage is often cheaper than losing Amazon rank, paying for air freight, or starving Shopify campaigns because stock landed but was not sellable yet.

How DOS feeds the reorder point

Use DOS to translate inventory coverage into a reorder trigger your team can act on.

  1. Estimate daily demand by SKU
    Use recent sell-through, adjusted for current promotions, channel mix, and seasonality. If your team needs better inputs here, these inventory forecasting methods help tighten the demand side of the calculation.

  2. Map the full lead time
    Count supplier production, booking delays, ocean or parcel transit, port delays, drayage, warehouse receiving, prep, relabeling, and transfer time to FBA or another node. Inventory is not available when it hits the port. It is available when customers can buy it.

  3. Set a target days-of-supply range
    This should reflect replacement risk and margin. A stable domestic SKU may justify a tighter range. An imported bestseller with erratic transit times usually needs more cover.

  4. Add safety stock deliberately
    Safety stock should absorb known uncertainty. It should not cover weak forecasting, but it should cover normal delays, receiving congestion, and marketplace volatility.

Here is the practical view:

Input Why it matters
Daily demand Sets the burn rate for each SKU
Lead time Shows how long you need stock to last before replenishment is sellable
Safety stock Protects against delays, demand spikes, and warehouse friction
Target DOS Sets the operating range your team is trying to maintain

Where reorder points usually go wrong

The math is rarely the problem. The assumptions are.

I see two recurring misses. First, teams use historical demand without adjusting for upcoming promotions, wholesale orders, or channel shifts. Second, they underestimate lead time because they stop the clock too early. A container can be physically delivered and still be days away from sellable inventory if receiving, inspection, kitting, or FBA prep is backed up.

A reorder point only works when it reflects the actual time between placing the order and having units available for sale.

Safety stock should match the cost of failure

Safety stock is not dead inventory if it protects a SKU that reliably sells and takes time to replace.

For a high-velocity SKU, intentionally carrying extra days of supply can be the lower-cost decision. That is the contrarian part many brands learn the hard way. If the stockout cost includes lost marketplace rank, interrupted ad efficiency, split shipments, customer service tickets, and expensive replenishment, a higher DOS is often the healthier operating choice.

That buffer should be selective. Weak SKUs do not deserve the same cushion as proven ones.

Brands that want tighter coordination between purchasing, inbound flow, and warehouse execution often get better results with a vendor-managed inventory approach, especially when the fulfillment partner also sees receiving delays and channel inventory in real time.

What a workable process looks like

The teams that use DOS well do a few things consistently:

  • Review coverage by SKU, not in aggregate
  • Update lead times based on actual receiving performance
  • Raise safety stock for proven SKUs when transit or marketplace risk increases
  • Keep weaker products on a tighter leash so cash stays available for items that earn it

That is how DOS becomes a reorder system instead of a dashboard metric.

Common Mistakes to Avoid When Using Days of Supply

Most problems with DOS don’t come from bad math. They come from using the metric in the wrong context.

I’ve seen teams calculate days of supply correctly and still make poor inventory decisions because the number was too broad, too old, or disconnected from actual replenishment constraints.

Mistake one using one DOS number for the whole business

A single company-wide DOS figure hides the products that need attention.

If one SKU is healthy, another is close to a stockout, and a third is badly overbought, an aggregate number can still look acceptable. That’s why SKU-level reporting matters. The more channels and bundles you run, the more dangerous blended coverage becomes.

A better habit is to group products by velocity and review them separately.

Mistake two treating historical demand as future demand

Historical DOS is useful. It is not a forecast.

This mistake gets expensive during promotions, seasonal swings, assortment changes, or marketplace shifts. If your Shopify campaign calendar, Amazon ranking changes, or wholesale orders are about to change demand, historical averages won’t protect you by themselves.

If your team needs a stronger planning process around upcoming demand, these inventory forecasting methods are a useful complement to DOS because they help translate sales patterns into purchase timing.

Good operators use DOS to measure coverage, then pressure-test it with forecast changes before they buy.

Mistake three forgetting non-selling time in the supply chain

Inventory isn’t available the minute you pay for it.

It may still be in transit, at the port, waiting for a delivery appointment, in receiving, under inspection, or being relabeled and bundled. If you calculate coverage without those delays, your reorder timing will be late even when your spreadsheet looks clean. Here, many brands need tighter operating discipline around handoff timing, inbound visibility, and warehouse execution. A practical checklist of inventory management best practices helps teams close that gap.

Mistake four using the same rule for every SKU

Not every product deserves the same target.

Use different logic for:

  • Core replenishment SKUs that drive repeat volume
  • Seasonal products that require a shorter or more careful buying window
  • Bundles and kits that depend on component availability
  • New products with weak sales history

A flat rule creates blind spots. Your best seller and your experimental SKU should not be managed with identical coverage assumptions.

Mistake five confusing buffer stock with overbuying

Buffer stock is strategic when it protects known demand against known supply risk.

It becomes overbuying when the team uses it to avoid making hard decisions about slow sellers, weak forecasts, or excess assortment. The difference is intent. Strategic buffer stock is planned. Overstock is usually rationalized after the fact.

The operators who use DOS well don’t chase one perfect number. They review the number in context, by SKU, with demand, lead time, and processing friction all in view.

Turning Inventory Data into a Competitive Advantage

The days of supply formula looks simple. Its impact isn’t.

Used well, it gives you a cleaner way to manage cash, protect top sellers, schedule replenishment, and avoid warehouse congestion. It also forces better conversations across purchasing, finance, and fulfillment because everyone can work from the same coverage target instead of competing instincts.

The bigger shift is strategic. Strong brands don’t treat inventory as a necessary headache. They treat it as an operating advantage.

That means knowing when to stay lean and when to hold a deliberate buffer. It means tracking coverage at the SKU level instead of trusting a blended business average. It means tying DOS to reorder points, safety stock, and lead-time reality so the math reflects what happens between supplier and customer.

For a deeper operational view of this metric in practice, the reference on days sales in inventory is worth reviewing alongside your own channel and SKU data.

Teams that do this well usually look calmer from the outside. That’s not because their supply chain is easier. It’s because they’ve replaced guesswork with an operating system.

Frequently Asked Questions About Days of Supply

How often should I calculate days of supply

For fast-moving SKUs, calculate it at least weekly. If demand shifts quickly, more frequent review is even better.

For slower products, a monthly review may be enough. The key is matching the reporting rhythm to the volatility of the SKU.

Should Amazon FBA and Shopify use the same DOS target

Usually, no.

Different channels create different risks. Amazon can punish stockouts in ways that affect listing momentum and availability. Shopify may give you more flexibility, but DTC demand can spike around promotions or product drops. Channel-specific targets are usually more useful than one shared rule.

What should I do for a brand-new SKU with no sales history

Use forecasted demand, then tighten your review cycle.

New products don’t have enough historical data to support a clean DOS calculation, so the first version will rely on assumptions. That’s normal. The important part is to revise quickly once actual sales start coming in.

Is lower always better

No.

A lower number can improve cash efficiency, but it can also raise stockout risk if lead times are unstable. For many importers and scaling e-commerce brands, a deliberate buffer is more sensible than running inventory too tight.

Should I calculate DOS in units or dollars

Use the version that matches the decision.

For financial reporting, value-based approaches are common. For purchasing and replenishment decisions, unit-based coverage is often easier for operators to use, especially at the SKU level.

What if a bundled product shares components with other SKUs

Calculate coverage for both the bundle and the shared components.

Otherwise, the bundle may look healthy while a key component is close to depletion. Kits, multipacks, and promotional bundles need component-level visibility if you want DOS to stay reliable.

If your brand needs a 3PL that understands inventory math, channel complexity, FBA prep, and inbound freight reality, Snappycrate can help you turn days of supply from a spreadsheet metric into a workable operating system.