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 problems may arise without effective coordination in the workplace?
Tarek was recently promoted to become the manager of the production department. He was told that this new post involves 4 functions, 10 roles and 3 managerial skills that should be mastered. List and define those giving examples wherever appropriate
It is recommended that two different approaches be given in order to cut down on the expenses associated with rework. Take into mind the need for a staggered implementation of both solutions?
What are different methods for simplification in order to reduce complex layers of Operations?
You are requested to write an original paper of 2,000 words maximum. The assignment involves the analysis of a Start-Up company of your choice and its marketing strategy, tactical plan and growth engine. The full dynamics of what is required will be discussed in greater depth in class as the workshop evolves.
Different methods available for task analysis and each method has some advantages and disadvantages. Show a tabulation and compare all methods with suitable examples.
CASE STUDY 4-1 TELECOMMUTING WITH A NEW TWIST Open a new Microsoft® Word document and answer the following questions. Save the file on your computer with your last name in the file name. (Example: case_1-1 _Jones.doc) Click the Choose File button to find and select your saved document. According to GlobalWorkplace-Analytics.com published in January 2016, there were 3.7 million employees (2.8 percent of the workforce) that are at least half-time telecommuters. And telecommuters among the non-self-employed population have increased by 103 percent since 2005. The employee population grew by 1.9 percent from 2013 to 2014, while the employee population who telecommute grew 5.6 percent. Data from Flexjobs.com published in 2016 showed telecommuters save 260 hours by not commuting on a daily basis and are 50 percent less likely to quit their jobs. Half of the U.S. workforce has jobs that are compatible with telecommuting arrangements. Working from home offers some clear advantages for both…
Today's Activity: Determine a skill you want to teach your classmate. Then, answer the following questions: Explain the primary reason for desiring to teach this skill. Specify and clarify the objectives you aim to achieve within the upcoming 14 days. If you like, include some potential resources for this event.
Make a list of two ways to reduce rework expenses. What role, in your opinion, does gradual delivery play in both approaches?
In this step of new product development, a product that passes test-marketing is ready for market introduction, called rollout, which requires a lot of logistical coordination. Various divisions of the company must be encouraged to give the new item the attention it deserves. Packaging and labeling in a different language may be required. Sales training sessions must be scheduled, spare parts inventoried, service personnel trained, advertising and promotion campaigns readied, and wholesalers and retailers informed about the new item. If the new product is to be sold internationally, it may have to be altered to meet the requirements of the target countries. For instance, electrical products may have to run on different electrical currents. Test market the new product Introduce the product evaluation of alternatives screen ideas/concepts
Please explain how Internet technologies are being used in the development of a process in one of the company's functional areas. Provide an example and assess its monetary worth in the business world.
Discuss the concept of IT asset management (ITAM) and its importance in resource acquisition. How can effective ITAM benefit an organization?