Using the Quantitative Inventory Analysis Template for the following problem:

Hospital purchasing agent Abby Smith needs to order examination gloves for the hospital. Currently, she orders 1,000 boxes of gloves whenever she thinks there is a need. Abby has heard that there is a better way to do this and wants to use economic order quantity to determine how much to order and when to order. She collects the following information.

Cost of the gloves: $4.00 per box Carrying costs: 33%, or $__________ per box Cost of ordering: $150 per order Lead time: 10 days Annual demand: 10,000 boxes per year

a. Tab 1 (Basic EOQ/ Economic Order Quantity) What quantity should Abby be ordering? Prove that your order quantity is "better" than Abby's by graphing ordering costs, holding costs, and total costs for 1,000, 1,500, and 2,000 boxes.

b. Tab 2 (ROP no SS/ Reorder Point No Safety Stock) How often will Abby need to order? About how many days will there be between orders?

c. Tab 2 (ROP w SS/ Reorder Point No Safety Stock) Assuming that Abby is not worried about safety stock, when should she place this order?

d. Tab 3 (ROP w SS/ Reorder Point with Safety Stock) Abby decides she will be happy if the probability of a stockout is 5 percent. How much safety stock should Abby carry?

Items to include are outlined as follows: ? Length of assignment 1 excel sheet / 3 tabs o 1 excel spreadsheet ? Tab 1 EOQ (Economic Order Quantity) ? Tab 2 ROP no SS (Reorder Point No Safety Stock) ? Tab 3 ROP w SS (Reorder Point with Safety Stock)

TO File G23 1 10 10 11 12 13 14 15 19 16 19 17 18 10 19 24 25 26 29 20 34 33 34 22 38 39 40 41 42 43 44 45 H A Quantitative Inventory Analysis A X O Mail - Webster, Rebecca Brown X V Quantitative Inventory Analysis Template 1 Home Insert Draw Page Layout Formulas Data Review View Automate Help 10 AA BI U ab D G Av B Arial X https://libertyuniv-my.sharepoint.com/:x:/r/personal/rbkudjo_liberty_edu/_layouts/15/Doc.aspx?sourcedoc=%7B0C60E2FA-20A7-49C3-8E36-17365D81BFE6%7D&file=Quantitative%20Inventory%20Analysis%20Template... A fx D Instructions E F Calculation Mode: Automatic Workbook Statistics Type here to search G Basic EOQROP no SS H Excel | Microsoft 365 I ROP w SS + 99+ J Notes on Using the EOQ Template All values in blue cells are to be entered by the user. All other values are automatically calculated and do not need to be altered. Each worksheet has a sample value set entered. Make sure to clear all values before proceeding with your own data. Cells with red marks in the upper right corner have comments. Let the mouse hover over those cells to read the comments to further explain the template model. This spreadsheet is locked to keep the cells with equations from being changed. K ( X Search (Alt + Q) L Eva Wrap Merge General Quantitative Inventory Analysis T X w Document22.docx M N O Q $5.000 3 SX R + S T U V W X Comments Y Z 73F Sunny M Catch up 0- AA ... AB 10 Editing AC Give Feedback to Microsoft 0 (64))) B - AD X G Share 8:12 AM 7/15/2023 RW V 100% +