The ladder plan that fills itself

What to make and when for a retailer's house-brand basics: inventory by size, month by month, against what the retailer says it will sell. It pulls from the ERP every weekday morning and flags any size heading below safety stock.

Replaced: a hand-kept Excel ladder, in two copies that never matched.

Live demoEvery name and number here is invented

On hand now: 115,044; S 19,368 · M 39,594 · L 36,816 · XL 19,266
In production, next 3 months: 120,000; S 21,600 · M 42,000 · L 38,400 · XL 18,000
On order after that: 480,000; S 86,400 · M 168,000 · L 153,600 · XL 72,000

8 upcoming months end below safety stock, starting Jan 2027. Pink cells show which sizes; red numbers are stockouts.

Crew Sock 8-Pack ladder

DM-2104 · main warehouse

CREW SOCK 8-PACK · DM-2104 · LADDER PLAN, MAIN WAREHOUSE
Target safety inventory	14,400	30,600	28,800	16,200	90,000	The retailer wants this much on hand at all times, split by the size mix.

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Sep 2026	33,984	72,216	67,968	38,232	212,400		Sep 2026	33,984	72,216	67,968	38,232	212,400
Planned receipts from factory	0	0	0	0	0		Actual receipts	0	0	0	0	0
Retailer projected sales	10,764	22,878	21,528	12,108	67,278		Actual shipped to retailer	11,136	23,664	22,272	12,528	69,600
Ending on hand	23,220	49,338	46,440	26,124	145,122		Ending on hand	22,848	48,552	45,696	25,704	142,800

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Oct 2026	23,220	49,338	46,440	26,124	145,122	Factory receipts land this month	Oct 2026	22,848	48,552	45,696	25,704	142,800
Planned receipts from factory	17,280	33,600	30,720	14,400	96,000	One container slipped to Nov; actual receipts are half of plan	Actual receipts	8,640	16,800	15,360	7,200	48,000
Retailer projected sales	10,938	23,238	21,870	12,300	68,346		Actual shipped to retailer	12,120	25,758	24,240	13,638	75,756
Ending on hand	29,562	59,700	55,290	28,224	172,776		Ending on hand	19,368	39,594	36,816	19,266	115,044

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Nov 2026	29,562	59,700	55,290	28,224	172,776	CURRENT MONTH	Nov 2026	19,368	39,594	36,816	19,266	115,044
Planned receipts from factory	25,920	50,400	46,080	21,600	144,000	Factory receipts land this month	Actual receipts
Retailer projected sales	14,436	30,684	28,878	16,242	90,240		Actual shipped to retailer
Ending on hand	41,046	79,416	72,492	33,582	226,536		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Dec 2026	41,046	79,416	72,492	33,582	226,536	Factory receipts land this month	Dec 2026
Planned receipts from factory	12,960	25,200	23,040	10,800	72,000		Actual receipts
Retailer projected sales	15,642	33,234	31,278	17,592	97,746		Actual shipped to retailer
Ending on hand	38,364	71,382	64,254	26,790	200,790		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Jan 2027	38,364	71,382	64,254	26,790	200,790	Below safety in XL: pull the next PO forward	Jan 2027
Planned receipts from factory	0	0	0	0	0		Actual receipts
Retailer projected sales	9,522	20,238	19,050	10,716	59,526		Actual shipped to retailer
Ending on hand	28,842	51,144	45,204	16,074	141,264		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Feb 2027	28,842	51,144	45,204	16,074	141,264	Factory receipts land this month	Feb 2027
Planned receipts from factory	8,640	16,800	15,360	7,200	48,000	Below safety in XL: pull the next PO forward	Actual receipts
Retailer projected sales	9,024	19,170	18,042	10,146	56,382		Actual shipped to retailer
Ending on hand	28,458	48,774	42,522	13,128	132,882		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Mar 2027	28,458	48,774	42,522	13,128	132,882	Factory receipts land this month	Mar 2027
Planned receipts from factory	17,280	33,600	30,720	14,400	96,000	Below safety in XL: pull the next PO forward	Actual receipts
Retailer projected sales	11,310	24,030	22,620	12,720	70,680		Actual shipped to retailer
Ending on hand	34,428	58,344	50,622	14,808	158,202		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Apr 2027	34,428	58,344	50,622	14,808	158,202	Factory receipts land this month	Apr 2027
Planned receipts from factory	17,280	33,600	30,720	14,400	96,000	Below safety in XL: pull the next PO forward	Actual receipts
Retailer projected sales	12,174	25,866	24,342	13,692	76,074		Actual shipped to retailer
Ending on hand	39,534	66,078	57,000	15,516	178,128		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
May 2027	39,534	66,078	57,000	15,516	178,128	Factory receipts land this month	May 2027
Planned receipts from factory	12,960	25,200	23,040	10,800	72,000	Below safety in XL: pull the next PO forward	Actual receipts
Retailer projected sales	11,928	25,350	23,856	13,422	74,556		Actual shipped to retailer
Ending on hand	40,566	65,928	56,184	12,894	175,572		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Jun 2027	40,566	65,928	56,184	12,894	175,572	Factory receipts land this month	Jun 2027
Planned receipts from factory	12,960	25,200	23,040	10,800	72,000	Below safety in XL: pull the next PO forward	Actual receipts
Retailer projected sales	10,938	23,244	21,882	12,306	68,370		Actual shipped to retailer
Ending on hand	42,588	67,884	57,342	11,388	179,202		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Jul 2027	42,588	67,884	57,342	11,388	179,202	Factory receipts land this month	Jul 2027
Planned receipts from factory	12,960	25,200	23,040	10,800	72,000	Below safety in XL: pull the next PO forward	Actual receipts
Retailer projected sales	11,046	23,466	22,086	12,426	69,024		Actual shipped to retailer
Ending on hand	44,502	69,618	58,296	9,762	182,178		Ending on hand

PLAN	S	M	L	XL	Total	Notes	ACTUAL	S	M	L	XL	Total
Aug 2027	44,502	69,618	58,296	9,762	182,178	Factory receipts land this month	Aug 2027
Planned receipts from factory	12,960	25,200	23,040	10,800	72,000	Below safety in XL: pull the next PO forward	Actual receipts
Retailer projected sales	12,030	25,566	24,060	13,536	75,192		Actual shipped to retailer
Ending on hand	45,432	69,252	57,276	7,026	178,986		Ending on hand

Months before Nov 2026 are closed and show actuals. The layout copies the planners' own spreadsheet, so nobody had to learn a new screen.