# Free retail calculators and templates

Free calculators for GMROI, stock cover, sell-through, price index, markdown, replenishment and stockout lost sales, plus Excel and CSV templates.

The numbers below are illustrative. Edit the figures inline on the page, or open a calculator for a focused explanation. You can copy an AI prompt with your inputs and result. Download the eight-tab workbook or the CSV templates to continue in your own spreadsheet.

## Calculators

### [Calculate weeks of cover](https://twelfth.ai/tools/weeks-of-cover)

How long will the stock on hand last?

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

Example inputs: Usable units on hand 30; Expected units sold per week 15.

Result: 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.

[Download the calculate weeks of cover CSV template](https://twelfth.ai/resources/retail-csv/weeks-of-cover.csv).

Replenishment: If supplier delivery takes longer than current stock cover, check the reorder point and confirmed stock on order. [Read more](https://twelfth.ai/glossary/replenishment).
Stockout: A week with empty shelves can make recorded sales look like weak demand. Use a normal trading week to estimate cover. [Read more](https://twelfth.ai/glossary/stockout).

### [Check a replenishment threshold](https://twelfth.ai/tools/replenishment)

Is the stock position below its reorder point?

Formula: Reorder point = expected demand during lead time + safety stock.

Example inputs: Expected units sold per week 15; Delivery lead time in weeks 2; Safety stock in units 10; Usable units on hand 30; Confirmed units on order 0.

Result: 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.

[Download the check a replenishment threshold CSV template](https://twelfth.ai/resources/retail-csv/replenishment.csv).

Weeks of cover: A reorder point can flag action even while stock appears to cover near-term sales. [Read more](https://twelfth.ai/glossary/weeks-of-cover).
Demand forecast: If a promotion doubles expected weekly demand, recalculate the reorder point before placing an order. [Read more](https://twelfth.ai/glossary/demand-forecast).

### [Estimate lost sales from a stockout](https://twelfth.ai/tools/stockout)

How many sales did a stockout cost?

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

Example inputs: Normal units sold per day 12; Days unavailable 3; Extra units similar lines sold 10; Gross profit per unit 6.

Result: 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.

[Download the estimate lost sales from a stockout CSV template](https://twelfth.ai/resources/retail-csv/stockout.csv).

Lost demand: Sales data only records what sold. Estimate unserved demand before a soft month is blamed on the range. [Read more](https://twelfth.ai/glossary/lost-demand).
Demand forecast: Flag the days a line was unavailable, or the next forecast reads them as days nobody wanted it. [Read more](https://twelfth.ai/glossary/demand-forecast).

### [Calculate sell-through](https://twelfth.ai/tools/sell-through)

How much of the available stock sold?

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

Example inputs: Units sold in the period 120; Opening stock 300; Units received in the period 100.

Result: 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.

[Download the calculate sell-through CSV template](https://twelfth.ai/resources/retail-csv/sell-through.csv).

Markdown: 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 more](https://twelfth.ai/glossary/markdown).
Range review: A line may sell through overall while one size or store is slow. Review that mix before changing the whole range. [Read more](https://twelfth.ai/glossary/range-review).

### [Calculate a markdown](https://twelfth.ai/tools/markdown)

What happens to margin after a price cut?

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

Example inputs: Original selling price 100; New selling price 80; Unit cost 50.

Result: 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.

[Download the calculate a markdown CSV template](https://twelfth.ai/resources/retail-csv/markdown.csv).

Sell-through: Compare sell-through before and after a price test to see whether the line actually moved faster. [Read more](https://twelfth.ai/glossary/sell-through).
Clearance: For an end-of-season line, set an exit date and check remaining stock as well as the new unit margin. [Read more](https://twelfth.ai/glossary/clearance).

### [Calculate a price index](https://twelfth.ai/tools/price-index)

How does a matched competitor price compare?

Formula: Price index = your price ÷ competitor price × 100.

Example inputs: Your price 20; Competitor price 18.

Result: 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.

[Download the calculate a price index CSV template](https://twelfth.ai/resources/retail-csv/price-index.csv).

Matched SKU: A 12-pack and a 24-pack are not a fair price match. Check the exact product, size, seller and date. [Read more](https://twelfth.ai/glossary/matched-sku).
Price position: A single competitor gap does not define the whole category. Compare a consistent basket to your intended position. [Read more](https://twelfth.ai/glossary/price-position).

### [Calculate GMROI](https://twelfth.ai/tools/gmroi)

How much margin did the stock investment earn?

Formula: GMROI = gross margin earned ÷ average inventory at cost.

Example inputs: Gross margin earned 12000; Average inventory at cost 4000.

Result: 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.

[Download the calculate gmroi CSV template](https://twelfth.ai/resources/retail-csv/gmroi.csv).

Range review: Two lines can earn the same margin dollars while one ties up much more stock. Compare their roles before removing either. [Read more](https://twelfth.ai/glossary/range-review).
Sell-through: A slow-selling line may hold inventory for longer. Check its sell-through alongside GMROI before adding stock. [Read more](https://twelfth.ai/glossary/sell-through).

## Worked decision paths

### 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. [Calculate weeks of cover](https://twelfth.ai/tools/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. [Check a replenishment threshold](https://twelfth.ai/tools/replenishment): 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.

Related concepts: [Demand forecast](https://twelfth.ai/glossary/demand-forecast), [Stockout](https://twelfth.ai/glossary/stockout), [Stock transfer](https://twelfth.ai/glossary/stock-transfer).

### 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. [Calculate sell-through](https://twelfth.ai/tools/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. [Calculate a markdown](https://twelfth.ai/tools/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.

Related concepts: [Clearance](https://twelfth.ai/glossary/clearance), [Cannibalisation](https://twelfth.ai/glossary/cannibalisation), [Assortment](https://twelfth.ai/glossary/assortment).

### 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. [Calculate a price index](https://twelfth.ai/tools/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. [Calculate GMROI](https://twelfth.ai/tools/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.

Related concepts: [Matched SKU](https://twelfth.ai/glossary/matched-sku), [Price position](https://twelfth.ai/glossary/price-position), [Gross-profit floor](https://twelfth.ai/glossary/gp-floor).

## Spreadsheet and checklist

- [Download the Excel workbook](https://twelfth.ai/resources/retail-metrics-template.xlsx). Import the .xlsx file into Google Sheets to use it there. It has formula rows for six metrics plus a range review tracker and matched-price log.
- [Download all nine CSV templates](https://twelfth.ai/resources/retail-csv-templates.zip). Each CSV imports as one sheet and contains 25 rows, including an illustrative example and formulas where applicable.
- [Download the range review CSV](https://twelfth.ai/resources/retail-csv/range-review.csv) or [matched-price log CSV](https://twelfth.ai/resources/retail-csv/price-match-log.csv) individually.
- [Use the range review checklist](https://twelfth.ai/glossary/range-review). It covers role, sales, margin, availability, shopper need, and a date to review the decision.
- [Browse the retail glossary](https://twelfth.ai/glossary) for definitions and further examples.

Source: https://twelfth.ai/tools
