excel assignment

Step

Instructions

Points Possible

1

Start Excel. Download and open the workbook named: Chapter_8_Game_Tree_Problem_Start.

0

2

In cells D22, D23, F22, F23, H22, H23, J22, and J23, do the following: By using cell references, calculate the payoffs for Firm A and Firm B for each of the game tree branches. Use cells E6-E8 and E10-E11. Enter zero as a numeric value if the payoff is zero. Note: Do not use the equal sign when entering a numeric value.

8

3

In cells D25 and D26, determine the correct decisions for each of the firms.

2

4

In cells D28 and D29, by using cell references, calculate the profit for each of the firms based on the decision made. Use appropriate cells among D22-D23, F22-F23, H22-H23, and J22-J23.

2

5

In cell F31, determine whether the threat from Firm A to combat entry is credible.

1

6

Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0

Total Points

13