Question: Please do a linear program using excel thanks Please formulate an LP on excel. 14. Two Indiana state senate candidates must decide which city to

Please do a linear program using excel thanks
Please formulate an LP on excel.
14. Two Indiana state senate candidates must decide which city to visit the day before the November election. The same four cities--Indianapolis, 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? Indianapolis a Republican Evansville az Candidate Fort Wayne az South Bend a4 Democratic Candidate Indianapolis Evansville Fort Wayne South Bend bi b2 by b4 0 -15 -8 20 30 -5 5 -10 10 20 20 20 10 15 -25Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
