A particularly useful Excel function in the formulation of transportation problems is the:
A) IF function
B) SUMIF function
C) SUMPRODUCT function
D) NPV function

Question

A particularly useful Excel function in the formulation of transportation problems is the:
A) IF function 
B) SUMIF function 
C) SUMPRODUCT function 
D) NPV function

Quizplus · Accepted Answer

The SUMPRODUCT function is particularly useful in the formulation of transportation problems, as it allows for the calculation of the total transportation cost by multiplying the quantity of each product transported with the corresponding transportation cost. This can be done across multiple products and multiple transportation routes. The IF function is used for logical statements, the SUMIF function is used for summing values based on a single criterion, and the NPV function is used for calculating the net present value of an investment based on a series of cash flows.

A Particularly Useful Excel Function in the Formulation of Transportation