Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost Order cost Annual holding cost Annual demand Average weekly demand Standard deviation of weekly demand Lead time Service probability Optimal order quantity Reorder point units units VALUE $12.00 $194.00/order 21% of item cost 24,700 units 494 /week 20 units 2 week 95% a. Determine the order quantity and reorder point. (Use Excel's NORMSINV() function to find your z-value and then round that z- value to 2 decimal places. Do not round any other intermediate calculations. Round your final answers to the nearest whole number.)

Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost Order cost Annual holding cost Annual demand Average weekly demand Standard deviation of weekly demand Lead time Service probability Optimal order quantity Reorder point units units VALUE $12.00 $194.00/order 21% of item cost 24,700 units 494 /week 20 units 2 week 95% a. Determine the order quantity and reorder point. (Use Excel's NORMSINV() function to find your z-value and then round that z- value to 2 decimal places. Do not round any other intermediate calculations. Round your final answers 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

Discount-Mart, a major East Coast retailer, wants todetermine the economic order quantity (see Chapter 12 for EOQformulas) for its halogen lamps. It currently buys all halogenlamps from Specialty Lighting Manufacturers in Atlanta. Annualdemand is 2,000 lamps, ordering cost per order is $30, and annualcarrying cost per lamp is $12. a) What is the EOQ?b) What are the total annual costs of holding and ordering(managing) this inventory?c) How many orders should Discount-Mart place with SpecialtyLighting per year?
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?
David's Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimates that the demand for the salamis is pretty steady at 175 per month. The salamis cost Gold $1.85 each. The fixed cost of calling his brother in New York and having the salamis flown in is $200. It takes three weeks to receive an order. Gold's accountant, Irving Wu, recommendsan annual cost of capital of 22 percent, a cost of shelf space of 3 percent of the value of the item, and a cost of 2 percent of the value for taxes and insurance. How many salamis should Gold have on hand when he phones his brother to send another shipment?
David’s Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimates that the demand for the salamis is pretty steady at 175 per month. The salamis cost Gold $1.85 each. The fixed cost of calling his brother in New York and having the salamis flown in is $200. It takes three weeks to receive an order. Gold’s accountant, Irving Wu, recommends an annual cost of capital of 22 percent, a cost of shelf space of 3 percent of the value of the item, and a cost of 2 percent of the value for taxes and insurance.a. How many salamis should Gold have flown in and how often should he order them?b. How many salamis should Gold have on hand when he phones his brother to send another shipment?c. Suppose that the salamis sell for $3 each. Are these salamis a profitable item for Gold? If so, what annual profit can he expect to realize from this item? (Assume that he operates the system optimally.)d. If the salamis…
Given this information:Lead-time demand 600 poundsStandard deviation of lead time demand 52 pounds (Assume normality.)Acceptable stockout risk during lead time 4 percenta. What amount of safety stock is appropriate?b. When should this item be reordered?c. What risk of stockout would result from a decision not to have any safety stock?
Describe the 3 differences between a fixed-quantity (Q) and a fixed-period (P) inventory ns4 a. system? Fixed Quality Inventory Fixed Period Inventory
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?
weekly demand for hamleys (a famous toy brand) at a toy store is normally disrtibuted with a mean of 250 and a standrd devaiton of 150.Ther toy store is opened 7 days a week.The toy store owner continoulsy monitors the inventory .Hamleys takes 2 weeks to fill an order with a standard devaiton of 4 days. 1] how much inventory should the sotre carry at the reorder point. 2] how much inventory would that be at the reorder point if the cycle service was increased to 98%?
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
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 × 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 $35 each Holding cost 20 percent of tire cost per year Demand 1,000 per year Ordering cost $20 per order Standard deviation of daily demand 3 tires Delivery lead time 4 days Because customers generally do not wait for tires but go elsewhere, you decide on a service probability of 98 percent. Assume the demand occurs 365 days per year. Determine the order quantity. Note: Round your answer to the nearest whole number. Determine the reorder point. Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 2 decimal places and final answer to the…
Daily demand for product sample kits is normally distributed with a mean of 35 units and a standard deviation of 4. Supply is virtually certain with a lead time of 9 days. The cost of placing an order is $20, and annual carrying costs for one kit is 25 percent. The price of one kit is $12.50. Assume a year has 365 days.If a 99% service level is desired, what is average inventory on hand? If demand had no variation, what would the reorder point be?
David’s Delicatessen flies in Hebrew National salamis regularly to satisfy a growing demand for the salamis in Silicon Valley. The owner, David Gold, estimatesthat the demand for the salamis is pretty steady at 175 per month. The salamis costGold $1.85 each. The fixed cost of calling his brother in New York and having thesalamis flown in is $200. It takes three weeks to receive an order. Gold’s accountant, Irving Wu, recommends an annual cost of capital of 22 percent, a cost of shelfspace of 3 percent of the value of the item, and a cost of 2 percent of the value fortaxes and insurance.b. How many salamis should Gold have on hand when he phones his brother tosend another shipment?