A nature center opened a gift shop a few years ago. Managing inventories has been a problem. One of the consistently selling items at the shop is a snow globe. EOQ is 145 units. Sales are 30 units per week with a standard deviation of 8 units. The lead time is 2 weeks. New orders are placed when inventory dips below 65 units.  

How to find Q = annual demand Std dev of D = standard deviation of demand L = lead time D = demand ROP = reorder point by Excel solver