The Excel inventory template found on the companion web site may be helpful for this problem. An… 1 answer below »

The Excel catalogue template institute on the colleague web locality may
be beneficial for this quantity. An Excel spreadsheet delay facts for
the quantity can also be downloaded from
Hospital purchasing sovereign Abby Smith deficiencys to prescribe examination
gloves. Currently, she prescribes 1,000 boxes of gloves whenever she thinks
there is a deficiency. Abby has heard that there is a improve way to do this and
wants to use EOQ to enumerate how abundantly to prescribe and when. She col-
lects the subjoined notice.
Cost of gloves:
Carrying costs:
Cost of prescribeing:
Lead time:
Annual demand:
33%, or $__________/box
10 days
10,000 boxes/year