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!