Please select one from these multiple choices.

$1-$ What is the purpose of transportation analysis in Excel?

To optimize the allocation of resources in a transportation network

To calculate the shortest path between two points

To analyze the efficiency of a transportation system

All of the above

$2-$ Which Excel tool is commonly used for solving transportation problems?

Solver

Goal Seek

Data Analysis Toolpak

Scenario Manager

$3-$ In transportation analysis, what is the objective of the transportation model?

Minimize the total transportation cost

Maximize the total transportation distance

Minimize the number of transportation routes

Maximize the total number of transportation units

$4-$ What is the difference between the transportation problem and the assignment problem?

The transportation problem is more complex than the assignment problem.

The assignment problem is a subset of the transportation problem.

There is no difference; they refer to the same problem.

The transportation problem deals with allocating resources to destinations, while the assignment problem deals with assigning tasks to workers.

$5-$Which Excel function is commonly used to represent supply and demand constraints in transportation analysis?

SUM

COUNT

MIN

MAX