Communities in English
Advertise on Engormix

Design and Development of Self-Made Cost-Effective Microsoft Excel Visual Basic Application for Livestock Ration Formulation

Published: July 26, 2022
By: Vishal Patil 1, Ravinder Singh Kuntal 2, Duraisamy Rajendran 2 and Radha Gupta 2 / 1 Department of Mathematics, FET JAIN (Deemed-to-be University), India; 2 Department of Mathematics, Dayananda Sagar College of Engineering, India.

One of the most important aspects of the livestock sector is ration cost optimization, which results in profit and ideal animal health. Manually preparing rations is time consuming and unsafe. Whereas computers can quickly formulate a ration that meets all of the nutritional requirements, after giving standard data on feeds. However, the existence of the ideal computer programme is questionable; if it exists, it is more expensive, less user-friendly, exclude local feeds, be limited to a particular region/country, feed composition may differ. As a result, in this chapter, the user will learn how to create and develop a self-made least-cost ration formulation using the locally available feeds, so that user may easily build their computer Programme using Visual Basic application of Microsoft Excel. There are three phases to ration formulation for any animal (ruminant or non-ruminant). The first phase requires the user to know the available feeds and their nutrient composition. The second part involves determining which nutrients are important for animals and creating nutrient equations. The third phase involves the creation of a linear programming model. Finally, the interface is being designed. Each phase is thoroughly explained in excel, with suitable data and reference coding.

Keywords: least cost ration, linear model, nonlinear model, visual basic application, nutrient requirements.


Open Access Peer-Reviewed Chapter, Animal Husbandry [Working Title]. DOI: 10.5772/intechopen.102470.

Related topics
Dr Ravinder Singh Kuntal
Rajendran Duraisamy
Would you like to discuss another topic? Create a new post to engage with experts in the community.
Create a post
Umberto Francesa
3 de noviembre de 2022
Hey guys, I would love to help but Im not going to download material without knowing the source. Why don't you give us something we can see, some regional rations, you know! The idea is great, it would help hundreds of small producers.
Hafiz Wasi Muhammad Khan
8 de noviembre de 2022
off course yes
Join Engormix and be part of the largest agribusiness social network in the world.