Murray Dairy Business Tool | Murray Dairy Region
Murray Dairy Business Tool
Each season dairy farmers are faced with questions around the impact water allocations, milk price, and grain or fodder prices might have on their business’s profitability.
This business tool is designed specifically for answering these questions and will assist dairy farmers to make better informed decisions around how to manage current seasonal conditions.
The tool is in a spreadsheet format and allows a farmer to enter their own farm business data to test the impact different water allocations, milk price and grain and fodder costs may have on their business.
The business tool also has a series of budgets, which addresses specific strategies a farmer may employ to improve their farm business profitability. The budgets show the costs and benefits of implementing strategies such as applying more nitrogen or milking more cows.
An updated version of the business tool is now available. The earlier version was designed assuming all home grown fodder would be consumed in the year it was produced. As farms may have surplus home grown fodder available this year, there has been an addition to the tool to allow you to input this amount for future seasons. Please download this version for future use.
Download the manual & business tool below:
Murray Dairy Business Tool
Murray Dairy Business Tool Manual
MACROS:
For this tool to work properly, you MUST enable the macros. The instructions to Enable macros will differ from one version of the Excel to the other
For Excel 97:
Click on Enable Macros while opening the spreadsheet.
For Excel 2003:
Before opening the spreadsheet, open Excel, Click on Tools > Macro > Security > Low box ticked, Security level Tab. Then, open the spreadsheet.
For Excel 2007:
After opening the spreadsheet, If there is a "Security Warning Macros have disabled" message on top left hand corner in Excel, then click on OPTIONS button, and check "Enable this content" button. Then click on OK.
OR In Excel, Click on Tools > Macro > Security > Low box ticked, Security level Tab. Then, open the spreadsheet.