Exhibit 11.21
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use Winter's method to forecast sales.
-Refer to Exhibit 11.21. The store wishes to use Solver to find the optimal values for cell E6. Provide the following Analytic Solver Platform (ASP) settings.
Objective Cell:

Variables Cells:

Constraints Cells:

Question

Exhibit 11.21
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use Winter's method to forecast sales. 
-Refer to Exhibit 11.21. The store wishes to use Solver to find the optimal values for cell E6. Provide the following Analytic Solver Platform (ASP) settings.
Objective Cell:
​
Variables Cells:
​
Constraints Cells:

Quizplus · Accepted Answer

The Answer of Exhibit 11.21
The following questions use the data below.
A store wants to predict quarterly sales. The owner has collected 3 years of sales data and wants your help in analyzing the data. He wants to use Winter's method to forecast sales. 
-Refer to Exhibit 11.21. The store wishes to use Solver to find the optimal values for cell E6. Provide the following Analytic Solver Platform (ASP) settings.
Objective Cell:
​
Variables Cells:
​
Constraints Cells:

Exhibit 11.21 The Following Questions Use the Data Below