Feed costs have typically represented 40 to 60 percent of the total cost of producing milk. The current volatility of milk and feed prices may increase this to 70 percent. The income left over after accounting for feed costs is what is left to pay other expenses. The same market volatility affecting milk and feed prices is also affecting fertilizer, seed, and fuel costs, to name a few. To remain profitable, producers should be monitoring and making decisions based on their herd's "income over feed costs" (IOFC). This enables producers to make more informed decisions about feed purchases, know when to lock in milk price, or adjust the ration program to accommodate price volatility.
Income over feed costs is a gross margin concept. Simply take the cow, value her daily output, and then subtract off the highest variable cost, which in this case is feed. What is left is gross income, which can be used to pay for interest expenses, labor, and veterinary bills and to provide the owner funds for withdrawals and loan payments.
Income over feed costs is measured in dollars per cow per day. The following equation can be used:
IOFC ($/cow/day) = Pmilk x (DAMP/100) - DFC
Pmilk is the all-milk price ($/cwt), DAMP is "daily average milk production" (lbs/cow/day), and DFC is "daily feed costs" ($/cow/day). DFC is the daily cost of feedstuffs required to produce the amount of milk reflected in DAMP. Essentially, the all-milk price is being converted from dollars per cwt to dollars per pound of milk produced, and then the cost of producing that milk is subtracted. For example:
$19.59/cwt (Pmilk) x 80 lbs/cow/day (DAMP)/100 - $5.90 feed cost/cow/day (DFC) = $9.77 IOFC/cow/day
A simple spreadsheet tool has been developed to help producers measure and monitor IOFC. This fact sheet explains the various components of the tool and two approaches to monitoring IOFC. The first approach is to compare a herd's IOFC to a benchmark based on the value of milk output (milk production and price). The second approach is to calculate the herd's cash flow to determine the breakeven IOFC value. The latter has more meaning as this reflects what the dairy operation needs to make in IOFC to pay bills and remain profitable. The IOFC tool will allow the producer to compare against both market conditions and their cash flow requirements.
Calculating Feed Cost per Lactating Cow per Day
Dairy rations consist of two basic components: homegrown and purchased feeds. These can be further divided into forages (hay, corn silage, and hay-crop forage), concentrates (cereal grains, protein sources, minerals, and vitamins), and by-products (distiller's grains, soy hulls, and bakery products). Many combinations of feedstuffs can be used to develop balanced rations. To simplify the calculation of daily feed costs, batch feed weights, the number of cows fed, and their respective prices can be used to calculate the daily feed cost per cow. Feed refusals are not excluded from the calculation because it costs money to feed the lactating cow whether she consumes the feed or not. Information needed for this section is as follows:
- Batch weight of ingredients fed to the lactating herd or the various milking cow groups if the herd is fed a total mixed ration (TMR)
- Individual ingredient amounts per day per cow for component-fed herds; break the herd into number of cows representing average milk production and number of cows representing peak milk production (more than 20 pounds over average milk production)
- Feed prices for all ingredients (forages, grain mixes, and commodities) fed to lactating cows (Figure 1)
Many producers raise their own forages. There are times when shortages occur and purchased hay/straw is needed to balance the ration. The most difficult part regarding forages is assessing an accurate price. There are two methods to assign a price to home-raised forages. You can assign the price it costs to raise the forage (seed, fertilizer, fuel, storage, etc.), or you can assign the market price of the forage if you were to sell the feed today. The Department of Dairy and Animal Science at Penn State maintains a monthly feed price list on all ingredients, including forages. The IOFC tool will be linked to the monthly feed price so market prices can be used for the forages. If the producer already has an accurate price for their homegrown forages, then that price can be entered in place of the market price. Otherwise, it is recommended that the current market price be used each month for calculating IOFC. The method used should be consistent each month. If producers have cost information on their home-raised feeds, evaluate IOFC with both the market price and the cost value of the forages.
Concentrates and By-Product Feeds
Numerous scenarios exist on farms as far as what is homegrown and what is purchased. Any feed that is homegrown has a corresponding feed price in the IOFC tool based on the current market conditions. The only price the user needs to enter is the actual purchase price for any grain, by-product, grain mix, and/or mineral vitamin mix. This price should be on a per-ton basis. In the event producers forward contract on a feedstuff, they should use the contracted price in lieu of the actual monthly market price.
Creating a Benchmark for Success
One way to use IOFC is to compare against a benchmark. It is recommended that a benchmark range be created using a high and low benchmark. A high IOFC benchmark means that given the herd's daily average milk production, the feed cost per cow is relatively low and gross earnings are relatively high. A low IOFC benchmark means the feed cost per cow is too high and gross earnings are relatively low. Also worth noting is that given the prevalence of component pricing and milk quality premiums, not every farm in a given region will receive the same price of milk. Thus, this could also affect the level of IOFC. The following formulas are used in the Excel spreadsheet tool:
Low IOFC Benchmark = Pmilk x (DAMP/100) - 0.6 * DAMP * Pmilk/100
High IOFC Benchmark = Pmilk x (DAMP/100) - 0.4 * DAMP * Pmilk/100
These benchmarks use the farm's actual daily average milk production. In addition, feed costs are measured as a percent of daily average milk production. Thus, if feed costs are merely 40 percent of milk revenue (DAMP * Pmilk/100), then IOFC is high. On the other hand, if feed costs are 60 percent of your milk revenue, then IOFC is low. In Figure 2 this example herd is doing a very good job with IOFC based on current milk production and feed costs. The IOFC exceeds the high range of the benchmark, which is good. Many farms will find their IOFC somewhere between the low and high benchmark value. That may represent some opportunities for cost control.
|Month and year||Gross mik price/cwt||Milk income/cow||Feed cost/row||IOFC||Average milk pounds||Low||High|
The worksheet allows a producer to track IOFC over time and to compare the farm's performance to a benchmark. The user can compare the farm's history to these goals. This information provides a guide of how efficiently the feeding program is working for the amount of milk being produced. Producers can use this information to set goals for IOFC, evaluate seasonality, and develop quarterly and/or monthly budgets.
Each month after calculating the feed cost per cow per day, the user should enter the gross milk price, the feed cost per cow (market), and the average milk pounds per day. The worksheet will compute and graph the IOFC compared to a benchmark. If IOFC consistently falls below the low range, producers should examine the nutrition and feeding management of the dairy operation. Some areas to investigate are dry matter intake efficiency, use of excessive feed additives, and level of concentrate feeding for production, to name a few. Conversely, if IOFC is consistently at or above the high range, the operation is doing a good job of converting feed to milk (Figure 3).
Comparing IOFC against Market Values and Actual Farm Costs
The lactating cow ration summary (Figure 1a) provides the tools to calculate IOFC using both market value for home-raised grains and forages and the cost value for these products. Both pieces of information are valuable and provide important management information to the dairy producer (Figure 4).
Figure 4. Comparison of on-farm breakeven income over feed costs (IOFC) compared to current market and cash flow (IOFC).
|Milk lbs shipped||5,750,000||5,750,000|
|Number of days in shipment||365||365|
|Daily milk sold||15,753||15,753|
|Milk price per cwt||$17.00||$17.00|
|Milk income per cow/day||$12.75||$12.75|
|Income over feed cost -- current||$6.95||$7.56|
|Income over feed cost -- breakeven||$6.74||$6.74|
|IOFC current compared to breakeven||$0.21||$0.82|
The market value of forages is derived from the Penn State Feed Price List and reflects a compilation of current market prices around Pennsylvania. This price includes all the marketing costs and transportation charges associated with the sale of grains and forages and includes the opportunity cost that producers could capture through the sale of grains and forages instead of marketing milk. This value is useful for comparing the farm to benchmarks and determining if feed costs appear high or low relative to other dairy operations. Standardizing the value of farm-raised feeds means benchmarks will be more consistent across dairy operations.
The IOFC information can be used to assess the viability of future cash flow plans during an upcoming month or year. This information allows the producer to make management adjustments when expected cash flow looks tight and also provides information to evaluate forward-pricing opportunities to determine when pricing milk and feed would be beneficial to farm cash flow (Figure 5). Figure 5 graphically depicts the difference between what the herd requires in breakeven cash flow from IOFC to remain viable. The dark orange bar represents the minimum breakeven cash flow needed to meet the farm's cash inflow requirement. The breakeven cash flow worksheet is found in the third section of the tool. The light orange bar shows the current IOFC for the dairy operation based on the cost value of home-raised grains and forages. In the example, the current price and production are providing $0.82 per cow per day above the required breakeven level. If the light orange bar drops below the dark orange breakeven level, the herd is experiencing insufficient cash flow and adjustments are needed.
For this use, the cost value is more appropriate than the market value because it reflects the cash expenditures incurred to produce a grain or forage crop. The cost value should reflect the amount producers actually spend to produce a grain or forage crop on the farm. It may be different from the market value of the forage or grain since marketing and transportation costs are not included. This value may actually exceed the market value of forages or grains where crop production is inefficient with either low yields or high crop production costs, or it may be the competitive advantage that allows producers to operate a highly profitable dairy when crops can be produced well below the market price.
Accurately establishing this cost value requires producers to conduct enterprise budgeting for their dairy operation to separate crop and dairy expenses and allocate direct and overhead costs between enterprises. The farm accounting system should separate expenses such as repairs, custom hire, and fuel and oil between crops and dairy to make the enterprise analysis more accurate.
When using the IOFC tool, producers may select any future time interval for evaluation of the breakeven IOFC. This could be the upcoming month where the amount of milk sold could reflect the expected quantity for the next 30 days, or it could be the 365-day projection for the upcoming year. To be most useful, producers should calculate breakeven IOFC on an annual basis at the start of the year to establish the big-picture view. Producers should then use the tool monthly, using information from their milk checks and comparing it to the cash flow required during the upcoming month. Frequent review of IOFC will alert managers to the need for adjustments as market conditions change throughout the year. When summarized on an annual basis, the IOFC calculation gives the producer a measure of the feasibility of the whole farm cash flow for the coming year and assesses the amount of risk associated with the projected plan.
Determining Breakeven Cash Flow
To calculate the breakeven IOFC based on cash flow, producers need to calculate their cash-flow requirement for a future time period. Figure 6 includes a whole-farm cash flow projected on an annual basis. Table 1 identifies the data required for this section. Cash inflow from sources other than milk is included since cash-flow needs must be met with either milk income or income from crop or livestock sales. Inflow from sources other than milk is calculated and entered. The total amount of outflow planned for all direct and overhead costs is calculated. In Figure 6 the total outflow includes owner withdrawals (family living) and a minimum ending balance. These must be deducted from the total before they are entered on the sheet. The total amount of all loan payments to be made is entered to finish the calculation of the total outflow required for the farm.
Table 1. Projected annual cash flow.
|Beginning cash balance||3,582|
|Direct and Counter -- Cyclical Program Payments||3,254|
|Other farm income||4,890|
|Crop custom hire||25,900|
|Livestock custom hire||3,998|
|Fuel and oil||34,000|
|Real estate taxes||16,282|
|Owner withdrawls (family living)||50,000|
|Minimum end balance||1,000|
|Total loan payments||94,555|
|Surplus or deficit||86,476|
By definition, IOFC includes only the cost of feed used for milking cows. Therefore, the user needs to compute the dollars required for purchased cow feed and enter the cash crop expenses for seed, fertilizer, chemicals, and custom hire. While a portion of labor and repairs are also involved in crop production, only those expenses that can be easily separated as crop production costs for this calculation are selected.
After this data is entered, the worksheet calculates the cash inflow that must be earned to cover all costs other than feed. The IOFC required can be translated into a monitoring tool for the farm cash flow. After entering the number of cows to be milking, the expected milk price, milk production, and the days in the calculation (month or year), the program will calculate the IOFC breakeven per day. Subtracting the daily milk income from the income over feed cost breakeven identifies the maximum amount available to spend on feed cost per cow per day. The feed cost per cow per day maximum can be compared to the current feed cost per cow per day to determine if the current ration and milk production are providing sufficient income to cover the needs of the whole-farm cash flow.
Since both milk yield and price fluctuate over time, Figure 7 provides a visual representation of how these changes influence the breakeven feed cost per lactating cow. In Figure 6 the whole-farm cash flow remains viable at $17 milk with 71 pounds of milk production, but when milk price drops to $15, if costs remain unchanged, 81 pounds of milk production would be needed to make the whole-farm cash flow breakeven. Figure 7 helps a producer establish realistic management goals and targets based on the current cash-flow requirements of the dairy operation. While it won't always be possible to readily change either feed costs or milk production, producers can quickly identify when management interventions are needed using this approach. The information can also be used to proactively look at forward-pricing opportunities based on the IOFC concept.
In summary, IOFC can be a valuable planning tool that can be used to establish benchmarks for profitability of the dairy operation. After planning a cash flow for the year, a producer can determine the breakeven IOFC needed to keep the operation viable. The measure can provide a means to benchmark the operation against other dairy farms and monitor the farm's financial progress against the projected cash-flow plan. IOFC can then be computed on a monthly basis and compared to this benchmark level. The milk check and actual monthly feed expenditures can be used to monitor IOFC. Corrective action can be taken if IOFC suddenly declines. In addition, the monthly calculations can be used in a hedging or forward contacting program in order to lock in an acceptable IOFC level. In this way a producer can be guaranteed a profit margin.
Producers who want assistance calculating the IOFC measure or using this spreadsheet tool should contact their local dairy extension educator for assistance. You can find contact information for educators on the Penn State Extension website.
Prepared by Ken Bailey, associate professor of agricultural economics; Tim Beck, senior extension educator; Erica Cowan, project associate; and Virginia Ishler, nutrient management specialist
Supported by an informational partnership of Penn State Extension, Pennsylvania Department of Agriculture, and USDA's Risk Management Agency.