Projected Sell-In Order Simulation
Distributor Ordering Behavior Based on Fixed Target Inventory Policy ( 100 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	214	100	114	execution
7/10/2023	435	103	100	214	−335	435	100	335	execution
7/17/2023	435	0	100	435	−335	435	100	335	execution
7/24/2023	429	0	100	435	−329	429	100	329	planning
7/31/2023	423	0	100	429	−323	423	100	323	planning
8/7/2023	331	0	100	423	−231	331	100	231	planning
8/14/2023	339	0	100	331	−239	339	100	239	planning
8/21/2023	339	0	100	339	−239	339	100	239	planning
8/28/2023	331	0	100	339	−231	331	100	231	planning
9/4/2023	180	0	100	331	−80	180	100	80	planning
9/11/2023	226	0	100	180	−126	226	100	126	planning
9/18/2023	226	0	100	226	−126	226	100	126	planning
9/25/2023	238	0	100	226	−138	238	100	138	planning
10/2/2023	230	0	100	238	−130	230	100	130	planning
10/9/2023	210	0	100	230	−110	210	100	110	planning
10/16/2023	234	0	100	210	−134	234	100	134	planning
10/23/2023	227	0	100	234	−127	227	100	127	planning
10/30/2023	214	0	100	227	−114	214	100	114	planning
11/6/2023	305	0	100	214	−205	305	100	205	planning
11/13/2023	287	0	100	305	−187	287	100	187	planning
11/20/2023	432	0	100	287	−332	432	100	332	planning
11/27/2023	1,080	0	100	432	−980	1,080	100	980	planning
12/4/2023	1,521	0	100	1,080	−1,421	1,521	100	1,421	planning
12/11/2023	1,821	0	100	1,521	−1,721	1,821	100	1,721	planning
12/18/2023	1,838	0	100	1,821	−1,738	1,838	100	1,738	planning
12/25/2023	1,658	0	100	1,838	−1,558	NA	100	1,558	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