Problem 2. Consider a scenario where the anticipated demand for SKU 1996-00-785-7777 occurs over a limited time horizon. You are tasked to determine the best replenishment schedule that is, what are the order quantities and in what periods should the orders be placed. Answer the next questions, Problem 2 parts a - d. Attach your Excel file in Problem 2e. The following information applies: Item Value = $10 per unit Order Cost = $50 per order Holding rate = 0.36 $7$/yr = 0.03 $/$/month hs Demand over the 12-month time horizon is: Period Demand 1 2 50 25 30 5 40 7 8 4525 11 45 15 19 35 50 12 35 50 Total 445 Question 3 ots Based on the information in Problem 2, use the EOQ as a Time Supply heuristic, answer the following questions. Problem 2a. What is the optimal order interval? Round to a whole number using standard rounding rules. T = periods Problem 2b. What is the size of the FIRST replenishment quantity? Enter a whole number. Period 1 Replenishment Quantity = units heuristic and answer the following questions for the FIRST replenishment quantity. (Note: You DO NOT need to calculate all replenishment quantities for the entire time horizon). Problem 2c. What is the value of A(T+1) that invokes the stopping rule for the Part-Period Balancing heuristic when determining the FIRST replenishment quantity? Express your answer to 2 decimal places using standard rounding rules. A(T+1) = $ Problem 2d. What is the size of the FIRST replenishment quantity? Enter a whole number. Period 1 Replenishment Quantity = units Problem 2. Consider a scenario where the anticipated demand for SKU 1996-00-785-7777 occurs over a limited time horizon. You are tasked to determine the best replenishment schedule that is, what are the order quantities and in what periods should the orders be placed. Answer the next questions, Problem 2 parts a - d. Attach your Excel file in Problem 2e. The following information applies: Item Value = $10 per unit Order Cost = $50 per order Holding rate = 0.36 $7$/yr = 0.03 $/$/month hs Demand over the 12-month time horizon is: Period Demand 1 2 50 25 30 5 40 7 8 4525 11 45 15 19 35 50 12 35 50 Total 445 Question 3 ots Based on the information in Problem 2, use the EOQ as a Time Supply heuristic, answer the following questions. Problem 2a. What is the optimal order interval? Round to a whole number using standard rounding rules. T = periods Problem 2b. What is the size of the FIRST replenishment quantity? Enter a whole number. Period 1 Replenishment Quantity = units heuristic and answer the following questions for the FIRST replenishment quantity. (Note: You DO NOT need to calculate all replenishment quantities for the entire time horizon). Problem 2c. What is the value of A(T+1) that invokes the stopping rule for the Part-Period Balancing heuristic when determining the FIRST replenishment quantity? Express your answer to 2 decimal places using standard rounding rules. A(T+1) = $ Problem 2d. What is the size of the FIRST replenishment quantity? Enter a whole number. Period 1 Replenishment Quantity = units