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 $/$/yr = 0.03 $1$/month Demand over the 12-month time horizon is: Period Demand 1 2 3 502530 4 15 5 40 6 50 7 8 4525 9 50 19 35 11 12 45 35 Total 445 3 pts Question 3 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 Based on the information in Problem 2, use the Part-Period Balancing 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. a . Period 1 Replenishment Quantity = units 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 $/$/yr = 0.03 $1$/month Demand over the 12-month time horizon is: Period Demand 1 2 3 502530 4 15 5 40 6 50 7 8 4525 9 50 19 35 11 12 45 35 Total 445 3 pts Question 3 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 Based on the information in Problem 2, use the Part-Period Balancing 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. a . Period 1 Replenishment Quantity = units