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?
To activate Solver Add-In:
The Excel Solver Add-In
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".
Find the Problematic Cell Values
To use Solver with no constraints:
Use Solver with no constraints
To calculate the difference:
Assess the Results
To calculate the difference: Month
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.
Calculate the average
To calculate the average:
Calculate the Average
Arithmetic mean
Use Solver with constraints
To use Solver with constraints:
Solver with Constraints
Constraint
To set the Solver parameters:
To set the constraints:
Set the Solver parameters
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