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	1,187	1,073	114	execution
7/10/2023	435	103	1,073	1,187	637	661	1,299	0	execution
7/17/2023	435	0	1,299	661	864	422	1,286	0	execution
7/24/2023	429	0	1,286	422	858	325	1,183	0	planning
7/31/2023	423	0	1,183	325	760	333	1,093	0	planning
8/7/2023	331	0	1,093	333	762	248	1,010	0	planning
8/14/2023	339	0	1,010	248	671	339	1,010	0	planning
8/21/2023	339	0	1,010	339	670	180	851	0	planning
8/28/2023	331	0	851	180	520	218	737	0	planning
9/4/2023	180	0	737	218	557	75	633	0	planning
9/11/2023	226	0	633	75	406	284	690	0	planning
9/18/2023	226	0	690	284	464	230	695	0	planning
9/25/2023	238	0	695	230	456	222	678	0	planning
10/2/2023	230	0	678	222	448	226	674	0	planning
10/9/2023	210	0	674	226	464	206	670	0	planning
10/16/2023	234	0	670	206	437	238	675	0	planning
10/23/2023	227	0	675	238	448	298	745	0	planning
10/30/2023	214	0	745	298	532	274	805	0	planning
11/6/2023	305	0	805	274	501	522	1,023	0	planning
11/13/2023	287	0	1,023	522	736	1,062	1,798	0	planning
11/20/2023	432	0	1,798	1,062	1,366	1,666	3,033	0	planning
11/27/2023	1,080	0	3,033	1,666	1,953	2,469	4,422	0	planning
12/4/2023	1,521	0	4,422	2,469	2,901	2,279	5,180	0	planning
12/11/2023	1,821	0	5,180	2,279	3,359	1,958	5,317	0	planning
12/18/2023	1,838	0	5,317	1,958	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