Spreadsheet to Calculate Milk Price

Calculates gross milk price using multiple-component pricing with the option of a somatic cell count adjustment.
Spreadsheet to Calculate Milk Price - Tools and Apps
Language: English


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.


Colostrum Dairy calves and heifers

More by Coleen M. Jones 

Heifer nutrition and management Effective fiber for dairy cows

More by Jud Heinrichs 


Only registered users can write reviews. Please, log in or register

Frequently Asked Questions


What happens after I check out with a smartsheet?
What are the technical requirements for accessing a smartsheet?
Can a smartsheet be saved, or accessed multiple times?
Can I share a smartsheet with multiple people?
Who do I contact if I have a question about a specific smartsheet?