Dairy Feed Cost and Milk Margin Worksheet
The feed bill is the largest check most dairies write, and the milk check is the largest one they receive. Setting them side by side, in the same units and the same month, is the fastest way to see whether the farm is making money on the cows.
Collect four numbers
You need figures from the same period, say one month, so that nothing is mismatched.
- Average cows in the milking herd (not total head).
- Total pounds of milk shipped, from your milk statement.
- Milk revenue, using the mailbox price rather than the announced price.
- Total feed cost fed to the milking herd: purchased feed, plus home-raised feed valued at a consistent rate.
If you are unsure how to turn the statement into a mailbox price, the Penn State Extension milk check guide shows the method: gross value minus deductions, divided by cwt shipped.
A daily example with invented figures
Imagine 120 milking cows averaging 78 pounds each. The herd ships 9,360 pounds a day, or 93.6 cwt. Say the mailbox price is $21.50 per cwt and feed costs $7.50 per cow per day. These figures are made up to show the arithmetic.
- Milk revenue per day: 93.6 cwt times $21.50 is $2,012.40.
- Feed cost per day: 120 cows times $7.50 is $900.00.
- Margin over feed per day: $1,112.40.
- Feed cost per cwt: $900.00 divided by 93.6 is about $9.62.
- Margin over feed per cwt: about $11.88.
- Feed as a share of milk revenue: about 44.7 percent.
Notice that the same data produce a per-cow, a per-cwt and a percentage view. Use the one your lender and adviser use so conversations match.
Reading what the numbers say
Now ask why. If margin per cwt has fallen against last quarter, take one variable at a time.
- Price side: did the mailbox price drop because the market moved, because your butterfat or protein test fell, or because deductions rose? The milk statement line-by-line guide helps you separate these.
- Volume side: is output per cow down, or is the herd carrying more late-lactation cows?
- Feed side: did the ration change, did ingredient prices move, or is shrink and waste rising?
Per-cwt feed cost rises when production per cow falls even if the ration costs the same, because the same feed is spread over fewer pounds of milk. That surprises many people the first time.
Variations worth a column
Add these columns once the basic sheet works.
- Dry cow and heifer feed, listed separately, so you can see the whole feed bill without blending it into the milking herd figure.
- Forage you grew versus feed you bought.
- A running three-month average to smooth out billing timing.
Be careful with timing. Feed bought in bulk and fed over several months should be spread over the months it is fed, or the margin will jump around for no real reason. The same applies to a milk check that includes an advance payment.
Using the sheet to talk to people
A tidy page showing revenue, feed and margin per cwt for the past 12 months makes meetings with a nutritionist, banker or insurance agent shorter and more productive. It also makes it easier to judge a risk program. FSA explains Dairy Margin Coverage as protection tied to the national gap between the all-milk price and average feed cost, so a farm that tracks its own margin can judge how closely that national measure tracks its own. The guide on income over feed cost covers the definition and limits, and milk pounds to hundredweight is handy if your records are in pounds.
Fill in the sheet monthly. After six months you will know your farm's normal range, and a month outside it will stand out immediately.
Keep reading
- Dairy Feed Market Volatility Worksheet
- Heifer Replacement Cost and Milk Prices
- Dairy Enterprise Budget Worksheet
- Dairy Income and Expense Comparison
Find your state: see federal order, dairy regulator, extension, cooperative and youth dairy listings in the state directory.
Sources: Penn State Extension, Understanding Your Milk Check · FSA, Dairy Margin Coverage Program
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.