Solution-Region to minimize total time

Region to minimize total time

Assignment Help C/C++ Programming

Reference no: EM13961885

The Omega pharmaceutical firm has five salespersons, which the firm wants to assign to five sales regions. Given their various previous contacts, the salespersons are able to cover the regions in different amounts of time. The amount of time (days) required by each salesperson to cover each city is shown in the following table:

Region (days)
Salesperson A B C D E
1 17 10 15 16 20
2 12 9 16 9 14
3 11 16 14 15 12
4 14 10 10 18 17
5 13 12 9 15 11

Which salesperson should be assigned to each region to minimize total time? Identify the optimal assignments and compute total minimum time using Solver in Excel.

Reference no: EM13961885

Questions Cloud

What is relationship between social action and evangelism : What is the relationship between social action and evangelism? Should evangelism take precedence over other types of ministry? Should a church movement express the cultural identity of a single people group or of multiple people groups? What are th..

Obtain a mathematical expression for this probability : The probability that the bob will be found within a small distance delta x at x in random observations is proportional to the time it spends in this region during each swing. Obtain a mathematical expression for this probability as a function of x..

Two identical conducting spheres a and b carry equal charge : Two identical conducting spheres A and B carry equal charge. They are separated by a distance much larger than their diameters.

Conclude p must be midway between the particles. : Two point particles, 1 with charge +8*10^-9C and the other with charge -2*10^-9C, are separated by 4m.

Region to minimize total time : Which salesperson should be assigned to each region to minimize total time? Identify the optimal assignments and compute total minimum time using Solver in Excel.

What lessons about life did douglass learn as a slave : What lessons about life did Douglass learn as a slave, and what did he hope for others to learn from his story

Discussing the laws of hammurabi : Write a short paragraph (at least 3-4 full sentences) discussing the laws of Hammurabi

Determine the total charge of the insulating shell. : This conducting shell has a charge of +q on its outer surface. A larger insulating shell, inner radius d and outer radius e, has a uniform charge density -a throughout its volume.

Find the optimal solution using excel solver : Set up this problem in excel; find the optimal solution using excel solver, and the solution's sensitivity report. What are your solution and your objective function value? For each constraint: what is its shadow price, what is its slack (or, you ..

User Account

All Pages

Region to minimize total time

Reference no: EM13961885

Reference no: EM13961885

Questions Cloud

Reviews

Write a Review

C/C++ Programming Questions & Answers

Create program that uses functions and reference parameters

Write a program using vectors and iterators

Write the code required to analyse and display the data

Write a webservices application

Iimplement a client-server of the game

Model-view-controller

Design a nested program

Convert celsius temperatures to fahrenheit temperatures

Evaluate and output the value in the given base

Design a base class shape with virtual functions

Implementation of classes

Technical paper: memory management

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT