Problem 20-30 (Algo)It is your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities forthe various items have been correctly established. You decide to test one item and choose Michelin tires, XW size 185 x 14 BSW. Aperpetual inventory system has been used, so you examine this, as well as other records, and come up with the following data:Cost per tireHolding costDemand50 each25 percent of tire cost per year1,100 рer yearOrdering costStandard deviation of daily demandDelivery lead time32 per order7 tires8 daysBecause customers generally do not wait for tires but go elsewhere, you decide on a service probability of 90 percent. Assume thedemand occurs 365 days per year.a. Determine the order quantity. (Round your answer to the nearest whole number.)Order quantity75 tiresb. Determine the reorder point. (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Do notround intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.)Reorder pointtires

Order quantity can be calculated as follows:

a. Determine the order quantity. (Round your answer to the nearest whole number.) Order quantity 75 tires b. Determine the reorder point. (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.)

a. Determine the order quantity. (Round your answer to the nearest whole number.) Order quantity 75 tires b. Determine the reorder point. (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.)

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.
Problem 20-30 (Algo) It is your responsibility, as the new head of the automotive section of Nichols Department Store, to ensure that reorder quantities for the various items have been correctly established. You decide to test one Item and choose Michelin tires, XW size 185 x 14 BSW. A perpetual inventory system has been used, so you examine this, as well as other records, and come up with the following data: Cost per tire Holding cost Demand Ordering cost Standard deviation of daily demand Delivery lead time Order quantity $ tires 50 each percent of tire cost per year Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 90 percent. Assume the demand occurs 365 days per year. a. Determine the order quantity. (Round your answer to the nearest whole number.) 15 1,100 per year $ 22 per order 4 tires 5 days
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…
Micro-Electronics Warehouse Headset and Webcam Sale Item Type Reg. Price After Savings Price BuddyChat 200 Headset $34.72 $24.40 BuddyChat 300 Headset $41.27 $34.91 BuddyCam HD Webcam $83.54 $61.46 You have decided to purchase the headset with the greatest markdown percent and the BuddyCam HD webcam in order to take advantage of an "Extra $15 Rebate" offer when you purchase both. What is the markdown percent on your total purchase including the rebate?
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 420 3.50 1470 2347 300 4.00 1,200 36.05 2349 120 2.50 300 9.01 2363 65 1.50 98 2394 60 1.75 105 3.15 2395 25 2.25 56 6782 7844 12 8210 10 8310 9111 22076 1.15 23 0.69 2.05 25 0.74 2.00 20 2.00 14 0.42 3.00 18 0.54 3,328
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.) L. Houts Plastics Charlotte Inventory Levels Item Code Avg. Inventory (units) Value ($/unit) Dollar Volume % of Dollar Volume 1289 380 3.50 insert answer insert answer 2347 300 4.00 1,200 37.83 2349 120 2.50 300 9.46 2363 75 1.30 insert answer insert answer 2394 60 1.75 105 3.31 2395 25 2.00 insert…
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?
Define each of the following terms: c. Economic Ordering Quantity (EOQ); EOQ model; EOQ range
ECUR UMIC ORDER QUANTITY CALCULATIONS (2 QUESTIONS) Company uses 800 units of a product per year on a continuous basis. The product year and order costs of $300 per order. It takes 30 days to receive a shipment after an order is placed and the a safety stock of 5 days usage in inventory. has carrying costs of $50 A. Calculate the economic order quantity a. 98 B. Determine the reorder a. 150 days (3 CASH DISCOUNTS point. ONS) (Assume (EOQ). a 360-day year.) per unit per firm requires
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)?
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 Avg. Inventory (units) Value ($/unit)1289 380 3.252347 300 4.002349 120 2.502363 70 1.302394 60 1.752395 25 1.756782 20 1.157844 12 2.058210 10…