Free Excel template · Excel for retail and ecommerce

Free reorder point calculator template

Q: How do I calculate a reorder point in Excel?

Multiply average daily sales by the lead time in days, then add safety stock: =daily_sales*(lead_time+safety_days). Order when stock on hand plus stock on order falls to that number.

Q: How much safety stock should I keep?

Enough to cover the gap between a normal and a bad week: slower deliveries or a sales spike. Many small shops start with a few days of sales and raise it for products that have run out before. The template lets you change it in one cell.

Q: What is days of cover?

How many days your current stock lasts at the current sales rate: stock divided by daily sales. If it is shorter than the supplier's lead time, order now.

For retailers and online sellers who keep running out of best sellers or sitting on too much of the rest. Enter stock on hand, stock already on order, units sold in a recent period and each supplier's lead time. The template works out daily sales, a reorder point with safety stock, days of cover, which products to reorder and a suggested order quantity.

cellwise-reorder-point-calculator.xlsxExcel workbook · 5.4 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H	I	J	K
1	SKU	Product	On hand	On order	Sold (period)	Lead time (days)	Daily sales	Reorder point	Days of cover	Status	Order qty
2	TS-01	Organic crew tee	160	0	206	14	6.87	145	23.3	OK	0
3	HD-02	Zip hoodie	40	0	79	21	2.63	74	15.2	Reorder	113
4	CP-03	Canvas cap	120	0	85	14	2.83	60	42.4	OK	0
5	TB-04	Tote bag	26	0	85	10	2.83	49	9.2	Reorder	108
6	BN-05	Beanie	18	80	93	21	3.1	87	31.6	OK	0
7	MG-06	Enamel mug	64	0	51	28	1.7	60	37.6	OK	0
8	SK-07	Crew socks (3 pack)	35	0	100	10	3.33	57	10.5	Reorder	122
9	PR-08	Art print A3	150	0	49	7	1.63	23	92	OK	0
10	JK-09	Rain jacket	14	0	29	30	0.97	36	14.4	Reorder	52
11											0
12											0
13											0
14											0
15											0
16											0

How the formulas work

Average daily sales

G2=IF(E2="","",ROUND(E2/$N$1,2))

Units sold in the period divided by its length in N1. Use a period that reflects what is coming: last 30 days for steady sellers, the same weeks last year ahead of a seasonal peak.

Reorder point with safety stock

H2=IF(E2="","",ROUNDUP(G2*(F2+$N$2),0))

Daily sales times the supplier's lead time plus the safety days in N2. When stock falls to this number, order. ROUNDUP keeps you on the safe side of a fraction.

Count stock already on order

J2=IF(E2="","",IF(C2+D2<=H2,"Reorder","OK"))

Compare on hand plus on order with the reorder point. Without the On order column, a product you ordered yesterday still shows Reorder and gets ordered twice. The beanies here are low on the shelf but 80 are on the way, so they show OK.

Suggested order quantity

K2=IF(J2="Reorder",MAX(0,ROUNDUP(H2+G2*$N$3-C2-D2,0)),0)

Enough to bring stock back above the reorder point plus the days of stock you want each order to cover (N3). Round up to the supplier's case size or minimum order before you send it.

Make it yours

Give slow, unreliable suppliers more safety days. One global number in N2 is a starting point; add a per-product column if your suppliers vary a lot.
Days of cover shorter than the lead time means you will run out before a new order can arrive. Sort by that column each week.
Products marked No sales have no recent sales: candidates for a promotion or a clearance, not a reorder.
Update On hand from your shop system or a stock count before you use the numbers.

FAQ

How do I calculate a reorder point in Excel?

Multiply average daily sales by the lead time in days, then add safety stock: =daily_sales*(lead_time+safety_days). Order when stock on hand plus stock on order falls to that number.

How much safety stock should I keep?

Enough to cover the gap between a normal and a bad week: slower deliveries or a sales spike. Many small shops start with a few days of sales and raise it for products that have run out before. The template lets you change it in one cell.

What is days of cover?

How many days your current stock lasts at the current sales rate: stock divided by daily sales. If it is shorter than the supplier's lead time, order now.

Functions used

Related guides

More free templates

Updated November 2, 2026