Do you mean something known as the optimal diet problem i.e. the problem in which the total cost of some food products is minimized subject to the constraints describing real consumption of nutrients included in the food products being at least/at most at some predefined levels?

Dear Manon Eggink,

I suggest you to see links and attached file on subject.

https://www.youtube.com/watch?v=6xa1x_Iqjzg

https://www.youtube.com/watch?v=4gImSq1-4Kg

https://ideas.repec.org/a/pkp/apscen/2016p9vol9.html

Article Formulation of Low Cost Balanced Ration for Livestock using ...

Article USING MICROSOFT EXCEL IN FORMULATING POULTRY RATIONS BY LINE...

Best regards

Kylian Manon Eggink , this step-by-step Excel implementation may help:

http://faculty.sfasu.edu/fisherwarre/lp_solver.html

Rolando Gonzales Martinez, the example you linked is very general. It shows how to solve an LP problem without specified practical application with the Excel Solver. But will it be useful for feeding optimization?

Moreover, the recommendation for entering the data for neighbouring constraints with the same relationship separately is not good. D11

Przemysław Kowalik , I believe there is a specific spreadsheet implementation linked to first link:

http://faculty.sfasu.edu/fisherwarre/solver_with_drive.html

The links I sent are only guidance, as I do not know the exact nature of the problem, I cannot offer an exact solution.

Rolando Gonzales Martinez , I agree that nobody can help with an exact solution (or rather just an Excel implementation) of the problem when in fact no information about the problem-specific details is provided.

The text you linked is good just to begin working with the problem.

And one more link about animal feeding optimization in Excel:

http://slunik.slu.se/kursfiler/HV0050/30037.1213/UNEform-optimization.pdf

Juan Manuel Izar

Some options:

Windows User-Friendly Feed Formulation for Poultry and Swine

https://extension.uga.edu/publications/detail.html?number=RB438

Practical Program for Formulation of Rations

https://sites.google.com/site/ppfrparaexcel2007ousuperior/home

Texas Tech University Department of Animal and Food Sciences

https://www.depts.ttu.edu/afs/home/mgalyean/