Palin's Muffler Shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system tomanage inventory of this standard muffler. Use the information in the following table to determine the optimal inventory target level (ororder-up-to level).Ordering costService probabilityAnnual demand3,750mufflers$ 6092 %per ordermufflers per working dayper muffler% of item valueworking daysStandard deviation of daily demandItem cost$39.00working daysper yearLead time3Working daysAnnual holding costReview period3125020a. What is the optimal target level (order-up-to level)? (Use Excel's NORMSINV() function to find the correct critical value for thegiven a-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest wholenumber.)Optimal target levelb. If the service probability requirement is 92 percent, the optimal target level will:O Stay the sameDecreaseO Increase

Given, Annual demand D = 3750 Daily Demand d = 3750/250 = 15 per day Review Period T = 20 Lead time…

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). mufflers mufflers per working day per muffler % of item value working days Annual demand 3,750 $ 60 Ordering cost Service probability per order Standard deviation of daily demand 6 92 % Item cost $39.00 Lead time working days Annual holding cost Review period 31 Working days 250 per year 20 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

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). mufflers mufflers per working day per muffler % of item value working days Annual demand 3,750 $ 60 Ordering cost Service probability per order Standard deviation of daily demand 6 92 % Item cost $39.00 Lead time working days Annual holding cost Review period 31 Working days 250 per year 20 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

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Chapter16: Lean Supply Chain Management

Section: Chapter Questions

Problem 10DQ: The chapter presented various approaches for the control of inventory investment. Discuss three...

See similar textbooks

Similar questions

The chapter presented various approaches for the control of inventory investment. Discuss three additional approaches not included that might involve supply chain managers.
Fisk Corporation is trying to improve its inventory control system and has installed an online system at its retail stores. Fisk anticipates sales of 58,800 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. In the second year, Fisk Corporation finds that it can reduce ordering costs to $1 per order, but carrying costs will stay the same at $1.50 per unit. a-1. What is the economic ordering quantity for the second year? Economic ordering quantity (EOQ) a-2. How many orders will be placed during the second year? Number of orders a-3. What will the average inventory be for the second year? Average inventory Total costs units units a-4. What is the total cost of ordering and carrying inventory for second year? LA
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 97,200 units per year, an ordering cost of $4 per order, and carrying costs of $1.50 per unit. What is the economic ordering quantity? How many orders will be placed during the year? What will the average inventory be? What is the total cost of ordering and carrying inventory?
Xemex has collected the following inventory data for the six items that it stocks: ITEM CODE UNIT COST ($) ANNUAL DEMAND (UNITS) ORDERING COST ($) CARRYING COST AS A PERCENTAGE OF UNIT COST 1 10.60 600 40 20 2 11.00 450 30 25 3 2.25 500 50 15 4 150.00 560 40 15 5 4.00 540 35 16 6 4.10 490 40 17 Lynn Robinson, Xemex’s inventory manager, does not feel that all of the items can be controlled. What ordered quantities do you recommend for which inventory product(s)?
Fisk Corporation is trying to improve its inventory control system and has installed an online computer at its retail stores. Fisk anticipates sales of 112, 500 units per year, an ordering cost of $3 per order, and carrying costs of $1.20 per unit. a. What is the economic ordering quantity? b. How many orders will be placed during the year? c. What will the average inventory be? d. What is the total cost of ordering and carrying inventory?
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…
Maroons Medical Supplies, Inc. must order masks from its supplier in lots of 1 dozen boxes. Given the information provided below, complete the following table: Annual demand 26,000 dozen Cost per order placed P30 Carrying cost 20% Price per dozen P7.80 Order Size (Dozen) 250 500 1,000 2,000 13,000 26,000 Number of orders Average inventory Carrying cost Order cost Total cost 1. What is the EOQ? Please include/fill the table and solve for EOQ. Thank you so much!
Describe the 3 differences between a fixed-quantity (Q) and a fixed-period (P) inventory ns4 a. system? Fixed Quality Inventory Fixed Period Inventory
Why do we use "Specifications or bill of material" in the dependent inventory model?
Cherylene Brown has asked you to help her determine the best ordering policy for a new product. The demand for the new product has been forecasted to be about 1,000 units annually. To help you get a handle on the carrying and ordering costs, Cherylene has given you the list of last year's costs. She thought that these costs might be appropriate for the new product. Cost Factor Taxes for the warehouse Receiving and incoming inspection New product development Acct. dept. costs to pay invoices Inventory insurance Product advertising Spoilage Sending purchasing orders Cost ($) 2,050 1,600 2,500 500 600 800 750 900 Cost Factor Warehouse supplies Research and development Purchasing salaries & wages Warehouse salaries & wages Pilferage of inventory Purchase order supplies Inventory obsolescence Purchasing dept. overhead Cost ($) 300 2,750 30,000 12,800 800 500 300 1,000 She also told you that these data were compiled for 10,000 inventory items that were carried or held during the year. You…
Thomas Kratzer is the purchasing manager for theheadquarters of a large insurance company chain with a centralinventory operation. Thomas’s fastest-moving inventory item hasa demand of 6,000 units per year. The cost of each unit is $100, and the inventory carrying cost is $10 per unit per year. The aver-age ordering cost is $30 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 120 units. (This is acorporate operation, and there are 250 working days per year.)a) What is the EOQ?b) What is the average inventory if the EOQ is used?c) What is the optimal number of orders per year?d) What is the optimal number of days in between any two orders?e) What is the annual cost of ordering and holding inventory?f ) What is the total annual inventory cost, including the cost ofthe 6,000 units?
A pharmacist is trying to determine the inventory order and stock levels for a particular drug. The following information is available about the drug. Demand (D) 85 tablets/week Working weeks per year 52 weeks Unit holding cost per year (H) $6 Order cost (S) $44/order Standard deviation of weekly demand (sd) 15 tablets Lead time (L) 2 weeks Desired cycle service level 95% If the pharmacist uses the continuous review (Q) system to control the inventory of the drug, what would be the order quantity and reorder point? If the pharmacist uses the periodic review (P) system to control the inventory of the drug, what would be the review interval and target inventory level? (Hint: Use the EOQ model to derive the review interval P)