Projected Sell-In Order Simulation
Distributor Ordering Behavior Based on 2 Weeks Coverage Target Inventory Policy
Week	Sell-Out Forecast	Retailer Orders	Opening Inventory	In-Transit Inventory	Ending Inventory	Sellin Order Quantity	Target Inventory1	Late Sales2	Planning Horizon3
7/3/2023	202	342	228	0	−114	752	638	114	execution
7/10/2023	435	103	638	752	202	668	870	0	execution
7/17/2023	435	0	870	668	435	428	864	0	execution
7/24/2023	429	0	864	428	435	416	851	0	planning
7/31/2023	423	0	851	416	429	326	754	0	planning
8/7/2023	331	0	754	326	423	248	671	0	planning
8/14/2023	339	0	671	248	331	347	679	0	planning
8/21/2023	339	0	679	347	339	331	670	0	planning
8/28/2023	331	0	670	331	339	172	511	0	planning
9/4/2023	180	0	511	172	331	75	406	0	planning
9/11/2023	226	0	406	75	180	272	452	0	planning
9/18/2023	226	0	452	272	226	238	464	0	planning
9/25/2023	238	0	464	238	226	242	469	0	planning
10/2/2023	230	0	469	242	238	202	440	0	planning
10/9/2023	210	0	440	202	230	213	443	0	planning
10/16/2023	234	0	443	213	210	251	461	0	planning
10/23/2023	227	0	461	251	234	207	441	0	planning
10/30/2023	214	0	441	207	227	291	518	0	planning
11/6/2023	305	0	518	291	214	378	591	0	planning
11/13/2023	287	0	591	378	305	414	718	0	planning
11/20/2023	432	0	718	414	287	1,225	1,511	0	planning
11/27/2023	1,080	0	1,511	1,225	432	2,169	2,601	0	planning
12/4/2023	1,521	0	2,601	2,169	1,080	2,263	3,342	0	planning
12/11/2023	1,821	0	3,342	2,263	1,521	2,137	3,659	0	planning
12/18/2023	1,838	0	3,659	2,137	1,821	1,675	3,496	0	planning
12/25/2023	1,658	0	3,496	1,675	1,838	NA	1,658	0	planning
1 Green: <= 600 cases capacity, Red: > 600 cases
2 Late sales occur when demand exceeds available inventory
3 Execution: Current + Next weeks with retailer order visibility