Export to

Contact Us

Abstract of Applied Sciences and Engineering

June 2016, Volume 9, 9, pp 9

Linear Programming and Excel Solver Functions for Dairy Ration Calculation

M. Gorgulu, N. Koluman, S. Goncu, U. Serbester

M. Gorgulu 1 

N. Koluman 1 S. Goncu 1 U. Serbester 1 
  1. Animal Science Department, Faculty of Agriculture, University of Cukurova, 01130, Adana, Turkey 1


Abstract:

Feed input occupies the most significant place in animal production costs. Reducing feed input cost is very important in terms of obtaining maximum farm profit. Animal feeders have used linear programming method very extensively after it has been adopted to the practice. Because diet formulation is a typical linear programming problem. Linear programming is a decision tool for optimum allocation of limited or scarce resources. The diet formulation is a typical linear programming problem. Feed industry is manufacturing tremendous feed and feed cost in animal production is a major part of total cost. Least cost diet formulation may therefore increase profit of farm and feed industry. Introducing linear programing to the staffs in animal production practice and academia may results in cost and environmentally effective diets when nutritional knowledge introduced to computer properly. Generally each office computer has excel program and excel has solver add-in. This add-in has capability to optimize different models. In this workshop, it is aimed to explain how linear programming solutions can be accomplished in Excel worksheet environment by people dealing with diet formulation with practical work.

Keywords:

Linear programming, Excel solver functions, Dairy, Ration calculation.

Statistics:

Google Scholor ideas Microsoft Academic Search bing Google Scholor

Funding:

Competing Interests:

Acknowledgement: