Anaplan Optimizer - minimize products used
Hi Optimization Pros! Would you be open to providing some input on whether this can be done in Anaplan Optimizer? I want to minimize the number of SKUs picked for shipment (i.e. we would prefer to fill a shipment by picking one SKU rather than two SKUs). These are the two designs I’ve tried with no luck.
Variable: SKU Qty
Objective: Minimize SKU Count, formula = MIN(SKU Qty, 1)
Constraint 1: SKU Qty = Prd Key Qty
Constraint 2: SKU Qty <= SKU Inventory
ERROR: Multiplication or variables only in Obj statement
Variable 1: SKU Qty
Variable 2: Binary Variable
Objective: Minimize Binary Variable
Intermediate Calc: SKU Total = SKU Qty * Binary Variable
Constraint 1: SKU Total = Prd Key Qty
Constraint 2: SKU Total <= SKU Inventory
ERROR: SKU Total is not linear and also appears to be an indirection error.
Really appreciate any guidance you can provide. Thanks!
Best Answer
-
It sounds like you'll need two variables.
Quantity Shipped, by sku, constrained to meet demand.
'SKU Is Included' , either binary or integer 0/1, also by sku,
Constrain 'SKU is Included' to be 0 when Quantity Shipped is 0 and 1 when Quantity Shipped > 0. How? Two constraints:
Quantity Shipped - 'SKU is Included' > = 0
'SKU is Included' - 0.000001 * Quantity Shipped >=0
Objective:
Minimize total 'SKU is Included'.0
Answers
-
Hello
The problem is not clear! can you provide more information on what you are trying to do ? what are the dimensions you are using? do you want to make sure you fulfill the entire demand of a given sku before you start shipping another one? or do you want to ship one sku at a time?
Can you give me the dimensions of your variables, constraints and objective function please?0 -
Dimensions are below
Variable (1 and 2): Sending Distribution Center>SKU>Receiving Distribution Center (combo list)
Objective: same as variable
Constraint 1: Sending Distribution Center>Product Key>Receiving Distribution Center (combo list)
Constraint 2: Sending Distribution Center > SKU (combo list)
0 -
The goal is to minimize the count of SKUs picked per shipment. A demand qty is provided at Product Key which must be filled with any combination of the SKUs that make up that Key.
0 -
Thanks hendersonmj! This worked and I think this tactic will open a lot of possibilities for us. I probably did something wrong as I don't see a way to accept your post as the solution.
0