Zarghams HW9 graded.xlsx - For a particular SKU the lead time is 6 weeks the average demand is 90 units a week and the safety stock is 200 units What i

• 4

This preview shows page 1 - 4 out of 4 pages.

For a particular SKU, the lead time is 6 weeks, the average demand is 90 units a week, and the safety stock is Weeks 10 Lead Time 6 Average 90 Safety 200 Ordered Un 900 Order Point 740 Inventory 650 Lead Time 540 points 4/4 The standard deviation of demand during the lead time is 100 units Calculate the safety stock required for the following service levels: 75%, 80%, 85%, 90%,95%, and 99.99% Service SF A SS 75% 0.67 100 67 80% 0.84 100 84 85% 1.04 100 104 90% 1.28 100 128 95% 1.65 100 165 99.99% 4 100 400 Calculate the change in safety stock required to increase the service levels from 75% to 80%, 80% to 85%, 85 SS Changes 84 17 104 20 where is the Excel graph 6.5/8 128 24 165 37 400 235 I think the when the stock levels increase then the number of units increses also A company stocks an SKU with weekly demand for 600 units and a lead time of 4 weeks. Management will to Weekly De 600

#### You've reached the end of your free preview.

Want to read all 4 pages?

Unformatted text preview: Service Lev 91.66 Weeks 52 Service Fac 1.42 Lead Time 100 Quantity 2500 ddlt 2400 Weeks in a 4 Orders in a 12.48 Safety Stoc 142 pts 6/6 Order Poin 2542 Average In 1392 The safety stock on an SKU is set at 500 units. The supplier says it has to increase the lead time from 4 weeks New Lead 5 Old Lead 4 SF 500 Safety Stoc 559.017 pts 2/2 Total points 18.5/20 s 200 units. What is the average inventory if 10 weeks' supply is ordered at one time? What is the order point 5 to 90%, 90 to 95%, 95 to 99.99%. What conclusion do you reach olerate one stockout per year. If sigma for the lead time is 100 and the order quantity is 2500 units, what is th s to 5 weeks. What should be the new safety stock t? he safety stock, the average inventory, and the order point?...
View Full Document

• Spring '14

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern