please show formula!

D H M T 3 4 5 or 7 A B E F G K L N o R S 1 Inventory Control 2 You must do the necessary calculations in the answer cells. Simply providing a number in the answer cell will not receive any credit. When look at the answer cell, I want to see a number, when I click on the cell I want to see the excel formula, for example, if I asked you the sum of cells B5 through D5, this is what I want to see: 7035.0 7035.0 6 1234 2345 3456 Note: cells (J4 & L4) (above) contain formulas that use cell referencing - which is a requirement for responses on all assignment 8 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: 10 Annual Demand (monthly demand 1/12 of annual demand) 1080 11 Cost per hoodie 15 Carrying Cost per sweatshirt per year as a percentage of the cost of a sweatshirt 30% Cost per order placed $50 Lead time in months 1 Standard Deviation of Demand during lead time 20 Desired Service Level should be at least 96.00% z-value =========> 1.75 9 12 13 14 15 16 17 18 Question 1: If you don't use safety stock, you should place an order when the inventory position reaches what amount? 19 Question 2: If you plan on using safety stock, how many should have have? (Give amount of safety stock only)? 20 Question 3: How much sweatshirts should be ordered when you reach the Re-Order Point? 21 22 23 Part 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 Daily Demand 25 units per day Sheet1 Sheet2 Sheet3 + 26