# How to find the lowest cost supplier-product mix?

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.

-

If you allowed fractional solutions (i.e. you could pick $2.5$ units) then this becomes Linear Programming which you can solve using lots and lots of packages widely available.