Question: please show formula on excel sheet Jestion 4 Dr. Chi's company distributes part of airplane in Michigan. Dmeand for the engine air filters has been

please show formula on excel sheet please show formula on excel sheet Jestion 4 Dr.
Jestion 4 Dr. Chi's company distributes part of airplane in Michigan. Dmeand for the engine air filters has been uniform. The lead time to obtain the filters is 2 months, and the average use rate is 1000 per month. The lead-time use is normally distributed with a standard deviation of 100 units. Order cost is $20 and holding cost is 1 dollar a year per filter. The estimated cost of a stockout is $30. a. What is the EOQ? b. How many orders per year will be placed at this ECG? How many days between orders ? c. What is the Pd optimum probability of a stockout? d. What is reorder level? .. How much will Dr. Chi spend per year to hold Inventory and ordering on this iter if it implements the values you determined above? 10 Times Dio De de 1000 per month working days S. SIN 02 Unit cost 03 E0Q=205/5 105 Day. Working Months. Times 100 Maximum 107 Minimum 5 108 Average 109 QIZH 110 DIO'S 111 Total Cost 112 L 113 33 50x score 114 RL dxLT. SDZ 115 Catokout Cost 116 CLT-OL 117 Standard Deviation 118 PS Proy COD 118 Probability of Majority 120 Z score 121

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!