Explain what assignment of jobs gives the minimum total, Ask an Expert

Management Studies

Six guys are to be assigned to five jobs, one guy per job (one guy will not get an assignment). Our goal is to assign jobs such that the total time is minimized. The following table gives the time in hours it takes each guy on each job. Remember that each guy, but one, gets one job.

Job 1 Job 2 Job 3 Job 4 Job 5
Adam 4 2 1 2 7
Bill 4 6 3 5 1
Charlie 3 1 7 3 1
Dave 5 1 3 2 1
Eddie 3 2 6 1 3
Frank 7 5 4 8 7

a. What assignment of jobs gives the minimum total time? This is a Transportation Problem of Linear Programming. Use Solver in Microsoft Excel©.

b. What is the minimum total time?

View complete question

Business Management, Management Studies

Category:- Business Management
Reference No.:- M9279923

Have any Question?Write your Review or question?

Related Questions in Business Management

Someone installed malware on carlos computer it records his

Someone installed malware on Carlo's computer. It records his purchases on Amazon and other sites and reports them to an agency that sends Carlo advertisements for other products. This is not a big deal. Do you agree? Ex ...

What should be done to maintain optimum stock levels and

What should be done to maintain optimum stock levels and why is it important to keep accurate and up-to-date records of stock?

Please choose an indigenous group past or present there is

Please choose an indigenous group, past or present. There is a long list of such groups here: https://en.wikipedia.org/wiki/List_of_indigenous_peoples . First, start with the facts. What was taken from or is being taken ...

Business management need example about a company

Business Management, Need example about a company organization was not able to achieve their goals. Why did this occur?

Define the two concepts moral hazard and adverse selection

Define the two concepts "moral hazard" and "adverse selection." Describe separately how the existence of each affects the market for health insurance and medical care. What are some of the ways that insurance companies t ...

Is it sensible to make employees accountable for what they

Is it sensible to make employees accountable for what they do not control? why/why not?

Explaining how professional etiquette can impact

Explaining how professional etiquette can impact professional relationships. Consistently displaying proper etiquette is a reflection of one's organization and can build or destroy business relationships. explain the imp ...

According to the national association of colleges and

According to the National Association of Colleges and Employers, finance graduates make an average of (µ) $52,402 a year. The standard deviation of annual salaries of finance graduates is (σ) $7,000. A random sample of 1 ...

True or false the implied warranty of merchantability means

True Or False: The "implied warranty of merchantability" means a seller's basic promise that the goods sold will do what they are supposed to do and that there is nothing significantly wrong with them.

The article titled data on what makes a car american is

The article titled "Data on What Makes a Car American" Is Not-So-Fine-Tuned from the Wall Street Journal before answering the questions below. Link: https://www.wsj.com/articles/data-on-what-makes-a-car-american-is-not- ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Business Management Expert