Multiple Choice
Which formula should be used to determine the Net Flow values in cell K6 in the following spreadsheet model?
A) SUMIF($C$6:$C$16,I6,$B$6:$B$16) -SUMIF($E$6:$E$16,I6,$B$6:$B$16)
B) SUMIF($I$6:$I$12,B6,$B$6:$B$16) -SUMIF($I$6:$I$12,I6,$B$6:$B$16)
C) SUMIF($E$6:$E$16,I6,$B$6:$B$16) -SUMIF($C$6:$C$16,I6,$B$6:$B$16)
D) SUMPRODUCT(B6:B16,G6:G16)
Correct Answer:

Verified
Correct Answer:
Verified
Q18: What is missing from transportation problems compared
Q29: Clifton Distributing has three plants and
Q31: What is the objective function in the
Q36: What is the constraint for node 2
Q37: A company wants to determine the
Q38: A company needs to ship 100
Q39: Which property of network flow models guarantees
Q39: What is the constraint for node 2
Q47: Consider modeling a warehouse with three in-flow
Q54: Which method is preferred for solving fully