Global soft drink giant implements COLA to streamline MIS across manufacturing, supply chain & finance functions
The client is the most popular and highest selling soft drink brand in history, as well as the best known product in the world. The client has a truly remarkable heritage. From a humble beginning in 1886, it is now the flagship brand of the largest manufacturer, marketer and distributor of non-alcoholic beverages in the world. The client operates in India through its wholly owned subsidiary, which is divided into 3 business regions and 26 profit centres. Their business model includes manufacturing the beverage, distribution and sales, trade marketing and market execution.
When the client returned to India, it quickly acquired more than 25 bottling plants all over the country and invested close to $ 1 Billion US, between 1993 and 2003 (Source: a report by the Tuck School of Business, Dartmouth). This frantic pace of growth led to creation of a huge distribution system with massive gaps in the MIS reporting at the corporate level. Each plant had its own system of accounting, monitoring and inventory and lack of integration between the plant systems compounded the overall collection of data in real time. Due to the company’s bottle refilling, they are distinctly different from other FMCG operations.
Hence project COLA (Countrywide Outbound Logistics Automation) was conceptualized with a goal to integrate all functions including manufacturing, sales, distribution, finance and logistics and streamline the flow of data from the corporate MIS.
The client wanted to strengthen their enormous distribution system through integration across all profit centres, Manufacturing/Bottling Plants and Sale Depots (Direct & indirect sales) with a single application. The client were looking for an IT Services partner who could undertake this huge task of integrating various internal functions around their core MFG/PRO ERP and roll out the new COLA solution to approximately 80 locations. In particular, the client wanted a partner who could demonstrate:
- Domain expertise in Food & Beverages sector
- Credible technology and functional skills in MFG/PRO ERP
- Custom applications development, integration and rollout capabilities
- Localization knowledge
JKT, with more than two decades of experience in IT services and consulting, has a proven track providing custom solutions and ERP services across industry sectors in Microsoft, SAP, Oracle, QAD & Progress. JKT’s Enterprise Solutions practice has undertaken many turnkey ERP implementations, migrations, roll-outs and consulting assignments for many leading names in the F&B sector. JKT has developed many bolt-on solutions for the F&B industry including Excise systems, Inventory modules, POS systems, Executive Dashboards, Mobile approvals systems. Further JKT’s QAD practice is one of the leading providers of MFG/ PRO based services to the industry for over 15 years and boasts of retaining several well known customers in the MFG/PRO space.
The overall JKT-COLA program involved:
- Functional and Technical consultancy on MFG/PRO
- Customisation of Financials, Logistics/Shipping, manufacturing modules
- Solution for Handheld Terminals using RFID to capture Direct sales on various routes
- Implementation of Sales Forecasting system
- Roll-out across 80 locations including profit centres, Manufacturing/Bottling Plants and Sale Depots
- Developing Interface with MIS applications for reporting, margin/profitability analysis etc
Due to the complexity of the project, JKT implemented a joint project governance plan and put in to practice with 3 tiers; Account level, Project level and Team level. Monthly statistics were created to analyse and quantify the efficiency of the team. Coding and reviewing best practices were created and enforced in order to achieve consistent quality and productivity.
The COLA Software was initially implemented at few pilot sites to identify gaps against business requirements, improve performance and freeze the template for implementation/ rollout at other locations. JKT rolled out the final software using ‘Wave Rollout’ methodology which prioritises the locations in a sequence based on business priorities, logistics considerations and infrastructure readiness.
The new COLA solution enabled uniform transaction processing and real time MIS availability across all profit centres, manufacturing and bottling plants and distribution channels. The client was able to track the movement of products and the overall service status through a single application.