Dairy Enterprise Budget Worksheet
A whole-farm tax return tells you what happened. An enterprise budget tells you why. By pulling the dairy's income and costs into one page, separate from cash crops or the family's personal spending, you can see whether the cows pay their own way.
What an enterprise budget is
An enterprise budget lists the revenues and costs attributable to one activity, here the dairy herd. The IRS notes in Publication 225 that detailed records can identify which crop or livestock enterprises are most profitable or where management changes are needed, so good bookkeeping is the foundation. See the IRS Publication 225 for what records to keep.
Work from last year's actuals first, then build a projection for the coming year. Use consistent categories each time.
Categories that work
- Revenue: milk sales at the mailbox price, cull cows, calves and bull calves, other livestock income.
- Feed: purchased feed, home-raised feed at a stated value, bedding if you prefer to keep it with feed.
- Replacement: cost of raising or buying heifers.
- Labor: hired, plus a charge for unpaid family labor and management.
- Herd health and breeding: vet, medicine, semen, supplies, DHIA testing.
- Operating overhead: fuel, utilities, repairs, hauling if not netted from milk revenue.
- Capital costs: interest, depreciation, taxes, insurance.
A frequent error is netting hauling and check-off out of revenue in one year and listing them as expenses in the next. Pick one treatment.
A worked example, per herd, per cow and per cwt
The figures below are invented round numbers. Suppose 100 cows ship 24,000 cwt a year at a $21.00 mailbox price.
- Milk revenue: 24,000 times $21.00 is $504,000. Cull cows and calves add $45,000. Total revenue is $549,000.
- Costs: feed $215,000, replacements $60,000, labor $90,000, herd health and breeding $40,000, operating overhead $45,000, interest $25,000, depreciation $38,000, taxes, insurance and other overhead $20,000. Total costs are $533,000.
- Net return: $16,000.
Per cow, revenue is $5,490, cost is $5,330 and net is $160. Per cwt, revenue is about $22.88, cost about $22.21 and net about $0.67.
Feed is about 40 percent of costs in this example. Heifers and labor together are about 28 percent. Those two lines are usually where an adviser looks next.
Reading the budget
Walk down the per-cwt column and ask which lines could realistically move.
- Price is largely outside your control, but components, quality premiums and deductions are not. Compare the mailbox price to the announced price using the mailbox price guide.
- Feed per cwt depends on production per cow and ration cost. A small gain in output per cow can drop feed per cwt more than a cheaper ration would.
- Labor per cwt falls when more milk is shipped per worker hour, but only if quality and cow health hold up.
- Capital costs are the slowest to change and the easiest to forget. See the discussion of labor, land and overhead in cost accounting.
A net of $0.67 per cwt means a swing of $0.67 in price, or a 3 percent change in costs, erases it. That is why the budget is a better conversation starter than a bank balance.
Using it through the year
Fix a calendar. Update the actuals each quarter, rerun the projection when something big changes, and keep every version. When you talk to a lender, an enterprise budget with clear categories shows you understand your costs. The loan conversation guide explains what lenders usually want to see. If you want to compare against others, the state directory can help you find your state's extension dairy specialist, who may have benchmark data or budget templates.
Keep reading
- Dairy Income and Expense Comparison
- Milk Revenue Per Cow Calculator
- Dairy Milk Production Versus Revenue Log
- Farm-Level Revenue Sensitivity Analysis
Find your state: see federal order, dairy regulator, extension, cooperative and youth dairy listings in the state directory.
Sources: IRS, Publication 225 Farmer's Tax Guide · USDA ERS, Milk Cost of Production Estimates
General information only, not tax, legal, insurance or investment advice. Prices, programs and rules change and differ by order, handler and state: confirm with USDA, your handler or cooperative, your lender and your extension dairy specialist.