Formation and Designing of “Least-Cost Ration Formulation Application of Cattle” Using Excel VBA

  • Vishal PatilEmail author
  • Radha Gupta
  • D. Rajendran
  • Ravinder Singh Kuntal
Part of the Asset Analytics book series (ASAN)


The present study is focused on the development of Excel VBA application for minimizing the cost of ration for cattle livestock, based on linear programming model. This application is designed in such a way that common dairy farmers can also use it easily. A variety of software has been developed to deal with the nutrient requirement of animals and minimization of feedstuff cost. However, existing software has not been widely used by majority of small dairy farmers due to lack of awareness, availability and basic skills required for using. This application does not require any advanced software and expertise. To operate, only Microsoft Excel should be installed. The application requires some basic information as an input like weight and age of the cattle, milk yield, milk fat, feeds available, pregnancy status of the cattle. Based on this information, it will calculate the requirement of dry matter and energy, protein, calcium, etc., and after a single click on button “SOLVE”, it will show least-cost ration along with quantity and cost of each feed. In addition, it will also show whether there is a profit or loss. The solution obtained for the livestock formulation problem of cattle in a particular region of Karnataka is validated as per ICAR standards in discussion with experts from NIANP, Bangalore, and is found to be well acceptable.


Excel VBA Ration formulation Nutrients Software Linear programming model 


  1. 1.
    Department of Animal Husbandry, Dairying and Fisheries, Ministry of Agriculture and Farmers Welfare, Govt. of India, Annual Report (2015–16)Google Scholar
  2. 2.
    Janzekovic M, Rozman C, Pazek K, Pevec P (2014) Mathematical model for balancing feed rations in dairy cows. In: DAAAM international scientific book, pp 153–162, Chapter 12Google Scholar
  3. 3.
    Saxena P (2010) Feed formulation software: a comparative study. Feedtech Int Feed Prod Technol 1(8):20–21Google Scholar
  4. 4.
    Patil V, Gupta R, Rajendran D, Kuntal RS (2017) Comparative study on feed formulation software—a short review. Int J Res-Grathaalayah 5(4):105–115, RASTGoogle Scholar
  5. 5.
    Feed Formulation (2008).
  6. 6.
  7. 7.
    Angadi1 UB, Anandan S, Gowda NKS, Rajendran D, Devi L, Elangovan AV, Jash S (2016) Feed assist—an expert system on balanced feeding for dairy animals. In: Agris on-line papers in economics and informatics, vol 8, pp 3–12Google Scholar
  8. 8.
    Hossain ME, Das GB, Akbar MA (2015) Formulation of least cost Dairy Ration for small scale Dairy Farms using ‘Solver Add‐Ins’ in Microsoft Excel. Iran J Appl Anim Sci 5(3):561–567Google Scholar
  9. 9.
    Patil V, Gupta R, Maria U (2015) Application of heuristic approaches by comparative study of bench mark problems. In: Second international conference on recent advances in science and engineeringGoogle Scholar
  10. 10.
    Patil V, Gupta R, Rajendran D, Kuntal RS (2016) Design and validation of ration formulation of cattle—a research investigation. Int J Control Theory Appl 9(42):251–258Google Scholar
  11. 11.
    Rajendran D, Swain PS, Rao SBN, Prasad KS (2015) A user friendly ration balancing tool for feeding of dairy animals: compendium of model training course on recent development in animal feeding practices. Conducted at ICAR-NIANP from January 2015:13–20, pp 17–24Google Scholar
  12. 12.
    TU-Ilmenau, Fakultät für Mathematik und Naturwissenschaften, Abebe Geletu (2007) Solving optimization problems using the matlab optimization toolbox—a tutorial, pp 6–139Google Scholar
  13. 13.
    Goswami SN, Chaturvedi A, Chatterji S, Patil NG, Sen TK, Hajare TN, Gawande RS (2013) Least cost diet plan of cows for small dairy farmers of Central India. Afr J Agric Res 8(47):5989–5995Google Scholar
  14. 14.
    Garg MR, Makkar HPS (2012) Balanced feeding for improving livestock productivity: food and agriculture organization of the United NationsGoogle Scholar
  15. 15.
    Ghosh S, Ghosh J, Pal DT, Gupta R (2014) Current concepts of feed formulation for livestock using mathematical modelling: animal nutrition and feed technology, pp 205–223Google Scholar
  16. 16.
    Onwurah FB (2011) Excel feed formulation and feeding models. Greener J Agric Sci 027–031Google Scholar

Copyright information

© Springer Nature Singapore Pte Ltd. 2019

Authors and Affiliations

  • Vishal Patil
    • 1
    Email author
  • Radha Gupta
    • 2
  • D. Rajendran
    • 3
  • Ravinder Singh Kuntal
    • 1
  1. 1.Department of MathematicsJain UniversityBangaloreIndia
  2. 2.Department of MathematicsDayananda Sagar College of EngineeringBangaloreIndia
  3. 3.NIANP (National Institutes of Animal Nutrient and Physiology)BangaloreIndia

Personalised recommendations