8 weeks of Data for two warehouses in W. Pa and E. Pa. 99% service level assured. Lead time = 2 weeks. Product A E.Pa-20,14,32,45,18,22,25,29 W.Pa24,40,13,45,33,23,18,25 Product B E.Pa66,45,32,18,55,43,56,32 W.Pa-16,65,45,32,28,40,15,40 Ordering cost==$45/order; Holding=$0.50/unit/week Transportation cost=$2/product from the two warehouses and $3 from the centralized warehouse. In-bound transportation cost=$2/product. If centralized, in-bound = $1.50/product Delivery lead time = 2 weeks in both scenarios Do an analysis of the decision to have a centralized warehouse. Calculate the correlation of demand between the two warehouses also in your analysis . . . 8 weeks of Data for two warehouses in W. Pa and E. Pa. 99% service level assured. Lead time = 2 weeks. Product A E.Pa-20,14,32,45,18,22,25,29 W.Pa24,40,13,45,33,23,18,25 Product B E.Pa66,45,32,18,55,43,56,32 W.Pa-16,65,45,32,28,40,15,40 Ordering cost==$45/order; Holding=$0.50/unit/week Transportation cost=$2/product from the two warehouses and $3 from the centralized warehouse. In-bound transportation cost=$2/product. If centralized, in-bound = $1.50/product Delivery lead time = 2 weeks in both scenarios Do an analysis of the decision to have a centralized warehouse. Calculate the correlation of demand between the two warehouses also in your analysis