Please show $me$ exactly what $to$ put into each excel cell and solver $(screenshots)$

$An$ engineer $is$ trying $to$ formulate the minimum cost set $of$ materials $to$ use $inan$ upcoming project. There are four groups $of$ materials, and exactly one item from each group must $be$ selected. The costs are given below:

$IfB2is$ selected, then $A3$ must $be$ used. $We$ can use $at$ most one $ofA1,B1,C1,$ and $D1,$ while $we$ must have $at$ least two $ofA3,C3,C4,$ and $D3.A2$ cannot $be$ used unless $B2orC4is$ used, and the combined cost from groups $A,B,$ and $E$ cannot $be$ more than $20.$ Finally, $C1$ and $E1$ cannot both $be$ used. Formulate and solve $a0-1$ integer programming model that will determine the optimal solution.

$An$ engineer $is$ trying $to$ formulate the minimum cost set $of$ materials $to$ use $inan$ upcoming

project. There are four groups $of$ materials, and exactly one item from each group must $be$

selected. The costs are given below:

$If{B}_{2}is$ selected, then $A_3$ must $be$ used. $We$ can use $at$ most one $of{A}_1,B_1,C_1,$ and $D_1,$ while $we$

must have $at$ least two $of{A}_3,C_3,C_4,$ and $D_3.A_2$ cannot $be$ used unless $B_{2}or{C}_{4}is$ used, and the

combined cost from groups $A,B,$ and $E$ cannot $be$ more than $20.$ Finally, $C_1$ and $E_1$ cannot both

$be$ used. Formulate and solve $a0-1$ integer programming model that will determine the optimal

solution.