Spreadsheet to Calculate Milk Price
This spreadsheet calculates milk price with the formula used in the Mideast Federal Order. To calculate a milk price for the Northeast Federal Order, the somatic cell count adjustment can be set to zero. Users can calculate their current price, project milk price at various levels of fat and protein, evaluate income over feed cost, and calculate total components shipped, providing a complete picture of the impact milk components and milk yield have on the farm's gross income. The spreadsheet also includes a page that can be used to track mailbox milk price over time.
Ginger D Fenton, PhD, Robert J. Van Saun, DVM, MS, PhD
Jud Heinrichs, Geoff Zanton
Coleen M. Jones, Jud Heinrichs