J. Appl. Poult. Res.
HOME HELP FEEDBACK SUBSCRIPTIONS ARCHIVE SEARCH TABLE OF CONTENTS
QUICK SEARCH:   [advanced]


     

J APPL POULT RES 1999. 8:110-121
© 1999 Poultry Science Association
This Article
Right arrow Full Text (PDF)
Right arrow Alert me when this article is cited
Right arrow Alert me if a correction is posted
Services
Right arrow Similar articles in this journal
Right arrow Alert me to new issues of the journal
Right arrow Download to citation manager
Right arrow reprints & permissions
Citing Articles
Right arrow Citing Articles via Google Scholar
Google Scholar
Right arrow Articles by Pesti, G. M.
Right arrow Articles by Seila, A. F.
Right arrow Search for Related Content
PubMed
Right arrow Articles by Pesti, G. M.
Right arrow Articles by Seila, A. F.

Research Reports

The Use of an Electronic Spreadsheet to Solve Linear and Non-Linear "Stochastic" Feed Formulation Problems

Gene M. Pesti

Department of Poultry Science, The University of Georgia, Athens, GA 30602-2772; Phone: (706) 542-1351; FAX: (706) 542-1827

Andrew F. Seila

Terry College of Business, The University of Georgia, Athens, GA 30602-6255

Correspondence: Gene M. Pesti

Typical linear programming models used by the feed industry for ration formulation include no features to account for variability in ingredient composition. Average composition values are input; therefore, the confidence in meeting nutrient restrictions is 50%. Commercial feed formulation software is available that contains non-linear "stochastic" models capable of meeting nutrient restrictions with any specified level of confidence. Such stochastic models require mean and variance values for the nutrient composition of each ingredient. Commercial stochastic programming software was offered for sale in the Spring of 1997 for $18.000. We show here how to solve the problem with spreadsheet software available for personal computers at a cost of under $300 (<$50 at our campus purchasing department). While the spreadsheet is not as powerful as the commercial software in some respects, it is capable of giving the correct answer to stochastic feed formulation problems. The models presented herein should be useful in teaching and research. They can also formulate a limited number of rations where more sophisticated commercial software is not necessary. This software is available on the World Wide Web.

Key Words: Electronic spreadsheet • feed formulation • linear programming • stochastic formulation






HOME HELP FEEDBACK SUBSCRIPTIONS ARCHIVE SEARCH TABLE OF CONTENTS
Copyright © 1999 by the Poultry Science Association.