Question: Please show work and complete in excel or a chart if possible. Given this information: Average weekly demand =100 units. Standard deviation =10 units. Lead

Please show work and complete in excel or a chart if possible.

Given this information: Average weekly demand =100 units. Standard deviation =10 units. Lead time =6 weeks . Acceptable stockout risk =2.5% Ordering cost =$30 Annual Holding cost =20% Unit cost (purchase price) =$20 The company operates =50 weeks a year. Weekly usage rates are distributed normally. Determine each of the following, assuming that lead time demand is distributed normally: a. Order quantity (EOQ). Note that h= annual holding cost % * unit cost. b. The safety stock needed to attain a 2.5 percent risk of stockout during lead time. c. The reorder point (ROP) that will provide a risk of stockout of 2.5 percent during lead time

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!

Given this information: Average weekly demand =100 units. Standard deviation =10 units. Lead time =4 weeks. Acceptable stockout risk =2.5% Ordering cost =$30 Annual Holding cost =20% Unit cost...

please solve using excel please solve with excel Supply Planning Item 1234 has the following characteristics: Average Weekly demand of 160 units Standard Deviation of Weekly demand of 100 units...

please solve using excel Supply Planning Item 1234 has the following characteristics: Average Weekly demand of 160 units Standard Deviation of Weekly demand of 100 units Replenishment lead time of 6...

Medium-Scale Expansion Profits Low Demand Medium High Annual Profit ($1000s) 50 150 200 Large-Scale Expansion Profits Annual Profit P(x) ($1000s) 20% 0 50% 100 30% 300 P(x) 20% 50% 30% Expected...

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

Here is all the information provided with the answers to Q 1 and 2. If someone could please help me with 3 and 4. There is no more information or references provided other than what is above. 3) This...

Your group has been hired by Sudhir Murarka to assess and improve the quality of Gati's newly introduced Premium Express Delivery process. Sudhir is concerned with the number of customer complaints...

2. (Irrespective of your answer question 1) Suppose the total value of 2010 inventory is $10 million and the increase in value of inventory required by Scientific Glass is $1.5 million. iii. Estimate...

I need to make sure the answers below are correct, and please explain process. If possible, show me the excel formulas. Thanks! Regional distributors are currently using continuous review inventory...

Table 2.15 reproduces the 100 waiting times for teller service that were originally given in Table 1.8 (page 13). a Construct a stem- and- leaf display of the waiting times. b Describe the...

Repeat Example 1.7 but find the current i for B c = 1.6 T. By what factor does the current have to be increased to result in this factor of 1.6 increase in flux density? EXAMPLE 1.7 Assume that the...

Which of the following would be an example of liquidity risk? A bank is forced to sell $ 8 , 0 0 0 , 0 0 0 of mortgage backed securities at a loss in order to meet the needs of depositors. A bank...

What is an example of constructive feedback? provide reference