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!
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
Minimize total 'SKU is Included'.0
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