Need help with the optimization tool!

Question

I would like to use the Optimization tool to maximize the weighted average revenue of my data but I cannot figure out how to properly configure the Optimization tool. I have variables a-g each with a pct weight that I want to apply to the Revenue field. Basically I want to find the max weighted average of the revenue and pct field while making sure the sum of the pct field is 1 and also making sure to bound the individual pct variables. Can someone please help me!? Thank you

Dummy_Revenue_Data.xlsx

philipmannering · Answer

I still don't fully understand. But had a go anyway. If the percentages are our decision variables then this is what we get,

If I've misunderstood, maybe you could explicitly lay out the objective function and constraints. Or maybe seeing how the Optimization Tool is set up will still help. Happy to help further.

Optimize Percentages.yxmd

Rwebber1991 · Answer

The pct field is the starting point. It is essentially the weighting for the weighted average.

philipmannering · Answer

So... is the current [pct] field in the data irrelevant, because you are deriving a new (and optimized) pct value between the lb and ub?