Hello,
So I'm still pretty new to using Alteryx on the predictive/optimization front and could use a little help with this problem. I am trying to build a workflow designed to optimize one value, lets call it revenue, while constrained by a second, lets call it cost.
Specifically, in my data set (An example one is attached here) I have ~150 "Areas" and each one has the option to select a revenue neutral option, and increase option, and a decrease option (Columns B-D). There are in turn corresponding costs associated with and dependent on each selection (Columns F-H). The goal is to maximize the sum of total revenue across all areas while costs are constrained at some given level (In this case say 0).
I can kind of think of a brute force method that might work with a few area options but was hoping that someone might be able to provide a more elegant and efficient solution.
Thank You in advance!
