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

Question 1: Which of the following best defines " stockout costs"? options: A) They are physical goods used in operations. B) They are costs associated with retrieving inventory items from a workshop C) They are costs associated with interruptions to assembly lines D) They are associated with inventory being unavailable when needed to meet demand. E) None of the above. Question 2 At many LCBO stores in Ontario, Hennessy Cognac is kept in a clear locked case. Based on this information, according to the ABC Inventory Analysis method, is Hennessy most likely to be classified as an A item, a B item, a C item, or none of these? Question 2 options: A) C item B) None C) A item D) B item Question 3 What purpose does Rent the Runway's high-speed reverse logistics system serve? options: A) It allows the customers to return inventory to the fulfillment centre in record time. B) It allows the company to send inventory out to recipients (customers) in record time. C) It allows customers to return…
Define each of the following terms: c. Economic Ordering Quantity (EOQ); EOQ model; EOQ range
Why do we use "Specifications or bill of material" in the dependent inventory model?
Discount-Mart (see Problem 16.8), as part of its newLean program, has signed a long-term contract with SpecialtyLighting and will place orders electronically for its halogen lamps.Ordering costs will drop to $.50 per order, but Discount-Mart alsoreassessed its carrying costs and raised them to $20 per lamp.a) What is the new economic order quantity?b) How many orders will now be placed?c) What is the total annual cost of managing the inventory withthis policy?
Cesar Rego Computers, a Mississippi chain of computer hardware and software retail outlets, supplies both educational and commercial customers with memory and storage devices. It currently faces the following ordering decision relating to purchases of disks: 35,000 disks $23 22% Purchase price Discount price $0.88 $0.81 Quantity needed to qualify for the discount = 5,900 disks. %3D What is the EOQ? EOQ = units (round your response to the nearest whole number).
Problem #1 Divan Incorporated sells preassembled furniture. Divan Inc buys module materials from its suppliers, who has now offered Divan a discount of $2 off all units if Divan will make a purchase greater than 500 or $5.00 off if the firm will make a purchase of at least 750 units. Current data for the company is: annual demand is 20,000 units per year; setup costs are $50, and I = 20% per year. Original price is $30 (e.g. if Divan purchases between 500 and 749, the price is $28, and if Divan purchases more than 750 units, the price is $25). (a) What is the optimal purchase quantity? (b) What are the annual product costs? (c) What are the annual setup costs? (d) What are the annual holding costs? (e) What is the annual total costs? ===== Problem #2 Hren Electronics is in process of setting a new office building. The following tables show the number of expected communications among the four departments and two possible layouts for considerations (tables 2 and 3 show the…
Problem #1 Divan Incorporated sells preassembled furniture. Divan Inc buys module materials from its suppliers, who has now offered Divan a discount of $2 off all units if Divan will make a purchase greater than 500 or $5.00 off if the firm will make a purchase of at least 750 units. Current data for the company is: annual demand is 20,000 units per year; setup costs are $50, and I = 20% per year. Original price is $30 (e.g. if Divan purchases between 500 and 749, the price is $28, and if Divan purchases more than 750 units, the price is $25). (a) What are the annual setup costs? (b) What are the annual holding costs? (c) What is the annual total costs?
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round individual dollar volumes to two decimal places. Also round percentage of dollar volume to two decimal places.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar % of Dollar Volume Volume 1289 360 4.00 2347 300 4.00 1,200 36.20 2349 120 2.50 300 9.05 2363 75 1,50 2394 60 1.75 105 3.17 2395 35 2.00 6782 20 1.15 23 0.69 7844 12 2.05 24.6 0.74 8210 5 1.60 8310 7 2.00 14 0.42 9111 3.00 18 0.54 3,315.1 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number…
Describe thebasic EOQ model and itsassumptions and solvetypical problems.
14 To calculate Economic Order Quantity (EOQ =sqrt(D*k/h)
L. Houts Plastics is a large manufacturer of injection-molded plastics in North Carolina. An investigation of the company's manufacturing facility in Charlotte yields the information presented in the table below. How would the plant classify these items according to an ABC classification system? (Round dollar volume to the nearest whole number and percentage of dollar volume to two decimal places.) Item Code L. Houts Plastics Charlotte Inventory Levels Avg. Value Inventory (units) ($/unit) Dollar Volume % of Dollar Volume 1289 360 3.75 2347 300 4.00 1,200 37.58 2349 120 2.50 300 9.40 2363 60 1.50 2394 60 1.75 105 3.29 2395 30 1.75 6782 20 1.15 23 0.72 7844 12 2.05 25 0.77 8210 8 2.00 8310 7 2.00 14 9111 6 3.00 18 0.44 0.56 3,193 For the following three questions, consider only items 1289, 2349, and 8210 from the above table for relative classification (these are some of the items for which you computed the metrics). Based on the percentages of dollar volume, item number 1289 should be…
Historical records on the use of spare parts for several large hydraulic presses are to serve asan estimate of usage for spares of a newly installed press. Stockout costs involve downtimeexpenses and special ordering costs. These average $4,200 per unit short. Spares cost $800each, and unused parts have zero salvage. Determine the optimal stocking level.Spares Used Relative Frequency Cumulative Frequency0 .20 .201 .40 .602 .30 .903 .10 1.004 or more .001.00