Data Analysis project with AXON Power & Control Inventory
Axon Power & Control has built an impressive reputation for itself as a trusted partner in the power and control industry. With roots dating back to 1984, Axon has grown leaps and bounds under the guidance of its founder, the Managing Director. Today, it serves clients from a diverse range of sectors and industries not only in Ireland and the United Kingdom but also across the globe. Collaboration lies at the heart of Axon's service and customers can avail themselves of unmatched electrical engineering solutions.
The Business Development Officer identified the following issues:
1. The smooth operation of their stock control is being impeded by the presence of approximately 7000 products within the system, necessitating the utilisation of the SAP program for monitoring business inventory.
2. The company faced a challenge in determining which products were in high demand and which ones were rarely used, resulting in a stockpile of unused items that unnecessarily drain funds and occupy valuable shelf space.
3. Certain goods were falling short of their minimum standards and occasionally, the time it took to obtain these items surpassed the date on which the customer placed their order. The storage of stock levels lacked any established reference point with respect to minimum and maximum thresholds.
4. Stock was procured and then promptly used to fulfil customer orders, this process lacked a record to ascertain the regularity of stock consumption and whether any surplus should be stocked on shelves as a precaution for lengthy lead times.
The company's data analysis revealed vital information about the minimum, average, and maximum levels of stock usage. It allowed them to ascertain the specific stock quantities needed for each product, empowering them to establish optimal minimum and maximum stock thresholds in collaboration with their suppliers.