Recovery at Oroton Group: planning orders for core products

OrotonGroup has been working to realize benefits from a number of supply chain initiatives. While a new ERP system has provided the organization with high levels of visibility in certain areas of the supply chain, they are still finding that the stock replenishment requires fine grained data analysis and consolidation that has been difficult to achieve within the ERP system. This paper outlines a VBA for Excel application that has been implemented to facilitate the stock replenishment process in OrotonGroup. The VBApp provides the user with complete visibility of the unique data environment required to establish orders, and also allows orders to be collected and efficiently reported to other managers. The system is currently in use in the organization.