contents $of$ each container.

Develop a binary integer model that will determine the two containers that will maximize the value $of$ the shipment.

$a.C_1=if$ Container $1is$ considered for shipment; $0$ otherwise

$C_2=if$ Container $2is$ considered for shipment; $0$ otherwise

$C_3=if$ Container $3is$ considered for shipment; $0$ otherwise

$C_4=if$ Container $4is$ considered for shipment; $0$ otherwise

$b.$Max$6000C_1+5500C_2+7500C_3+6000C_4$

$c\mathrm{.}5C_1+6C_2+9C_3+7C_{4}20$

$C_1+C_2+C_3+C_4=2$

for $i=1,2,3,4$

$d.$

USE EXCEL and show step $by$ step