Maximizing an objective that is a ratio
I would like to be able to maximize the total Value/Ore, rn I just have it as being able to select the material manually and then it calculates what the Value/Ore is.
How would I go about this optimization problem? I was thinking about using simplex on the excel solver, but idk if this would work for an objective that is a ratio (Value/Ore). iirc the solver can't select from a dropdown either so I'd need to create a binary matrix.
I could brute force it too, but this is not the only set of factories I will be optimizing, there will be other tables with possibly 10+ factories, so I imagine it will get to a point where brute forcing is unreasonable.
Anyone got an idea on what the cleanest and most effective way to go about solving this would be? Note: I would like the materials that are used in the calc to be toggleable too.
[link] [comments]
Want to read more?
Check out the full article on the original site