Managing Uncertainty in Supply Chain
1. Using the Wal-Mart Demo for Example 4, what happens to the Required Safety Stock inventory when the Desired Customer Service level is increased to 95%? What happens to the Required Safety Stock inventory when the Desired Customer Service level is decreased to 80%? What about 70%? What did you learn from this exercise?
Note: This is not a “Solver” problem. Just change the service level directly in Excel from .90 to .80 and .70 to see the impact on safety inventory.
2. Using the Wal-Mart Demo, what happens to the Required Safety Stock inventory when the periodic review interval is changed to quarterly, i.e., 12 weeks versus 4 weeks? What happens when it is changed to weekly, i.e., 1 week versus 4 weeks? What did you learn from this exercise?
Note: This is not a “Solver” problem. Just change the Review Interval directly in Excel from 4 weeks to 12 weeks to 1 week, respectively.
Managing Uncertainty in a Supply Chain: Safety Inventory
Author Name
Institution Affiliation
From the Wal-Mart Demo for Example 4, I have learned that the safety stock inventory and the desired cycle service level are linked to one another (Arshinder et al. 2011). It may not be possible for us to increase the cycle service level of a product without increasing the safety stock. In other words, we can say that if the safety stock decreases, then the cycle service level will also decrease.
Desired cycle service level =
0.7
Answer
Intermediate calculation
Mean demand during lead time RL =
5000
SD of demand during lead time sL =
707
Results
Required safety inventory =
371
Desired cycle service level =
0.95
Answer
Intermediate calculation
Mean demand during lead time RL =
5000
SD of demand during lead time sL =
707
Results
Required safety inventory =
1163
It is now clear that the review interval and the safety stock requirement are directly linked to one another (Szymczak, 2013). When the review interval period increases, we will require a high level of safety stock. Similarly, when the review interval period decreases, we will need a low level of safety stock. The product level is not frequently reviewed, so we will have to increase the holding stock in order to fulfi...
👀 Other Visitors are Viewing These APA Essay Samples:
-
Assignment Part A: Learning and Development Report
5 pages/≈2750 words | 15 Sources | APA | Management | Coursework |
-
Leadership Development Program for a Multinational Company
5 pages/≈2750 words | 15 Sources | APA | Management | Coursework |
-
Determining the Optimum Level of Product Availability
1 page/≈275 words | 1 Source | APA | Management | Coursework |