Book a demo

twelfth · Free tools

Retail numbers you can work through yourself.

Seven calculators, a spreadsheet and connected examples. Free to use without signing in; all example figures are illustrative.

Start with the question on your desk

Change the example figures to see each result update here. Try the connected concepts to understand what the number leaves out, or use the spreadsheet for a list of products.

Calculate weeks of cover

How long will the stock on hand last?

Weeks of cover = usable units on hand ÷ expected units sold per week

Weeks of cover
2.00

At this sales rate, stock lasts 2.00 weeks. Cover is only as reliable as the expected weekly sales rate. A stockout or promotion can distort that rate.

See it alongside

Another example: If supplier delivery takes longer than current stock cover, check the reorder point and confirmed stock on order. Read Replenishment →

Check a replenishment threshold

Is the stock position below its reorder point?

Reorder point = expected demand during lead time + safety stock

Reorder point (units)
40.00
Stock position (units)
30.00
Gap to reorder point (units)
10.00

The stock position is 10.00 units below the reorder point. A gap below the reorder point signals a review; it is not automatically the quantity to order.

See it alongside

Another example: A reorder point can flag action even while stock appears to cover near-term sales. Read Weeks of cover →

Estimate lost sales from a stockout

How many sales did a stockout cost?

Sales lost = normal units per day × days unavailable − extra units similar lines sold

Unserved demand (units)
36.00
Recovered by similar lines (units)
10.00
Sales lost (units)
26.00
Gross profit lost ($)
156.00

About 26 of 36 units of demand left the store, worth $156.00 of gross profit. The normal rate should come from comparable days. Shoppers who stop visiting after a gap are not in this number.

See it alongside

Another example: Sales data only records what sold. Estimate unserved demand before a soft month is blamed on the range. Read Lost demand →

Calculate sell-through

How much of the available stock sold?

Sell-through = units sold ÷ (opening stock + receipts) × 100

Sell-through
30.0%

30.0% of the units available in this period sold. Whether sell-through is healthy depends on how far through the selling period you are.

See it alongside

Another example: At week ten of a twelve-week season, low sell-through may prompt a price test; at week two, it may be too early. Read Markdown →

Calculate a markdown

What happens to margin after a price cut?

Price reduction = (original price − new price) ÷ original price × 100

Price reduction
20.0%
Original gross margin
50.0%
New gross margin
37.5%

Gross profit per unit changes from $50.00 to $30.00. The margin result is per unit. It does not predict how many extra units a lower price will sell.

See it alongside

Another example: Compare sell-through before and after a price test to see whether the line actually moved faster. Read Sell-through →

Calculate a price index

How does a matched competitor price compare?

Price index = your price ÷ competitor price × 100

Price index
111.11

You are priced 11.11% above the competitor on this matched item. 100 is price parity; above 100 means you are priced above the competitor. Check the match first.

See it alongside

Another example: A 12-pack and a 24-pack are not a fair price match. Check the exact product, size, seller and date. Read Matched SKU →

Calculate GMROI

How much margin did the stock investment earn?

GMROI = gross margin earned ÷ average inventory at cost

GMROI
3.00

That is $3.00 of gross margin per $1 of average inventory at cost. GMROI compares gross margin earned with average inventory at cost over the same period.

See it alongside

Another example: Two lines can earn the same margin dollars while one ties up much more stock. Compare their roles before removing either. Read Range review →

Follow a decision through more than one number

A single metric rarely settles a retail decision. These examples connect the calculation to the next question a buyer or planner would ask.

A stock alert: cover, then reorder point

A product has 30 usable units on hand and is expected to sell 15 each week. A supplier takes two weeks to deliver. The team holds 10 safety units and has nothing confirmed on order.

  1. Step 1

    Calculate weeks of cover

    30 ÷ 15 = 2 weeks of cover.

    The stock could run out just as a normal delivery arrives, before allowing for a delay or an unexpected rise in demand.

  2. Step 2

    Check a replenishment threshold

    15 × 2 + 10 = 40 units at the reorder point. Stock position is 30, so the gap is 10 units.

    Review the order now. The 10-unit gap does not account for the next order cycle, case packs or minimum order quantities.

Before ordering, check whether the weekly forecast was depressed by an earlier stockout and whether any unrecorded delivery is due.

Concepts that change the reading

A seasonal line: sell-through, then markdown

A line began the period with 300 units, received another 100 and sold 120. Its original price is $100, proposed price is $80 and unit cost is $50.

  1. Step 1

    Calculate sell-through

    120 ÷ (300 + 100) = 30% sell-through.

    Thirty percent is a pace measure. It needs the date in the season and the remaining stock to mean anything.

  2. Step 2

    Calculate a markdown

    ($100 − $80) ÷ $100 = 20% price reduction. Gross margin moves from 50% to 37.5% per unit.

    Each unit would earn $30 gross profit instead of $50. Estimate the likely extra units and the effect on nearby lines before making the cut.

A clearance decision also needs an exit date and a view of whether the new price draws sales from another line in the range.

Concepts that change the reading

A price gap: match the item, then check the economics

Your price for an item is $20 and a competitor lists it at $18. The item earned $12,000 gross margin over the year on $4,000 average inventory at cost.

  1. Step 1

    Calculate a price index

    $20 ÷ $18 × 100 ≈ 111 on the your-price-over-competitor-price scale.

    You are priced about 11% above the competitor if the article, pack size, seller and observation date truly match.

  2. Step 2

    Calculate GMROI

    $12,000 ÷ $4,000 = 3.0 GMROI for the year.

    The line earned $3 gross margin per $1 of average inventory at cost. That does not, by itself, justify matching the lower price.

Check the intended price position, margin floor and how long the gap has existed before proposing a price move.

Concepts that change the reading

Put the formulas in a spreadsheet

The eight-tab workbook has formulas for six metrics, plus a range review tracker and matched-price log. Open it in Excel or import the .xlsx file into Google Sheets.

CSV files import one sheet at a time and do not keep workbook formatting. A CSV percentage of 30 means 30%. Use the .xlsx for the full set of formatted tabs.

Turn a range review into a checklist

Check role, sales, margin, availability and shopper need before adding or removing a line. Set a date to test whether the change worked.

Need the meaning behind a measure? Browse the retail glossary.

Want to run these checks across a whole category with your own data? Show us the decisions your team is working through.

No bad cookies on these shelves.

Essential cookies keep the store running. Analytics only if you choose.