Projected Sell-In Order Simulation
Distributor Ordering Behavior Based on 4 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	1,615	1,501	114	execution
7/10/2023	435	103	1,501	1,615	1,066	656	1,722	0	execution
7/17/2023	435	0	1,722	656	1,286	331	1,618	0	execution
7/24/2023	429	0	1,618	331	1,189	333	1,522	0	planning
7/31/2023	423	0	1,522	333	1,099	333	1,433	0	planning
8/7/2023	331	0	1,433	333	1,101	240	1,341	0	planning
8/14/2023	339	0	1,341	240	1,002	188	1,190	0	planning
8/21/2023	339	0	1,190	188	851	226	1,077	0	planning
8/28/2023	331	0	1,077	226	746	218	964	0	planning
9/4/2023	180	0	964	218	783	88	871	0	planning
9/11/2023	226	0	871	88	645	276	921	0	planning
9/18/2023	226	0	921	276	695	210	904	0	planning
9/25/2023	238	0	904	210	666	246	912	0	planning
10/2/2023	230	0	912	246	681	219	901	0	planning
10/9/2023	210	0	901	219	691	193	884	0	planning
10/16/2023	234	0	884	193	650	329	979	0	planning
10/23/2023	227	0	979	329	752	280	1,032	0	planning
10/30/2023	214	0	1,032	280	818	419	1,237	0	planning
11/6/2023	305	0	1,237	419	932	1,170	2,103	0	planning
11/13/2023	287	0	2,103	1,170	1,816	1,503	3,319	0	planning
11/20/2023	432	0	3,319	1,503	2,888	1,966	4,854	0	planning
11/27/2023	1,080	0	4,854	1,966	3,774	2,485	6,259	0	planning
12/4/2023	1,521	0	6,259	2,485	4,738	2,100	6,838	0	planning
12/11/2023	1,821	0	6,838	2,100	5,017	300	5,317	0	planning
12/18/2023	1,838	0	5,317	300	3,479	17	3,496	0	planning
12/25/2023	1,658	0	3,496	17	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