Coca Cola – Andina S.A.

Embotelladora Andina S.A. is a holding of companies mainly advocated to production, distribution and marketing of Coca Cola products through operations in Chile, Brasil, Argentina and Paraguay.

Andina Argentina S.A. today’s operations covers several provinces of Argentina that consolidated computes for 1.9 million Km2 which represents 68% of Argentine territory and a population of 16.6 million people, 41% of its total population.

Andina was experiencing the traditional problems of planning on spreadsheet basis: inconsistent assumptions, undetected errors, and a lot of manual work, which produced that most of Business Analysts time was wasted building and checking numbers rather than exploring how to add value to the company.

In the year 2013 Coca Cola Andina selects Novix for developing and implementing an Integrated Business Planning Model with Cubeplan. The reasons for the selecting Cubeplan where user friendliness, flexibility and scalability, influence diagrams for representing business logic, graphical representation of every step in calculation, interpretable formulation language, easy what if analysis, multiple scenario comparison and finally users control management and empowered user collaboration.

After 6 months of development the model was in place and users were trained to take full control of model use and administration.

Now the model allows not only to produce the Business Plan and Rolling Forecast rapidly but also to answer critical questions such as: How much is the contribution margin per SKU? In which production facility is more profitable to produce? From which distribution center is more profitable to supply a particular region?