Hi everyone,

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.

=SUM(A1:C1)

=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.)

Thanks again.