Bold Bodybuilders, Inc. is a large sporting goods store. It has become the exclusive distributor of the new bodybuilding equipment called Geni. After carrying the equipment for a year, Joe Sabatini, a manager of the supply chain, decided to analyze the company's inventory policy for Geni. On the basis of the past year's record, Joe has identified the following weekly demand data:

Weekly Demand Occurrence, Week

95 8

96 2

97 6

98 10

99 8

100 6

101 6

102 2

103 4

Total 52

The annual demand for Geni is considered to be 5,128 units, annual holding cost per equipment is $244, and ordering cost is $4,250 per order. The equipment price is $929 per unit. The new order is made when the inventory level in the store drops to a predetermined number of units on hand. Once the company orders Geni from the supplier, it will come to the store in about 3 weeks.

Questions (Please fill in your answer using the enclosed Excel answer template)

1. Explain what inventory planning and ordering system you are going to use in this case and why.
2. Identify the optimal order quantity and total annual inventory cost. Explain the insights of your results.
3. What are the best safety stock and reorder point that guarantees with a probability of 99% that the store will not run out of stock of Geni equipment? Explain the insights of your results.