How to avoid result negative when running Optimizer

Dwianto · June 2024

I Want to solve Linier program issue using Anaplan optimizer.

I have following all scenario from anapedia.

But one of result show negative value like picture (Red Rectangle)

Now my question is, how to setting variable result to avoid negative value???

————————————————————————————————————————

if you curious about Liner program question here is, I am looking for cheaper expedition cost

Supply

Demand

Expedition Cost

Constraint

10AX + 11AY + 13 AZ =< 80
8BX + 9BY + 11BZ =< 70
7CX + 8CY + 10CZ =< 50
10AX + 8BX + 7CX = 60
11AY + 9BY + 8CY = 50
13AZ + 11BZ + 10CZ = 90

jasonblinn · June 2024

Hi @Dwianto

When setting the variable, you can choose a Min and Max value. In this case, just Set the Min to 0, and it will not produce a result with a negative number:

Dwianto · June 2024

Hey @jasonblinn Thankyou for your answer it's very help full..

I have another question, about using Objective Minimize and Maximize (Red Rectangle) in Optimizer menu

Base on my question above, I am looking for Minimal cost for transportation..
I have Run both Minimize and Maximize Value, but both of them show same Total Cost (Red Rectangular) like picture below, if I compare with Excel (Green Color Fill), Excel can show different total cost result…
Am I make a mistake?

Minimize Result