Options
Title
Teaching the principles of least-cost poultry feed formulation utilizing the Solver function within a computer software workbook
Author(s)
Publication Date
2024
Open Access
Yes
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>
Publication Type
Journal Article
Source of Publication
Poultry Science, 103(6), p. 1-8
Publisher
Elsevier BV
Place of Publication
The Netherlands
ISSN
1525-3171
0032-5791
File(s)
Fields of Research (FoR) 2020
Peer Reviewed
Yes
HERDC Category Description
Peer Reviewed
Yes
Permanent link to this record