Question: weekly Demand for dishwasher soaps at a Harris Teeter store is normally distributed, with a mean of 3,000 and a standard deviation of 700. The


weekly Demand for dishwasher soaps at a Harris Teeter store is normally distributed, with a mean of 3,000 and a standard deviation of 700. The store manager continuously monitors dishwasher soaps inventory and places a replenishment order for 10,000 units when there are 7,000 units in inventory. The supplier takes two weeks to supply an order. What CSL does the store achieve? Data is provided on the excel sheet. Show your work on the excel file. 63% O 74% 84% 95% = Inputs Average demand per unit time, D = Lead time, L = SD of demand per unit time, od Order quantity, Q= Reorder Point, ROP 3,000 2 700 10,000 7,000 Distribution of Demand during Replenishment Lead Time Mean demand during lead time DL = SD of demand during lead time ou = = Outputs Safety Inventory, ss = Cycle Service Level, CSL = weekly Demand for dishwasher soaps at a Harris Teeter store is normally distributed, with a mean of 3,000 and a standard deviation of 700. The store manager continuously monitors dishwasher soaps inventory and places a replenishment order for 10,000 units when there are 7,000 units in inventory. The supplier takes two weeks to supply an order. What CSL does the store achieve? Data is provided on the excel sheet. Show your work on the excel file. 63% O 74% 84% 95% = Inputs Average demand per unit time, D = Lead time, L = SD of demand per unit time, od Order quantity, Q= Reorder Point, ROP 3,000 2 700 10,000 7,000 Distribution of Demand during Replenishment Lead Time Mean demand during lead time DL = SD of demand during lead time ou = = Outputs Safety Inventory, ss = Cycle Service Level, CSL =
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
