Question: inventory forecast analytic QUESTION 2 Please see the data pertaining to two warehouses (Warehouse 1 and Warehouse 2) provided in the Microsoft Excel file (see

inventory forecast analytic inventory forecast analytic QUESTION 2 Please see

QUESTION 2 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 safety stock requirement in Warehouse 2? Select the closest answer. 661 units 546 units 433 units 676 units 25 X & fx B 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 12

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

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...

are two parts to this assignment: Part 1: In the Microsoft Excel file on the "Ratio template for students" tab you will be calculating Liquidity, Solvency, and Profitability ratios for each company,...

help please Final Project Assignment SCM 301 Overview of the Case Analysis We have discussed many concepts in SCM 301 related to planning, sourcing, making and delivering products and services. The...

inventory forecast analytic. PLEASE help OFF Home Insert Draw Page Layout Formulas Data Review View B1 X fx Month A B D E G H 1 2 3 4 5 6 7 8 9 10 Month January February March April May June July 12...

inventory forecast analytic D B Notation D Op L O k H P C Value Measurement 8,860 units per year 2.040 units per year 0.1 years 0.04 years 24% per year per dollar of average Inventory 52.00 per unit...

inventory forecast analytic A1 fx Parameter B Notation D L OL k H P S D Value Measurement 8.860 units per year 2,040 units per year 0.1 years 0.04 years 24% per year per dollar of average inventory...

supply chain management- Mixed integer linear programming- SportStuff.com Case - This Case study assignment should be solved in Excel - there's two question at the end - the highlighted text in red...

Consider yourself a summer intern and your summer assignment is to put all you learned in SCM 301 to good use helping the Throx company evaluate their current supply chain practices. You are tasked...

Hello, Would you please review the attached assignment? I know I have errors in and this assignment carries into the rest of the course so I need to get it corrected to move forward. I have attached...

What marketing recommendations, including pricing recommendations, would you make to Southwest as it moves into the next decade? Its the same plane going to the same place at exactly the same time....

Describe the purpose of a flexible budget. Suppose a manager claims flexible budgets are useful because costs are difficult to predict and flexibility is needed to change budgeted costs as input...

1 . Discuss the nature of the deferred income tax accounts and possible classifications in a company s balance sheet.

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...