JoShop wants to assign four different categories of machines to five types of tasks. The numbers...

 

Transcribed Image Text:

JoShop wants to assign four different categories of machines to five types of tasks. The numbers of machines available in the four categories are 25, 30, 20, and 30. The numbers of jobs in the five tasks are 20, 20, 30, 10, and 25. Machine category 4 cannot be assigned to task type 4. The table below provides the unit cost (in dollars) of assigning a machine category to a task type. The objective of this problem is to determine the optimum number of machines in each category to be assigned to each task type. Use Excel Add-in Solve to solve the problem and interpret the result. (Hint: Put a big number, such as 100, in the cell at the intersection of machine 4 and task type 4) Machine category 1 2 3 4 1 10 5 15 20 2 20557 10 15 Task type 3 3 15 14 13 4 15 527 5 9 4 15 8 JoShop wants to assign four different categories of machines to five types of tasks. The numbers of machines available in the four categories are 25, 30, 20, and 30. The numbers of jobs in the five tasks are 20, 20, 30, 10, and 25. Machine category 4 cannot be assigned to task type 4. The table below provides the unit cost (in dollars) of assigning a machine category to a task type. The objective of this problem is to determine the optimum number of machines in each category to be assigned to each task type. Use Excel Add-in Solve to solve the problem and interpret the result. (Hint: Put a big number, such as 100, in the cell at the intersection of machine 4 and task type 4) Machine category 1 2 3 4 1 10 5 15 20 2 20557 10 15 Task type 3 3 15 14 13 4 15 527 5 9 4 15 8

Answer rating: 100% (QA)

SOLUTION The given problem can be formulated into exel as follows NOTE we are us... View the full answer