Pepsico Challenge

System that allows an agile handling of the information related to the production of concentrates and purchases for the decision making process.


The Management Information System was implemented using Impromptu and PowerPlay from Cognos as development tools.


  • It integrates the information of the different Pepsi concentrate plants of America.
  • Multidimensional cubes were developed for each of the needs of analysts and managers. They reside in New York and are consulted by all the concentrate plants via Internet.
  • They allow an analysis of production indices and comparison of projections versus actuals by different variables such as date, region, plant, type of index, etc.