Projected Sell-In Order Simulation
Distributor Ordering Behavior Based on Fixed Target Inventory Policy ( 300 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	414	300	114	execution
7/10/2023	435	103	300	414	−135	435	300	135	execution
7/17/2023	435	0	300	435	−135	435	300	135	execution
7/24/2023	429	0	300	435	−129	429	300	129	planning
7/31/2023	423	0	300	429	−123	423	300	123	planning
8/7/2023	331	0	300	423	−31	331	300	31	planning
8/14/2023	339	0	300	331	−39	339	300	39	planning
8/21/2023	339	0	300	339	−39	339	300	39	planning
8/28/2023	331	0	300	339	−31	331	300	31	planning
9/4/2023	180	0	300	331	120	180	300	0	planning
9/11/2023	226	0	300	180	74	226	300	0	planning
9/18/2023	226	0	300	226	74	226	300	0	planning
9/25/2023	238	0	300	226	62	238	300	0	planning
10/2/2023	230	0	300	238	70	230	300	0	planning
10/9/2023	210	0	300	230	90	210	300	0	planning
10/16/2023	234	0	300	210	66	234	300	0	planning
10/23/2023	227	0	300	234	73	227	300	0	planning
10/30/2023	214	0	300	227	86	214	300	0	planning
11/6/2023	305	0	300	214	−5	305	300	5	planning
11/13/2023	287	0	300	305	13	287	300	0	planning
11/20/2023	432	0	300	287	−132	432	300	132	planning
11/27/2023	1,080	0	300	432	−780	1,080	300	780	planning
12/4/2023	1,521	0	300	1,080	−1,221	1,521	300	1,221	planning
12/11/2023	1,821	0	300	1,521	−1,521	1,821	300	1,521	planning
12/18/2023	1,838	0	300	1,821	−1,538	1,838	300	1,538	planning
12/25/2023	1,658	0	300	1,838	−1,358	NA	300	1,358	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