You Can Set Up Complex Business Models in a Worksheet

question 130

Multiple Choice

You can set up complex business models in a worksheet and use Solver to determine the optimal set of decision inputs to improve profitability, such as minimizing costs or ____ income.

• A) maximizing
• B) reducing
• C) cutting
• D) lowering

---

Definitions:

Moving Average Method

A statistical technique used to analyze time series data by calculating averages of different subsets of the complete dataset.

9-year Moving Averages

A method of smoothing data by calculating the average of different subsets of the total data period of nine years each.

Seasonal Variation

Regular fluctuations in a time series variable within a year, often related to the seasons.

Random Variation

The unpredictable changes in data that cannot be attributed to any specific cause.