Which Formula Should Be Used to Determine the Net Flow

question 49

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)

---

Definitions:

Relevant

Relates to or directly impacts the subject under discussion.

Fixed Costs

Expenses that do not change with the level of production or sales over a short period, such as rent, insurance, and salaries.

Sunk Costs

Costs that have already been incurred and cannot be recovered.

Avoidable Costs

Expenses that can be eliminated if a particular decision is made or if a particular activity is discontinued.