These documents will help you to construct enterprise and cash flow budgets for dairy. This budget package is intended to help decision makers assess the profitability and financial feasibility of dairy operations under various price and cost conditions.
Dr. David Kohl
Agricultural Economist, Virginia Tech University
Waupaca County UW-Extension Agricultrue Agent
Cost Analysis of TMR Mixer. How to Documentation.
After entering projected sales, investment costs, and production coefficients ON FARM MILKP.XLS analyzes your “On Farm Milk Processing” plan. This decision aid produces both a profitability and cash flow analysis. Sensitivity analysis is presented in both tabular and formats.
Examples and Instructions:
The “Forage Land Base Calculator” is an Excel spreadsheet that can help evaluate change in forage acres (either alfalfa, corn silage, or both) as a result of a change in any one or more of the following factors…forage yield; dairy herd expansion or reduction; custom raising heifers; higher or lower alfalfa / corn silage feeding ratio; and, change in harvest, storage or feeding losses. The first worksheet is the computerized spreadsheet which will do all calculations for you. The second worksheet (located directly behind the computer spreadsheet) can be printed and used as a hand-held worksheet on the farm. Both the spreadsheet and hand-held worksheet contain step-by-step directions. Developed by Greg Blonde, Associate Professor UW-Extension, Waupaca Co., WI…June 2000