A leading consumers products company was experiencing tremendous business growth and the CFO and Vice President of Operations realized that the current finance, accounting and supply chain Excel based technology and workflow was not able to deliver the data quality, security, collaboration, integration, visualization and cycle times required by the business, so they engaged the KeenVision team.
Working closely with the CFO and Accounting Manager to understand their current process and future goals, we designed and configured a solution the provided daily integration of their QuickBooks General Ledger data into a robust, multidimensional database that could be leveraged for financial planning and management reporting across their critical business dimensions (account, department, product line, customer and vendor), along with providing the data security required for the finance and operation teams.
Also, we partnered with the V.P. Operation and Director of Supply Chain and designed and built a demand and inventory planning model for finished goods with an underlying data structures to calculate off of demand estimates, component units required, component cost, finished good inventory on hand and purchases required.
The Bill of Materials for each finished good was kept in a separate model for each product. We built a tool to cycle through all the models and extract the data and store the BOM’s in a database which drove COGS calculations and component items required to fulfill finished good demand.
Voice of the Customer
CFO Quote: “I’ve worked with KeenVision for the last 10 years; they know technology extremely well and they understand the needs of data-oriented CFOs even better. Their knowledge and experience enabled a design and development of an automated data workflow that included our operational supply chain data and our financial and accounting data, providing us a single source of truth and new planning, reporting and security capabilities. I would definitely partner with KeenVision in the future if the opportunity presents itself”.
By: Gary Tammaro, Managing Director