Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A motorist needs to visit a total of 6 cities over the course of the next few days and wants to minimize the total
A motorist needs to visit a total of 6 cities over the course of the next few days and wants to minimize the total distance driven to visit all 6 cities. The distances between each pair of cities is given in the matrix below, and each city has been given a number between 0 and 5 for planning purposes. The motorist needs to start and finish in City O. The motorist has set up the problem as a "traveling salesperson problem" in Solver. The decision variables are in G48:G52 and the objective function is given in cell H54. Answer the following questions regarding this problem and its setup in Solver. Use relative addressing for ALL cell/range addresses. Do NOT use any absolute addressing. All cell addresses should be upper case (e.g., A6 NOT a6). E F G H J K L M N P Q 44 45 Distances between cities 46 Index # 47 From To Distance INDEX 0 1 2 3 4 5 48 0 1 40 0 9999 40 30 50 60 20 49 1 2 30 1 40 9999 30 10 60 30 50 2 3 40 2 30 30 9999 40 25 60 51 3 4 60 3 50 10 40 9999 60 40 52 4 5 40 4 60 60 25 60 9999 40 53 5 0 20 5 20 30 60 40 40 9999 54 Total 230 55 What formula is in cell F50? Enter the entire formula, including the equal sign. What is the formula in cell H54? Enter the entire formula, including the equal sign. What is the name of the function used in cell H52? Just give the function name with no equals sign, parentheses, or arguments. What is the first argument of the function used in cell H52? What is the third argument of the function used in cell H52?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
This image describes a Traveling Salesperson Problem where a motorist needs to visit a total of 6 ci...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started