Modular tool for dairy cow ration optimization: spreadsheet based approach
Keywords:
linear programming, weighted goal programming, penalty function, spreadsheet ration optimization, dairy economicsAbstract
Paper presents developed spreadsheet tool for dairy cow ration formulation It is constructed on the basis of two linked modules in MS Excel platform, merging common linear programming and weighted goal programming model with penalty functions. The frst module estimates the least-cost magnitude that might be expected. Obtained result enters into the second module as goal that should be met as close as possible. The tool was tested at two different values of preferential weights for dairy cow with 20 kg daily milk yield. Obtained results confrm benefts of applied methodology since one is enabled to formulate least-cost ration and simultaneously overcome major drawbacks of LP approach. Besides fne tuning of set goals rational violence is enabled through penalty function system. As result calculated ration is more effcient both from economic and nutritive point of view.
Downloads
References
2. Ferguson E.L., Darmon N., Fahmida U., Fitriyanti S., Harper T.B., Premachandra I.M. 2006. Design of Optimal Food-Based Complementary Feeding Recommendations and Identifcation of Key »Problem Nutrients« Using Goal Programming. The Journal of Nutrition, 136, 9: 2399-2404
3. Gass S. 1987. The setting of weights in linear goal-programming problems. Computers and Operations Research, 14, 3: 227-229
4. KIS. 2007. Model calculations (unpublished). Agricultural institute of Slovenia
5. Lara P., Romero C. 1994. Relaxation of Nutrient Requirements on Livestock Rations through Interactive Multigoal Programming. Agricultural Systems, 45, 4:443-453
6. Rehman T., Romero C. 1984. Multiple-criteria decision-making techniques and their role in livestock ration formulation. Agricultural Systems, 15, 1:23-49
7. Rehman T., Romero C. 1987. Goal Programming with penalty functions and livestock ration formulation. Agricultural Systems, 23, 2:117-132
8. Rehman T., Romero C. 1993. The Application of the MCDM Paradigm o the Management of Agricultural Systems: Some Basic Considerations. Agricultural Systems, 41, 3: 239-255
9. Tamiz M., Jones D., Romero C. 1998. Goal programming for decision making: An overview of the current state-of-the-art. European Journal of Operational research, 111, 3: 569-581
10. Waugh F.V. 1951. The minimum-cost dairy feed. Journal of Farm Economics, 33, 299-310
11. Žgajnar J., Kermauner A., Kavčič S. 2007. Model za ocenjevanje prehranskih potreb prežvekovalcev in optimiranje krmnih obrokov. In: Slovensko kmetijstvo in podeželje v Evropi, ki se širi in spreminja. 4. konferenca DAES. Kavčič S. (ed). Ljubljana, Društvo agrarnih ekonomistov Slovenije, Domžale, 278-288
12. Žgajnar, J., Erjavec, E., Kavčič, S. 2010. Multi-step beef ration optimisation: application of linear and weighted goal programming with a penalty function. Agricultural and Food Science. 19(3): 193-206
