?? A company was awarded a contract that will require a total of 150 labor hours and

??

Transcribed Image Text:

A company was awarded a contract that will require a total of 150 labor hours and involve three workers. 'Worker A' must be assigned at least 40% of the total number of hours assigned to the other two workers but is available a maximum of 50 hours for the project. 'Worker C must be assigned at least 15% of the total contract hours but must not exceed 25% of the total number of hours assigned to the other two workers. Workers A, B, and C earn $30, $25, and $18 per hour, respectively. The objective is determine the optimal number of hours to be assigned to each worker in order to minimize cost. The resulting linear model for this problem is given below. Min 30A +258 +18C S.T.: A + B + C = 150 A-0.4B -0.4C >= 0 A = 0.15(150) C-0.25A -0.25B = 0 Run Excel Solver and generate the Answer and Sensitivity Report What is the optimal allocation of hours? A hours hours hours B C What is the total cost? A company was awarded a contract that will require a total of 150 labor hours and involve three workers. 'Worker A' must be assigned at least 40% of the total number of hours assigned to the other two workers but is available a maximum of 50 hours for the project. 'Worker C must be assigned at least 15% of the total contract hours but must not exceed 25% of the total number of hours assigned to the other two workers. Workers A, B, and C earn $30, $25, and $18 per hour, respectively. The objective is determine the optimal number of hours to be assigned to each worker in order to minimize cost. The resulting linear model for this problem is given below. Min 30A +258 +18C S.T.: A + B + C = 150 A-0.4B -0.4C >= 0 A = 0.15(150) C-0.25A -0.25B = 0 Run Excel Solver and generate the Answer and Sensitivity Report What is the optimal allocation of hours? A hours hours hours B C What is the total cost?