An Introduction to Management Science: 15th Edition

Chapter 5: NOTE: I need this in Excel with Solver. I know how to do this by hand, I'm looking for guidance on the excel program method.

14. Two Indiana state senate candidates must decide which city to visit the day before the November election. The same four citiesIndianapolis, Evansville, Fort Wayne, and South Bendare available for both candidates. Travel plans must be made in advance, so the candidates must decide which city to visit prior to knowing the city the other candidate will visit. Values in the payoff table show thousands of voters gained by the Republican candidate based on the strategies selected by the two candidates. Which city should each candidate visit and what is the value of the game? Democratic Candidate bi Indianapolis ai Republican Evansville az Candidate Fort Wayne az South Bend as Indianapolis Evansville Fort Wayne South Bend b2 b3 b4 0 -15 -8 20 30 -5 5 -10 -25 0 20 20 20 10 15 10