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
Bookmarks