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 2,500 mufflers Ordering cost Service probability Lead time Working days $ 95 per order Standard deviation of daily demand mufflers per working day per muffler TAX of item value working days 79 % Item cost Annual holding cost Review period $38.00 working days 33 250 per year 17 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

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 2,500 mufflers Ordering cost Service probability Lead time Working days $ 95 per order Standard deviation of daily demand mufflers per working day per muffler TAX of item value working days 79 % Item cost Annual holding cost Review period $38.00 working days 33 250 per year 17 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

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...

See similar textbooks

Similar questions

What are the four fundamental methods for determining the amount of work done?
Give an example of an activity in an industry that requires careful measurement of work.
Western General Hospital for Children is the third-largest hospital within the Western General System and is used as the initial location to receive cultural competence training. The training is to focus on improving the cultural awareness of staff and enhancing the hospital’s connection to local ethnic communities served by the hospital. Quickly, the lack of knowledge about the different cultures, language, socioeconomic, and ethnic barriers is identified as the main challenges for staff. What interventions could be suggested?
Can you illustrate the advantages of applying the Work Breakdown Structure (WBS) idea using any SDLC of your choice?
What kinds of information should be collectd during a work analysis?
Please explain how Internet technologies are being used in the development of a process in one of the company's business operations. Make use of an example and assess its monetary worth.
Can you show me the steps calculated manually instead of with excel?
Discuss the role of technology in modern continuity planning. How can organizations leverage technology for better preparedness?
Sometimes job design has to be modified to adapt to emergent technologies or product redesign. How can OD interventions assist in this scenario?
It is recommended that two different approaches be offered in order to save costs associated with rework. Consider the fact that both strategies will need to be put into action in stages?
What is meant by the need to make trade-offs between cost, performance , and schedule? Provide examples to support your response. *Please do not copy from other homework sites; I need a unique response.*
What are the factors to be kept in mind while designing a job?