Excel Format Tools Data Window Help O Mon Feb 21 5:28 PM File Edit View Insert AutoSave OFF AB 0.. BE Inventory-2021-Fall - Home Insert Draw Page Layout Formulas Data Review View Tell me e Share Comments X Arial 14 y Insert = ~ A A v General 2-D 10% Delete Format WES Sort & Filter Find & Select Analyze Data Sensitivity G J L M N 0 P RO ASU Paste BTU A === + E S% Conditional Format Cell Formatting as Table Styles G37 1x fx Grading Rubric A D E H 22 23 rt 2: Enter the requested information into the yellow cells. Round off to 1 decimal point 24 (Use the data given below for questions referring to Part 2) 25 EOQ 250 units 26 Daily Demand 25 units per day Lead time in days 10 days 28 Desired service level should be at least 95.50% (note: Look up z-value in table) 29 Standard Deviation of Demand during lead time and review 10 See note below 30 (note this is not the daily sd of demand, but the sd over the entire review period + lead time) 31 Inventory Position 212 units in stock 27 32 33 34 35 Part 2, Question 1: What is the optimal review period? Part 2, Question 2: What is the target Inventory level? Part 2, Question 3: How much should ordered? days units units 38 37 38 39 40 41 Grading Rubric Possible Earned Comments 15 15 15 15 15 15 20 20 20 20 15 15 100 100 P1 Quest1 P1 Quest2 P1 Quest3 P2 Quest 1 P2 Quest 2 P2 Quest 3 Totals 42 43 44 45 48 47 48 49 50 51 52 Sheet1 Sheet2 Sheel3 + C 100% Ready Screen Recording isco mpi 21 A