Estimating Crude Protein Variability and Savings of Broiler Feeds Using Microsoft Excel

UGA Extension contacts:
Gene Pesti and Gregory Colson

This publication describes Microsoft Excel workbooks designed to calculate the effects of dividing ingredients into above- and below-average portions (2-bin method) and the costs of providing nutrients at specified confidence levels.

Authors of the original manuscript include Rashed A. Alhotan, Former Graduate Student, Department of Agricultural and Applied Economics; Gregory J. Colson, Professor, Department of Agricultural and Applied Economics; and Gene M. Pesti, Professor Emeritus, Department of Poultry Science

One source of inefficiency in poultry production comes from variation in feed ingredients. Using standard feed mixing techniques, grains and meals are each stored in their own bins (1-bin method). Linear programs are typically used to find the combination of ingredients meeting nutrient restrictions based on average ingredient compositions. To increase the probability of meeting nutrient restrictions more than 50 percent of the time, stochastic models may be implemented. For instance, feed cost may be increased by 20 percent to meet the minimum crude protein requirement in 80 percent of batches instead of 50 percent of batches. In-line equipment (such as NIR) is now available to quickly estimate ingredient compositions (e.g., percent protein) and facilitate improved formulation techniques.

This publication describes Microsoft Excel workbooks designed to calculate:

The effects of dividing ingredients into above- and below-average portions (2-bin method), and

The costs of providing nutrients at specified confidence levels.

By dividing ingredients into above- and below-average portions, efficiency is increased by improving performance due to under-feeding with below-specification batches of feed, and by minimizing waste from over-feeding.

Click the “Download PDF” link above to read the full text of this publication.

Click here to download the Stochastic Programming Workbook (1-bin method) tutorial
Click here to download the Stochastic Programming Workbook (1-bin method) Excel file

Click here to download the Stochastic Programming Workbook (2-bin method) tutorial
Click here to download the Stochastic Programming Workbook (2-bin method) Excel file

Click here to download the Crude Protein Variation Estimator Workbook (1-bin method) tutorial
Click here to download the Crude Protein Variation Estimator Workbook (1-bin method) Excel file

Click here to download the Crude Protein Variation Estimator Workbook (2-bin method) tutorial
Click here to download the Crude Protein Variation Estimator Workbook (2-bin method) Excel file

Click here to view the Truncated Normal Distribution Calculator

Published by University of Georgia Cooperative Extension. For more information or guidance, contact your local Extension office.

The University of Georgia College of Agricultural and Environmental Sciences (working cooperatively with Fort Valley State University, the U.S. Department of Agriculture, and the counties of Georgia) offers its educational programs, assistance, and materials to all people without regard to age, color, disability, genetic information, national origin, race, religion, sex, or veteran status, and is an Equal Opportunity Institution.

Our Experts

Gene Pesti

Professor Emeritus

Gregory Colson

Interim Department Head, Interim CAED Director, Professor

Status and Revision History

Published with Full Review on December 12, 2024

What is a Bulletin?

Bulletins represent a major writing effort and cover a broad subject area. They address individual topics in a particular discipline for a specific commodity.