Specialists at Michigan State University have developed a simple spreadsheet that allows dairy farmers to use their farm’s financial data to estimate their cost of producing milk. This spreadsheet is primarily based on the data generated from the Schedule F used for federal income tax filing purposes.
However, dairy farmers and consultants can use data generated from the farm’s accounting system or a business analysis summary. Inputs to the spreadsheet include expense information for every expense category that appears on the Schedule F. Each expense and income category may also be adjusted if the user desires to allocate less than 100 percent of a specific expense to the cost of producing milk.
For more information on the Michigan State spreadsheet, click here.