Track: Modeling and Simulation
Abstract
The team designed a fully automated, user-friendly inventory management system for a small fireworks business active in the southern United States region. The company has made the decision to update their inventory management system to save time and money on the receiving and giving end of sales. Employing MS Excel with macro extensions, the team combined client, supplier, and transaction data to optimize operations. This system boosted efficiency by 50% and saved the company $30,990 annually by cutting labor, software, and system maintenance. This offered the team hands-on experience, allowing them to hone their technical skills in a real-world problem-solving environment.