I was given a Excel spreadsheet with this table:
The user wants to find the lowest price mix amongst the various suppliers. The user wants to constrain the number of products that each supplier gets using this table:
Is there a tool (Excel addin) or technique (algorithm) that would help me in trying to solve this problem?
Note: My original question was posted on Programmers.