MyBreakeven
E-commerce BUSINESS PLANNING GUIDE

Inventory Holding Cost per SKU: Price the Stock You Keep

Published by MyBreakeven. Report a calculation or content issue to support@mybreakeven.com.

Calculate inventory holding cost per SKU from storage, handling and losses. Separate cash costs from assumptions and test order size and clearance.

Ecommerce warehouse owner checking stock bins and boxed inventory.
AI-generated editorial illustration of this business topic; not a real customer or business.

Inventory holding cost per SKU is the cost of keeping that stock available over a defined period. It can include storage, inventory administration, shrinkage, damage, obsolescence and a clearly labeled capital-cost assumption. Calculate each component from a usable allocation rule, then compare it with the contribution the SKU earns. The fictional USD examples below are planning calculations, not accounting policy, tax treatment or market-rate estimates.

Quick answer

Choose a monthly or annual period. Estimate average stock quantity and value, allocate storage and handling using a defensible driver, and add expected losses without duplicating costs already recorded elsewhere. Keep actual cash expenses separate from an imputed cost of tied-up capital. Use the total to compare replenishment quantities and slow stock, not to invent an unexplained percentage.

The direct answer: a SKU held through one month

Suppose a store holds an average of 100 units of one SKU at a landed product cost of $20 per unit. Average inventory value is $2,000. The SKU occupies storage space allocated $40 monthly, consumes $20 inventory-administration effort and has an expected $30 monthly loss allowance under the store's documented assumptions.

For comparison only, the owner uses a 12% annual capital-cost assumption. The simple monthly equivalent is 1%, or $20 on the $2,000 average inventory value. This is a hypothetical opportunity-cost measure, not an interest invoice or a claimed current borrowing rate.

Total modeled monthly holding cost is $40 + $20 + $30 + $20 = $110. Actual operating cash components total $90 before any financing-specific payments. Keep the $20 imputed component separately labeled so you do not subtract it as though cash necessarily left the bank that month.

If the store sells 50 units during the month, allocating the $110 across sold units gives $2.20 per sold unit. Dividing by 100 units held gives $1.10 per average unit held. Both ratios can be useful, but they answer different questions. Name the denominator instead of presenting either as the one universal unit cost.

Suppose a sale leaves $8 contribution before holding cost and other fixed commitments. Fifty sales leave $400 contribution. Subtracting the modeled $110 holding cost leaves $290 for the remaining commitments under this management view. If storage is already included in monthly overhead, do not subtract the same $40 again in the break-even model.

The ecommerce profit-margin guide explains the wider cost boundary. Holding-cost analysis adds a time and stock-level view; it does not replace order contribution.

What changes the answer

Average quantity matters more than a single snapshot. Beginning and ending balances may provide a rough average when stock moves steadily, but a large delivery mid-month can make that shortcut misleading. Use daily or weekly observations when they materially change the decision.

Storage allocation should reflect the resource used. Pallet positions, shelf volume or occupied bins may be better drivers than purchase value. A cheap bulky SKU can consume more space than an expensive small SKU. Explain the driver before comparing the allocated costs.

Losses need a defined basis. Damage, expiry, theft and markdowns can overlap in accounting records. Do not add a theoretical shrinkage allowance on top of the same actual write-off without labeling the comparison. Use a period and assumptions that fit the stock.

Handling is different from outbound fulfillment. Receiving, cycle counts and relocation can be inventory costs; pick-and-pack per customer order may already be included in order contribution. Separate the activities so the same labor is not charged twice.

Capital cost is optional and assumption-dependent. If using actual financing, model its real arrangement separately. If using an opportunity-cost assumption, show the rate and keep it distinct from cash expenses. This guide does not recommend financing products or estimate a fair market interest rate.

Product life changes the decision. Fashion, seasonal goods and perishables can lose value before they sell. An item that is technically in stock may no longer be economically sellable at the planned price. Record expected realizable sales rather than assuming every unit will sell at full price.

The free-shipping threshold guide helps you assess basket changes; avoid using a stock-clearing promotion without recalculating its order contribution.

Three worked scenarios

Buy a smaller quantity

Suppose average stock falls from 100 to 60 units. At the same $20 landed cost, average inventory value becomes $1,200. Allocated storage falls from $40 to $28, administration stays $20, expected losses fall to $18 and the 1% monthly capital assumption becomes $12.

Modeled holding cost is $78, saving $32 monthly versus $110. If more frequent orders add $45 monthly inbound freight, the combined change costs $13 more. Lower stock is not automatically cheaper after replenishment costs are included.

A slower month

Hold the original $110 monthly cost but sell only 20 units. Holding cost per sold unit becomes $5.50. At $8 contribution per sale, the 20 sales leave $160 before holding cost, or $50 after the modeled allocation.

The physical cost of holding the inventory has not necessarily increased; the cost is spread across fewer sales. That distinction helps explain why a weak month can expose a slow SKU without proving storage prices rose.

Clear part of the stock

Suppose a markdown leaves $5 contribution per sold unit instead of $8 and sells an extra 30 units. Those extra sales contribute $150 before any promotion cost. If the clearance avoids $60 of expected future holding and loss costs, the combined modeled benefit is $210.

If ten full-price sales are displaced by discounted sales, the lost contribution difference is 10 × ($8 − $5) = $30. The net benefit becomes $180 under those assumptions. Verify actual displacement and avoided costs; neither is guaranteed by the discount itself.

How to run your own numbers

Use a SKU worksheet with average quantity, landed unit cost, occupied space, handling tasks and loss assumptions. Use the ecommerce break-even calculator to connect order contribution with monthly commitments, placing holding expenses in one consistent cost location.

MyBreakeven supports other currencies. Keep one currency throughout and label whether a figure is per month, per held unit or per sold unit. A monthly storage allocation cannot be entered as a per-order expense without the appropriate division.

Keep a cash-only column and an optional economic-cost column. This lets you discuss stock efficiency without confusing an imputed capital charge with an immediate bill. Reconcile actual financing separately where relevant.

Review purchase quantity, reorder frequency and stock ageing together. Keep expected demand, supplier lead time, safety stock and usable inventory position in a separate reorder worksheet. The holding-cost total helps compare purchase quantities, while the reorder point identifies when replenishment should be reviewed.

Common mistakes

Applying one unexplained percentage to every SKU hides different storage and expiry patterns. Build the components and their drivers.

Using closing stock as average stock can distort a month with a late shipment. Use observations suited to the replenishment pattern.

Charging pick-and-pack here and again in order costs duplicates fulfillment. Separate stock holding from customer delivery activities.

Treating an opportunity-cost charge as a cash bill misstates cash flow. Keep the assumption visibly separate.

Ignoring minimum order sizes can make a smaller-stock scenario impossible. Test the supplier's actual carton, freight and order rules.

Treating unsold units as guaranteed future full-price sales overlooks obsolescence. Use defensible sales and loss assumptions.

FAQs

Should I use purchase cost or retail value?

Use the valuation basis that matches your stated management calculation, commonly landed cost for capital tied in inventory. Do not apply a capital-cost assumption to retail value while describing it as money already invested. Formal accounting treatment needs its own appropriate review.

Is holding cost the same as storage cost?

Storage is one component. Administration, stock losses and a separately labeled capital assumption can also matter. Include only components relevant to the decision and avoid duplicating costs elsewhere.

How should I allocate shared warehouse rent?

Choose a driver related to occupied resources, such as space or pallet positions. Record the assumption and use it consistently. An allocation helps management comparison but does not mean each SKU creates a separately avoidable rent payment.

Is a slow SKU always worth removing?

Not necessarily. It may support customer baskets or require little dedicated space. Compare expected contribution, avoidable holding costs and its role in the range before making a product decision.

Can holding cost be zero?

Some components may be negligible, but that does not make all stock free to keep. Check space, handling, damage and cash tied up. Avoid inventing costs solely to make a formula look complete.

Does ordering less always improve cash?

It reduces one purchase's size, but more frequent freight, supplier terms and stockouts can change the result. Model the dated payments and total replenishment cost. A lower inventory balance alone does not establish a better overall plan.

Closing takeaways

  • State the period and denominator for every unit-cost ratio.
  • Allocate storage using the resource a SKU consumes.
  • Separate actual cash costs from imputed capital costs.
  • Compare smaller purchases with freight and stockout effects.

Read related methods in the business guide library.

Planning estimates only—not accounting, tax, legal or lending advice.