First of all I was'nt sure where would be the most suitable place to submit this thread so I tried to play it safe by posting it here in Math Topics.
I'm facing a little optimization problem. I have 3 products, let's call them A B and C. Each of them require a certain amount of ressources.
A require 4 red blocks, 2 Yellow Blocks and 1 Blue block.
B : 1 Red, 4 Yellow and 2 Blue
C : 2 Red, 1 Yellow, 4 Blue
I would like to produce as many products as possible out of the ressource I own.
Could someone help me through this so I can get an algorythm that I can use in an Excel spreadsheet where I'll only have to insert the ressource I own and find out how many of each product I should create to get as many end product as possible.
Thank you very much
EDIT: I already asked this on Yahoo answers and got an interesting answer.
=4*A1 =B1 =2*C1
=2*A1 =4*B1 =C1
=A1 =2*B1 =4*C1
=SUM(A2:A4) =SUM(B2:B4) =SUM(C2:C4)
amt red amt yellow amt blue
=A6-A5 =B6-B5 =C6-C5
On the ribbon select solver target cell is d1 (max)
adjustable are a1:c1
constraint a7>=0 b7>=0 c7>=0
Of course this is already the way to create the excel file. Unfortunately this does'nt really help me understand the math behind the formula. Also I'm having a hard time recreating this in Excel. I don't understand some part of it and why there is 1 solver case since I'm looking for 3 answers (how many A, B and C products to create.)