Anaplan Optimizer - minimize products used

CommunityMember115548 · 2023-03-24T18:52:58+00:00

There was an error rendering this rich post.

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!

Accepted answers

hendersonmj

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'.

All comments

dihya.atmani

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?

CommunityMember115548

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)

CommunityMember115548

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.

hendersonmj

CommunityMember115548

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.

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…