Projected Sell-In Order Simulation
Distributor Ordering Behavior Based on Fixed Target Inventory Policy ( 600 cases)
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	714	600	114	execution
7/10/2023	435	103	600	714	165	435	600	0	execution
7/17/2023	435	0	600	435	165	435	600	0	execution
7/24/2023	429	0	600	435	171	429	600	0	planning
7/31/2023	423	0	600	429	177	423	600	0	planning
8/7/2023	331	0	600	423	269	331	600	0	planning
8/14/2023	339	0	600	331	261	339	600	0	planning
8/21/2023	339	0	600	339	261	339	600	0	planning
8/28/2023	331	0	600	339	269	331	600	0	planning
9/4/2023	180	0	600	331	420	180	600	0	planning
9/11/2023	226	0	600	180	374	226	600	0	planning
9/18/2023	226	0	600	226	374	226	600	0	planning
9/25/2023	238	0	600	226	362	238	600	0	planning
10/2/2023	230	0	600	238	370	230	600	0	planning
10/9/2023	210	0	600	230	390	210	600	0	planning
10/16/2023	234	0	600	210	366	234	600	0	planning
10/23/2023	227	0	600	234	373	227	600	0	planning
10/30/2023	214	0	600	227	386	214	600	0	planning
11/6/2023	305	0	600	214	295	305	600	0	planning
11/13/2023	287	0	600	305	313	287	600	0	planning
11/20/2023	432	0	600	287	168	432	600	0	planning
11/27/2023	1,080	0	600	432	−480	1,080	600	480	planning
12/4/2023	1,521	0	600	1,080	−921	1,521	600	921	planning
12/11/2023	1,821	0	600	1,521	−1,221	1,821	600	1,221	planning
12/18/2023	1,838	0	600	1,821	−1,238	1,838	600	1,238	planning
12/25/2023	1,658	0	600	1,838	−1,058	NA	600	1,058	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