A B C D E F G The manager of a retail store wants to pay greater attention to the efficient and effective management of product inventories. Please see the demand, lead time, and cost information provided in the next tab ("Data \& Template"). Based on this information, and assuming an optimal reorder point policy is in place, please answer the following questions: Q.1 What is the optimal order quantity? Q.2 What is the optimal safety stock? Q.3 What is the optimal fill rate? Q.4 What is the optimal annual order placement cost? Q.5 What is the expected *annual* stockout quantity in the optimum? 15 Q.6 What is the total *annual* number of order placements in the optimum? 17 \begin{tabular}{l|l|l} \hline 18 & Q.7 What is the estimated total annual logistics cost in the optimum? \end{tabular} 19 20 Q.8 The store manager looks at your work and is skeptical: "With an in-stock rate under 80%, I have a hard time believing that we wouldn't be better off providing better customer service. Why shouldn't we strive for a better in- stock rate?" Please provide your answer to the question in the answer box to the right. Questions Data \& Template (please type your answer here) 21 the right. 22 AutoSave Ooff v Assignment2_Su22 - Excel Caleb Toomey File Home Insert Page Layout Formulas Data Review View Automate Help A B C D E F G The manager of a retail store wants to pay greater attention to the efficient and effective management of product inventories. Please see the demand, lead time, and cost information provided in the next tab ("Data \& Template"). Based on this information, and assuming an optimal reorder point policy is in place, please answer the following questions: Q.1 What is the optimal order quantity? Q.2 What is the optimal safety stock? Q.3 What is the optimal fill rate? Q.4 What is the optimal annual order placement cost? Q.5 What is the expected *annual* stockout quantity in the optimum? 15 Q.6 What is the total *annual* number of order placements in the optimum? 17 \begin{tabular}{l|l|l} \hline 18 & Q.7 What is the estimated total annual logistics cost in the optimum? \end{tabular} 19 20 Q.8 The store manager looks at your work and is skeptical: "With an in-stock rate under 80%, I have a hard time believing that we wouldn't be better off providing better customer service. Why shouldn't we strive for a better in- stock rate?" Please provide your answer to the question in the answer box to the right. Questions Data \& Template (please type your answer here) 21 the right. 22 AutoSave Ooff v Assignment2_Su22 - Excel Caleb Toomey File Home Insert Page Layout Formulas Data Review View Automate Help