Dear All

I hope this message finds you all well.

I am trying to see whether there is a formula out there that will assist me in finding the most optimal mix of products to allocate to any particular mix of 3 suppliers. Supplier A, B and C are represented in the table below and have two different product offerings. Figures are for representation purposes only. What combination would be optimal by using excel?

A B C
PRODUCT 1 100 150 120
PRODUCT 2 120 50 170

I have tried to use the what if function but I have not been able to get my head around it. I would greatly appreciate any help offered.

Thank you
Alphonse