# Optimizer Help

Options

I am trying to learn and understand how optimizer works in Anaplan and need some assistance in overcoming a roadblock. I am going over a practice problem that I have created in excel and am having difficulties with one of the constraints.

The Problem: Without getting to into the weeds this practice problem is about making three products (Wine, Juice, Jelly) with 5 different grape grades (scale 1-5 where 5 means excellent). Objective function is to maximize profit with the constraint each grade only has so many lbs. of grapes available and the rating of the products have to be within a threshold. The Variable is how many lbs. of grapes to use for each grade and product. I will share pictures below.

Solved Problem in excel:

Blue: given information

Green: Constraints

Yellow: Objective function

Purple: Variable

Solver Parameters:

Excel with Formula text:

The Issue:

The Only issue that I am running into is the constraint of Current Rating >= Required Total Rating. The error I recieve "The Constraint 'Rating CON check?' is invalid. It should be of the form Ax >= B, not Ax >= Bx.
Change your formula so that only one side of the Constraint is dependent on variables."

My Question:

So is a problem like this not possible to solve in optimizer because of the restraints is Ax >= Bx? Since, I have the solution in excel I can copy and paste the current rating so that it is A >= Bx and optimizer solves that, but that kind of defeats the purpose. Is there any work around to find a solution? Thanks

Tagged:

Options

Hi

can you change formula into this AX - BX >= 0.

In optimizer you need to have Variables on one side and constants another side