Abstract:
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.
