Explain what assignment of jobs gives the minimum

Assignment Help Business Management

Reference no: EM1359608

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?

Reference no: EM1359608

Questions Cloud

Mental health policy or piece of legislation : Select at least one mental health policy or piece of legislation passed within the last few years that is relevant today.

Show the evolution of organizational behaviour : Explain how these schools influenced our understanding of individual behavior in the organization

Accounting for income taxes : In AT&Ts 2000 annual report, the company reported long-term deferred tax assets of $4,523,000,000 and current deferred tax assets of $1,791,000,000. What might contribute to AT&Ts need to record a valuation allowance?

Ethical and legal implications of drug testing : Discuss some of the ethical and legal implications of drug testing.

Explain what assignment of jobs gives the minimum : Explain What assignment of jobs gives the minimum total time and This is a Transportation Problem of Linear Programming

Impact of corporate taxation on accounting : What impact does corporate taxation have on the accounting profession? What type of role do you see yourself playing with regard to corporate taxation?

Which one these rights is the most important and why : Show human Rights have four important characteristics and they are universal, human rights are equal rights, not transferable and human rights are natural rights

Calculate the annualized return : From last three years, the common stock of Makkeny Corporation sold for $63.29 on the NYSE. Today, the current share price for the firm is $38.61. The company paid no dividends over this period of time and Makkeny executed a two for one stock split 2..

Revision of the dsm-iv-tr controversial : Can someone help me with an explanation of one ethical and one legal responsibility related to the release of the DSM-5 as well as help me explain at least one anticipated change in the DSM-IV-TR? Also, why is the revision of the DSM-IV-TR controv..

User Account

All Pages