Excel File Edit View Insert Format Tools Data Window Help o 96% Sun Oct 17 7:59 PM O.. AutoSave OFF A 9 LUB Assignment 2_(9) Home - Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Arial v 10 APM Y == Y General 29 Wrao Text 27. O V - high res 9 Insert v Delete Format v Paste 11 AVA Z Sort & Filter = = = + + Merge & Centar & Conditional Format Cell Formatting as Table Styles . Find & Select Analyze Data N20 fx A B C D E F G N 0 P Q R S chaudhary folio 1an c job bes 34567899rQHBB9www 1 Q.3 2 Variable name Variable Avg. annual demand 31,025 units per yoar Avg. daily demand 85 units per day Std. deviation of demand 20 units per day Unit purchase cost 42 $ per unit Inventory holding cost factor 24% per year Order cost 225 $ per order Economic order quantity units per order Q.3a 11 Mean lead time 12 days 12 Std. deviation of lead time 4 days Mean demand during lead time units Std. deviation of lead time demand units per lead time In-stock probability during lead time type 1 service level Q.3b No. of std. deviations corresponding to a 17 Safety stock units 18 Reorder point units Q.3a 19 Expected number of units out of stock per cycle units 20 Fill rate type 2 service level 21 22 3. Consider the demand, lead time, and cost information provided in the worksheet. At its last retreat, the 24 Executive Committee determined that 95% of consumer demand should be filled from on-hand inventory. 25 a) Which inventory control parameter values (rearder point and order quantity) will enable the firm to meet 26 this customer service objective while minimizing costs? b) What will be the in-stock probability (type 1 service level) in this case? 28 Lille nous88 uw he became led folder NONNNNN n2_2021 27 30 Assignment 2 questions Q1-2 Q3 + arya_exam 1 Ready 136% OUT 1 17 otvo X 9