This series of short videos have been created to help guide producers through the process of using the Dairy Goat Cost of Production Benchmarking Tool in Excel. Each video covers an individual producer tab. Providing step-by-step instructions on how to enter the data correctly into the cells. Along with highlighting some of the information calculated and provided by each tab. To get the most out of the tool producers should try to fill out the information as completely and accurately as possible.
Learn more about and access the Dairy Goat Cost of Benchmarking Tool here.
Introduction Video
This video provides a general overview of the tool. Covering some benefits of using the tool, the information calculated by the tool, information required, and general instructions on how to use the tool.
Livestock Video
This video provides instructions on how to fill out the goat herd and other livestock inventory, and the value per head. Additionally, it covers the information calculated and provided by this tab, such as the total value per head and animal inventory totals.
Production Video
This video provides instructions on how to enter the gross milk revenue, deductions, total litres produced, and butterfat and protein percentages and revenue shares. It also covers some information provided by the tab such as yearly totals and monthly averages.
Capital Input Video
This video provides instructions on how to enter the various capital assets used on farm, and how to properly allocate each asset by enterprise.
Feed Usage Video
This video covers how to enter feed usage data per goat livestock category. It also covers some information received such as total amount used per feed or bedding type.
Feed and Other Video
This video covers how to enter feed and other crop inventory and production information, along with how to enter the data for the other on farm inventory. It covers some of the information that is automatically filled out in the tab, and some of the information provided by the tab.
Labour Video
This video covers how to enter worker information and how to properly allocate percentage of labour to each labour category.
Revenue and Expense Video
This video provides instructions on how to enter the farm’s revenue and expenses, along with how to properly allocate the percentage of revenue received or expenses incurred by each enterprise.
Balance Sheet Video
This video covers how to enter the farm’s liabilities and assets.
2 comments / Add your comment below