Food and Beverage

Coca-Cola Andina

Embotelladora Coca-Cola Andina S.A.

Food & Beverage / Argentina

Food and Beverage

Embotelladora Andina S.A. produces, distributes, and markets Coca-Cola products through operations in Chile, Brazil, Argentina and Paraguay. Andina Argentina S.A. operations cover several provinces of Argentina accounting for 1.9 million Km2, representing 68% of the Argentine territory and 41% of its total population.

Andina was experiencing problems commonly associated with the use of spreadsheets: inconsistent assumptions, undetected errors, and a lot of manual work. Business Analysts time was wasted time error checking and validating data rather than exploring how to add value to the company.

In 2013 Coca-Cola Andina selected Pyplan for developing and implementing an Integrated Business Planning Model. The reasons for the selection were user friendliness, flexibility and scalability, influence diagrams for representing business logic, graphical representation of every step in the calculation, interpretable formulation language, easy what-if analysis, multiple scenario comparisons, and finally user controlled management and collaboration.

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

The model rapidly produces the Business Plan and Rolling Forecast. It provides answers to critical questions such as:

  • How much is the contribution margin per SKU?
  • In which production facility is it more profitable to produce?
  • From which distribution center is it more profitable to supply a particular region?