Drum SD. 1999;1:13-18 How to use partial budgets to predict the
Production tool |
Steven D. Drum, DVM, MS; William E. Marsh, PhD
SDD: Remsen Veterinary Clinic, 609 South Cleveland, Remsen, Iowa 51050; email: drum@nwidt.com
Drum SD, Marsh WE. How to use partial budgets to predict the impact of implementing segregated early weaning in a swine herd. Swine Health Prod. 1999;7(1):13-18.
This article available in PDF format. (176k)
Summary
Partial budget analysis is a powerful yet simple technique that enables producers to predict the impact a management intervention will have on profitability in their operations. This article presents a partial budget model to predict how a change from conventional weaning to segregated early weaning, with a concomitant increase in breeding herd size from 250 to 500 breeding females, will effect profitability in a hypothetical herd. Sensitivity analysis is also discussed.
Keywords: swine, partial budgets, segregated early weaning (SEW), sensitivity analysis
Received: December 9, 1997
Accepted: July 14, 1998
Recent changes in the United States swine industry have placed many small producers in a quandary. Although these producers may have debt-free facilities, they feel the economic pressures of an increasingly competitive industry. The operations of these small producers could be made more competitive by implementing new management technologies; for example, production tools such as segregated early weaning (SEW) promise to improve efficiency and provide the opportunity to expand so that producers can capture economies of scale. Investment decisions are easier to make and access to capital is more readily available when one can easily and confidently define the expected costs and benefits of a planned management change. What producers need, then, is a reliable way to estimate the specific economic impact of these management changes.
Partial budgeting is an economic analysis tool that provides a straightforward means for estimating the financial impact of implementing a new technology.1-3 Partial budgets compare pre- and post-change scenarios by calculating the expected impact on both income and expenses associated with a particular management change. In this paper, we illustrate how partial budgeting can be used to estimate the economic impact of implementing SEW and doubling the size of the breeding herd in a hypothetical operation.
Hypothetical herd defined
The assumptions we used in our hypothetical analysis were drawn from several different sources in order to simulate as realistically as possible a situation in which SEW might be considered an appropriate intervention. The values chosen for production levels in this example are for illustrative purposes only. Actual performance levels can vary dramatically between herds; when using this model, practitioners should input the herd-specific production data from their client’s herd.
Our hypothetical operation was modeled on a farrow-to-finish enterprise that is debt-free and has sufficient collateral to finance expansion and construction. New debt will be incurred to finance sow herd expansion, remodeling, and new construction. The formula for interest used in this model used 1 as the number of payments per year. It is not uncommon for farm loans to be amortized using one payment per year. Over the life of a long loan, such as a home mortgage amortized over 30 years, the additional interest is substantial. However, the difference in shorter loans will not be that great. The initial herd size was chosen to reflect the predominant breeding female inventory in the United States (250 head) at the time of this analysis (1997).4 Breeding female inventory was subsequently doubled to mimic an expansion plan commonly used when implementing SEW (although such an increase in the breeding herd is not a necessary part of implementing SEW). Values for herd reproductive performance that change when weaning age is decreased from 24 to 10 days (weaned pigs per breeding female per year, replacement rate, wean-to-service interval, pigs weaned per litter, and litters per breeding female per year) were estimated from the PigCHAMP(R) database (Table 1).5 Nursery grow:finish performance was modeled on results observed in a trial conducted by Drum, et al.6 The following points further define the hypothetical operation for this example:
- Sow herd expansion is amortized over 3 years and remodeling and construction costs are amortized over 7 years at 8% interest, as calculated by the following formula:
p=Ax(R-1)/(1-R-N)
R=(1+I/1)
where:
p is the payment,
A is the amount borrowed,
N is the number of payments,
I is the annual interest rate, andR =(1+I/the number of monthly payments).
- Hand mating will be implemented after expansion, and additional labor will be required for management changes totaling $35,000 per year.
- Construction and remodeling costs used in this example are those of an actual producer who completed a project of similar size and nature in 1996. Construction costs will vary locally, so the figures used in this example should be regarded as illustrative rather than average.
- No select breeding stock will be sold before or after intervention.
- No nursery pigs or weaned pigs will be sold before or after intervention.
- To simplify calculations, capital recovery costs are ignored. It is intended that this example measure the financial impact to the enterprise after meeting debt obligations.
- Due to local variation, we will ignore the effect of taxes, insurance, and utilities.
- All weight measurements are in lb and financial outcomes are calculated in $US.
Calculations
Our partial budget compared only those budget items that we anticipated would change on the basis of the strategic intervention (Table 1). Pigs weaned per litter was increased in the "after SEW" scenario because we reasoned that fewer pigs would die if removed from the sow before they could be infected with diseases endemic in the gestation facility. Production parameters that would stay the same for both the pre- and post-intervention scenarios were not included in the budget (Table 2).
Any partial budget uses the same basic equation:
increased revenues
+ decreased costs
– increased costs
– decreased revenues
= change in revenue
Implementing an SEW intervention requires an extensive partial budget because this management strategy will have an impact on production parameters throughout every facet of production (Table 3). In our hypothetical example, the values in the partial budget are input into this equation:
$795,343 in increased revenues
+ $1487 in decreased costs
– $717,779 in increased costs
– $0 in decreased revenues
= a change in revenue of $79,051 per year (Table 4)
A Microsoft(R) Excel(TM)-compatible spreadsheet of this model is available for download at the SHAP website: http://www.aasp.org/shap/v7n1/V7N1P13.UUE. [This file is UUcoded and pkzipped.]
Sensitivity analysis
Partial budget analysis is a way to assess the profitability of prospective decisions or interventions. However, because it is necessary to make assumptions about the parameters used in partial budget analysis, it is desirable to have additional tools that allow one to accurately assess the impact of these assumptions on the outcome of the partial budget analysis. Sensitivity analysis investigates the effect on overall profitability when one parameter (such as hog price) is varied over a possible range at values while holding the rest of the variables in the analysis constant. Sensitivity analysis thus allows one to explore the robustness of a partial budget outcome–i.e., it allows you to determine how sensitive the results of partial budgets are to the assumptions that go into the analysis. In this example, we performed sensitivity analysis on both parameters directly affected by the planned intervention (PW/MF/Y, N-F F:G), and those factors that can vary independently of the intervention (interest rate and market price) (Figure 1). The lines in Figure 1 with the steepest slopes (PW/MF/Y, N-F F:G) show that relatively small changes in the values chosen for these variables have the largest impact on the projected profitability.
Threshold analysis
A particularly useful variant of sensitivity analysis is threshold analysis. Threshold analysis can address the question of "what is the minimum or maximum level for a particular parameter that will make the plan- ned intervention profitable?" Advanced spreadsheet users may perform this operation by setting the net benefit to zero and solving for each variable of interest in turn. The points in Figure 1 where the lines cross the zero point on the x axis denote the break-even value for that parameter: i.e., the level for a given parameter at which the planned intervention results in neither a profit or a loss (net benefit = 0).
Discussion
Inspection of the increased expense items in this hypothetical intervention indicate that increased feed costs and increased market sales dwarfed other categories of increase or decrease in this example. In our model, the net benefit was most sensitive to market price ($/cwt). Market price has a direct impact on market hog revenues, which was the single largest item in the partial budget. Pigs per mated female per year determines how many pigs are finished per year and thus, not surprisingly, played a major role in predicted total market hog revenues in our model.
Anticipated profitability will be very sensitive to small changes in values for "big ticket items," such as the components of planned feed expenses (price, quantity) and expected market sales (price/cwt, market weight, premiums). Because these values can have a dramatic impact on the potential profitability of an intervention, great care should be taken in obtaining estimates for these variables, and sensitivity analysis should be carried out over a reasonable range of settings. Conversely, the bottom line is less sensitive to values of components at smaller dollar values, such as interest rate (Figure 1). Thus, "ballpark" estimates for these parameters may be adequate for this and other models.
It is important to keep in mind that our hypothetical example assumed a debt-free situation. Rarely, however, is this the case. The solvency (ratio of debt:equity1) of an operation is an important factor in considering the advisability of implementing any management intervention (e.g., implementing SEW and doubling the size of the breeding herd). Lender tolerance for higher debt:equity ratios also varies considerably. Although partial budgets are an important first step in determining the profitability of an intervention, additional means of determining the feasibility of an intervention are necessary. Partial budgeting does not calculate solvency as defined by debt:equity ratio. Solvency and liquidity before, during, and after an intervention should be determined before an intervention is undertaken.
Amortized construction costs (ACC) and interest rate had a minimal impact on profitability in this hypothetical model. For the debt-averse producer, the temptation might be to minimize borrowing in order to minimize interest and principal payments. In doing so, this type of producer may forgo labor-saving investments hoping to increase pro-fitability by decreasing capital expenses. Our partial budget analysis indicates that, at least in some situations, this course of action may in fact decrease profitability. Producers that follow this course may spend too much time completing laborious tasks and would therefore be unable to invest the necessary time to maximize productivity and efficiency in the reproductive herd and the finishing barn. Greater opportunities might be lost if N-F F:G and P/MF/Y suffer than could be realized by decreasing ACC or interest costs.
Producers who undertake leveraged interventions should be aware of the consequences of prolonged periods of low market prices. Risk reduction strategies, such as hedging or contract sales, should be implemented to insure profitability and maintain solvency if low market prices are likely. Risk reduction strategies for N-F F:G should include feed purchasing strategies that reduce overall feed costs as well as management and production strategies that reduce the amount of feed required to produce lean gain. Risk reduction strategies are not necessary for every intervention and should be used at the discretion of the individual producer. Additionally, production and management strategies that maximize P/MF/Y are also necessary to ensure pro-fitability.
Implications
- Partial budgets quickly estimate performance differences and subsequent changes in profitability that result from an intervention by using historical information and projected intervention performance levels.
- Reliability of the analysis is dependent on the reliability of the input estimations.
- Sensitivity analysis allows producers to visualize the effects on profitability if input performance parameters are varied.
- Partial budgeting does not determine liquidity, or the capacity to generate cash to pay debt.
References
1. Boehlje MD, Eidman VR. Farm Management. New York, New York: Wiley and Sons. 1984.
4. Hogs and Pigs Report. ISDA-NASS. December 18, 1995.
5. Koketsu Y. Influence of feed intake and other factors on lactational and postweaning reproductive performance of sows. 1994. University of Minnesota. PhD Thesis.