Farm Milk Revenue and Volume Dashboard
The milk check lands, the number at the bottom is lower than last month, and the first question at the kitchen table is always the same: did we ship less, or did we get paid less? A one-page dashboard answers that in thirty seconds, but only if it was built before the bad month arrived.
The five lines worth tracking
A dashboard fails when it tries to show everything. Five lines, updated once a month from the milk statement, cover most of what a farm needs.
- Pounds shipped. Total for the pay period, taken from the top of the statement. UW-Madison Extension notes that checks usually open with milk shipped during the pay period, often daily weights plus a monthly total.
- Average cows milking. Use the herd count you actually milked, not the number on the inventory sheet.
- Component tests. Butterfat, protein and other solids percentages, plus somatic cell count.
- Gross revenue and total deductions. Pull both from the statement.
- Mailbox price. Farm Credit East describes it as total premium and component dollars, less all deductions, divided by total pounds and multiplied by 100 to give dollars per cwt.
Everything else on the page is arithmetic on those five. Pounds per cow per day is pounds shipped divided by cows and days. Revenue per cow is net revenue divided by cows. Our milk revenue per cow calculator walks through that second one in detail.
Separating volume from price
The point of the dashboard is to split a revenue change into two parts. Suppose, with made-up round numbers, that last month the farm shipped 300,000 pounds and netted $20.00 per cwt, and this month it shipped 280,000 pounds and netted $20.50.
- Last month: 3,000 cwt x $20.00 = $60,000.
- This month: 2,800 cwt x $20.50 = $57,400.
Revenue fell $2,600 even though price per cwt rose. The volume effect (200 fewer cwt at last month's price) is about $4,000 lost, and the price effect (2,800 cwt x $0.50) is about $1,400 gained. Without the split, the farm might blame the market for what was really a herd or feed problem, or the reverse.
Keep a column for each effect. When the volume column is the big negative, look at fresh cows, heat, ration changes or a mastitis flare. When the price column moves, go to the statement and ask whether the cause was announced prices, a changed premium or a deduction that crept up.
Reading the price column honestly
The mailbox price blends several things you do not control (announced component prices, the producer price differential) and several you partly do (components, quality, volume premiums). The uniform milk price guide explains the order-level number, and the monthly milk check audit shows how to confirm that your handler applied the published prices correctly. Put the announced price for your order in a row next to your mailbox price. The gap between them, which some advisers call basis, is worth watching month after month. If it widens while your components are steady, call your handler or cooperative field rep and ask which line changed.
Do not mix the mid-month advance into these figures. Penn State Extension points out that the advance is a partial payment, not a cost, and that the mailbox price excludes advances, forward contracts and assignments.
Layout that gets used
A dashboard nobody opens is worse than none. Keep it to one printed page or one spreadsheet tab.
- Top row: this month against the same month last year, for pounds, mailbox price and revenue per cow. Seasonality is real, so compare like months.
- Middle: a twelve-month line for pounds per cow per day and one for mailbox price. Two small charts beat six crowded ones.
- Bottom: a notes box. One sentence per month on what happened (new heifers in, hot spell, new premium schedule). Memory fails by next spring.
For the monthly production side of this record, see the milk production versus revenue log. If you want a state-level reference for herd and production data, NASS publishes monthly cow numbers and production by state at nass.usda.gov, which is useful for judging whether a swing is yours alone or the whole region's.
When to share it
Bring the one-pager to the lender, the nutritionist and the accountant. A lender who sees twelve months of shipped pounds, tests and net price asks better questions and is less likely to be surprised by one low month. See preparing for a dairy loan conversation for what else to bring.
Read the statement notes first at UW-Madison Extension's milk check walkthrough, and see Farm Credit East's milk check article for the mailbox price method.
Keep reading
- Benchmarking Your Dairy Against Others
- Labor, Land and Overhead in Dairy Cost Accounting
- Dairy Production Cost per Hundredweight
- Dairy Cost of Production Survey Worksheet
Find your state: see federal order, dairy regulator, extension, cooperative and youth dairy listings in the state directory.
Sources: UW-Madison Extension, Reading the Milk Check · Farm Credit East, Understanding Your Milk Check · USDA NASS
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.