Assume that the cola market is a Bertrand oligopoly and that Coke’s estimated demand function (based on Gasmi et al., 1992) is q_c = 58 − 4p_c + 2p_p, where q_c is the number of cases of Coke, p_c is Coke’s price per case , and p_p is Pepsi’s price per case. The average and marginal cost of producing a case of Coke or Pepsi is 5. 

a. Create a spreadsheet with Column A denoted Pepsi Price, and with Coke’s price, quantity, revenue, cost, and profit in the following columns. Enter the values 10 to 15 in increments of 1 in the Pepsi price column. Leave the Coke Price column blank. Enter the formulas for Coke’s quantity, revenue, cost, and profit functions. Because the Coke Price column is blank, the revenue and profit columns initially show what happens if the Coke price is zero – zero revenue and large losses. Use Excel’s Solver tool to determine Coke’s best price response (the one that maximizes its profit) for each Pepsi price in Column A. Solver generates a dialog box in which you should select Keep Solver Solution then click on OK. Solver enters the profit-maximizing Coke price in the Coke Price column. You must apply Solver in each row of the spreadsheet. 

b. Pepsi’s demand function is q_p = 63.2 − 4p_p + 1.6p_c. Create a new spreadsheet to determine Pepsi’s best price response to Coke prices that range from 10 to 15 in increments of 1. Verify that each firm charging a price of 13 is a Nash-Bertrand equilibrium.