Footlocker experiences demand for a popular athletic shoe that is nearly constant at 800 pairs per week. The cost per pair is $54. It costs $72 to place an order, and annual holding costs are charged at 22% of the cost per unit. The lead time is two weeks.

What is Footlockers economic order quantity for this athletic shoe?

What is Footlockers reorder point?

What is Footlockers cycle time?

What is the total annual cost?

Develop your EOQ Inventory Model for Footlockers athletic shoe in Excel.

Attach your Excel spreadsheet.