Greg Steele is vice president, dairy industry, for AgStar Financial Services.
He can be reached
When considering an investment in a new technology for your dairy business, the first step is to figure out how the change will affect your operation’s profitability.
A good method to determine an impact on the profitability of your business is a partial budget. This simple and efficient tool can help you define the financial impact of incremental changes. A partial budget helps you segment and analyze the costs that will change and assume other costs such as feed costs or crop production costs will remain unaffected.
Partial budgets are built on the theory that small changes can have meaningful results.
When beginning this exercise, it’s vital to include all income and expense items that will be affected by the change. For example, if milk production is expected to increase, then revenues will increase. If you use less feed, feed costs will likely go down. A partial budget analysis provides you with an easy-to-see, side-by-side comparison.
Done correctly, a partial budget will help you see how the proposed technology could influence your dairy’s income and/or expenses. Will your income increase or decrease? Will your expenses rise or fall? A partial budget can provide the answers.
Let’s examine the following theoretical situation: A new technology that is quickly gaining acceptance is a cow sensor monitoring system that provides data via your mobile phone. For this example, we’ll compare the technology’s claimed benefit of improving reproductive efficiency with improved conception and pregnancy rate while simultaneously reducing drug and hormone therapy costs in the dairy herd.
Also assume the herd size in question is 500 head and the cost to install and implement is $200 per cow for a total of $100,000. The herd presently has a pregnancy rate of 20% and a heat detection rate of 55%. Currently, the herd uses a timed AI program for breeding.
Robotic milker partial spreadsheet, Extended column
The projected annual savings are as follows: Drugs costs will be reduced $12 per cow and labor costs will go down $60 per cow. It is also anticipated that heat detection will increase to 65% with a pregnancy rate increase to 24%. This improvement is expected to lower the days in milk from 185 to 175. We will assume the economic value of this change is $5 per cow per days in milk or $25,000 in added income.
OK, let’s run the numbers as we should have all the information we need to create a partial budget on this.
The analysis assumes that reducing days in milk will add an estimated $25,000 in milk revenue. Additional changes to net income occur from reduced drug and labor costs by $36,000, for a total net income increase of $61,000. In this situation, there would be no decrease in net income.
The cost of the sensors, however, is a consideration. We can reasonably spread the $100,000 cost of these devices over a three-year useful life and, as such, include one-third of the investment cost, $33,333, plus interest costs of $3,300 in the budget.
This analysis illustrates that adoption of the technology will result in an annual net benefit of $24,367. Additionally, the entire investment is paid for in less than 24 months, bringing future years’ potential benefits even higher.
The key to this analysis is using realistic assumptions on economic benefits of the expected changes. Remember, this budgeting process can only estimate the potential financial results, not guarantee them.
A good practice is to repeat the analysis, inputing different price assumptions, as this will provide you with an idea about the degree of risk that is involved when considering a change.
All in all, partial budgeting can be a very helpful method when analyzing the benefits of investing in new technology. This systematic approach can assist the dairy manager in making informed financial decisions.