The Linear Programming problem will use the following instructions. Prior to beginning the exam, use these to create a model (“Living Spreadsheet”) for this problem using all three steps. Once your model is created, remember to test it thoroughly before beginning the exam.

Relax-and-Enjoy Lake Development Corp. is developing a lakeside community at a privately owned lake. The primary market are middle and upper income families. An experienced advertising firm has been engaged that has recommended that only five media outlets be used initially.

	Media
	Daytime TV	Evening TV	Newspaper	Sunday Paper	Radio
# Potential Cust per ad	1,000	2,000	1,500	2,500	300
Cost per ad	$1,500	$3,000	$400	$1,000	$100
Exposure Quality *	65	90	40	60	20

* Exposure Quality is a relative measure of demographics, image, and more
used to represent the potential customer’s responsiveness to the ad.

However, there are limitations on the number of times each month these media can be used. Radio has the greatest availability with 30 spots open. The Sunday newspaper has the least with only 4. The daily newspaper has 25 spots, daytime TV has 15, and evening TV has 10.

The corporation obtained additional financing. This campaign now has a $55,000 budget to reach at least 65,000 customers. Because of this additional funding, the TV station has reduced the cost of an evening TV spot to $2,500. Therefore management has increased the limit on TV spending to $24,000.

1) How many total TV ads are placed?

2)How many potential customers would be reached in this campaign?

3)How much money is spent on this campaign

4)How many radio ads will be placed?

Coca-Cola, or Coke, is a carbonated soft drink manufactured by The Coca-Cola Company. Originally marketed as a temperance drink and intended as a patent medicine, it was invented in the late 19th century by John Stith Pemberton and was bought out by businessman Asa Griggs Candler.Analyse Coca-Cola’s business environment using the Five Forces framework. You should use as much of the following information as possible in your analysis. Do NOT make your own assumptions.There are many kinds of energy drinks/juice products in the market. Coca-Cola does not really have an entirely unique flavour in relation to other beverages.Currently, the main competitor of Coca-Cola is Pepsi. Pepsi is an immensely popular brand in the market as well. In a blind taste test, consumers are unable to tell the difference between Coca-Cola and Pepsi.There are no consumer switching costs in the beverage industry, and capital requirements are low.The main ingredients for Coca-Cola include carbonated water, phosphoric acid, sweetener, coca leaves, and kola nuts (a source of caffeine). There are many suppliers of these ingredients and the Coca-Cola Company is likely the largest customer of any of these suppliers.Coca-Cola is seen not only as a beverage but also as an established brand. It has held a very significant market share for a long time and loyal customers are not very likely to try a new brand.Customers who buy Coca-Cola are mainly individual consumers.Coca-Cola is also stocked by large retailers like Woolworths and Coles, who tend to order in bulk. Due to end consumer loyalty, they cannot afford to leave Coca-Cola off their shelves.3a. Please create a table for Porter’s 5 forces Analysis with three columns: (1) Force, (2) Market Players, (3) Influence/Position3b. Based on your Five Forces analysis above, state and justify a strategy that Coca-Cola should adopt in its current industry.