Butterfat Price Tracking Worksheet
Butterfat is the component most farmers feel first, because it is the one they can see in a test result and in the bulk tank. The price paid for each pound comes from butter, not from a plant's own fat market. If you can follow butter, you can follow your fat dollars.
Where the butterfat price comes from
USDA collects weekly sales of salted, 80 percent butterfat, USDA Grade AA butter in 25-kg and 68-lb boxes, reported by manufacturers through the mandatory reporting program. The weekly weighted averages become a monthly average, and the formula printed on AMS's class and component price announcement is:
Butterfat price = (butter price - $0.2272) x 1.211
The $0.2272 is the butter make allowance in effect since the 2025 amendments, and 1.211 is the pounds of butter associated with a pound of butterfat. The same formula appears in 7 CFR 1000.50. The butterfat price is then used in Class III, Class IV and, with a small addition of $0.007 per pound, Class II.
What a butter move means for your check
You can skip the current price and work with changes. If the butter price rises by 10 cents per pound, the butterfat price rises by 0.10 x 1.211, about 12.1 cents per pound of fat. A cow herd shipping 3.5 pounds of fat per cwt would see about 42 cents per cwt more from fat, all else equal (0.121 x 3.5). Double your test and the effect grows with it. That is arithmetic from the published formula, not a forecast.
The monthly routine
Keep a simple page, paper or spreadsheet, with one line per month and these columns in this order:
- Month the milk was shipped.
- Average butter price used in the announcement (from the class and component price release).
- Announced butterfat price per pound.
- Your butterfat test for the month, from your statement.
- Pounds of butterfat shipped (pounds of milk times test).
- Fat dollars (pounds of fat times butterfat price).
- Fat dollars per cwt (fat dollars divided by cwt shipped).
Fill in columns 2 and 3 when AMS releases the monthly announcement, no later than the 5th of the following month. The exact day floats with weekends and holidays, so check the AMS release calendar. Fill in 4 to 7 when your statement arrives.
What to look for
- Does line 3 equal the formula? Redo the arithmetic once. If it matches, your tracking sheet is trustworthy.
- Is line 6 close to the fat line on your statement? Differences point to premiums, deductions or adjustments. Component-priced orders pay on pounds of components, as UW Extension explains in its milk check walkthrough. Four orders use skim-fat pricing, so check which applies to you.
- Is your test drifting? Fat test usually has seasonal swings. Compare each month to the same month last year before blaming feed.
Picking a trend, not a prophecy
Three months of numbers tells you little. Twelve begins to show seasonality, and two years lets you compare. Resist forecasting from the sheet. Use it to answer practical questions: how much of this month's change came from price and how much from my test?
Next, do the same exercise for protein, then connect all components in understanding milk component pricing and try the component yield and revenue exercise to see how fat and protein tests change revenue per cwt.
Keep reading
- Protein Price Tracking Worksheet
- Other Solids Price Tracking Worksheet
- Milk Component Yield and Revenue Exercise
- Dairy Product Price Survey Explained
Find your state: see federal order, dairy regulator, extension, cooperative and youth dairy listings in the state directory.
Sources: USDA AMS Announcement of Class and Component Prices · eCFR 7 CFR 1000.50 · UW Extension milk check walkthrough
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.