Explore BrainMass


Research Pepsico (

Using your research findings from the Library and the Internet, develop both an EFAS (External Factors Analysis Summary) table and an IFAS (Internal Factors Analysis Summary) table. The tables are to be submitted in one Excel file (one sheet for the EFAS and one sheet for the IFAS), separate from your assignment that will be written in MS Word.

You will be graded on your knowledge of the software and math in building the MS Excel tables, and on your ability to communicate in writing and present your arguments. The description of both your environmental and internal scanning process, including what factors you considered and why will be in your MS Word file.

In summary, you will submit two files: one file in MS Excel, which will count as two written pages, and one file in MS Word.

**** I am also attaching the examples he gave us for both the Excel file and the word document.. The attached are the examples of how he wants this done.


Solution Preview

About Pepsi

Pepsi Company was incorporated in 1898; 8years after Coca-cola came into existence. In 1893, the original Pepsi formula was created by a pharmacist named Caleb Bradham in New Bern, North Carolina. The drink was originally called Brad's Drink and the ingredients consisted of carbonated water, sugar, vanilla, rare oils, pepsin and cola nuts. However, on August 28, 1898, Brad's Drink was later renamed to Pepsi Cola after the ingredients pepsin and cola nuts. Due to the success of the Pepsi-Cola formula, Caleb Bradham officially created the Pepsi-Cola Company in 1902 and the name Pepsi-Cola was trademarked on June 16th, 1903.

Indra Nooyi is the current chief executive officer and President of Pepsico, Inc (PepsiCo, 2007). The first Indian born female was voted to head a western corporation on August 14, 2006. Nooyi succeeded Steve Reinemund as CEO; in the fall of 2006 Reinemund was due to retire (Mark Memmott, 2006). Nooyi received her bachelor's degree from Madras Christian College in 1974. Right away she was accepted into the MBA program at the Indian Institute of Management located in Calcutta.
PepsiCo's Chief Financial Officer is Alfred H. Drewes received his position in June of 2001. Drewes started with Pepsi in 1982 as a financial analyst. Mr. Drewes earned a bachelor of science degree in electrical engineering from the University of Massachusetts in 1978 and an MBA from Columbia University in 1982 (

Remote Environment

Generally, the remote environment of any company consists of the political, economic, technological and social factors as well as other ecological factors that affect the business.

Let's discuss the important factors affecting Pepsi

Economic Forces:

One has to monitor the economic trends like GDP trends, Interest rates, Money supply, Inflation rates, Unemployment levels, Disposable income. Opening up through WTO, free trade blocs and other agreements between countries. This has resulted in opening up of business to the world. As the restrictions have reduced, now any organization can set its business anywhere throughout the globe. For example Pepsi and Coke are pervasive and present everywhere in every corner of the world. But for Pepsi currently, the developed markets are matured and hence less growing but in other parts of world there is growth especially in Asian countries. Also events like terrorist attacks and political instability may affect the ...

Solution Summary

This provides the steps to prepare EFAS and IFAS (Environmental analysis) with the help of an example of Pepsi