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

Abstract

ABSTRACT: 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. UffdAu.xlsm is available free of charge from the Poultry Hub Australia website (https://www.poultryhub.org).

Keywords

• feed formulation
• linear programming
• tertiary Instruction