solution

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 or 7035.0 1234 2345 3456 Note: cells (J4 & L4) (above) contain formulas that use cell referencing – which is a requirement for responses on all assignments. 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 sweatshirts: Annual Demand (monthly demand 1/12 of annual demand) 1080 Cost per hoodie 15 Carrying Cost per sweatshirt per year as a percentage of the cost of a sweatshirt 30% Cost per order placed Lead time in months 1 Standard Deviation of Demand during lead time 20 Desired Service Level should be at least 96.00% z-value =========> $50 1.75 Question 1: If you don’t use safety stock, you should place an order when the inventory position reaches what amount? Question 2: If you plan on using safety stock, how many should have have? (Give amount of safety stock only)? Question 3: How much sweatshirts should be ordered when you reach the Re-Order Point? Part 2: Enter the requested information into the yellow cells. Round off to 1 decimal point (Use the data given below for questions referring to Part 2) EOQ 250 units Daily Demand 25 units per day Lead time in days 10 days Desired service level should be at least 95.50% (note: Look up z-value in table) Standard Deviation of Demand during lead time and rev 10 see note below (note this is not the daily sd of demand, but the sd over the entire review period + lead time) Inventory Position 212 units in stock 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