A) What is the safety stock quantity that will be held using a periodic system of inventory management? B) What is the target inventory level (T), assuming a periodic review inventory management system is used? C) What is the average inventory level?
KungFu Panda is a popular Chinese takeout in a large metropolitan city. The restaurant is famous for its noodle soup, for which special noodles are sourced from a small local authentic Chinese noodle production plant. The inventory of raw materials in the restaurant is managed by the chef’s daughter, Ms. Huan, who balances college studies with running the stock room. She only has time once a week to check inventory levels and place orders for items running low. Unfortunately, Chegg.com is not very helpful in running a real operation.
To keep her chef parents happy, she wants to ensure a 98% cycle service level. Data on daily usage (demand) of noodle boxes for the past 30 days, and lead time of the last 20 orders placed with the supplier is available in the Excel file. You may assume that this data is representative and can be used to estimate demand and lead time.
The cost of a box of noodles for KungFu Panda restaurant is 2$. The holding cost is 25% of an items value. See below for remaining data attached
A) What is the safety stock quantity that will be held using a periodic system of inventory management?
B) What is the target inventory level (T), assuming a periodic review inventory management system is used?
C) What is the average inventory level?
![Demand (usage of
noodle boxes per
Lead time (#
Day
day)
Order #
days)
1
276
1
3.6
2
527
2
3.9
606
3
3.2
4
527
4
3.9
543
4.8
590
6
2.7
7
758
7
2.9
8
573
2.7
9
618
2.8
10
419
10
0.3
11
745
11
3.5
12
705
12
3.1
13
582
13
2.3
14
477
14
1.9
15
621
15
3.8
16
335
16
2.3
17
541
17
2.4
18
531
18
3.3
19
657
19
2.1
20
446
20
4.5
21
435
22
348
23
769
24
592
25
728
26
531
27
630
28
738
29
565
30
370](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F2db05b6a-0675-4fca-8f3e-99355c426502%2F87eda23e-2379-4ac6-b8ca-39569dc1155e%2F1hgp928_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)