The stock report flags the straw lid as the longest position: 36 weeks of supply. But the lids hold about $17,000 at cost. (The numbers come from one example: a drinkware company in early November.) The water bottle, at 28 weeks, holds about $88,000, more than the lids and the best-selling tumbler combined. Weeks of supply is the number of weeks a product's stock will last at its current pace of sales: units on hand divided by average weekly unit sales.
The lesson of this example is plain: the product with the most weeks of supply is not always the product trapping the most cash. Units, location and cash each need their own view, and a weekly scorecard that shows only units will miss it. The sections below take the three views one at a time.
The weeks of supply formula
Weeks of supply = units on hand ÷ average weekly unit sales
The forward version swaps the denominator for expected sales, the output of a demand forecast:
Forward weeks of supply = units on hand ÷ expected weekly unit sales over the coming weeks
Three choices move the answer more than the arithmetic does. Average four to eight recent weeks of normal selling, and leave out weeks when the product was out of stock, since they show what could ship rather than what customers wanted. Leave out a one-off spike, such as a single large wholesale order, unless it will repeat. And count as on hand only what can be sold: units promised to an open wholesale order are spoken for, units Amazon has received but not yet made available are inbound, and stock on the water is a separate line.
The units view: weeks of supply by product
The example company sells about $8 million a year through its Shopify store, Amazon and about 40 independent outdoor shops. Three of its products are below, each unit valued at its landed cost.
| Product | Landed cost | Units in the network | Average weekly units, last 8 weeks | Weeks of supply |
|---|---|---|---|---|
| 20 oz tumbler | $7.50 | 6,000 | 750 | 8.0 |
| 32 oz bottle | $9.00 | 9,800 | 350 | 28.0 |
| Straw lid | $1.20 | 14,400 | 400 | 36.0 |
| All three, in units | 30,200 | 1,500 | 20.1 |
Distrust the bottom line. Lids are 48 percent of the units but 11 percent of the money, so a figure blended in units leans toward the cheapest product. Weighted by cost, the three hold about 16 weeks.
The 6,000 tumblers include 600 units Amazon has received but not yet made available. Counting only the 5,400 that are sellable today, the tumbler has 7.2 weeks.
The forward view changes the picture again. In November the tumbler is a gift, expected to sell about 1,000 a week through the holidays, while the bottle slows to about 280 a week in winter and the lid holds at 400.
| Product | Units in the network | Expected weekly units, next 8 weeks | Forward weeks of supply |
|---|---|---|---|
| 20 oz tumbler | 6,000 | 1,000 | 6.0 |
| 32 oz bottle | 9,800 | 280 | 35.0 |
| Straw lid | 14,400 | 400 | 36.0 |
The tumbler drops from eight weeks to six, or 5.4 on sellable stock, in the busiest weeks of the year. The bottle lengthens from 28 weeks to 35. Whether six weeks is too few is a question for the planning tools; the finance question is what the next order costs and whether the cash is there.
The location view: Amazon, the 3PL and stock on the water
A product's total hides where its stock sits. Here are the tumbler's 6,000 units by location.
| Where the tumblers are | Units | Weekly units sold from there | Weeks of supply |
|---|---|---|---|
| Amazon FBA, available | 1,800 | 450 | 4.0 |
| Amazon FBA, inbound (received, not yet available) | 600 | ||
| 3PL, serving Shopify and wholesale | 3,600 | 300 | 12.0 |
| In the network, total | 6,000 | 750 | 8.0 |
| On the water, factory paid | 7,200 |
Amazon has four weeks it can sell, or about 5.3 once the inbound units are available. The 3PL's 12 weeks looks comfortable, but the 3PL also supplies Amazon's next shipment, so read the two together. With the container on the water the tumbler stands at about 17.6 weeks, and none of the extra 9.6 can sell until it lands and is received.
Keep three figures apart: stock you can sell now, stock inside your own network that is not yet sellable, and stock on the water. All three are inventory at cost, though stock on the water carries only what has been paid or owed so far, here the factory price, with freight and duty added when incurred. Depending on the shipping terms it may instead still be a prepayment to the supplier. Only the first figure ships an order this week.
Location also changes what a long position costs. Amazon charges FBA storage monthly based on the space the inventory occupies, and adds an aged inventory charge, billed monthly, on items stored in a fulfillment center for more than 181 days, according to Amazon's FBA page. That is about 26 weeks. If 2,100 of the bottles sit in FBA and Amazon sells 70 a week, that position is 30 weeks, and some of those bottles will likely cross the line before they sell.
The cash view: weeks of supply times weekly cost
Multiply a product's weeks of supply by its weekly cost of sales (weekly units times landed cost) and the result is the cash parked in that product, at cost. It equals units times landed cost; the weeks add how long that stock will take to sell through. They are not the date the cash comes back, which depends on net receipts and each channel's payment dates.
| Product | Weeks of supply | Weekly cost of sales | Cash on the shelf | Share of shelf cash | Share of weekly cost of sales |
|---|---|---|---|---|---|
| 20 oz tumbler | 8.0 | $5,625 | $45,000 | 30% | 61% |
| 32 oz bottle | 28.0 | $3,150 | $88,200 | 59% | 34% |
| Straw lid | 36.0 | $480 | $17,280 | 11% | 5% |
| All three | 16.3 | $9,255 | $150,480 | 100% | 100% |
This is the table that answers the opening question. The lid has the longest position and the smallest cash problem. The bottle holds 59 percent of the money while accounting for 34 percent of weekly cost of sales. The tumbler is the reverse: the fastest-selling stock, in the shortest position.
At 16 weeks, about where the three stand together, the bottle would hold $50,400. The other $37,800 is cash parked in bottles, and each week it stays there costs storage, insurance and the return the money could earn elsewhere, as worked through in inventory carrying cost.
The figure is at cost. At the $42 store price the bottles would ring up about $412,000, less on wholesale and after Amazon's fees, but the company paid $88,200 for them and that is what the balance sheet shows. A long position does not on its own lower that value. Stock is written down only when it will sell for less than its cost after the fees and shipping needed to sell it. A $9.00 bottle selling for $42 is far from that line, but a position that keeps lengthening is how products become dead stock.
How weeks of supply relates to days of inventory and turnover
Days of supply is weeks of supply times seven, so the tumbler's 8.0 weeks is 56 days. Annualized inventory turnover at today's pace is 52 divided by weeks of supply, about 3.2 turns for the three products together. Days inventory outstanding is average inventory at cost divided by cost of goods sold, times 365, about 114 days at the current pace.
The difference is the source. Weeks of supply reads one product's current stock against its current or expected pace. Turnover and days inventory outstanding come from the financial statements, averaged over a period for the whole business, which is why last year's figure can differ from today's. Use them for lenders and published benchmarks; the related measures are in the guide to inventory KPIs.
What the cash view means for the next order
The weeks say how fast the bottles sell through, not when the cash comes back. At 280 a week, about $33,000 of bottle stock at cost sells over the next 13 weeks, leaving about $55,000 on the shelf in early February. The cash from those sales is the net receipts (price less fees, refunds and ad spend), arriving on each channel's payout schedule or the shops' terms, as traced in order to cash for ecommerce. When an order has paid back is worked from those receipts and dates, as in from factory deposit to payout.
Meanwhile the tumbler, at six forward weeks, needs another 7,200 units. At a $5.40 factory price that is $38,880: a 30 percent deposit of $11,664 now and a $27,216 balance when it loads. About $15,120 of freight, duty and fees follows when it lands, so the order costs $54,000, $7.50 a unit landed. The container already on the water has its own $15,120 due in about four weeks. Together that is $69,120 before any new tumbler sells.
Much of that money is sitting in bottles, and it comes back only as they sell and their net receipts land. Whether the order is affordable depends on whether the bank balance, plus the net receipts from tumbler and bottle sales each week, covers each payment on its date without dropping below the minimum kept for payroll and surprises. A 13-week cash flow forecast answers that before the purchase order goes out.
If the answer is tight, start with the factory: ask for 30 days on the balance after the container ships instead of paying at loading. Terms are often the cheapest money available, because the factory charges no interest on a balance it agrees to wait for. The factory may also say no, especially on a newer relationship, so have the next options ready: sell more bottles to the outdoor shops at a wholesale price that still clears cost, pull FBA bottles back before 181 days (weighing Amazon's per-item removal charge, listed on the same FBA page, against the aged inventory charge), split the tumbler order into two shipments, or bridge the gap with inventory and PO financing. The cash conversion cycle shows how long each dollar is gone from deposit to payout.
When the next bottle purchase comes up, bring the cash view, not only the units view. The lid's 36 weeks looked like the problem on the stock report; the bottle's $88,200 is the one that decides what the tumbler order can be.
FAQ
How do you calculate weeks of supply?
Divide the units on hand by the average number of units sold per week. With 9,800 units on hand and sales of 350 a week, weeks of supply is 28. Use recent weeks of normal selling, leave out weeks when the product was out of stock, and use expected weekly sales instead when a season or promotion is about to change the pace.
What is the difference between weeks of supply and days of inventory?
Days of supply is weeks of supply times seven, so 8 weeks is 56 days. Days inventory outstanding is different: it comes from the financial statements, dividing average inventory at cost by cost of goods sold and multiplying by 365, for the whole business over a period. Weeks of supply reads one product's current stock against its current pace.



