As Ms. Highgrove is extremely busy, she has retained your professional services to prepare a consulting report answering these questions:
- What are good estimates of order cost and inventory-holding cost for Strike Disinfectant?
- What is the recommended economic order quantity for this SKU?
- What is the reorder point with safety stock for Strike Disinfectant to offer a 97% service level?
- What are the savings over the 16-week period resulting from the implementation of a fixed quantity system (FQS) compared to the existing practice?
Include your Excel file with all calculations.