Reference to this Question

Q2 (20 points). Redo QI assuming a Type 2 Service level approach Q1 (20 points). You work for a computer manufacturer. They tasked you to manage the inventory for a critical part they procure on a regular basis. Historical data and forecasts indicate a normal distribution for the weekly demand with a mean of 40 and variance of 120. There is a 3-week lead time for receiving this part and each part costs $20. Accounting uses 35% interest rate for holding costs estimates a stock-out cost of $150 per part and that each order has a fixed cost of $80 per order. a) (15 points) Type 1 Service level-based approach: Assuming that the company wants to use EOQ and achieve a 98% service level in meeting demand, what would be the order quantity and the reorder point? b) (5 points) What are the average costs related to holding, setup (ordering), and stock outs for this inventory control policy. HINT: Expected Stockout Per Cycle= n(R)= OaL*L(z): note the sigma is for demand during lead time (or lead time demand), Oal =sqrt (Los+dol) L(z)= NORM.S.DIST(2,0)-z*(1-NORMSDIST(z)) - Standardized Loss Function