Program to Estimate Feedlot Cost of Gain (FLCALC Revision 3)
Electronic spreadsheets can be used to evaluate the performance and profit potential of cattle confinement operations. This publication describes the methods for estimating cattle performance and financial aspects of cattle feeding using a spreadsheet program. The program described was written using Excel.
Gains can be estimated from past experience or by using net energy equations, which have been used for years to predict feedlot gain with a high degree of accuracy. When predicting gains with the program, the user is asked to calculate the Net energy for maintenance (NEm) and Net energy for gain (NEg) using values of the diet on a dry matter basis. The user then inputs the expected average daily feed intake for the feeding period. Cattle feeders will often estimate feed intake from past feeding experience. If in doubt, custom feedlots can usually help cattle owners estimate feed intake. The following rules of thumb may be helpful. With light weight cattle, dry matter intake approaches 3 percent of their weight. Most larger feedlot cattle will not average over 2 to 2.5 percent of their mean feeding weight. The mean feeding weight is calculated and shown in the upper right of the screen and print out.
Estimation of average daily gain can be checked using the energy values calculated
from the ration. If feed energy values or feed intakes are set too high, calculated
gain will be too high, and conversely if set too low. Data are expressed on a pay-to-pay
The original version of the program used the 1974 NRC equations, which were developed in the 1960s for steers and heifer calves. Over the years, additional growth potential has been bred into cattle. By providing the additional six equations published in the 1984 NRC Nutrient Requirements of Beef Cattle, the user should be able to better match this program to the cattle being fed. The two original equations are retained for reference and for the many cattle to which they still apply.
Inputs necessary to evaluate a cattle feeding venture involve the usual cattle and financial information, along with the cost, moisture content, and net energy values of the feedlot ration. This program is designed for the user to enter data on a trial basis, i.e. make an entry and see what impact it has on the cost of gain or profitability.
The program format is shown in Table 1. In copies of this program distributed by OSU, all cells except those the user should change are protected. The protection of cells containing equations is necessary because any value entered over a calculated number will result in the equation being erased. The unprotected cells requiring inputs (boldface in Table 1) are listed below in the same order that they appear on the screen.
- Cattle cost ($/cwt.) delivered to the lot.
- Purchase weight in pounds (this program works pay-to-pay).
- Days to be fed (days on feed).
- Animal frame size and sex type 1-8.
- Feed cost ($/ton on an as fed basis).
- Dry matter content of ration (%).
- Expected selling price ($/cwt) of the cattle at market time.
- Equity in the cattle ($/head, Interest free money).
- Cattle finance rate (%).
- Freight to the feedlot ($/head).
- Estimated death loss (%).
- Medical cost ($/head).
- Beef check off ($/head).
- Other costs such as hedge or option costs ($/head).
- Yardage cost, if charged ($/day).
- Estimated feed intake (average pounds of dry matter/day).
- Estimate of daily gain in pounds/head/day.
- Interest cost on the operating capital (%).
- Ration inputs (upper right side).
Ration NEm (entered as mcal/100 pounds).
Ration NEg (entered as mcal/100 pounds).
Both of these items should be on a dry matter basis.
Note in the listing that some very critical data and equations are stored in column one (off the sheet) on an 80-column screen. These are the net energy equations and a number of other critical statements. This is done to avoid clutter on the screen. The net energy equations used are the steer and heifer equations published in the 1976 and 1984 editions of the NRC Nutrient Requirements for Beef Cattle. These equations have worked well for estimations made on a pay-to-pay basis assuming normal and reasonable weighing conditions and shrinks. When making modifications to the program, it is critical that these statements not be damaged. It is recommended to renamed the working copy before making modifications.
Body Type: Eight net energy equations (Table 2) are included in this program. They are based on (1-6) the 1984 NRC equations. Equations 7 and 8 were used in the original version of this program. The two original equations were used most frequently in receiving programs where weight gain was often a recovery of purchase weights. The equations for large frame cattle (2 and 3) will result in more gain on the same amount of feed. Select the equation that best describes the cattle being fed. Equations 7 and 8 describe what some might call small frame cattle today. The equation selected is identified on the sheet.
This program uses a circular calculation to estimate mean feeding weight because the mean feeding weight of the animal cannot be determined until the program is recalculated.
Table 2. Animal frame and sex type selection table.
|1||Large-frame bull calves and compensating large-frame yearling steers.|
|2||Large-frame heifer calves and compensating medium-frame yearling heifers.|
|3||Large-frame steer calves and compensating medium-frame yearling steers.|
|5||Medium-frame heifer calves.|
|6||Medium-frame steer calves.|
|7||NRC 74 steer equation.|
|8||NRC 74 heifer equation.|
Some cattle feeders may desire more options for evaluating weather conditions, cattle types, multiple rations, or modifications of the energy requirements. In these cases, users may wish to use OSU Beefgain, which is a more flexible program. It may be obtained from Extension Animal Science at Oklahoma State University.
In many areas of the country weather and other factors affect cattle performance. To the right of the spreadsheet is the option to increase or decrease the efficiency of cattle by the month that they are marketed. The default value for no change is 100. If expected performance falls below the norm for cattle marketed in March, entering 95 implies that the close out gain would be only 95 percent of the expected performance. These factors only apply to the gain computed using net energy values. They do not apply to the input expected gain to the left of this value.
A suggested set of default values for Oklahoma feedlots might be: January 98, February 97, March 96, April 95, May 98, June 99, July 100, August 101, September 102, October 103, November 100, and December 99. Both feeding conditions and the acclamation background of the cattle affect these factors.
For example, cattle from the South might not do as well as cattle from the North if
the close out is March. If cattle are expected to close out in September, the northern
cattle may be at a disadvantage depending on the length of time they had been on feed.
Copies of OSU Animal Science developed programs are available from: Extension Animal Science Department, 201 Animal Science Building, Oklahoma State University, Stillwater, OK 74078; or they are available for download from the Animal Science web site www.ansi.okstate.edu.
Associate Professor, Animal Science
David L. Lalman
Extension Beef Cattle Specialist