Question: Answer in excel and show how to do it if possible A company begins a review of ordering policies for its continuous review system by

Answer in excel and show how to do it if possible
A company begins a review of ordering policies for its continuous review system by checking the current policies for a sample of SKUs. Following are the characteristics of one item: > Demand (D) = 84 units/week (Assume 51 weeks per year) > Ordering and setup cost (S) = $90/order > Holding cost (H) = $18/unit/year > Lead time (L) = 5 week(s) > Standard deviation of weekly demand = 21 units > Cycle-service level = 90 percent > EOQ = 207 units Using the above information, develop the best policies for a periodic review system. Refer to the standard normal table for z-values. a. What value of P gives the same approximate number of orders per year as the EOQ? weeks. (Enter your response rounded to the nearest whole number.) b. To provide a 90 percent cycle-service level, the average safety stock is units. (Enter your response rounded to the nearest whole number.) To provide a 90 percent cycle-service level, the target inventory level is units. (Enter your response rounded to the nearest whole number.)Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
