3: Optimization

It is crucial to understand that changes may be made to the Solver parameters or to the performed method at any time.

Optimization

Dealing with Optimization Problems

What is Excel Solver?

3: Optimization

Define the problem

Formulating the Problem

3: Optimization

To activate Solver Add-In:

The Excel Solver Add-In

3: Optimization

Activate Solver Add-In

3: Optimization

To calculate Total SUM:

Using Solver

3: Optimization

To copy a sheet in Excel:

Then, we must open the Excel file that contains the tourist visits data for the year 2019 in a sheet called "2019".

3: Optimization

Find the Problematic Cell Values

To use Solver with no constraints:

3: Optimization

Use Solver with no constraints

3: Optimization

To calculate the difference:

Assess the Results

3: Optimization

To calculate the difference: Month

3: Optimization

Calculate the difference

3: Optimization

So, to continue working in the same Excel file, we will create another copy of the sheet "2019",

So, given the fact that our initial Solver results are not completely satisfactory,

Tourist visits values for 2019 and data after Solver

Now we are ready to take a look to our sheet and assess the results. Taking a closer look at the Solver values for June, July and September, we observe that they are are now extremely high.

3: Optimization

Calculate the average

To calculate the average:

Calculate the Average

Arithmetic mean

3: Optimization

Use Solver with constraints

To use Solver with constraints:

Solver with Constraints

Constraint

3: Optimization

To set the Solver parameters:

To set the constraints:

3: Optimization

Set the Solver parameters

3: Optimization

In conclusion, the results of the Solver with constraints show that a holistic tourism campaign should be designed in order to increase tourist visits in every month of the year,

Tourist trips values for 2019 and data after Solver with constraints

Assess the Solver with Constraints Results

3: Optimization

Read the sentences and tick True or False.

حل Read the sentences and tick True or False.
3: Optimization

Apply the Solver function in order to design your tourism campaign for the year 2023. Can we use this data for such a purpose? Justify your answer.

حل Apply the Solver function in order to design your tourism campaign for the year 2023. Can we use this data for such a purpose? Justify your answer.

Compare the Solver function with no constraints and the Solver function with constraints. Write down two of their basic differences.

حل Compare the Solver function with no constraints and the Solver function with constraints. Write down two of their basic differences.
3: Optimization

Assess the results of the exercise 4 and compare them with the results described in the lesson. Which results do you consider more suitable for designing your tourism campaign? Justify your a

حل Assess the results of the exercise 4 and compare them with the results described in the lesson. Which results do you consider more suitable for designing your tourism campaign? Justify your a

Assess the results of the Solver function that you used in exercise 3, and explain if they are realistic or not? What other solutions do you have in order to obtain better results and why? Ju

حل Assess the results of the Solver function that you used in exercise 3, and explain if they are realistic or not? What other solutions do you have in order to obtain better results and why? Ju