Excel Solver: adding ratio as a constraint

@Alf: Thanks for the sample... I took a look a the solution and doesn't seem to be right -- Solver looks like its simply taking the 300 and 200 quantity and dropping it in along with the computed 125 figure. Also should not the 125 JAR output (D5) be 25% of the total 625? in D6 (which it is not)

@MrShorty: Some more information after reading your post:
Yes the decision variables are the amount of each ingredient.

I'm not sure what the ratio part means, that's where I'm stumped The problem verbatim is this: "The mixture must contain at least 200 Kg of Bar, 300 Kg of Foo, 100 kg of Jar, and the ratio of Jar to the other two ingredients cannot exceed 1 to 4". "What is the amount of each ingredient needed to be put into the mixture that will meet all the requirements of the mix and minimize total cost."

I've added a workbook for both your kind consideration.

Thanks for the help.