Solve Problem

[Mamdouh Elfors]

hi
This is a table of ingredients for animal feed
The first table (column H,I,J,K) consists of feeding animals that produce 38 kg of milk per head, and the conversion rate of a kg of feed is 1.4 kg of milk.
When the milk yield changes to 36 kilos per head and the conversion rate to 1.38, I create the second table (column M,N,O,P,Q)
However, there must be some conditions (on column B, C, D, F):
Reducing concentrates (as they are the highest price and the highest quantity)
Increase of filling feed (as it is the lowest price)
Without change to vitamin, mineral and feed additives
To get the lowest possible cost in the cell (O 31)
I tried to use SOLVER in Excel to obtain feed ingredients at the lowest possible cost, but failed
I hope to solve the problem through SOLVER or any other way

Thank you.

 

[Peter Bartholomew]

It is not obvious to me what the constraints on the problem are that prevent both the concentrates and the filler feed being reduced to zero. Not that starving animals would produce a good yield!

 

[Mamdouh Elfors]

Hi
I have a problem with the solver
what is the condition I need to add to make the SOLVER select from all the materials
The problem is that I have 25 material but the SOLVER selected 4 only, I need the SOLVER to include all the 25 materials in the calculation
thanks