Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). $ 35 Ordering cost Service probability 2,970 mufflers per order Annual demand 89 % mufflers per working day per muffler * of item value working days Standard deviation of daily demand $21.00 Lead time 4. working days Item cost 36 Working days 270 per year Annual holding cost' Review period 22 a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV) function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
icon
Concept explainers
Topic Video
Question
Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to
manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or
order-up-to level).
$ 35
Ordering cost
Service probability
Lead time
per order
2,970
6.
mufflers
Annual demand
Standard deviation of daily demand
mufflers per working day
89 %
working days
per muffler
* of item value
working days
$21.00
4
Item cost
36
Working days
270
per year
Annual holding cost
Review period
22
a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV) function to find the correct critical value for the
given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole
number.)
Optimal target level
b. If the service probability requirement is 90 percent, the optimal target level will:
O Increase
O Decrease
O Stay the same
< Prev
13 of 14
Next >
0,325
13
区目GA p
Transcribed Image Text:Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (or order-up-to level). $ 35 Ordering cost Service probability Lead time per order 2,970 6. mufflers Annual demand Standard deviation of daily demand mufflers per working day 89 % working days per muffler * of item value working days $21.00 4 Item cost 36 Working days 270 per year Annual holding cost Review period 22 a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV) function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level b. If the service probability requirement is 90 percent, the optimal target level will: O Increase O Decrease O Stay the same < Prev 13 of 14 Next > 0,325 13 区目GA p
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.