Generated data. Every figure here comes from seed/generate_workbook.py — a seven-node fulfillment network, 420 SKUs, 18 months of weekly shipments, seeded so it is identical on every run.

Replenishment planner

Safety stock, reorder point and economic order quantity per SKU and node - planned against delivered lead times rather than contracted ones, and against inventory position rather than what is on the shelf.

Lines to order 595 of 1,524 stocked locations

Order value $3.58M 95,488 units at cost

Safety stock held $4.56M 126,193 units of buffer

Contribution at risk $303k 11 stocked out, 160 below safety stock

Mean delivered lead time 33 d from receipts, not from contracts

Cost of planning on contract $1.21M stock the contracted lead times would have missed

POLICY LAB

What changes under pressure?

Hold today's inventory position fixed, then challenge demand, delivered lead time, and the network service target. The scenario reprices buffers, orders, and expected lead-window exposure; it never places an order or overrides the approved plan.

SIMULATED · APPROVAL REQUIRED

Saved in the static copy: the seven service targets on the frontier chart; demand multipliers 0.8, 0.9, 1.0, 1.1, 1.2 and 1.25; lead-time multipliers 1.0, 1.1, 1.2 and 1.3. Other values need the full app.

Scenario order value $3.00M 598 of 1,524 locations due

Scenario safety stock $3.81M 110,069 buffer units

Lead-window exposure $303k 22,978 expected units short

Decision status Review required simulation never submits an order

Service-cost frontier

Annual buffer carrying cost versus modeled shortage exposure. The lowest modeled point is an economic screen, not an approved service promise.

Highest scenario exposures

One row per SKU-node policy exception, ranked by expected financial consequence inside the scenario lead window.

SKU	Node	Scenario status	Position	Safety	Order	Exposure
B000165	YYZ4	Below scenario safety stock	418	520	1,744	$20,663
B000041	YYZ4	Stocked out	0	1,282	3,264	$18,813
B000034	YYZ4	Below scenario safety stock	167	332	736	$6,528
B000056	YUL5	Scenario order due	507	355	528	$6,372
B000031	YUL5	Below scenario safety stock	122	187	600	$5,891
B000075	YUL5	Below scenario safety stock	37	120	289	$5,826
B000165	YUL5	Scenario order due	366	224	592	$5,577
B000378	YHZ1	Below scenario safety stock	277	546	1,566	$4,999
B000056	YVR2	Scenario order due	327	246	384	$4,989
B000090	YVR2	Below scenario safety stock	24	209	528	$4,817
B000181	YUL5	Below scenario safety stock	806	1,178	1,200	$4,455
B000165	YVR2	Scenario order due	242	183	456	$4,275
B000343	YYZ4	Scenario order due	739	427	528	$4,097
B000160	YVR2	Scenario order due	173	161	301	$3,906
B000046	YYZ4	Below scenario safety stock	201	349	720	$3,796
B000190	YVR2	Below scenario safety stock	472	804	1,152	$3,624
B000262	YYZ4	Scenario order due	1,068	740	1,411	$3,489
B000403	YYZ4	Below scenario safety stock	48	117	302	$3,456
B000056	YEG3	Scenario order due	116	109	204	$3,397
B000262	YVR2	Below scenario safety stock	487	517	1,136	$3,391
B000375	YYZ4	Below scenario safety stock	117	217	508	$3,314
B000245	YUL5	Below scenario safety stock	93	394	952	$3,151
B000392	YYZ4	Scenario order due	696	487	672	$3,145
B000405	YYZ4	Below scenario safety stock	245	261	534	$2,997
B000262	YUL5	Below scenario safety stock	321	375	895	$2,880

Showing 25 of 1,524 locations. Exposure is an analytical screen, not a realised loss.

What to order

A line appears here when inventory position — on hand, plus what is on a truck, minus what is already promised — has fallen to the reorder point. Quantities are rounded up to a whole case.

Node ABC Department Status only lines due CSV Excel

SKU	Item	Node	ABC	Position	Reorder pt	Safety	Lead	Cover	Order	Value	Risk	Status
B000165	Aurelia Everyday Puzzle 4-Pack	YYZ4	A	418	2,091	650	52 d	2.2 wk	1,872	$65,857	100%	Below safety stock
B000041	Harbourline Heritage Hair Care Bulk Case	YYZ4	A	0	3,358	1,601	56 d	0.0 wk	3,600	$51,840	99%	Stocked out
B000034	Aurelia Everyday Cables & Adapter 4-Pack	YYZ4	A	167	879	414	31 d	1.6 wk	816	$59,544	93%	Below safety stock
B000056	Ashgrove Insulated Headphone 12-Pack	YUL5	A	507	1,051	443	68 d	8.0 wk	612	$137,119	68%	At reorder point
B000031	Meridian Bay Slimline Headphone 2-Pack	YUL5	A	122	703	234	52 d	1.9 wk	648	$32,808	100%	Below safety stock
B000075	Coppermill Essential Cycling 12-Pack	YUL5	A	37	334	150	63 d	1.8 wk	319	$17,988	98%	Below safety stock
B000165	Aurelia Everyday Puzzle 4-Pack	YUL5	A	366	921	280	52 d	4.3 wk	648	$22,797	98%	At reorder point
B000378	Ironpine Everyday Outerwear 4-Pack	YHZ1	A	277	1,727	682	29 d	1.1 wk	1,704	$15,762	99%	Below safety stock
B000056	Ashgrove Insulated Headphone 12-Pack	YVR2	A	327	723	307	68 d	7.6 wk	444	$99,478	72%	At reorder point
B000090	Fenwick Pro Team Sport 4-Pack	YVR2	A	24	568	261	63 d	0.7 wk	582	$17,640	99%	Below safety stock
B000181	Northvale Insulated Portable Power Single	YUL5	A	806	2,220	1,471	68 d	10.4 wk	1,500	$81,675	47%	Below safety stock
B000165	Aurelia Everyday Puzzle 4-Pack	YVR2	A	242	682	229	52 d	4.0 wk	504	$17,731	97%	At reorder point
B000343	Meridian Bay Slimline Tablet 2-Pack	YYZ4	A	739	1,288	533	68 d	9.5 wk	648	$83,430	52%	At reorder point
B000160	Calder and Vine Cordless Headphone 4-Pack	YVR2	A	173	477	202	52 d	4.7 wk	341	$51,910	85%	Below safety stock
B000046	Ironpine Cordless Activewear 4-Pack	YYZ4	B	201	860	349	63 d	3.5 wk	720	$10,505	93%	Below safety stock
B000190	Larkspur Insulated Water Sport 2-Pack	YVR2	A	472	1,736	1,004	63 d	5.8 wk	1,356	$33,642	70%	Below safety stock
B000262	Larkspur Traveller Portable Power 2-Pack	YYZ4	A	1,068	2,500	924	68 d	6.5 wk	1,595	$126,499	87%	At reorder point
B000403	Larkspur Heavy Duty Basic Single	YYZ4	B	48	319	117	47 d	1.6 wk	302	$9,815	98%	Below safety stock
B000056	Ashgrove Insulated Headphone 12-Pack	YEG3	A	116	325	136	68 d	5.9 wk	240	$53,772	87%	Below safety stock
B000262	Larkspur Traveller Portable Power 2-Pack	YVR2	A	487	1,647	645	68 d	4.7 wk	1,265	$100,327	95%	Below safety stock
B000375	Larkspur Traveller Cables & Adapter Single	YYZ4	A	117	606	271	33 d	1.6 wk	564	$46,090	95%	Below safety stock
B000245	Larkspur Lightweight Pantry Staple Single	YUL5	C	93	883	307	56 d	1.3 wk	864	$2,056	98%	Below safety stock
B000392	Meridian Bay Everyday Outdoor Play Single	YYZ4	A	696	1,399	608	63 d	7.9 wk	792	$33,280	63%	At reorder point
B000405	Ashgrove Essential Headphone 2-Pack	YYZ4	A	245	793	325	68 d	5.1 wk	600	$48,768	92%	Below safety stock
B000262	Larkspur Traveller Portable Power 2-Pack	YUL5	A	321	1,230	468	68 d	4.1 wk	988	$78,358	97%	Below safety stock
B000228	Fenwick Lightweight Smart Home 2-Pack	YYZ4	A	180	661	244	33 d	2.0 wk	576	$29,451	98%	Below safety stock
B000034	Aurelia Everyday Cables & Adapter 4-Pack	YEG3	A	27	287	136	31 d	0.8 wk	296	$21,599	97%	Below safety stock
B000041	Harbourline Heritage Hair Care Bulk Case	YVR2	A	571	1,405	653	56 d	6.1 wk	936	$13,478	72%	Below safety stock
B000165	Aurelia Everyday Puzzle 4-Pack	YHZ1	A	68	276	85	52 d	2.7 wk	240	$8,443	100%	Below safety stock
B000190	Larkspur Insulated Water Sport 2-Pack	YHZ1	A	126	735	381	63 d	3.2 wk	660	$16,375	89%	Below safety stock
B000041	Harbourline Heritage Hair Care Bulk Case	YHZ1	A	174	745	350	56 d	3.5 wk	624	$8,986	90%	Below safety stock
B000174	Calder and Vine Pro Outdoor Play Bulk Case	YVR2	B	15	279	86	63 d	0.7 wk	286	$8,529	100%	Below safety stock
B000099	Northvale Insulated Cables & Adapter 12-Pack	YYZ4	A	276	647	318	31 d	3.8 wk	444	$53,422	63%	Below safety stock
B000134	Rivermont Everyday Streaming Device 2-Pack	YYZ4	A	116	695	225	52 d	1.8 wk	642	$11,004	100%	Below safety stock
B000017	Rivermont Heritage Basic Single	YHZ1	A	550	1,037	424	47 d	6.1 wk	624	$23,113	62%	At reorder point
B000010	Aurelia Premium Tablet 4-Pack	YYC1	A	49	669	316	31 d	0.6 wk	708	$15,930	98%	Below safety stock
B000120	Ashgrove Premium Hair Care 2-Pack	YYZ4	C	32	234	86	56 d	1.7 wk	228	$5,034	96%	Below safety stock
B000370	Northvale Cordless Building Set Single	YYZ4	B	379	645	178	52 d	6.1 wk	336	$9,741	79%	At reorder point
B000056	Ashgrove Insulated Headphone 12-Pack	YYZ4	A	1,437	1,899	804	68 d	12.7 wk	576	$129,053	19%	At reorder point
B000343	Meridian Bay Slimline Tablet 2-Pack	YEG3	A	101	231	86	68 d	6.7 wk	168	$21,630	86%	At reorder point
B000414	Harbourline Premium Cookware Single	YYZ4	A	68	328	141	31 d	1.6 wk	312	$10,159	96%	Below safety stock
B000378	Ironpine Everyday Outerwear 4-Pack	YEG3	A	627	1,446	597	29 d	3.1 wk	1,026	$9,491	78%	At reorder point
B000267	Ashgrove Traveller Basic 12-Pack	YYZ4	A	650	1,029	441	63 d	9.9 wk	456	$16,275	39%	At reorder point
B000108	Rivermont Essential Tableware 6-Pack	YUL5	A	270	729	323	31 d	2.9 wk	552	$15,191	81%	Below safety stock
B000010	Aurelia Premium Tablet 4-Pack	YUL5	A	261	1,027	537	31 d	2.4 wk	876	$19,710	81%	Below safety stock
B000033	Fenwick Studio Footwear Single	YYZ4	C	9	108	41	29 d	0.6 wk	120	$3,038	96%	Below safety stock
B000166	Solstice Row Essential Hair Care Single	YYZ4	B	143	448	239	31 d	3.0 wk	360	$8,179	68%	Below safety stock
B000185	Ashgrove Value Smart Home Bulk Case	YYZ4	A	118	598	239	33 d	1.5 wk	576	$13,697	98%	Below safety stock
B000040	Ashgrove Slimline Portable Power Single	YUL5	A	64	197	88	31 d	2.6 wk	158	$12,458	85%	Below safety stock
B000074	Meridian Bay Pro Activewear 4-Pack	YUL5	C	40	295	95	63 d	1.8 wk	278	$3,097	98%	Below safety stock
B000017	Rivermont Heritage Basic Single	YYZ4	A	2,664	3,540	1,505	47 d	8.8 wk	1,200	$44,448	20%	At reorder point
B000001	Ashgrove Heritage Footwear 12-Pack	YYZ4	C	10	97	33	63 d	1.4 wk	96	$3,075	98%	Below safety stock
B000041	Harbourline Heritage Hair Care Bulk Case	YWG2	A	166	546	251	56 d	4.5 wk	432	$6,221	86%	Below safety stock
B000174	Calder and Vine Pro Outdoor Play Bulk Case	YUL5	B	188	418	125	63 d	5.8 wk	263	$7,843	91%	At reorder point
B000090	Fenwick Pro Team Sport 4-Pack	YWG2	A	66	283	134	63 d	4.0 wk	234	$7,093	90%	Below safety stock
B000373	Tidewater Studio Water Sport Single	YEG3	A	44	121	57	63 d	6.2 wk	88	$12,851	77%	Below safety stock
B000330	Larkspur Slimline Storage & Organisation Single	YVR2	A	0	190	82	31 d	0.0 wk	216	$7,402	100%	Stocked out
B000262	Larkspur Traveller Portable Power 2-Pack	YEG3	A	172	591	218	68 d	4.5 wk	458	$36,324	97%	Below safety stock
B000343	Meridian Bay Slimline Tablet 2-Pack	YVR2	A	281	459	175	68 d	9.6 wk	216	$27,810	51%	At reorder point
B000160	Calder and Vine Cordless Headphone 4-Pack	YEG3	A	102	199	65	52 d	5.6 wk	116	$17,659	85%	At reorder point
B000081	Rivermont Slimline Activewear 6-Pack	YYZ4	C	23	185	65	63 d	1.7 wk	175	$2,996	97%	Below safety stock
B000228	Fenwick Lightweight Smart Home 2-Pack	YEG3	A	18	203	78	33 d	0.7 wk	216	$11,044	100%	Below safety stock
B000392	Meridian Bay Everyday Outdoor Play Single	YHZ1	A	95	262	104	63 d	5.4 wk	188	$7,900	89%	Below safety stock
B000213	Rivermont Compact Camping Single	YYZ4	A	9	157	114	8 d	0.2 wk	188	$8,652	73%	Below safety stock
B000007	Tidewater Lightweight Cat Food Single	YYC1	A	102	683	424	7 d	0.4 wk	834	$4,545	78%	Below safety stock
B000174	Calder and Vine Pro Outdoor Play Bulk Case	YYZ4	B	533	825	251	63 d	8.3 wk	357	$10,646	60%	At reorder point
B000129	Aurelia Pro Outerwear Single	YHZ1	A	1,188	1,589	651	47 d	8.6 wk	540	$25,796	22%	At reorder point
B000190	Larkspur Insulated Water Sport 2-Pack	YUL5	A	1,279	2,138	1,162	63 d	11.8 wk	972	$24,115	30%	At reorder point
B000141	Stonebrook Pro Water Sport 2-Pack	YYC1	A	23	91	36	29 d	1.7 wk	84	$3,771	96%	Below safety stock
B000183	Calder and Vine Pro Basic 2-Pack	YYZ4	C	5	78	27	47 d	0.7 wk	84	$1,802	99%	Below safety stock
B000149	Ashgrove Insulated Oral Care 2-Pack	YYZ4	C	35	170	61	56 d	2.6 wk	149	$3,431	94%	Below safety stock
B000280	Calder and Vine Premium Accessorie 4-Pack	YYZ4	A	408	789	337	63 d	8.1 wk	432	$7,914	60%	At reorder point
B000414	Harbourline Premium Cookware Single	YUL5	A	67	233	97	31 d	2.2 wk	216	$7,033	93%	Below safety stock
B000074	Meridian Bay Pro Activewear 4-Pack	YYZ4	C	177	398	125	63 d	5.8 wk	252	$2,807	83%	At reorder point
B000236	Larkspur Deluxe Outerwear Single	YYZ4	C	398	754	241	63 d	7.0 wk	414	$2,538	73%	At reorder point
B000263	Solstice Row Cordless Fitnes 2-Pack	YUL5	A	0	87	47	8 d	0.0 wk	124	$6,242	96%	Stocked out
B000280	Calder and Vine Premium Accessorie 4-Pack	YVR2	A	161	413	177	63 d	6.2 wk	288	$5,276	81%	Below safety stock
B000190	Larkspur Insulated Water Sport 2-Pack	YWG2	A	173	521	290	63 d	6.7 wk	384	$9,527	66%	Below safety stock
B000031	Meridian Bay Slimline Headphone 2-Pack	YYZ4	A	541	802	249	52 d	7.3 wk	336	$17,012	54%	At reorder point
B000089	Stonebrook Essential Camping Single	YEG3	A	10	166	72	63 d	1.0 wk	168	$4,916	99%	Below safety stock
B000041	Harbourline Heritage Hair Care Bulk Case	YUL5	A	1,071	1,691	790	56 d	9.6 wk	744	$10,714	33%	At reorder point
B000202	Fenwick Everyday Diapering 6-Pack	YYZ4	A	568	1,005	427	29 d	4.1 wk	576	$15,408	52%	At reorder point
B000294	Bellwood Heritage Activewear 2-Pack	YYZ4	B	40	113	44	29 d	2.4 wk	96	$4,082	86%	Below safety stock
B000375	Larkspur Traveller Cables & Adapter Single	YVR2	A	56	182	70	33 d	2.3 wk	152	$12,421	95%	Below safety stock
B000108	Rivermont Essential Tableware 6-Pack	YWG2	A	25	174	71	31 d	1.1 wk	173	$4,761	99%	Below safety stock
B000270	Northvale Deluxe Bedding 6-Pack	YUL5	A	150	286	100	59 d	6.8 wk	162	$6,940	77%	At reorder point
B000325	Ashgrove Insulated Activewear 4-Pack	YYC1	B	19	204	77	47 d	1.0 wk	208	$2,432	99%	Below safety stock
B000246	Bellwood Pro Writing 6-Pack	YYZ4	B	18	109	69	11 d	0.7 wk	120	$5,768	70%	Below safety stock
B000190	Larkspur Insulated Water Sport 2-Pack	YYZ4	A	1,215	1,846	847	63 d	10.9 wk	744	$18,459	30%	At reorder point
B000156	Larkspur Pro Oral Care Single	YEG3	A	74	196	79	31 d	2.8 wk	150	$2,148	87%	Below safety stock
B000345	Bellwood Value Storage & Organisation 6-Pack	YYZ4	B	198	300	97	59 d	8.2 wk	144	$8,388	53%	At reorder point
B000271	Larkspur Traveller Fitnes 4-Pack	YUL5	A	19	317	281	29 d	2.2 wk	312	$7,282	55%	Below safety stock
B000221	Stonebrook Slimline Tableware 6-Pack	YVR2	A	20	100	48	31 d	1.7 wk	93	$4,198	92%	Below safety stock
B000379	Meridian Bay Lightweight Footwear 6-Pack	YUL5	B	138	391	144	47 d	3.8 wk	292	$1,953	89%	Below safety stock
B000082	Tidewater Stackable Activewear 4-Pack	YHZ1	A	225	341	136	47 d	7.4 wk	156	$6,800	38%	At reorder point
B000046	Ironpine Cordless Activewear 4-Pack	YUL5	B	149	332	137	63 d	6.9 wk	210	$3,064	71%	At reorder point
B000144	Northvale Slimline Cookware 4-Pack	YHZ1	B	6	134	40	42 d	0.4 wk	144	$2,376	100%	Below safety stock
B000373	Tidewater Studio Water Sport Single	YYZ4	A	273	387	167	63 d	11.2 wk	140	$20,444	26%	At reorder point
B000408	Ironpine Heritage Puzzle Single	YYC1	B	12	78	34	63 d	2.4 wk	72	$3,151	94%	Below safety stock
B000262	Larkspur Traveller Portable Power 2-Pack	YHZ1	A	411	815	329	68 d	8.2 wk	454	$36,007	68%	At reorder point
B000067	Rivermont Everyday Cycling 12-Pack	YYC1	A	64	166	64	29 d	2.6 wk	144	$3,833	89%	At reorder point
B000181	Northvale Insulated Portable Power Single	YYZ4	A	477	813	467	68 d	13.3 wk	384	$20,909	28%	At reorder point
B000082	Tidewater Stackable Activewear 4-Pack	YWG2	A	149	247	108	47 d	7.2 wk	120	$5,231	43%	At reorder point
B000041	Harbourline Heritage Hair Care Bulk Case	YYC1	A	669	1,100	511	56 d	9.1 wk	528	$7,603	37%	At reorder point
B000041	Harbourline Heritage Hair Care Bulk Case	YEG3	A	304	599	276	56 d	7.6 wk	336	$4,838	56%	At reorder point
B000226	Larkspur Stackable Bedding 12-Pack	YUL5	B	44	208	60	42 d	1.8 wk	192	$3,525	100%	Below safety stock
B000312	Fenwick Insulated Skincare 12-Pack	YYZ4	B	21	202	110	11 d	0.4 wk	238	$2,737	85%	Below safety stock
B000265	Solstice Row Slimline Breakfast 4-Pack	YYZ4	C	240	488	172	56 d	6.1 wk	288	$1,699	72%	At reorder point
B000129	Aurelia Pro Outerwear Single	YYZ4	A	4,718	5,161	2,083	47 d	10.4 wk	900	$42,993	5%	At reorder point
B000047	Larkspur Compact Smart Home 12-Pack	YYC1	A	148	321	147	31 d	3.8 wk	216	$13,623	64%	At reorder point
B000084	Coppermill Essential Tableware 6-Pack	YWG2	A	6	194	92	42 d	0.4 wk	240	$2,419	98%	Below safety stock
B000034	Aurelia Everyday Cables & Adapter 4-Pack	YUL5	A	328	535	254	31 d	5.2 wk	272	$19,848	35%	At reorder point
B000236	Larkspur Deluxe Outerwear Single	YUL5	C	382	630	202	63 d	8.0 wk	300	$1,839	62%	At reorder point
B000089	Stonebrook Essential Camping Single	YYZ4	A	691	1,080	485	63 d	10.4 wk	456	$13,343	34%	At reorder point
B000393	Bellwood Premium Figure Single	YYZ4	B	50	142	100	16 d	2.7 wk	144	$5,206	45%	Below safety stock
B000129	Aurelia Pro Outerwear Single	YUL5	A	3,368	3,745	1,867	47 d	12.1 wk	660	$31,528	5%	At reorder point
B000148	Tidewater Pro Small Appliance Single	YVR2	B	9	117	50	35 d	0.7 wk	132	$2,842	97%	Below safety stock
B000070	Fenwick Heavy Duty Small Appliance Single	YHZ1	B	5	142	54	20 d	0.2 wk	168	$1,467	99%	Below safety stock
B000324	Solstice Row Value Building Set 12-Pack	YYC1	B	9	43	19	16 d	0.9 wk	48	$2,405	90%	Below safety stock
B000280	Calder and Vine Premium Accessorie 4-Pack	YEG3	A	92	240	106	63 d	6.2 wk	168	$3,078	79%	Below safety stock
B000160	Calder and Vine Cordless Headphone 4-Pack	YYZ4	A	880	1,079	416	52 d	9.9 wk	289	$43,994	14%	At reorder point
B000370	Northvale Cordless Building Set Single	YHZ1	B	68	131	35	52 d	5.3 wk	80	$2,319	90%	At reorder point
B000221	Stonebrook Slimline Tableware 6-Pack	YUL5	A	88	180	78	31 d	3.8 wk	116	$5,236	65%	At reorder point
B000162	Ironpine Essential Oral Care 6-Pack	YYZ4	B	184	416	169	56 d	6.0 wk	264	$3,131	73%	At reorder point
B000358	Kestrel Pro Portable Power Bulk Case	YYZ4	B	137	233	78	33 d	4.1 wk	130	$11,057	65%	At reorder point
B000265	Solstice Row Slimline Breakfast 4-Pack	YUL5	C	36	179	68	56 d	2.6 wk	160	$944	92%	Below safety stock
B000055	Solstice Row Value Activewear Single	YUL5	C	21	66	19	47 d	3.0 wk	56	$1,322	96%	At reorder point
B000201	Coppermill Essential Cables & Adapter 2-Pack	YYZ4	A	301	501	174	52 d	6.9 wk	252	$10,292	62%	At reorder point
B000407	Kestrel Essential Outerwear Single	YYZ4	C	96	172	51	47 d	5.4 wk	96	$1,329	73%	At reorder point
B000082	Tidewater Stackable Activewear 4-Pack	YYZ4	A	1,147	1,341	580	47 d	10.2 wk	312	$13,600	9%	At reorder point
B000084	Coppermill Essential Tableware 6-Pack	YYZ4	A	939	1,455	644	42 d	7.0 wk	672	$6,774	34%	At reorder point
B000335	Ashgrove Cordless Streaming Device Single	YYZ4	A	598	1,040	499	33 d	5.2 wk	560	$32,066	41%	At reorder point
B000113	Bellwood Insulated Accessorie 4-Pack	YYZ4	C	14	117	32	47 d	1.1 wk	144	$805	100%	Below safety stock
B000265	Solstice Row Slimline Breakfast 4-Pack	YYC1	C	13	126	46	56 d	1.3 wk	124	$732	97%	Below safety stock
B000074	Meridian Bay Pro Activewear 4-Pack	YHZ1	C	23	101	32	63 d	3.0 wk	86	$958	97%	Below safety stock
B000162	Ironpine Essential Oral Care 6-Pack	YEG3	B	6	139	66	56 d	0.7 wk	144	$1,708	95%	Below safety stock
B000017	Rivermont Heritage Basic Single	YWG2	A	580	785	302	47 d	8.1 wk	288	$10,668	25%	At reorder point
B000193	Tidewater Insulated Small Appliance Single	YYZ4	B	113	209	73	59 d	7.0 wk	120	$4,763	70%	At reorder point
B000319	Rivermont Heritage Basic Single	YYZ4	B	71	123	49	29 d	4.0 wk	72	$3,278	54%	At reorder point
B000096	Kestrel Compact Streaming Device Single	YYZ4	C	9	28	9	52 d	3.5 wk	22	$2,756	93%	At reorder point
B000314	Kestrel Traveller Cables & Adapter Single	YYZ4	B	427	667	220	68 d	9.2 wk	288	$11,364	56%	At reorder point
B000366	Fenwick Everyday Tablet 4-Pack	YHZ1	A	67	214	86	52 d	3.9 wk	168	$6,171	93%	Below safety stock
B000245	Larkspur Lightweight Pantry Staple Single	YVR2	C	377	575	195	56 d	8.0 wk	248	$590	51%	At reorder point
B000064	Solstice Row Traveller Storage & Organisation Single	YEG3	B	3	48	17	35 d	0.5 wk	51	$2,044	100%	Below safety stock
B000225	Solstice Row Everyday Water Sport 12-Pack	YUL5	A	218	309	148	63 d	12.2 wk	120	$8,735	22%	At reorder point
B000271	Larkspur Traveller Fitnes 4-Pack	YEG3	A	88	327	298	29 d	12.4 wk	248	$5,788	34%	Below safety stock
B000378	Ironpine Everyday Outerwear 4-Pack	YWG2	A	670	1,066	461	29 d	4.6 wk	546	$5,051	39%	At reorder point
B000070	Fenwick Heavy Duty Small Appliance Single	YYZ4	B	270	473	167	20 d	2.6 wk	308	$2,689	64%	At reorder point
B000060	Bellwood Cordless Toys & Treat 12-Pack	YYZ4	B	18	136	57	9 d	0.3 wk	180	$2,621	96%	Below safety stock
B000290	Bellwood Traveller Baking Bulk Case	YYZ4	C	32	159	72	9 d	0.5 wk	200	$458	84%	Below safety stock
B000017	Rivermont Heritage Basic Single	YVR2	A	1,749	2,068	833	47 d	9.6 wk	528	$19,557	10%	At reorder point
B000225	Solstice Row Everyday Water Sport 12-Pack	YWG2	A	48	94	49	63 d	9.5 wk	60	$4,367	46%	Below safety stock
B000245	Larkspur Lightweight Pantry Staple Single	YYZ4	C	920	1,149	401	56 d	9.9 wk	328	$781	29%	At reorder point
B000171	Ironpine Insulated Headphone Single	YWG2	A	65	113	51	68 d	10.0 wk	72	$7,185	46%	At reorder point
B000332	Calder and Vine Studio Cleaning Supplie Single	YWG2	B	23	58	17	42 d	3.4 wk	48	$1,783	95%	At reorder point
B000198	Northvale Slimline Cleaning Supplie Single	YYZ4	B	10	60	24	20 d	0.8 wk	72	$1,986	96%	Below safety stock
B000129	Aurelia Pro Outerwear Single	YYC1	A	1,467	1,688	645	47 d	9.5 wk	378	$18,057	9%	At reorder point
B000234	Meridian Bay Cordless Streaming Device Single	YYZ4	B	17	62	26	33 d	2.2 wk	53	$3,649	88%	Below safety stock
B000120	Ashgrove Premium Hair Care 2-Pack	YVR2	C	34	84	31	56 d	5.1 wk	60	$1,325	79%	At reorder point
B000339	Bellwood Traveller Nursery 4-Pack	YUL5	B	13	111	57	16 d	0.6 wk	128	$2,286	88%	Below safety stock
B000394	Northvale Traveller Tableware Single	YYZ4	A	391	667	277	35 d	5.0 wk	360	$6,926	50%	At reorder point
B000341	Ashgrove Pro Camping Single	YVR2	B	10	53	53	29 d	∞	44	$2,514	38%	Below safety stock
B000014	Bellwood Pro Cleaning Supplie Bulk Case	YVR2	B	67	147	52	35 d	3.5 wk	144	$3,213	82%	At reorder point
B000185	Ashgrove Value Smart Home Bulk Case	YUL5	A	130	296	123	33 d	3.5 wk	240	$5,707	76%	At reorder point
B000305	Aurelia Slimline Figure 4-Pack	YYZ4	B	880	1,112	337	52 d	8.5 wk	336	$4,580	30%	At reorder point
B000400	Harbourline Studio Frozen Meal 2-Pack	YYZ4	C	8	90	32	56 d	1.1 wk	96	$737	98%	Below safety stock
B000262	Larkspur Traveller Portable Power 2-Pack	YWG2	A	210	394	148	68 d	8.2 wk	210	$16,655	69%	At reorder point
B000179	Solstice Row Heavy Duty Portable Power 4-Pack	YVR2	B	39	75	29	33 d	4.0 wk	46	$2,859	65%	At reorder point
B000257	Larkspur Lightweight Habitat 4-Pack	YEG3	A	193	435	236	9 d	1.2 wk	400	$5,080	52%	Below safety stock
B000017	Rivermont Heritage Basic Single	YYC1	A	1,286	1,533	587	47 d	9.2 wk	432	$16,001	12%	At reorder point
B000404	Harbourline Premium Coffee & Tea 2-Pack	YUL5	B	0	116	71	7 d	0.0 wk	160	$1,002	85%	Stocked out
B000198	Northvale Slimline Cleaning Supplie Single	YUL5	B	4	43	18	20 d	0.5 wk	48	$1,324	98%	Below safety stock
B000286	Calder and Vine Premium Outdoor Play 2-Pack	YYZ4	B	98	145	53	16 d	2.4 wk	96	$4,156	43%	At reorder point
B000348	Tidewater Insulated Desk Accessorie Single	YVR2	B	93	233	107	11 d	1.2 wk	224	$2,231	69%	Below safety stock
B000370	Northvale Cordless Building Set Single	YWG2	B	44	83	25	52 d	5.6 wk	48	$1,392	83%	At reorder point
B000240	Kestrel Compact Headphone Single	YVR2	B	77	191	74	33 d	3.1 wk	140	$1,322	81%	At reorder point
B000228	Fenwick Lightweight Smart Home 2-Pack	YYC1	A	116	216	85	33 d	4.2 wk	132	$6,749	64%	At reorder point
B000184	Kestrel Compact Basic 2-Pack	YYZ4	A	1,122	1,375	566	47 d	9.4 wk	376	$6,847	13%	At reorder point
B000094	Larkspur Cordless Basic 12-Pack	YEG3	B	56	115	38	47 d	4.9 wk	72	$1,071	82%	At reorder point
B000036	Aurelia Stackable Personal Device 4-Pack	YYC1	C	1	29	11	56 d	0.4 wk	31	$916	98%	Below safety stock
B000217	Harbourline Studio Oral Care 2-Pack	YHZ1	C	3	17	6	56 d	2.3 wk	16	$601	94%	Below safety stock
B000146	Kestrel Heavy Duty Feeding 4-Pack	YVR2	B	0	48	20	16 d	0.0 wk	60	$1,320	99%	Stocked out
B000378	Ironpine Everyday Outerwear 4-Pack	YYZ4	A	3,263	3,860	1,329	29 d	5.4 wk	1,206	$11,156	13%	At reorder point
B000315	Harbourline Deluxe Portable Power 2-Pack	YEG3	A	22	87	38	31 d	2.0 wk	80	$5,455	93%	Below safety stock
B000126	Ironpine Premium Vitamin 2-Pack	YYC1	C	34	118	46	31 d	2.1 wk	104	$554	86%	Below safety stock
B000011	Bellwood Studio Fitnes Single	YYZ4	C	7	37	14	63 d	2.8 wk	33	$967	93%	Below safety stock
B000275	Rivermont Cordless Board Game Single	YYZ4	C	3	22	5	52 d	1.4 wk	22	$605	100%	Below safety stock
B000416	Northvale Value Figure 4-Pack	YYZ4	A	358	566	393	16 d	4.8 wk	288	$7,612	17%	Below safety stock
B000056	Ashgrove Insulated Headphone 12-Pack	YYC1	A	710	813	342	68 d	14.5 wk	156	$34,952	8%	At reorder point
B000298	Stonebrook Cordless Small Appliance 12-Pack	YWG2	A	10	51	26	20 d	1.2 wk	56	$2,186	88%	Below safety stock
B000338	Larkspur Deluxe Snack Single	YUL5	B	0	76	40	6 d	0.0 wk	128	$497	93%	Stocked out
B000244	Solstice Row Heavy Duty Hair Care 4-Pack	YYZ4	B	60	116	43	31 d	3.7 wk	84	$2,625	68%	At reorder point
B000259	Aurelia Essential Camping 12-Pack	YUL5	A	28	110	55	8 d	0.6 wk	130	$2,232	85%	Below safety stock
B000090	Fenwick Pro Team Sport 4-Pack	YEG3	A	250	371	172	63 d	11.3 wk	144	$4,365	27%	At reorder point
B000412	Fenwick Insulated Dog Food Single	YYC1	B	10	105	64	9 d	0.3 wk	132	$706	79%	Below safety stock
B000347	Ashgrove Value Footwear 2-Pack	YYC1	C	41	127	56	47 d	3.9 wk	100	$839	75%	Below safety stock
B000257	Larkspur Lightweight Habitat 4-Pack	YUL5	A	561	908	533	9 d	1.9 wk	640	$8,128	24%	At reorder point
B000156	Larkspur Pro Oral Care Single	YUL5	A	388	541	273	31 d	6.3 wk	216	$3,093	18%	At reorder point
B000066	Harbourline Premium Diapering Single	YYZ4	A	143	280	115	29 d	3.6 wk	180	$4,475	66%	At reorder point
B000156	Larkspur Pro Oral Care Single	YVR2	A	322	454	211	31 d	5.8 wk	192	$2,749	22%	At reorder point
B000178	Stonebrook Traveller Oral Care 2-Pack	YEG3	A	91	203	162	11 d	3.6 wk	144	$3,948	26%	Below safety stock
B000212	Solstice Row Everyday Basic Single	YEG3	B	83	123	51	63 d	10.4 wk	48	$1,828	36%	At reorder point
B000378	Ironpine Everyday Outerwear 4-Pack	YYC1	A	1,572	1,970	725	29 d	5.2 wk	702	$6,494	18%	At reorder point
B000075	Coppermill Essential Cycling 12-Pack	YYZ4	A	565	660	282	63 d	13.5 wk	137	$7,725	9%	At reorder point
B000047	Larkspur Compact Smart Home 12-Pack	YWG2	A	60	119	50	31 d	3.9 wk	78	$4,919	64%	At reorder point
B000129	Aurelia Pro Outerwear Single	YVR2	A	3,100	3,212	1,304	47 d	11.0 wk	396	$18,917	3%	At reorder point
B000335	Ashgrove Cordless Streaming Device Single	YEG3	A	88	205	93	33 d	3.7 wk	144	$8,245	70%	Below safety stock
B000110	Tidewater Everyday Vitamin 12-Pack	YYZ4	B	90	133	53	31 d	4.9 wk	64	$1,732	39%	At reorder point
B000266	Tidewater Everyday Tablet 6-Pack	YUL5	B	41	80	25	52 d	5.6 wk	46	$3,559	80%	At reorder point
B000017	Rivermont Heritage Basic Single	YEG3	A	1,184	1,368	550	47 d	9.8 wk	336	$12,445	9%	At reorder point
B000014	Bellwood Pro Cleaning Supplie Bulk Case	YYZ4	B	282	385	138	35 d	5.7 wk	192	$4,284	34%	At reorder point
B000174	Calder and Vine Pro Outdoor Play Bulk Case	YWG2	B	102	154	45	63 d	8.4 wk	64	$1,908	59%	At reorder point
B000127	Rivermont Slimline Outerwear Bulk Case	YYZ4	C	152	206	116	29 d	7.0 wk	78	$1,233	25%	At reorder point
B000002	Meridian Bay Studio Accessorie Single	YHZ1	C	6	29	11	63 d	3.0 wk	30	$608	93%	Below safety stock
B000149	Ashgrove Insulated Oral Care 2-Pack	YEG3	C	30	71	34	56 d	6.5 wk	47	$1,082	60%	Below safety stock
B000396	Ashgrove Everyday Water Sport 4-Pack	YUL5	B	76	125	55	63 d	9.7 wk	57	$2,239	43%	At reorder point
B000190	Larkspur Insulated Water Sport 2-Pack	YYC1	A	621	841	401	63 d	12.7 wk	276	$6,848	18%	At reorder point
B000330	Larkspur Slimline Storage & Organisation Single	YEG3	A	38	90	39	31 d	3.3 wk	72	$2,467	74%	Below safety stock
B000158	Fenwick Pro Outerwear 4-Pack	YUL5	C	6	32	17	47 d	2.6 wk	32	$749	77%	Below safety stock
B000184	Kestrel Compact Basic 2-Pack	YUL5	A	581	729	292	47 d	9.0 wk	216	$3,933	16%	At reorder point
B000246	Bellwood Pro Writing 6-Pack	YVR2	B	7	31	21	11 d	1.1 wk	36	$1,731	60%	Below safety stock
B000368	Aurelia Essential Tablet 12-Pack	YUL5	C	33	73	27	68 d	6.9 wk	48	$2,201	73%	At reorder point
B000315	Harbourline Deluxe Portable Power 2-Pack	YYZ4	A	389	575	292	31 d	6.2 wk	252	$17,184	23%	At reorder point
B000367	Bellwood Stackable Frozen Meal 2-Pack	YYZ4	C	30	96	43	9 d	0.7 wk	108	$453	75%	Below safety stock
B000313	Tidewater Essential Bedding Single	YVR2	A	378	550	238	42 d	7.3 wk	224	$4,346	29%	At reorder point
B000131	Meridian Bay Heritage Camping 2-Pack	YVR2	B	54	84	35	63 d	9.8 wk	40	$2,887	42%	At reorder point
B000332	Calder and Vine Studio Cleaning Supplie Single	YYZ4	B	170	224	89	42 d	7.6 wk	80	$2,972	26%	At reorder point
B000132	Ironpine Studio Tablet Single	YVR2	B	63	116	41	52 d	6.3 wk	66	$2,402	68%	At reorder point
B000359	Coppermill Slimline Streaming Device Single	YYC1	B	21	54	19	31 d	2.7 wk	48	$3,339	88%	At reorder point
B000415	Meridian Bay Stackable Personal Device Single	YYZ4	C	17	67	25	56 d	3.2 wk	60	$505	90%	Below safety stock
B000312	Fenwick Insulated Skincare 12-Pack	YEG3	B	9	61	35	11 d	0.6 wk	68	$782	79%	Below safety stock
B000397	Fenwick Value Bedding Single	YUL5	C	62	93	25	42 d	5.5 wk	48	$1,426	62%	At reorder point
B000185	Ashgrove Value Smart Home Bulk Case	YWG2	A	30	97	42	33 d	2.6 wk	96	$2,283	88%	Below safety stock
B000393	Bellwood Premium Figure Single	YVR2	B	41	78	58	16 d	4.5 wk	48	$1,735	28%	Below safety stock
B000225	Solstice Row Everyday Water Sport 12-Pack	YVR2	A	131	176	86	63 d	13.0 wk	60	$4,367	17%	At reorder point
B000414	Harbourline Premium Cookware Single	YYC1	A	96	161	68	31 d	4.6 wk	96	$3,126	46%	At reorder point
B000382	Tidewater Slimline Oral Care Single	YUL5	A	173	321	162	11 d	1.8 wk	247	$2,408	43%	At reorder point
B000305	Aurelia Slimline Figure 4-Pack	YEG3	B	156	231	71	52 d	7.3 wk	100	$1,363	53%	At reorder point
B000099	Northvale Insulated Cables & Adapter 12-Pack	YHZ1	A	184	257	133	31 d	6.7 wk	101	$12,152	18%	At reorder point
B000132	Ironpine Studio Tablet Single	YUL5	B	96	153	54	52 d	7.2 wk	72	$2,621	54%	At reorder point
B000280	Calder and Vine Premium Accessorie 4-Pack	YWG2	A	48	103	47	63 d	7.7 wk	72	$1,319	63%	At reorder point
B000211	Tidewater Traveller Streaming Device 4-Pack	YYC1	B	79	123	50	68 d	10.4 wk	52	$2,225	42%	At reorder point
B000213	Rivermont Compact Camping Single	YVR2	A	29	73	59	8 d	2.4 wk	56	$2,577	30%	Below safety stock
B000109	Tidewater Cordless Dog Food Single	YYZ4	B	0	49	26	7 d	0.0 wk	72	$1,958	92%	Stocked out
B000184	Kestrel Compact Basic 2-Pack	YVR2	A	635	767	304	47 d	9.3 wk	204	$3,715	12%	At reorder point
B000236	Larkspur Deluxe Outerwear Single	YWG2	C	97	162	55	63 d	8.1 wk	78	$478	60%	At reorder point
B000149	Ashgrove Insulated Oral Care 2-Pack	YVR2	C	49	82	30	56 d	7.6 wk	40	$921	55%	At reorder point
B000022	Meridian Bay Value Figure 4-Pack	YYC1	B	228	303	100	63 d	10.0 wk	144	$3,334	34%	At reorder point
B000147	Ironpine Traveller Dog Food Single	YEG3	B	4	21	11	7 d	0.4 wk	27	$929	83%	Below safety stock
B000125	Harbourline Stackable Writing 2-Pack	YYZ4	C	157	223	60	34 d	4.7 wk	100	$887	55%	At reorder point

Showing the 250 largest of 595 lines by contribution at risk. The CSV and Excel exports carry all of them.

Where the network stands

What service costs

Safety stock for the whole network at each cycle service level. The last three points of service cost more than the first eighty-five, because z climbs steeply as the target approaches one.

Economic order quantity against what is being ordered

Ordering cost per SKU is the marginal cost of a line plus its share of raising the purchase order — not the whole per-order cost, which would inflate every quantity by the square root of the lines on the order.

Biggest ordering-cost gaps

SKU	Item	EOQ	Ordering	Gap	Saving / yr	Read as
B000056	Ashgrove Insulated Headphone 12-Pack	336	4,623	+1,276%	$108,928	Over-ordering: order less at a time, more often
B000129	Aurelia Pro Outerwear Single	1,524	14,336	+841%	$68,879	Over-ordering: order less at a time, more often
B000190	Larkspur Insulated Water Sport 2-Pack	984	8,250	+738%	$19,085	Over-ordering: order less at a time, more often
B000017	Rivermont Heritage Basic Single	1,056	5,616	+432%	$16,699	Over-ordering: order less at a time, more often
B000169	Meridian Bay Value Oral Care 4-Pack	12	4,397	+36,540%	$16,459	No forward demand - stop ordering
B000090	Fenwick Pro Team Sport 4-Pack	594	5,435	+815%	$15,701	Over-ordering: order less at a time, more often
B000262	Larkspur Traveller Portable Power 2-Pack	605	2,481	+310%	$13,509	Over-ordering: order less at a time, more often
B000082	Tidewater Stackable Activewear 4-Pack	612	3,595	+487%	$12,979	Over-ordering: order less at a time, more often
B000229	Fenwick Compact Portable Power 2-Pack	4	1,530	+38,150%	$12,795	No forward demand - stop ordering
B000160	Calder and Vine Cordless Headphone 4-Pack	213	1,069	+402%	$12,535	Over-ordering: order less at a time, more often
B000341	Ashgrove Pro Camping Single	2	1,482	+74,017%	$10,150	No forward demand - stop ordering
B000373	Tidewater Studio Water Sport Single	132	789	+498%	$9,676	Over-ordering: order less at a time, more often
B000084	Coppermill Essential Tableware 6-Pack	1,200	134	-89%	$9,389	Under-ordering: order more at a time, less often
B000010	Aurelia Premium Tablet 4-Pack	1,308	5,255	+302%	$8,047	Over-ordering: order less at a time, more often
B000376	Ironpine Heavy Duty Tablet 2-Pack	288	1,161	+303%	$7,770	Over-ordering: order less at a time, more often
B000259	Aurelia Essential Camping 12-Pack	706	99	-86%	$7,685	Under-ordering: order more at a time, less often
B000108	Rivermont Essential Tableware 6-Pack	811	3,552	+338%	$6,991	Over-ordering: order less at a time, more often
B000128	Ironpine Premium Personal Device 12-Pack	24	4,264	+17,667%	$6,304	No forward demand - stop ordering
B000353	Tidewater Heritage Paper 2-Pack	311	23	-93%	$5,795	Under-ordering: order more at a time, less often
B000171	Ironpine Insulated Headphone Single	216	848	+293%	$5,706	Over-ordering: order less at a time, more often
B000378	Ironpine Everyday Outerwear 4-Pack	3,018	10,154	+236%	$5,573	Over-ordering: order less at a time, more often
B000391	Rivermont Traveller Basic 12-Pack	12	1,622	+13,413%	$5,510	No forward demand - stop ordering
B000414	Harbourline Premium Cookware Single	456	2,086	+357%	$5,102	Over-ordering: order less at a time, more often
B000306	Fenwick Stackable Team Sport 2-Pack	192	840	+338%	$5,032	No forward demand - stop ordering
B000075	Coppermill Essential Cycling 12-Pack	285	1,244	+336%	$5,001	Over-ordering: order less at a time, more often

Saving is the annual ordering plus cycle-stock holding cost avoided by moving to the economic quantity. The total-cost curve is flat near its minimum, so a small gap is genuinely not worth acting on.

Planning parameters

These are policy, not physics. Changing one rebuilds the whole analysis from the same data — a service level moves z, which moves safety stock, the reorder point, every order quantity, the excess threshold and the action list underneath it.

Parameter edits need the full app. The values shown are the ones in use.