Answered step by step
Verified Expert Solution
Link Copied!

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

image

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic management concepts

Authors: Fred david

13th Edition

9780136120988, 136120997, 136120989, 978-0136120995

More Books

Students also viewed these General Management questions

Question

Why do some individuals confess to a crime they did not commit?

Answered: 1 week ago