Solved

Match Each of the Following What-If Analysis Tools to Its

Question 26

Matching

Match each of the following what-if analysis tools to its most likely use:

Premises:

Responses:

Scenario Manager

You want to know how many products your production line can make with the least waste.

Two-variable data table

You want to compare best-case,worst case and most-likely case scenarios for a business decision.

Solver

You want to compare the total interest paid on the lifetime of a loan with varying interest rates and terms.

One-variable data table

You want to know what interest rate you need to find to make a loan payment exactly $500 per month.

Goal Seek

You want to compare different calculations like monthly payment and total interest paid on a loan with the different interest rates.

Premises:

Scenario Manager

Two-variable data table

Solver

One-variable data table

Goal Seek

Responses:

You want to know how many products your production line can make with the least waste.

You want to compare best-case,worst case and most-likely case scenarios for a business decision.

You want to compare the total interest paid on the lifetime of a loan with varying interest rates and terms.

You want to know what interest rate you need to find to make a loan payment exactly $500 per month.

You want to compare different calculations like monthly payment and total interest paid on a loan with the different interest rates.

Correct Answer:

Premises:

Responses:

Scenario Manager

Two-variable data table

Solver

One-variable data table

Goal Seek