EuroOffice Modeller - Optimization
Basic Optimization - Overview and Example (linear optimization)
Use Modeller to determine the maximum or minimum value of one cell by changing other cells. For example, you can change the amount of elements of your diet and see the effect on the cost. amount.
Let us examine the following example:
The level of cup of drinks indirectly determining the amount of vitamins and calories, and the cost. Modeller can change the amounts of dietary drinks (cells B23:C23), while satisfies the daily reqiirements (cells C35:C39) until the value for the total cost reaches the minimum possible cost. The values in the decision variable cells are related to the formula in the target cell B24.
After Solver runs, the new values are as follows: