TABLE 7-2 Standard Deviations and Probabilities Z= Number of Deviations Required Probability of Being in Stock Probability of Stockout 84.13% 15.77% 1.04 85 1.28 90 1.65 95 1.96 97.5 2.0 97.72 2.28 2.33 99 3.0 99.86 0.14 Swink Chapter 7 HW Saved Foods Galore is a major distributor to restaurants and other institutional food users. 28 Foods Galore buys cereal from a manufacturer for $29 per case. Annual demand for cereal is 245,000 cases, and the company believes that the demand is constant at 980 cases per day for each of the 250 days per year that it is open for business. Average lead time from the supplier for replenishment orders is eight days, and the company believes that it is also constant. The purchasing agent at Foods Galore believes that annual inventory carrying cost is 20 percent and that it costs $54 to prepare, send, and receive an order. Use Table 7-2. 0.77 points a-1. How many cases of cereal should Foods Galore order each time it places an order? (Round your answer to the nearest whole number.) Economic order 2.136 cases quantity a-2. What will be the average Inventory? (Round your answer to 1 decimal place.) Average inventory 1,068.0 cases a-3. What will be the inventory turnover rate? (Round your answer to 1 decimal place.) Inventory tumover 114.7 times per year a-4. Calculate the total annual cost based on a product cost of $29/unit. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Total annual cost Foods Galore conducts an in-depth analysis of its inventory management practices and discovers several flaws in its previous approach. First, they find that by ordering 14,000 or more cases each time, they can obtain a price of $27 per case from the supplier. b-1. Calculate the total annual cost based on a product cost of $27/unit. Total annual cost b-2. What order quantity should Foods Galore place? Quantity to be ordered cases b-3. How much will they save annually by ordering the quantity shown in Part b-2 instead of Part a-1? (Round your answer to 2 decimal places.) Amount saved b-3. How much will they save annually by ordering the quantity shown in Part b-2 instead of Part a-1? (Round your answer to 2 decimal places.) Amount saved c. In its analysis, Foods Galore determined that demand and lead time are not constant. In fact, demand has a standard deviation of 75 cases per day and lead time has a standard deviation of 1.6 days. Foods Galore management wants to evaluate two service level policies. One policy would incur a 5 percent risk of stockout while waiting for replenishment, the other only a 1 percent risk of stockout. What would be the cost of carrying the safety stocks for each of the two policies? (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Carrying Cost 5 percent risk of stockout 1 percent risk of stockout TABLE 7-2 Standard Deviations and Probabilities Z= Number of Deviations Required Probability of Being in Stock Probability of Stockout 84.13% 15.77% 1.04 85 1.28 90 1.65 95 1.96 97.5 2.0 97.72 2.28 2.33 99 3.0 99.86 0.14 Swink Chapter 7 HW Saved Foods Galore is a major distributor to restaurants and other institutional food users. 28 Foods Galore buys cereal from a manufacturer for $29 per case. Annual demand for cereal is 245,000 cases, and the company believes that the demand is constant at 980 cases per day for each of the 250 days per year that it is open for business. Average lead time from the supplier for replenishment orders is eight days, and the company believes that it is also constant. The purchasing agent at Foods Galore believes that annual inventory carrying cost is 20 percent and that it costs $54 to prepare, send, and receive an order. Use Table 7-2. 0.77 points a-1. How many cases of cereal should Foods Galore order each time it places an order? (Round your answer to the nearest whole number.) Economic order 2.136 cases quantity a-2. What will be the average Inventory? (Round your answer to 1 decimal place.) Average inventory 1,068.0 cases a-3. What will be the inventory turnover rate? (Round your answer to 1 decimal place.) Inventory tumover 114.7 times per year a-4. Calculate the total annual cost based on a product cost of $29/unit. (Do not round intermediate calculations. Round your answer to 2 decimal places.) Total annual cost Foods Galore conducts an in-depth analysis of its inventory management practices and discovers several flaws in its previous approach. First, they find that by ordering 14,000 or more cases each time, they can obtain a price of $27 per case from the supplier. b-1. Calculate the total annual cost based on a product cost of $27/unit. Total annual cost b-2. What order quantity should Foods Galore place? Quantity to be ordered cases b-3. How much will they save annually by ordering the quantity shown in Part b-2 instead of Part a-1? (Round your answer to 2 decimal places.) Amount saved b-3. How much will they save annually by ordering the quantity shown in Part b-2 instead of Part a-1? (Round your answer to 2 decimal places.) Amount saved c. In its analysis, Foods Galore determined that demand and lead time are not constant. In fact, demand has a standard deviation of 75 cases per day and lead time has a standard deviation of 1.6 days. Foods Galore management wants to evaluate two service level policies. One policy would incur a 5 percent risk of stockout while waiting for replenishment, the other only a 1 percent risk of stockout. What would be the cost of carrying the safety stocks for each of the two policies? (Do not round intermediate calculations. Round your final answers to 2 decimal places.) Carrying Cost 5 percent risk of stockout 1 percent risk of stockout