Each job depend on machine-job combinations

Reference no: EM13261845

Machineco has four jobs to be completed. Each machine must be assigned to complete one job. The time required to setup each machine for completing each job depend on machine-job combinations. Machineco wants to minimize the total setup time needed to complete the four jobs. Using and LP and excel solver this problem, which the followings is an optimal assignment?

Job1 (hours) Job2 (hours) Job3 (hours) Job4 (hours)

Machine 1 14 5 8 7

Machine 2 2 12 6 5

Machine 3 7 8 3 9

Machine 4 2 4 6 1

a) machine 1 to job 4

b) machine 2 to job 1

c) machine 3 to job 3

Reference no: EM13261845

Questions Cloud

Delinquents of the middle and upper class : What are the challenges and percentage of the delinquents of the middle and upper class that don't experience the factors of the low class?

How a conviction changes a probationer : How a conviction changes a probationer/parolee’s legal status with regards to searches, the exclusionary rule, and Miranda warnings

What type of time-series components : What type of time-series components would you expect for the following items?

Advantages and disadvantages of probation and parole : Identify the advantages and disadvantages of probation and parole. Describe the key problems in attempting to implement a successful re-entry program. Identify and describe the various forms of intermediate sanctions.

Each job depend on machine-job combinations : Machineco has four jobs to be completed. Each machine must be assigned to complete one job. The time required to setup each machine for completing each job depend on machine-job combinations.

Auditing tools in excel : Which of the following can be done using the auditing tools in excel

Discuss how early jazz differs from its roots of blues : Discuss how early jazz differs from its roots of blues, ragtime and brass bands. Include aspects such as improvisation, rhythm, repertory, variety and any other points you feel are relevant.

Healthcare administrator : You are a new healthcare administrator having just graduated with a bachelor’s degree in HSA. Your first job is the director of a 250 bed skilled nursing facility You are really excited about your first job as a healthcare administrator and show up e..

Effective transformational leader : Is charisma a necessary ingredient for being an effective transformational leader? can you think of any well known examples of either?

User Account

All Pages