Dunstreet's Department Store would like to develop an inventory ordering policy with a 99 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 4,300 per year. The store is open 365 days per year. Every four weeks (28 days) inventory is counted and a new order is placed. It takes 12 days for the sheets to be delivered. Standard deviation of demand for the sheets is eight per day. There are currently 160 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV() function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number. > Answer is complete but not entirely correct. Number of sheets 330 x

Dunstreet's Department Store would like to develop an inventory ordering policy with a 99 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 4,300 per year. The store is open 365 days per year. Every four weeks (28 days) inventory is counted and a new order is placed. It takes 12 days for the sheets to be delivered. Standard deviation of demand for the sheets is eight per day. There are currently 160 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV() function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number. > Answer is complete but not entirely correct. Number of sheets 330 x

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
41 Dunstreet's Department Store would like to develop an inventory ordering policy with a 90 percent probability of not stocking out. To illustrate your recommended procedure, use as an example the ordering policy for white percale sheets. Demand for white percale sheets is 3,400 per year. The store Is open 365 days per year. Every two weeks (14 days) inventory is counted and a new order is placed. It takes 12 days for the sheets to be delivered. Standard deviation of demand for the sheets is five per day. There are currently 170 sheets on-hand. How many sheets should you order? Note: Use Excel's NORM.S.INV function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number.
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 3,910 mufflers Ordering cost $ 75 per order Standard deviation of daily demand 6 mufflers per working day Service probability 87 % Item cost $ 27.00 per muffler Lead time 2 working days Annual holding cost 36 % of item value Working days 230 per year Review period 18 working days 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 α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal target level_________________ b. If the…
Green Grass Industries Limited (GGIL) has used a fixed-time period inventory system that involved taking a complete inventory count of all items each month. However, increasing labor costs, are forcing GGIL, to examine alternative ways to reduce the amount of labor involved in inventory stockrooms, yet without increasing other costs, such a shortage costs. Table 10 is a random sample of 20 GGIL's items. Table 10. Annual Usage by Value of a sample of GGIL's Inventory Item Number Annual Usage ($) Item Number Annual Usage ($) 1 10,600 11 2,750 2 14,000 12 1,400 3 4,000 13 3,200 4 16,000 14 2,500 5 8,100 15 110,000 1,800 16 14,800 7 84,000 17 9,500 8. 890 18 1,700 9 940 19 3,700 10 94,000 20 12,500 a) What would you recommend GGIL to do to cut back its labor cost? (Illustrate using an ABC plan). b) Item 18 is critical to continued operations at GGIL. i. How would you recommend it be classified? ii. Give the reason(s) for your answer.
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 50 each 25 percent of tire cost per year 1,100 рer year Ordering cost Standard deviation of daily demand Delivery lead time 32 per order 7 tires 8 days 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.) 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…
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%?
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?
Please do not give solution in image format thanku Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of ordering tape is $1 per order, and carrying costs are 40 cents per roll a year. Lead-time is three days. a) Ignoring the demand uncertainty (i.e., looking only at average values), find the economic order quantity (EOQ) and the reorder point (ROP). b) Consider now the uncertainty. The order quantity remains the same. If the target is to have a 99% annual service level, what should be the ROP
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…
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