please include excel caluclations , any help is appreciated as im struggling to understand what to do!

Paste Format B TU THI Merge & Center % 9 Conditional Format Cew Formatting as Table Styles L12 c D K 10 11 14 1.64 7 Part 1: Enter the requested information into the green cells. Round off to 1 decimal point. The online Collegiate Products Store gathered the following information regarding UND Sweatshirts: Annual Demand (monthly demand 1/12 of annual demand) 1200 Cost per hoodie 15 Carrying Cost per sweatshirt per year as a percentage of the cost of a sweatshirt 30% 12 Cost per order placed $50 13 Lead time in months 1 Standard Deviation of Demand during lead time 23 15 Desired Service Level should be at least 95.00% z-value >> 17 Question 1: If you don't use safety stock, you should place an order when the inventory position reaches what amount? 18 Question 2: If you plan on using safety stock, how many should have have? (Give amount of safety stock only)? 19 Question 3: How much sweatshirts should be ordered when you reach the Re-Order Point? 20 21 22 Part 2: Enter the requested information into the yellow cells. Round off to 1 decimal point 23 (Use the data given below for questions referring to Part 2) EOQ 300 units Daily Demand 20 units per day Lead time in days 10 days 27 Desired service level should be at least 95.50% (note: Look up 2-value in table) Standard Deviation of Demand during lead time and review 10 see note below (note this is not the daily sd of demand, but the sd over the entire review period + lead time) 20 Inventory Position 212 units in stock 24 25 20 20 31 32 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 14 35 3 P1 Quest1 P1 Quest2 P1 Quest3 P2 Quest 1 P2 Quest 2 P2 Quest 3 Totals Grading Rubric Possible 15 15 15 20 20 15 100 Eamed Comments 15 15 15 20 20 15 100 41 4 Sheet1 Sheet2