Projected Sell-In Order Simulation
Distributor Ordering Behavior Based on Fixed Target Inventory Policy ( 400 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	514	400	114	execution
7/10/2023	435	103	400	514	−35	435	400	35	execution
7/17/2023	435	0	400	435	−35	435	400	35	execution
7/24/2023	429	0	400	435	−29	429	400	29	planning
7/31/2023	423	0	400	429	−23	423	400	23	planning
8/7/2023	331	0	400	423	69	331	400	0	planning
8/14/2023	339	0	400	331	61	339	400	0	planning
8/21/2023	339	0	400	339	61	339	400	0	planning
8/28/2023	331	0	400	339	69	331	400	0	planning
9/4/2023	180	0	400	331	220	180	400	0	planning
9/11/2023	226	0	400	180	174	226	400	0	planning
9/18/2023	226	0	400	226	174	226	400	0	planning
9/25/2023	238	0	400	226	162	238	400	0	planning
10/2/2023	230	0	400	238	170	230	400	0	planning
10/9/2023	210	0	400	230	190	210	400	0	planning
10/16/2023	234	0	400	210	166	234	400	0	planning
10/23/2023	227	0	400	234	173	227	400	0	planning
10/30/2023	214	0	400	227	186	214	400	0	planning
11/6/2023	305	0	400	214	95	305	400	0	planning
11/13/2023	287	0	400	305	113	287	400	0	planning
11/20/2023	432	0	400	287	−32	432	400	32	planning
11/27/2023	1,080	0	400	432	−680	1,080	400	680	planning
12/4/2023	1,521	0	400	1,080	−1,121	1,521	400	1,121	planning
12/11/2023	1,821	0	400	1,521	−1,421	1,821	400	1,421	planning
12/18/2023	1,838	0	400	1,821	−1,438	1,838	400	1,438	planning
12/25/2023	1,658	0	400	1,838	−1,258	NA	400	1,258	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