Price Comparison Formula

Hi guys,

I have an excel sheet that comprises a list of 20 products. I have obtained prices of each of those 20 products from 8 different suppliers.

Now the deal is that whichever supplier I chose out of the 8, I will have to give them the order of ALL the 20 products as a package. But unfortunately, I don't know the quantity of the products required.

So I'm looking to create a formula that weighs the products when I have the quantities available. Like I want the excel sheet to weigh the product by importance because one supplier might have one product that is cheaper but there is another supplier who will be cheaper in total. I want to create a combination which tells me which supplier will cost me the least for a package of all 20 products.

Unfortunately I dont have the quantity right now thats why I was thinking if there is some way to weigh the products or give them importance in a sequence which can be used in the future when I have the quantity