Reference no: EM132633788
Calculate Order Receiving Cost, Inventory Holding Cost, Total Cost, Service Level (K) when Service Level (Percentage) is say 95%, 99%, 97.5%, Average Demand, Average Lead Time, Standard Deviation of Demand, Standard Deviation of Lead Time and Combined Standard Deviation of Lead Time. Kindly rounded to the nearest integer and please share the answers with calculations from the above google drive link location.
Question 1: For Product D, what is the combined standard deviation of lead time and demand? (rounded to the nearest integer, e.g. xx.xx-->xx)
Question 2: For Product E, what is the safety stock you would hold if you wanted to reach a 90% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
Question 3: For Product B, what is the safety stock you would hold if you wanted to reach a 97.5% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
Question 4: For Product D, what is the safety stock you would hold if you wanted to reach a 95% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
Question 5: For Product E, what is the safety stock you would hold if you wanted to reach a 90% fill rate? (rounded to the nearest integer, e.g. xx.xx-->xx)
Attachment:- Receiving cost.zip