inventory forecast analytic

QUESTION 3 Please see the data pertaining to two warehouses (Warehouse 1 and Warehouse 2) provided in the Microsoft Excel file (see link below). Please use this data to determine safety stock levels before and after centralization (and complete some additional calculations). Then use this information to answer the following question. This is a risk pooling/DC centralization type problem. Note: This data will be used to answer questions 2 and 3. WarehouseData.xlsx Question: What is the Pooled safety stock (after centralization)? Select the closest answer. 743 units 731 units O 1.222 units 444 units B D Warehouse 1 Warehouse 2 332 411 -0.3 95% 1 2 Std. deviation of lead time demand 3 Correlation of lead time demands 4 In-stock rate (alpha) 5 Std. normal variate (2) 6 Safety stock 7 Combined safety stock (WH1, WH2) 8 Pooled std. deviation of lead time demand 9 Pooled safety stock (after centralization) 10 Portfolio effect 11 QUESTION 3 Please see the data pertaining to two warehouses (Warehouse 1 and Warehouse 2) provided in the Microsoft Excel file (see link below). Please use this data to determine safety stock levels before and after centralization (and complete some additional calculations). Then use this information to answer the following question. This is a risk pooling/DC centralization type problem. Note: This data will be used to answer questions 2 and 3. WarehouseData.xlsx Question: What is the Pooled safety stock (after centralization)? Select the closest answer. 743 units 731 units O 1.222 units 444 units B D Warehouse 1 Warehouse 2 332 411 -0.3 95% 1 2 Std. deviation of lead time demand 3 Correlation of lead time demands 4 In-stock rate (alpha) 5 Std. normal variate (2) 6 Safety stock 7 Combined safety stock (WH1, WH2) 8 Pooled std. deviation of lead time demand 9 Pooled safety stock (after centralization) 10 Portfolio effect 11