Ignore question 2 because I already solve it in Xl sheet. I posted Xl sheet if it will help you to answer other questions, but if don't help you ignore it.

The Northern Appliance Company (NAC) assembles refrigerators for the domestic market. The compressor units used in the model F70 refrigerator are purchased from international suppliers. An analysis of the purchasing operation shows that approximately 2.5 hours are required to process a purchase order, regardless of the quantity purchased. Salaries in the Purchasing Department average OMR 12 per hour, including employee benefits. In addition, a detailed analysis of 30 previous purchase orders showed that OMR 388 was spent on telephone, paper, and other consumables directly related to the ordering process. Also, the company's financial analysts established a holding cost of 19%. The annual demand for the compressors is 16,200 units, and the assembly plant operates 280 days per year. The lead time for the compressors is variable. Data for lead times from the past 70 orders is provided in the file LT.xls. Currently, the company has a contract to purchase the compressors from the supplier at a cost of OMR 42 per unit, and it is using a policy of replenishing its inventory of compressors once a month. Service level guidelines indicate that 0.5 stockouts per year is acceptable. Part A 1. What is the ordering cost? 2. Assuming that the lead time data sample (LT.xls) in your possession is large enough, determine whether the lead time is normally distributed or not. 3. Calculate the current annual total inventory cost under the company's current policy. 4. Which model should be used to find the best inventory policy? Justify your answer. 5. Determine the optimal order quantity. 6. How much safety stock is recommended for the company to carry? 7. State the optimal inventory policy. 8. What is the optimal total annual inventory cost? 1 Historic record of lead times in days for the past 70 cycles LT frequenc y frequency fraction LT frequency fraction 2 2 1 1 2.6 3.2 3.3 2 2.6 3.2 3.3 3,4 3.6 3.9 4 4.1 4.2 4.3 3.6 3.9 4 4.1 4.2 4.3 2.6 2.6 32 32 3.3 3.4 3.6 3.6 3.9 3.9 4.0 4.0 4.1 4.1 4.1 4.1 4.1 4.2 42 4.2 4.3 4.3 43 4.5 4.6 4.7 2 3 4. 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 4.5 4.6 4.7 4.8 4.9 5 2 2 5 3 3 2 4 4 4 1 3 2 2 1 2 2 2 2 2 2 2 0.028571429 0.028571429 0.014285714 0.014285714 0.028571429 0.028571429 0.028571429 0.071428571 0.042857143 0.042857143 0.028571429 0.057142857 0.057142857 0.057142857 0.014285714 0.042857143 0.028571429 0.028571429 0.014285714 0.028571429 0.028571429 0.028571429 0.028571429 0.028571429 0.028571429 0.028571429 0.014285714 0.028571429 0.014285714 0.014285714 0.014285714 0.014285714 0.028571429 0.014285714 0.03714286 0.04571429 0.04714286 0.04857143 0.05142857 0.05571429 0.05714286 0.05857143 0.06 0.06142857 0.06285714 0.06428571 0.06571429 0.06714286 0.06857143 0.07 0.07142857 0.07285714 0.07428571 0.07571429 0.07714286 0.07857143 0.08 0.08142857 0.08428571 0.08571429 0.08714286 0.09 0.09142857 0.09285714 0.09428571 0.09571429 0.09857143 0.1 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.9 6 4.9 5 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.9 6 6.1 6.3 6.4 6.5 6.6 6.7 6.9 7 6.1 1 2 4.4 4.5 4.5 4.5 4.5 4.6 4.6 4.6 4.6 4.7 4.7 4.7 1 6.3 6.4 6.5 6.6 6.7 6.9 7 1 1 1 2 1 4.8 The Northern Appliance Company (NAC) assembles refrigerators for the domestic market. The compressor units used in the model F70 refrigerator are purchased from international suppliers. An analysis of the purchasing operation shows that approximately 2.5 hours are required to process a purchase order, regardless of the quantity purchased. Salaries in the Purchasing Department average OMR 12 per hour, including employee benefits. In addition, a detailed analysis of 30 previous purchase orders showed that OMR 388 was spent on telephone, paper, and other consumables directly related to the ordering process. Also, the company's financial analysts established a holding cost of 19%. The annual demand for the compressors is 16,200 units, and the assembly plant operates 280 days per year. The lead time for the compressors is variable. Data for lead times from the past 70 orders is provided in the file LT.xls. Currently, the company has a contract to purchase the compressors from the supplier at a cost of OMR 42 per unit, and it is using a policy of replenishing its inventory of compressors once a month. Service level guidelines indicate that 0.5 stockouts per year is acceptable. Part A 1. What is the ordering cost? 2. Assuming that the lead time data sample (LT.xls) in your possession is large enough, determine whether the lead time is normally distributed or not. 3. Calculate the current annual total inventory cost under the company's current policy. 4. Which model should be used to find the best inventory policy? Justify your answer. 5. Determine the optimal order quantity. 6. How much safety stock is recommended for the company to carry? 7. State the optimal inventory policy. 8. What is the optimal total annual inventory cost? 1 Historic record of lead times in days for the past 70 cycles LT frequenc y frequency fraction LT frequency fraction 2 2 1 1 2.6 3.2 3.3 2 2.6 3.2 3.3 3,4 3.6 3.9 4 4.1 4.2 4.3 3.6 3.9 4 4.1 4.2 4.3 2.6 2.6 32 32 3.3 3.4 3.6 3.6 3.9 3.9 4.0 4.0 4.1 4.1 4.1 4.1 4.1 4.2 42 4.2 4.3 4.3 43 4.5 4.6 4.7 2 3 4. 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 4.5 4.6 4.7 4.8 4.9 5 2 2 5 3 3 2 4 4 4 1 3 2 2 1 2 2 2 2 2 2 2 0.028571429 0.028571429 0.014285714 0.014285714 0.028571429 0.028571429 0.028571429 0.071428571 0.042857143 0.042857143 0.028571429 0.057142857 0.057142857 0.057142857 0.014285714 0.042857143 0.028571429 0.028571429 0.014285714 0.028571429 0.028571429 0.028571429 0.028571429 0.028571429 0.028571429 0.028571429 0.014285714 0.028571429 0.014285714 0.014285714 0.014285714 0.014285714 0.028571429 0.014285714 0.03714286 0.04571429 0.04714286 0.04857143 0.05142857 0.05571429 0.05714286 0.05857143 0.06 0.06142857 0.06285714 0.06428571 0.06571429 0.06714286 0.06857143 0.07 0.07142857 0.07285714 0.07428571 0.07571429 0.07714286 0.07857143 0.08 0.08142857 0.08428571 0.08571429 0.08714286 0.09 0.09142857 0.09285714 0.09428571 0.09571429 0.09857143 0.1 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.9 6 4.9 5 5.1 5.2 5.3 5.4 5.5 5.6 5.7 5.9 6 6.1 6.3 6.4 6.5 6.6 6.7 6.9 7 6.1 1 2 4.4 4.5 4.5 4.5 4.5 4.6 4.6 4.6 4.6 4.7 4.7 4.7 1 6.3 6.4 6.5 6.6 6.7 6.9 7 1 1 1 2 1 4.8