Edit View Twerfur Toy D Toos Dals Window lep > CQ Men Feb 21 2:09 PM O Excel file Aulow AT Inventory-2021-Fall Home Ingert Drew Page Layout Formu Data Review View Tell me Share Arial v 14 == wa Talv Number v TLS Good NALIT Xar Ons ramal > 4 IF CM YO. 0 Pesto BI Chak cell Nuys & Cul AA- Calw Conditional Formu Porong xx Tabs Eglory.hr ISC Dual Furnal Ford Bor & Fas SHRI C wala Cata Scy . I. W X A NA or TO. K15 XV -NORM.S.INV||16| R N OF You must do the necessary calculation in the armur cella. Simply providing a number in the armur cell will not receive any credit When look at the answer Goll want to san a number, whon I click on the call want to sao thoaxcel formuls, for example iflaked you the sum of ella es through Ds, this is we went towe: Tuss, er . 1214 2345 346 Note call: J4 & L41(abbiconkain borulas traluce cell referencing-which is uirement reconsonal assignments. nter the requested information into the green cells. Round off to 1 decimal point. The online Colegiate Products Store gathered the following Information regarding LIND NA Shirts: Annual Demandimorchly demand 1:12 of annual derardi 1080 11 Cool per hoodie 15 11 20% 13 Cosi per Owaishit per year as a parcentage of the cost of a sweatshit $50 S50 11 LAAG 1ma In monita 1 Standard Deviation of Demand during leac time 20 Desired Service Level should be at legel 96.00% 2-vale ------> > 1.751 17 1: 1: If you don't use wafely sok, you should place an order when the memory poeilion reacties what amount? 2: If you plan an uang safety stock, how many should have hAVA? (Glve amount of safety stack onlyi? 22 2: How much sweatshirts should be ordered when you reach the Re Order Print? 21 23 23 nter the requested information into the yellow cells. Round off to 1 decimal point (Use the data given below for questions referring to Part 2) 2: EOQ 250 units 29 Deiy Demand 25 units per day 27 Lead 1 ma in cas 10 days 29 Desired service levelshould be at least 85.50% ince: Look up z-value in tabule % ) Standard Daviation of Damand during lac Time and revien 10 SAA na halow (note this is not the daily sd of demand, but the sd over the entire review period + lead time) 91 nentory roelion 212 units in stock .22 33 Part 2, Queelin 1: What is the uplimal review period? 31 Part 2, Question 2: Wher la tha torget Ir varvary level? 3: Part 2, Question 3: How much shoulc ordered? days Junta units .17 39 22 43 41 Grading Rubrie Possible Earned Comments 15 151 10 151 15 151 20 20 20 15 151 100 10: P1 ques11 P1 Quest2 P1 Quests P2 Quest 1 1 P2 Quest 2 P2 quaat 3 Tntals + 42 49 dd Sheet1 Shoc Shocta 1 Blo GLU NA ? LE