About the Company
Coca-Cola Bottling Co. Consolidated has one of the highest per capita soft drink consumption rates in the world and manages franchise territories with a consumer base of more than eighteen million people. They utilize SAP software for their enterprise resource planning. Coca-Cola came to Global Software, UK Ltd. with the need to retrieve dynamic data directly from their SAP application into Microsoft® Excel in a less complicated and inconclusive way. In addition, they wanted the ability to design financial reports on the fly with more flexibility. For these needs, and many more, Global introduced them to Spreadsheet Server and Distribution Manager.
Situation & Strategy
Coca-Cola came to Global Software, Inc. with the need to retrieve dynamic data directly from their SAP application into Microsoft® Excel in a simple, inconclusive way. In addition, they wanted the ability to design financial reports on the fly with more flexibility. Coca-Cola desired a more efficient way to examine these statements to determine profit ratios, to examine costs and selling prices and to transfer subtotals more accurately from month to month. For these needs and many more, Global introduced them to Spreadsheet Server and Budget Accelerator.
Spreadsheet Server converts Excel into a tightly integrated analytical tool for any ERP system. Users can leverage the strength of their spreadsheets with seamless dynamic integration to their information, along with powerful drilldown capability to the lowest level of detail. It allows users to build a range of reports from simple ad hoc workbooks to complex dashboard-type views of critical business data.
Distribution Manager automates the distribution of reports from Microsoft® Excel.
- Increased accuracy and flexibility in examining profit/loss statements and on-the-fly reporting
- Report distribution efficiency increased by transforming the manual, multi-step data entry process to one-click results
- Fast implementation and training for intuitive, user-friendly products
In a Nutshell
Coca-Cola has not only saved a tremendous amount of time each month working on Income statements, but they are able to achieve new capabilities. They can now perform more detailed allocations between departments within their organization and easily view forecasts for individual functions and the entire company.Download PDF - 165.92 KB