PepsiCo's environmental data systems varied widely across the organization and included spreadsheets, stand alone custom databases (MS Access, Lotus Notes, etc.), mainframe systems, document management systems, and other commercial off-the-shelf (COTS) applications.
E2 facilitated a series of requirement definition and topic prioritization workshops geared at determining the topics of most value for automation and the requirements within those topics. The workshop sessions resulted in a focusing of the longer list of potential topics into a shorter list of six core topics. Using the requirements gathered in the workshops, E2 conducted a Keep/Modify/Retire (KMR) review of legacy applications across the business units as well as an evaluation of the commercial off-the-shelf (COTS) marketplace. Based on these reviews, a short list of COTS vendors were carried forward for vendor demonstrations. E2 facilitated the vendor demonstrations by preparing demo scripts and scoring matrixes. Upon completion of the demonstrations E2 facilitated a structured evaluation and comparison session. E2 's final report of findings was structured to assist PepsiCo staff in obtaining the necessary project approvals and funding, and in justifying the procurement of the preferred vendor. Working with PepsiCo IT, E2 developed initial detailed implementation, resource responsibility/staffing, and module phasing plans.