Abstract
In this document I will use the knowledge of research method for managers and try to apply the solution to an imaginary business problem. I'm going to use the techniques and tools practiced in class to a business case in the Coca-Cola Company. In this fictional case, the company wants to develop a new line of sodas for one of its biggest brand Sprite. The new line is composed of 3 new flavored sodas. Using tools like Excel and Solver, I will try to demonstrate how many cans of each new sodas the Coca-Cola company need to produce per day in order to maximize the profits given constraints of time, labor, raw materials etc.
The Coca Cola Company is one of the oldest and greatest international beverage firm. The product was invented by a pharmacian, John S. Pemberton in 1886. In 1888, Asa Candler begins to acquire personal control of the Coca Cola formula and patents from John Pemberton and his partners. He founded The Coca-Cola company in 1892 in Atlanta, Georgia (1). The company has grown to become quickly a national firm and a global firm. They have based their reputation based on a strong marketing policy. The annual advertising budget has passed from $11,000 in 1892 to a budget of 1 millions USD in 1911 (2). Some advertising are very famous around the world like the one with Santa, that help to create the modern interpretation of St Nick.
