Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Contemporary Business

Authors: Louis E. Boone, David L. Kurtz, Susan Berston

18th Edition

1119498414, 9781119498414

More Books

Students also viewed these Accounting questions