Simulation for Logistics Inventory Management (1) objetiv: inventory management at a better cost level Data base Initial quantities demand from customes per week Average demand during the last weeks Storage cost per unit in euro Cost per order in euro 20 21 0.04 6.3 week 5 week 6 week 7 week 8 week 9 week 10 week 11 Quantities in inventory beginning of the week Inventory after loading Customer demand Quantities in inventory by the end of the week Order Quantity Orders Cost Storage Cost Total Cost per week Acumulated Cost week 1 week 2 week 3 week 4 25 4 3 25 24 23 21 21 21 4 3 2 20 20 20 20 6.3 0.16 0.12 0.08 0.16 6.42 6.38 0.16 6.58 12.96 20 6.3 16.2 19.8 Remarks: The Suppliers LEAD Time is one week A) Complete the table 11) maintain the data flow 2) assume the supplier lead time change for two weeks ifrom week 6 on B) Explain the inpact in KPI's C) Which of the KPI's are more afected Simulation for Logistics Inventory Management (1) objetiv: inventory management at a better cost level Data base Initial quantities demand from customes per week Average demand during the last weeks Storage cost per unit in euro Cost per order in euro 20 21 0.04 6.3 week 5 week 6 week 7 week 8 week 9 week 10 week 11 Quantities in inventory beginning of the week Inventory after loading Customer demand Quantities in inventory by the end of the week Order Quantity Orders Cost Storage Cost Total Cost per week Acumulated Cost week 1 week 2 week 3 week 4 25 4 3 25 24 23 21 21 21 4 3 2 20 20 20 20 6.3 0.16 0.12 0.08 0.16 6.42 6.38 0.16 6.58 12.96 20 6.3 16.2 19.8 Remarks: The Suppliers LEAD Time is one week A) Complete the table 11) maintain the data flow 2) assume the supplier lead time change for two weeks ifrom week 6 on B) Explain the inpact in KPI's C) Which of the KPI's are more afected