Question: need help show work in excel please Given this information: Lead-time demand =645 pounds Standard deviation of lead time demand =54 pounds (Assume normality.) Acceptable

need help show work in excel please

Given this information: Lead-time demand =645 pounds Standard deviation of lead time demand =54 pounds (Assume normality.) Acceptable stockout risk during lead time =1 percent Use Table. a. What amount of safety stock is appropriate? (Round your answer to the nearest whole number.) b. How much of this Item should be reordered? (Round your answer to the nearest whole number.) c. What risk of stockout would result from a decision not to have any safety stock

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!

Help Check my w Problem 13-20 Given this information: Lead-time demand- 640 pounds Standard deviation of lead time demand 53 pounds (Assume normality) Acceptable stockout risk during lead time 2...

Given this information: Lead-time demand =555 pounds Standard deviation of lead time demand =36 pounds (Assume normality.) Acceptable stockout risk during lead time =2 percent Use Table. a. What...

Given this information: Lead-time demand = 605 pounds Standard deviation of lead time demand = 46 pounds (Assume normality.) Acceptable stockout risk during lead time = 2 percent Use Table a. What...

please label answers. thanks Given this information: Lead-time demand = 600 pounds Standard deviation of lead time demand = 45 pounds (Assume normality.) Acceptable stockout risk during lead time = 1...

Help Save & EX Check Given this information: Lead-time demand = 650 pounds Standard deviation of lead time demand = 55 pounds (Assume normality) Acceptable stockout risk during lead time = 3 percent...

Problem 13-20 Given this information: Lead-time demand = 575 pounds Standard deviation of lead time demand = 40 pounds (Assume normality.) Acceptable stockout risk during lead time = 5 percent Use...

Chapter 12 Problem 2 1 Problem 12-20 (Algo) 50 points Given this information: Lead-time demand = 610 pounds Standard deviation of lead time demand 50 pounds (Assume normality.) Acceptable stockout...

Given this information: Lead-time demand = 610 pounds Standard deviation of lead time demand = 70 pounds (Assume normality.) Acceptable stockout risk during lead time = 4 percent Use Table. a. What...

Given this information: Lead-time demand = 580 pounds Standard deviation of lead time demand = 41 pounds (Assume normality.) Acceptable stockout risk during lead time = 4 percent Use Table. a. What...

Given this information: Lead-time demand = 565 pounds Standard deviation of lead time demand = 38 pounds (Assume normality.) Acceptable stockout risk during lead time = 4 percent Use Table. a. What...

(a) Write out the second order equation in terms of the coefficients a, b, c, d of the first order system. (b) Show that there is a one-to-one correspondence between solutions of the system and...

T. J. Management operates Gabby's Saloon and Eatery in Minneapolis, Minnesota. In 1986, the Minneapolis City Council issued Gabby's a class B on-sale liquor license and annually renewed the license...

One of the conditions required for self-liquidating loan is that the maturity of the note and the schedule of repayments must be such that the payments cannot met from cash generated by the...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...