6) An engineer is trying to formulate the minimum cost set of materials to use in...

 

Transcribed Image Text:

6) An engineer is trying to formulate the minimum cost set of materials to use in an upcoming project. There are four groups of materials, and exactly one item from each group must be selected. The costs are given below: Group Group Group Group A Cost Cost Cost Cost A1 10 B1 C1 8. D1 A2 12 B2 1 C2 D2 8 A3 16 C3 11 D3 C4 13 If B, is selected, then A, must be used. We can use at most one of A, B., C, and D, while we must have at least two of A3, C3, C4, and D3. Finally, D, cannot be used unless A, or C, is used. Formulate and solve a 0-1 integer programming model that will determine the optimal solution. on Excel 6) An engineer is trying to formulate the minimum cost set of materials to use in an upcoming project. There are four groups of materials, and exactly one item from each group must be selected. The costs are given below: Group Group Group Group A Cost Cost Cost Cost A1 10 B1 C1 8. D1 A2 12 B2 1 C2 D2 8 A3 16 C3 11 D3 C4 13 If B, is selected, then A, must be used. We can use at most one of A, B., C, and D, while we must have at least two of A3, C3, C4, and D3. Finally, D, cannot be used unless A, or C, is used. Formulate and solve a 0-1 integer programming model that will determine the optimal solution. on Excel