This project is designed to outline the use of information technology in inventory control and inventory management. Using a dynamic Excel workbook, the provided data was cleaned, organized, and analyzed into a usable inventory tracker. This inventory data involves multiple distribution centers, and a wide variety of products and product categories.