Question: Please help solve 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

Please help solve a. What is the optimal target

Please help solve 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 -level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)

and

b. If the service probability requirement is 95 percent, the optimal target level will:

Thank you!

Problem 20-36 (Algo) 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). Annual demand Standard deviation of daily demand Item cost Annual holding cost Review period 2,400 mufflers 6 mufflers per working day $21.00 per muffler 36 % of item value 15 working days Ordering cost Service probability Lead time Working days $ 90 per order 81 % 3 working days 200 per year a. What is the optimal target level (order-up-to level? (Use Excel's NORMSINVO) 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 95 percent, the optimal target level will: Increase Decrease Stay the same

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!