|
Home College of Veterinary Medicine Washington State University WSU Faculty &Staff Page John Gay, DVM PhD DACVPM AAHP FDIU VCS |
VM 577P Herd Production Medicine Producer Enterprise Budget Exercise D R A F T - Last Updated 06/25/07 Note: This webpage is a quick marriage of a printed class handout (the top section) and an on-line page of links, which are listed at the bottom. Purpose: The purpose of this is for you to:
Task: Build a livestock enterprise budget spreadsheet in Excel that enables you to do ""what if's" on veterinary preventive programs for producers in the geographic area that you expect to practice in. This is a large task. To get the most input to create the best tool, you are encouraged to work in groups but everyone should have their own final version at the end. If you need a quick Excel tutorial, a search using the key words "excel tutorial" in Goggle yields a bunch (15,000 hits), several of which should be to your liking. Note: To save your time and to make this exercise reasonably painless, using Google I've located on-line versions of most of the materials that you will need. Livestock Enterprise Budget Spreadsheet Goal: Create a livestock enterprise budget spreadsheet to calculate annual costs and returns per production unit (e.g., calved beef cow or dairy cow) and per unit of production (e.g., hundredweight of milk or weaned calf), including veterinary services. Background: Enterprise accounting is a method for determining if each major component (e.g., producer herd, replacement rearing, crop production) of a farm is profitable on its own. It treats each major farm section, such as crop production and replacement rearing as well as the primary product production (milk in the case of dairy farms or calves in the case of beef cow-calf herds) as separate enterprises. These sections are those in which a producer could specialize, such as raising only crops or only raising replacements, rather than having an integrated operation. In an integrated operation, the crops are "sold" at local market price within the farm to the livestock enterprises and heifer calves are "sold" at local market price from the mature herd enterprise to the replacement rearing enterprise. The idea is that if one enterprise isn't profitable at least on paper when "buying" inputs from and "selling" outputs to the other integrated farm enterprises at local market prices, then the producer is likely better off closing down the unprofitable enterprises, expanding the profitable enterprises and buying those inputs, such as feed, from other producers or custom operators. This method isolates those enterprises with which you as an ag animal veterinarian are concerned. A unit of production is typically a hundred weight (cwt) of milk or feeder calf. The unit cost of production (UCOP), the cost of producing a unit of production, is the single most important summary measure a producer (and you) can use as a basis for making decisions. For producers of commodities, such as milk or feeder calves, selling into a cyclical market a very important goal for long term survival is to have a ucop that is equal to or below the median value for the industry. Because the unit cost of production captures both the production and economic efficiency of an operation, it is a good measure for making benchmark comparisons between operations and for determining if a particular practice, such as adopting a new vaccine, is economically beneficial. If it lowers the producer's long run ucop, it is beneficial. If it doesn’t, it isn’t. If a producer’s ucop is high relative to market price or above the median benchmark for the industry, the next step is to determine why and to do "what if" scenarios for either reducing it, weathering the period of low price for an upturn or increasing the value of the product. Procedure: Read background material explaining enterprise accounting, the important measures and their benchmark values. Examples of these materials are the following: Select the region in which you want to practice, define the primary type of livestock producer that you expect will be your clientele (e.g. commercial beef cow-calf, commercial dairy, registered beef, feedlot, registered dairy, small ruminant, swine). Put these into your spreadsheet as text blocks. Note: As noted above, I've located most of the on-line resources needed for constructing the spreadsheets for the first two types of operations (commercial cow-calf or dairy) but not for the rest. You are free to select any type of livestock enterprise of interest to you but you may have to track down the enterprise budgets for them. Find several livestock enterprise budgets and benchmarks for type of operation and the approximate size (number of head) that apply to your selected region. Livestock Enterprise Budgets produced by Agricultural Extension Services provide midrange estimates of costs and revenues (the cost structure) for typical producers in their region. The following sources were located using the main Google.com search terms "enterprise budget" with qualifier terms such as "livestock", "cow-calf", "dairy", "feedlot" or "swine": General: Characteristics and Production Costs of U.S. Cow-Calf Operations (USDA ERS bulletin 974-3, 2001 pdf) List of state enterprise budgets maintained by Ohio State University Extension Regional: Milk Production Costs in 2002 on Selected Wisconsin Dairy Farms (note the farm size effect) Idaho Livestock Enterprise Budgets (beef, dairy, sheep, swine – pdf’s)
See Cowcost, CCFS - Cost of Production Estimates for Commercial Cow Calf Enterprise, as well as others. Nevada Enterprise Budgets (pdf’s) Oklahoma 2000 Livestock Enterprise Budgets (beef cow-calf, stocker –
spreadsheets for purchase) Develop the structure of an enterprise budget for the type of livestock producer you selected above. Look at the layout of several from different sources to see how they are constructed and combine those that works for you. Generally, the printed version of a spreadsheet will be most convenient if it fits vertically on 8.5 x 11 pages from the top down rather than side to side. Sophisticated Excel users may want to use separate sheets for feed and veterinary costs, carrying the summary values to the front sheet. Note: Many states provide on-line spreadsheets that are excellent starting points. You can find these by using the terms "enterprise budget spreadsheet" with the appropriate qualifier term in Google.com. (I can also provide you some I have collected but are not longer on the web if you provide me a disk. I haven't as yet selected one as "the best".) Examples: o Iowa State University
Extension provides basic livestock enterprise budget Excel
spreadsheets for beef, swine and lamb feedlots To start from one of these as a template if you wish: o Save the spreadsheet from the browser to your directory. As most of these spreadsheets contain Macros that will be blocked for computer security reasons, you will have to enable Macros to open the spreadsheet. Unprotect the entire spreadsheet by clicking the upper left corner of the cells to select all and then selecting "Tools > Protection > Unprotect". o So that you can keep rows and columns straight, bring back all the cell borders by clicking the upper left corner to select all the cells, selecting "Format > Cells > Border", clicking on both "Outline" and "Inside" and then "Okay". Design the spreadsheet to provide "What if" flexibility. My ideas are the following: In the upper left area of spreadsheet cells, put: o The herd size o The average production § For dairies, put the herd's average days in milk and the average daily production in lbs. § For beef cow-calf, put the average weaning weight. § If the production is significantly different between groups, such as cows vs. heifers, split them out. o The important production profile rates (e.g., cow cull rate, cow death loss rate, heifer death loss rate, calving rate (number of calves / number of cows bred), calf death loss rate) for the type of enterprise. § Be sure to include those that can be manipulated by veterinary interventions. § If the rate is different between groups, separate out the groups. For example, the death risk for the dam and calf due to dystocia is often higher in first calf heifers than in cows. The pregnancy rates of second calf beef cows is often lower than that of first calf heifers or older cows. In the main body of your spreadsheet enterprise budget put at least the following columns: o Per unit costs of inputs (e.g., cost per ton of hay) o Quantity of input consumed per cow (e.g., tons of hay per cow). If the quantity is different between age groups, you can make each one a different row. o Cost or revenue per primary unit of production (e.g., per cwt (hundredweight) of milk (dairy) or cwt of calf sold (beef)) o Total cost or revenue per cow at the herd average production per cow. In this main body, each type of input cost (e.g., lactating cow hay) or one income (e.g., cull cow income) should be a row. Because feeds are the largest component of variable costs and are highly variable, break feed costs into sufficient detail that each ration component for each production stage is present as a row. Be aware of the volatility of feed costs, which occurs due to such things as drought in major production areas, crude oil price volatility (which affects fertilizer as well as fuel costs) and events in other industries consuming these inputs. Within this volatility lies opportunities for substitution as well as significant financial risk. Break veterinary costs into at least professional fees, prevention (vaccines), routine group treatments and procedures (e.g., worming, pour-ons, implanting) and "other". Be careful of the veterinary cost estimates in many of the livestock budgets because they often include biologicals (vaccines), pharmaceuticals (pour-on's as well as injectable drugs) and breeding costs (semen, synchronization drugs) under "veterinary costs". Due to the competition in the biological and OTC drug supply business, the gross margin for drug and biological sales is often as low as 8% for large ranch and dairy accounts. Thus, only a portion of these overall veterinary costs are a direct professional service fees and only a small portion of the balance winds up in your pocket even if you market these products to producers. For an example of broken out veterinary costs, see page 3 of Colorado 2000-01 Livestock Enterprise Budgets (beef cow-calf, no dairy) at <http://www.coopext.colostate.edu/ABM/abm32.pdf>. Include each routine item (e.g., vaccines, wormers) as a row by name and use per label recommendations (i.e., two shots for killed viral vaccines) in a typical prevention program that you would recommend your type of client and include per animal costs. To determine what producers are using, see the relevant NAHMS reports at <http://www.aphis.usda.gov/vs/ceah/cahm/>. As these reports are large PDF files, this is best done with a personal computer directly connected to the Internet rather than through a phone modem. Examples of the information in these are the following (PDF page rather than document page):
For approximate costs of vaccines, wormers, delousers, fly tags, vitamin injections, growth implants and so on, you can use the following or others: o American Livestock Supply o PBS Animal Health o Valley Vet Include the labor and facility costs. Understanding the overall costs and cost per production unit of machinery and major facilities (animal housing, feed storage and handling, milking parlor) is important, particularly for making benchmark comparisons between herds. Pay careful attention to how labor and machinery costs are allocated between the farm's enterprises, particularly between crops and livestock. Be very careful how labor costs are established, particularly for family labor and for hired labor that often has housing, utilities and some food provided. Prepare to modify the spreadsheet to reflect the economic and husbandry conditions of your typical client. At this point, your spreadsheet represents the general cost structure for an average client rather than a particular herd. Due to supply and demand effects caused by weather and other factors, the prices of inputs such as feedstuffs and replacement cattle as well as outputs such as milk and cull cattle are quite variable. However, if set up well, you can enter a herd's information into the spreadsheet to examine "what if's" for various interventions against problems. For example, how much does reproductive performance have to increase to justify the cost of including a new vaccine in the vaccine schedule? If you have access to information from a particular herd, use it if the herd represents the clientele you expect to have in the future. Current prices within a region for feedstuffs, cull and replacement cattle are available from several on-line sources. One of the largest set of links is the USDA Livestock and Grain Market News Branch at <http://www.ams.usda.gov/LSMNpubs/index.htm>. Many local livestock markets are listed under the species and species class selections. Hay and other feedstuffs are also included, usually as FOB so you will have to add shipping costs to the farm. For pricing of feedstuffs that aren't traded, such as corn silage, see "Pricing Forage in the Field" <http://www.extension.iastate.edu/agdm/crops/pdf/a1-65.pdf>, "What is the value of a standing corn crop" <http://www.ag.ndsu.nodak.edu/aginfo/farmmgmt/pubs/Cornvalue02.pdf>, "An improved AUM for range cattle" (with feed equivalents) <http://jrm.library.arizona.edu/data/1965/186/15vall.pdf>. For pricing pasture, see documents such as "Determining Pasture Rental Rates" <http://www.ext.nodak.edu/extpubs/plantsci/hay/r1092w.htm>, "Computing a Pasture Rental Rate" <http://www.extension.iastate.edu/agdm/wholefarm/pdf/c2-23.pdf>, <http://jrm.library.arizona.edu/data/1965/186/15vall.pdf> or identify others by using the terms "pasture rental rates" in Google. Recent prices of livestock and commodities are also available in some farm trade magazines (e.g., Drover's for beef cattle, in print or at <http://www.drovers.com/>). Discussion and Comments: Veterinarian usage How are veterinarians used by your future clientele? What are the likely trends in this use? What is the "SWOT" for this aspect of practice? Cost of professional services Contrast the evidence on cost of professional services per production unit with your expectations from the professional services exercise. Preventive practices Why do significant proportions of producers likely use or not use particular classes of vaccines? What information do you need to justify this use or non-use? Where can you find this information or, if you can't find it, how can you develop it for your clients? Other References: Morris, DL (ed.). Standardized Performance Analysis of Beef Cattle Operations. Vet Clin NA Food Animal 11(2), July 1995. Koontz, SR (ed.). Economics of the Red Meat and Dairy Industries. Vet Clin NA Food Animal 19(2), July 2003. Producer Enterprise Budget Exercise Links
|
|
Return to: John Gay's Homepage College of Veterinary Medicine Homepage Washington State University Homepage Copyright 1998-2007 John Gay, Washington State
University, All rights reserved |