What formula would be entered in cell G18 in this Excel model? (Assume the objective is to minimize the total shipping cost.) A. SUMPRODUCT(K6:K12,L6:L12) B. SUMPRODUCT(B6:B16,G6:G16) c. SUMPRODUCT(G6:G16,K6:K12) D. SUMPRODUCT(B6:G16,L6:L12) Which formula should be used to determine the net flow values in cell K6 in the previous spreadsheet model? (Assume the objective is to minimize the total shipping cost.) A. SUMIF(\$C \$6:\$C \$16,16,\$B \$6:\$B \$16)-SUMIF(\$E\$6:\$E \$16,16,\$B \$6:\$B \$16) B. SUMIF(\$1\$6:\$1 \$12,B6,\$B \$6:\$B \$16)-SUMIF(\$I\$6:\$I \$12,16,\$B \$6:\$B \$16) C. SUMIF($E$6:$E$16,16,$B$6:$B$16)SUMIF($C$6:$C$16,16,$B$6:$B$16) D. SUMPRODUCT(B6:B16,G6:G16)