Question: please solve this problem using excel. Thank you. 5-21 In a job shop operation, four jobs can be performed on any of four machines. The

please solve this problem using excel. Thank you.

5-21 In a job shop operation, four jobs can be performed on any of four machines. The hours required for each job on each machine are presented in the following table: MACHINE X 10 14 16 13 JOB A12 A15 B2 B9 12 13 15 12 9 12 12 11 14 16 18 16 The plant supervisor would like to assign jobs so that total time is minimized. Use the assignment model to find the best solution

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A single-phase transformer has 500 turns on the primary and 40 turns on the secondary winding. The mean length of the magnetic path in the iron core is 150 cm and the joints are equivalent to an...

2. Consider the following optimal tableau, where S and S, are slack variables added to the original problem: $10 $30 $0 $0 SOLUTION MIX X X S, S, QUANTITY SIO X 1 4 2 0 160 $0 S2 -7 1 200 Z $10 $40...

2. In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like...

4. In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like...

Question 2:5 points In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant...

In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like to...

2. A Lumber Company ships pine flooring to three building supply houses from its factories in Pineville, Oak Ridge, and Maple town. Determine the best transportation schedule for the data given in...

Question 2: 10 points In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant...

5-23 In a job shop operation, four jobs can be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like...

Ms. Sabeena owns 2 furnished houses, both houses are let out for residential purposes. The details of each residential property for the tax year 2019/20 are as follows: 1st house: In 2018, She...

Certain hormones, such as epinephrine, can increase the levels of cAMP within cells. Let's suppose you pretreat cells with or without epinephrine and then prepare a cell extract that contains the...

Question 4 1 Mutual oral sex is sometimes calledOtribadism.O rimming.O tea - bagging.O fondling.O sixty - nine.

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...