Projected Sell-In Order Simulation
Distributor Ordering Behavior Based on 3 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	316	202	114	execution
7/10/2023	435	103	202	316	−233	668	435	233	execution
7/17/2023	435	0	435	668	0	435	435	0	execution
7/24/2023	429	0	435	435	7	422	429	0	planning
7/31/2023	423	0	429	422	6	417	423	0	planning
8/7/2023	331	0	423	417	91	240	331	0	planning
8/14/2023	339	0	331	240	−8	347	339	8	planning
8/21/2023	339	0	339	347	0	339	339	0	planning
8/28/2023	331	0	339	339	8	323	331	0	planning
9/4/2023	180	0	331	323	151	30	180	0	planning
9/11/2023	226	0	180	30	−46	272	226	46	planning
9/18/2023	226	0	226	272	0	226	226	0	planning
9/25/2023	238	0	226	226	−12	250	238	12	planning
10/2/2023	230	0	238	250	8	223	230	0	planning
10/9/2023	210	0	230	223	21	189	210	0	planning
10/16/2023	234	0	210	189	−24	258	234	24	planning
10/23/2023	227	0	234	258	7	220	227	0	planning
10/30/2023	214	0	227	220	13	201	214	0	planning
11/6/2023	305	0	214	201	−91	395	305	91	planning
11/13/2023	287	0	305	395	18	269	287	0	planning
11/20/2023	432	0	287	269	−145	577	432	145	planning
11/27/2023	1,080	0	432	577	−648	1,727	1,080	648	planning
12/4/2023	1,521	0	1,080	1,727	−442	1,963	1,521	442	planning
12/11/2023	1,821	0	1,521	1,963	−300	2,121	1,821	300	planning
12/18/2023	1,838	0	1,821	2,121	−17	1,854	1,838	17	planning
12/25/2023	1,658	0	1,838	1,854	179	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