Inventory

Inventory Carrying Cost Formula: A Shopify SKU Example

Inventory carrying cost is the annual expense of holding unsold stock, expressed as a percentage of average inventory value at cost. It answers how much cash a SKU consumes while it sits, not how much you paid the supplier.

APQC’s Open Standards Benchmarking measure for inventory carrying cost reports a median of 10.0% of inventory value across 6,468 companies. That is a cross-industry median, not a target for a Shopify catalog. A slow seasonal SKU will sit above it. A fast consumable with short lead times can sit near it.

Shopify does not publish a carrying-cost percentage in its default inventory reports. You build the number from cost per item, average inventory value, and four documented cost buckets. Then you test what a lower cover does to that SKU’s annual cost before you change the next purchase order.

What the inventory carrying cost formula answers

The formula converts one year of holding expense into a rate you can compare across SKUs. Purchase price is acquisition cost, an asset until the unit sells. It becomes cost of goods sold only at sale. Neither the unsold acquisition cost nor COGS is carrying cost.

Carrying cost starts when units are available and continues until they sell, get written down, or get discarded. A leftover colorway can look quiet on a sales dashboard and still occupy a bin, raise insured value, and lock cash you could use on a bestseller reorder.

The inventory carrying cost formula

Use one year of documented costs and average inventory value at cost, not retail price.

Inventory carrying cost (%) = (Total annual carrying costs / Average inventory value) x 100

Each input has a source. If you cannot point to an invoice, a loan rate, or a write-off total, leave that line blank and label the rate incomplete. A guessed 25% rate is not a calculation.

Average inventory value

Average inventory value is (beginning value + ending value) / 2 for a simple year. If you have monthly snapshots, average the 12 month-end figures. A single ending balance overstates the year when you received a large inbound shipment last week.

In Shopify, the Month-end inventory snapshot report shows ending inventory value when cost per item is filled in. Shopify’s inventory report documentation defines ending inventory value as the total value of inventory at the end of the selected month, calculated from cost per item. Available quantity excludes committed units on open orders. Incoming units on transfers are not available stock, so do not add them into the value you are holding today.

Total annual carrying costs

Total annual carrying costs are the sum of capital, storage, service, and risk for the same period as the inventory value. APQC’s measure description groups opportunity cost or cost of capital, storage space, insurance, taxes, handling and administration, shrinkage, and obsolescence. Those lines map cleanly onto the four buckets below.

Document capital, storage, service, and risk

Write the source next to every line. A defensible rate is one you can rebuild next quarter from the same invoices.

Capital cost

Capital cost is interest you pay on inventory financing, or the return you give up because cash is tied up in units. Use the rate on an inventory line of credit if you have one. If you do not, use a rate you would actually earn or save elsewhere, and write that rate on the sheet so next quarter matches this quarter.

Capital usually scales with inventory value. It is the bucket most likely to fall when you cut cover on a slow SKU, which is why it should be calculated per SKU rather than buried in a store average.

Storage cost

Storage is warehouse rent or 3PL bin and pallet fees, utilities allocated to stock, inbound receiving, and pick labor tied to holding rather than shipping. If a 3PL invoices by location, allocate fees by cubic volume or by locations occupied. A home-based seller still has a storage cost: the floor space and time used to stash cartons.

Storage often has a step. Dropping from 400 units to 180 may not free a pallet if both quantities occupy the same location. Rebuild the fee from the new location count. Do not multiply the old storage dollar by the new unit ratio.

Service cost

Service cost is insurance on stock, inventory-related taxes where they apply, cycle-count labor, and inventory software allocated to the SKU. Insurance usually follows insured value. Software and cycle-count time often stay flat until you drop a SKU from the active count list.

Risk cost

Risk cost is value you expect to lose while goods sit: damage, expiry, style obsolescence, theft, and forced markdowns. Estimate it from your own write-offs, damaged refunds, and markdown dollars on that SKU or that product type. Do not paste an industry shrink rate into the cell and call it your risk.

The National Retail Federation’s 2023 National Retail Security Survey reported U.S. retail shrink of $112.1 billion in 2022, with an average shrink rate of 1.6% of sales. That figure is a sales-based industry total. It is a reminder that shrink is material, not a substitute for your catalog’s write-off history. Seasonal apparel, dated supplements, and last-generation electronics need a higher risk rate than a staple that sells the same way every month.

A hypothetical Shopify SKU calculation

The figures below are an example, not a merchant result. Copy the layout and replace every number with an invoice, a cost-per-item field, or a written rate.

The formula needs average inventory value for the same year as the costs. This example assumes the merchant holds the SKU flat at 400 units all year, so beginning value, ending value, and the annual average are the same $8,800. Recent velocity is only there to translate that constant level into days of cover. It is not a second denominator.

  • On-hand units, held flat for the year: 400
  • Cost per item: $22
  • Average inventory value for the year: $8,800 (400 x $22)
  • Recent velocity: 2 units per day over 28 days
  • Days of cover at that constant average: 200
Cost bucketSource used in this exampleAnnual amount
Capital$8,800 average inventory value x 11% written opportunity rate$968
StorageOne allocated 3PL location at $40 per month$480
ServiceInsurance at 1.5% of the $8,800 average, plus $80 allocated software and count time$212
RiskExpected markdown and unsellable units, from a written 4% of the $8,800 average$352
Total carrying costSum of the four documented buckets for the year$2,012
Carrying cost rate$2,012 / $8,800 average inventory value22.9%

At 2 units per day, a constant 400 units is 200 days of cover. Annual cost of $2,012 divided by the $8,800 average is 22.9%. That rate is this SKU’s annual result only under the constant-stock assumption. It is not a store target, and it is not evidence that any real store saved a specific dollar amount.

What a lower cover does to the cost

Test a lower steady cover before you change the purchase order. At 2 units per day, 90 days of cover is 180 units, or $3,960 at the same $22 cost. For the comparison, assume that 180-unit level is also held flat for a full year, so its average inventory value is $3,960. Rebuild each annual bucket against that average. Do not multiply $2,012 by 180/400.

BucketHow it changes in this exampleNew annual amount
Capital11% of the $3,960 average$436
StorageSame location still occupied, so the $40 monthly fee stays$480
ServiceInsurance falls to 1.5% of the $3,960 average; software and count time stay at $80$139
Risk4% of the smaller average, if the markdown assumption still holds$158
TotalRebuilt annual buckets on the $3,960 average$1,213
Carrying cost rate$1,213 / $3,960 average inventory value30.6%

In this example, a full year of carrying cost on the SKU falls from $2,012 to $1,213, a difference of $799. Both totals use the same four buckets for a full year, each divided by its own average inventory value. Storage did not fall, because the location fee is a step cost, so the rate rises from 22.9% to 30.6% even while the dollar total falls. If the smaller quantity frees the location, storage drops too, and both the dollars and the rate can fall. If insurance has a minimum premium, service drops less than the table shows.

The $799 is the holding-cost difference between two constant annual averages, $8,800 and $3,960. It is not recovered cash until you actually buy fewer units or exit the extra 220. Those 220 units are still on hand. Valuing them is this calculation. Choosing a markdown, bundle, or wholesale exit belongs in the excess inventory workflow, which sizes surplus units against a target cover before you discount.

How to read the rate

Read the rate against your own buckets, your prior period on the same SKU, and that SKU’s cover. Do not grade it against a published “good” percentage. Use the APQC median above as cross-industry context only.

  • Compare the SKU with itself. A rate you can rebuild from the same invoices is usable. A rate with a blank bucket is not, even if the percentage looks tidy.
  • Pair the rate with cover from your own velocity. A lower rate on a product that already sells through its stock quickly is not a reason to buy less. A higher rate on a SKU with long cover is a reason to rebuild the buckets at a lower steady quantity before the next purchase order.
  • Check which bucket moved. Capital and risk usually scale with average value. Storage and some service lines often stay flat until a location or a count task actually goes away. A rate that rises after you cut units can mean a fixed fee is now spread over a smaller average, as in the example above.
  • Incomplete: any bucket without a source. Do not rank purchase orders on that rate.

A store-wide percentage hides the decision. Two SKUs can share one blended rate while one sells through quickly and the other sits at the 200 days of cover in the example. Repeat the formula on the SKUs with the highest inventory value.

Find the SKUs worth recalculating

High carrying cost concentrates where inventory value is high and sell-through is low. Shopify’s inventory reports can surface both, once cost per item is filled in.

  1. Open Analytics, then Reports, and filter to Inventory.
  2. Run the Month-end inventory snapshot and sort by inventory value. Those SKUs hold the most cash.
  3. Run Inventory remaining per product. Shopify estimates days of inventory remaining from ending quantity and average units sold per day. Flag SKUs whose remaining days exceed the cover you would actually hold. Treat 0 days on a top seller as a stockout risk, not a carrying-cost win.
  4. Run Products by sell-through rate. Shopify calculates sell-through as units sold divided by units sold plus units still in inventory. Low sell-through plus high value is the hotspot.
  5. If your plan includes ABC product analysis, use it as a grade, not as the carrying-cost math. Shopify’s ABC report groups products by share of revenue over a recent window. Pair the grade with the value and cover lists.

Shopify’s ABC analysis guidance recommends keeping backup stock on A-grade items and ordering C-grade less often, or stopping it. A C-grade variant with high ending value and cover longer than you would reorder to is the first SKU to rerun through the four buckets. The ABC analysis workflow turns those grades into purchase decisions. It does not replace this formula.

A store-level inventory-to-sales comparison is a separate formula. Track your own inventory-to-sales ratio if you need that view. It is not a cover target for a single SKU, and it does not replace the carrying-cost rate.

What to do after the calculation

Change cover only where the rebuilt annual buckets fall by more than the cost of a stockout or a missed price break. Keep or raise cover when cutting it would leave less stock than that SKU’s supplier lead time and your own service buffer require, or ahead of a seasonal peak you have dated and given a written exit. Set those limits from your lead times and sales history. Do not copy a day count from another store.

A lower unit cost on a large minimum order is a false save if the extra units sit for half a year. Compare the supplier’s price break with the rebuilt carrying cost on the extra units. If holding the extra units costs more than the price break saves, skip the break or ask for a split shipment. The order quantity that balances ordering cost and holding cost is a separate calculation, covered in the economic order quantity guide. Use the holding-cost dollar from this page as an input there. Do not re-derive EOQ here.

If the SKU is slow because you reorder too early, fix timing in the Shopify reorder formula post. That page owns the reorder-point calculation. This page only tells you the annual cost of the units you choose to hold.

Once cost per item is trustworthy, stock intelligence can rank live cover and stockout risk so you spend the formula on the SKUs that actually hold cash. A blank cost field still produces a clean-looking rank. Fill the cost before you trust the sort.

A monthly close for the rate

  1. Confirm cost per item on every variant received since the last close.
  2. Average the month-end inventory values you will use as the denominator.
  3. Refresh capital, storage, service, and risk from this period’s invoices and write-offs. Note which lines are fixed.
  4. Divide total carrying costs by average inventory value. Write the percentage next to last month’s rate and note what changed.
  5. Rerun the four buckets on the highest-value SKU over your cover cap, using the lower-cover quantities you would actually buy.
  6. Place one smaller reorder or one delay, and assign one exit to aged units. The percentage does not free cash. The purchase order and the exit do.