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

Zarghams HW9 graded.xlsx - For a particular SKU the lead...

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
Image of page 1
Image of page 2
Image of page 3
Image of page 4

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

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors