Question
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
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. 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.
A) What is the average inventory level? Enter your answer rounded to 2 decimal places.
B) What is the annual inventory holding cost? Enter your answer rounded to 2 decimal places.
Demand Data | |
Day | Demand (usage of noodle boxes per day) |
1 | 276 |
2 | 527 |
3 | 606 |
4 | 527 |
5 | 543 |
6 | 590 |
7 | 758 |
8 | 573 |
9 | 618 |
10 | 419 |
11 | 745 |
12 | 705 |
13 | 582 |
14 | 477 |
15 | 621 |
16 | 335 |
17 | 541 |
18 | 531 |
19 | 657 |
20 | 446 |
21 | 435 |
22 | 348 |
23 | 769 |
24 | 592 |
25 | 728 |
26 | 531 |
27 | 630 |
28 | 738 |
29 | 565 |
30 | 370 |
Lead Time Data | |
Order # | Lead time (# days) |
1 | 3.6 |
2 | 3.9 |
3 | 3.2 |
4 | 3.9 |
5 | 4.8 |
6 | 2.7 |
7 | 2.9 |
8 | 2.7 |
9 | 2.8 |
10 | 0.3 |
11 | 3.5 |
12 | 3.1 |
13 | 2.3 |
14 | 1.9 |
15 | 3.8 |
16 | 2.3 |
17 | 2.4 |
18 | 3.3 |
19 | 2.1 |
20 | 4.5 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started