Back to blog
Formulas & LessonsSeptember 26, 20262 min read

Ten inventory formulas every small business should know

Inventory looks like it needs a degree in mathematics. It does not. Almost everything you need to run stock sensibly comes down to ten short formulas, and most of them are multiplication or division you can do on a phone calculator while standing in the aisle.

This is the cheat sheet. Each entry says what to calculate, what the answer tells you, and where to read the full lesson. Skim it now and come back when a question comes up.

Ten formulas you can run today
  • Stock valuequantity x unit cost
  • Available stockon hand - reserved - blocked
  • Reorder point(daily use x lead time) + safety stock
  • Days of coveron hand / daily use
  • Inventory turnovercost of goods sold / average stock value
  • Sell-throughunits sold / units received x 100
  • Fill rateorders shipped complete / total orders x 100
  • Inventory accuracyitems that match / items counted x 100
  • Economic order quantitysquare root of (2 x demand x order cost / holding cost)
  • Margin(price - cost) / price

Every one of these can be worked out from numbers you already have.

How much do I have?

  • Stock value = quantity x unit cost. Sort items by it and you have your A, B and C groups. See The 80/20 rule that quietly runs your shop.
  • Available stock = on hand - reserved - blocked. It is the number you can actually promise a customer.
  • Days of cover = on hand / average daily use. It turns a quantity into time, which is the unit buyers think in. Days of cover and sell-through has the lesson.

When and how much do I order?

  • Reorder point = (average daily use x lead time) + safety stock. It tells you when. How to set a reorder point for an inventory item covers it.
  • Economic order quantity = the square root of (2 x annual demand x cost per order / holding cost per unit per year). It suggests how much. EOQ explained walks through it.
A reorder point answers when. An order quantity answers how much. Mixing them up is how shops end up with both too much and too little.

How well am I doing?

What does it cost me?

  • Landed cost per unit = (goods + freight + duties + handling) / units received. Landed cost shows how it changes your margin.
  • Margin = (price - cost) / price. Markup = (price - cost) / cost. They are not the same, and Markup vs margin shows what that costs people.
One imaginary shop, five numbers

$60,000

Average stock value

30 days

Days of cover

4

Turns a year

92%

Fill rate

86%

Inventory accuracy

Invented figures, to show what the formulas produce.

Why these ten

Each one replaces a hunch with a number. 'I think we have plenty' becomes 'thirty days of cover.' 'Deliveries seem slow' becomes 'a fill rate of 92 percent.' Numbers are not smarter than hunches, but they can be compared with last month, and that is where improvement starts.

A fill rate of 92 percent
92%0100

Orders shipped complete

Eight in a hundred orders went out short. That is the list to start with.