Teaching the principles of least-cost poultry feed formulation utilizing the Solver function within a computer software workbook

Author(s)
Pesti, G M
Choct, M
Chrystal, P V
Bedford, M R
Moss, A F
Publication Date
2024
Abstract
<p>A Microsoft Excel workbook, User-Friendly Feed Formulation with Data from Australia (UffdAu.xlsm), has been developed for teaching feed formulation techniques to tertiary level, university students. It runs under both Microsoft Windows and Apple iOS operating systems. The example ingredient composition matrix is based on the Australian Feed Ingredient Database to illustrate the biological and econometric principles of least-cost feed formulation. The nutrient data are based roughly on recent primary breeder company recommendations. The workbook is easily adapted to appropriate ingredients, nutrients, and prices most relevant to the students, wherever it is used. The workbook uses the linear routines of Excel's Solver add-in under the Data heading in the header Ribbon. There is a worksheet illustrating how to adapt non-linear responses such as exogenous enzymes to typical linear models using a step function. Additional worksheets illustrate how proximate analysis can be interpreted in modern analytical chemistry terms and, how various feed energy measures are related to feed composition.</p>
Citation
Poultry Science, 103(6), p. 1-8
ISSN
1525-3171
0032-5791
Link
Publisher
Elsevier BV
Rights
Attribution 4.0 International
Title
Teaching the principles of least-cost poultry feed formulation utilizing the Solver function within a computer software workbook
Type of document
Journal Article
Entity Type
Publication

Files:

NameSizeformatDescriptionLink
openpublished/TeachingPestiChoctBedfordMoss2024JournalArticle.htm 167.817 KB Published version View document