Story Details
Excel Trivia
Case Results
100

The name of the airline's president

Who is Richard Cook?

100

This function returns the sum of the product of corresponding arrays or ranges

What is SUMPRODUCT?

100

The total profit found in part A

What is $302,000?

200

The three cities mentioned in the case

What is Seattle, Portland, and San Francisco?

200

These are the individual points on a graph (depicted as dots or circles) and the relationships/connections between these points (depicted as lines)

What are nodes and edges?

200

The total number of planes found in part C

What is 4 planes?

400

The name of the regional airline that pertains to this case

What is Northwest Commuter?

400

This is the mathematical technique used to find the best possible outcome in a given mathematical model

What is linear programming?

400

The total number of flights that can be flown, found in part C

What is 15 flights?

M
e
n
u