Question: Use the Excel Solver to solve this problem. Enter objective function, cells to be changed, and constraints into the solver. Please incluse screenshots of work,

 Use the Excel Solver to solve this problem. Enter objective function,

Use the Excel Solver to solve this problem. Enter objective function, cells to be changed, and constraints into the solver. Please incluse screenshots of work, show formulas, and solver inputs. You are a sports writer working for the Tulsa Tribune. As the Big XII conference self-destructs before your eyes, your editor wants you to visit 9 present and former Big 8/12 campus location, one each day, and writ e a personal interest story about the history of the conference. Your quest starts in Owasso (your home), and ends in Stillwater (OSU). In between, you need to visit lowa State (ISU), Nebraska (NU), Kansas (KU), Missouri (MU), Oklahoma (OU), Texas Tech (TT), TCU (TCU) and Tex as (TX). You need to visit each location once and only once. You have been instructed to not consider trave ling more than 400 miles between locations. You can travel in any direction between locations. Find the shortest route starting in Owasso, visiting all 9 locations once and only once, ending in OSU. Your solution must make sense (no teleportation). The distance matrix (shown below) can be applied in either direction - thus, it is 184 miles to go from Out o TCU, and 184 miles to go from TCU to OU. QU TX TT TCU KU MU ISU NU Owasso OSU 82 450 411 263 280 325 542 326 68 OU 371 341 184 332 382 594 389 115 TX 382 189 700 674 962 731 429 TT 314 661 647 923 574 387 TCU 512 512 774 558 255 KU 156 266 149 190 MU 223 265 268 ISU 180 416 NU . 318 Owasso Some hints and other requirements

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!