Question On How To Create A Master Quote File

[achan040]

Hi all,

I would like to create a master workbook, preferrably a spreadsheet, of the following:

Part Number
Quantity being quoted
Price per quantity being quoted
Supplier


I would like to easily and visually see which supplier offers the lowest price per product as well as the quantity I must purchase in order to receive that price.



Problems:

There will be multiple suppliers for the same product. (product A can be supplied by supplier X and Z <-- each with their own quantity they use to quote)

There will be multiple quantities for the same product. (product being quoted can be by 5s, 10s, 15s, 20s, 25s, etc.)

There will be multiple prices for the same product. (each supplier will charge different amounts for their products)



There will roughly be 30,000 unique part numbers. Each with their own set of suppliers, quantities, and price.


Any thoughts to this dilemna?

I will be happy to clarify since my examples may be confusing.