Here is a handy reference of computer modeling programs available to the pork industry.

Pork editors first began looking at computer modeling programs in September 1999, and since that time have spotlighted several different programs. It soon became apparent that there are far too many of these programs to hit each one in a timely manner with a feature of its own.

So in an effort to cover as many of these programs as possible, the Pork staff has compiled this directory. We have categorized the computer modeling programs, as well as provided a summary, cost information, technical needs and where to go for more information.

Of course the directory will not be complete, but we will continue to update the information on our Web site and, if needed, we will publish updates in the magazine. If you know of a modeling program that should be included in the directory please e-mail tkelley@vancepublishing.com or send it to Pork magazine modeling program, 10901 W. 84th Terrace, Suite 200, Lenexa, KS 66214.

NUTRITION

Feed Budgeting program
What: This program calculates feed budgets based on past closeouts data, and can be used to print feed budgets for use in the feed mill or in the barn. The program also has a simple lysine calculator that helps determine the correct lysine-to-calorie ratio based upon pig weight ranges and the fat-free-lean index.

Program/ Hardware: Microsoft Excel.

Source: Kansas State University, Mike Tokach, 1515
College Ave., Manhattan, KS 66506; mtokach@oz.oznet.ksu.edu; (785) 532-5833.

Price: $25

Computer Modeling Program for Predicting the Nutrient Requirements of Swine
What: This program is part of the National Research Council's 10th revised edition of The Nutrient Requirements of Swine.

Program/ Hardware: CD-ROM

Source: The Nutritional Requirements of Swine, including the CD-ROM program, is available from the National Academy Press, 2101 Constitution Ave., N.W., Lockbox 285, Washington, DC 20055.

Price: The revisions and the CD-ROM cost $43.95.

Swine Ration Calculator for PIH-7
What: This simple spreadsheet allows you to enter inclusion rates and prices for ingredients for a swine ration. It then calculates (based on inclusion rates) the composition of the ration, which can be compared with the requirement. Requirements are based on NRC (1998) for diets containing 3,265 kcal ME/kg of diet. First, select the swine production stage for which the diet is being designed by clicking the proper radio button at the bottom of the sheet. Change inclusion rates until the diet has the required nutrient composition. Try different ingredients and check prices to formulate cheaper rations. Make sure to check Table 5 in PIH-7 for maximum recommended ingredient inclusion rates.

This is not a least-cost formulation program. Do not add or delete rows or columns as it will cause improper future calculations. To add different ingredients, simply change the names and corresponding nutrient values of existing ingredients.
Program/ Hardware: The spreadsheet was created in Excel 8.0 2000 but can be opened with version 7.0 1997.
Source: North Carolina State University, Extension Swine Husbandry http://mark.asci.ncsu.edu/Nutrition/formulate.htm.
Price: Free downloads.

LEAN-GROWTH MODELING

The North Central region Physiological Intake and Growth Model
What: NCPIG is a physiologically based model capable of predicting pigs' growth and responses to nutrition, environment and genetic potential. To accomplish this the model had to simulate the physiological processes of feed intake, digestion, body maintenance, tissue accretion, heat and manure production for growing pigs in the 20-kg to 100-kg range. Inputs required include feed, genetics and environmental data, such as temperature, relative humidity and air velocity.

Program/ Hardware: Windows '95 or higher.

Source: University of Kentucky Web site at www.bae.uky.edu/~lturner/ncpig.html

Price: Free downloads.

FINANCIAL MANAGEMENT

Return-on-Equity Model
What: This program combines production information and financial information to illustrate how each change affects your return on equity, return on assets and return on investment. The program makes some adjustments automatically, while you must enter others. There are four major input categories: animal flow, feed budget, balance sheet and allocating non-feed costs according to production.

Program/ Hardware: Windows '95 or higher, Microsoft Excel 5.0 or higher

Source: National Pork Producers Council, (515) 223-2600 or FarmWise Systems, (877) 474-4946.

Price: $49 plus shipping and handling.
(See the February 2000 issue of Pork)

FINPACK
What: FINPACK can help you evaluate your financial situation, explore alternatives and make informed decisions about the future of your farm. You can easily develop balance sheets, long range plans, cash-flow plans, year-end analysis and historic financial and production reports.

Program/ Hardware: Pentium 180MHz or better personal computer running Windows 95+, Windows ME, Windows NT 4.0+ or Windows 2000, 32 MB of RAM, 100 MB of free hard-drive space, 800 x 600 screen resolution.

Source: University of Minnesota, Center for Farm Financial Management Web site at www.cffm.umn.edu/

Price: Free downloads.

Objective-Based Pricing
What: This program identifies the return you need to cover specific costs within your operation. The program uses your tax records, balance sheets, basic production estimates and depreciation schedules to determine the net farm income from the operation and the return on equity.

Program/ Hardware: Microsoft Excel '97, using about 1 megabyte of hard-drive space.

Source: National Pork Producers Council, Web site at www.nppc.org, look under "Especially for Producers" in the check-off funded activities heading or call (515) 223-2600.

Price: Free downloads or $15 disks may be sent.
(See the December 1999 issue of Pork)

REPRODUCTION

(The next four programs are part of spreadsheet package from the University of Nebraska that may be used individually or as part of an interconnected system.)

Boar Stud Options
What: This program helps you determine whether to obtain artificial insemination semen from on-farm boar collection, a cooperative boar stud, fee-for-service stud or commercial stud.

Program/ Hardware: Microsoft Excel '97

Source: University of Nebraska web site at http://ianrwww.unl.edu/ianr/anisci/swine/levis/ or call (402) 472-6445.

Price: Free downloads or $15 for disks of six programs.
(See the September 2000 issue of Pork)

Constructing and Operating a Boar Stud
What: Allows you to compare the costs of building a boar stud, establishing boar isolation protocols, buying artificial insemination equipment and supplies and the cost of various management factors.

Program/ Hardware: Microsoft Excel '97

Source: University of Nebraska web site at http://ianrwww.unl.edu/ianr/anisci/swine/levis/ or call (402) 472-6445.

Price: Free downloads or $15 for disks of six programs.
(See the September 2000 issue of Pork)

Artificial Insemination Equipment
What: Calculates the initial cost of consumable supplies and non-consumable equipment, over a specified time period.

Program/ Hardware: Microsoft Excel '97

Source: University of Nebraska Web site at http://ianrwww.unl.edu/ianr/anisci/swine/levis/ or call (402) 472-6445.

Price: Free downloads or $15 for disks of six programs.
(See the September 2000 issue of Pork)

Commercial Semen
What: Compares the cost of operating an on-farm boar stud vs. purchasing commercial semen.

Program/ Hardware: Microsoft Excel '97

Where: University of Nebraska Web site at http://ianrwww.unl.edu/ianr/anisci/swine/levis/ or call (402) 472-6445.

Price: Free downloads or $15 for disks of six programs.
(See the September 2000 issue of Pork)

MANURE MANAGEMENT

Manure Nutrient Inventory Spreadsheet
What: This program estimates nutrient excretion by livestock and poultry, the quantity of nutrients remaining after losses and the land needed to utilize those nutrients at agronomic rates. The program provides an option to estimate nutrient excretion based on feed intake and lets you observe the value of dietary options that reduce nutrient excretion. Many states require manure management plans that document land needs and application rates. This program can help you with that.

Program/ Hardware: A collection of eight Microsoft Excel 5.0 worksheets

Source: University of Nebraska home page at www.ianr.unl.edu/manure/Koelsch.html.

Price: Free downloads.

Manure Application Planner
What: The MAP program allows you to run an optimization to determine the most effective manure management plan that does not over apply nutrients. The optimization will determine the manure application method and rate for each field, or you can select a constraint for the field. If you have an application in mind, you can use MAP to calculate the nutrients applied, to calculate any supplemental commercial fertilizer required and to help you document the applications.

Program/ Hardware: IBM-PC or 100 percent compatible computer, MS-DOS/ PC-DOS 3.3 or higher operating system, an 80386 or later processor, a hard-disk drive with at least 2 megabytes of free space, one diskette drive and two megabytes of RAM.

Source: University of Minnesota, Center for Farm Financial Management Web site at www.cffm.umn.edu/
Price: Free downloads.

Odor Modeling Program
What: This program uses factors like historic weather data, location of neighbors relative to the production site, terrain, ventilation, manure management systems and hog numbers to determine an odor threshold. Among the required inputs is the number of odor units coming from a specific location – this will require a scentometer reading. The program lets you change variables for seasons, animal populations and community odor standards.

Program/ Hardware: Not available to the public. Must be used as part of a consultation with Iowa State University.

Source: Iowa State University, Dwaine Bundy, agricultural and biosystems engineer; (515) 294-9973

Price: Variable, depending on travel distance.
(See the January 2000 issue of Pork)

Iowa Crop Management Database
What: The program has a built-in list of various livestock manure traits, along with default nutrient values. You can enter manure nutrient values from your own farm into the program. When you combine these values with those from the fertilizer recommendation section of Crop Management Database, you can determine the manure application rates for your crops and record the information in the database.

Program/ Hardware: Pentium PC or Power Mac.

Source: Extension Software Services, 100 EES Building, Haber Road, Ames, IA 50011-3070; (515) 294-8658.

Price: $100.
(See the September 2000 Profit Tips in Pork)

Nutrition and Waste: How does your nutrition program rank?
What: There are many ways to reduce swine production impact on the environment – nutrition is only one of them. It's worthwhile to consider what nutritional methods are available to reduce nitrogen and phosphorus excretion, ammonia and odor. The worksheet consists of a series of questions used to determine the impact of different nutritional strategies on manure management and the environment. Review the questions and enter your answer in the "yellow shaded area"; "red-shaded areas" are calculated values and should not be changed. "Green-shaded areas" represent results.

Program/ Hardware: The spreadsheet was created in Excel 8.0 2000 but can be opened with version 7.0 1997.

Source: North Carolina State University, Extension Swine Husbandry http://mark.asci.ncsu.edu/Nutrition/nitrophos.htm

Price: Free downloads.

Segregated Early Weaning
(The following two programs are part of a six-program package, including four reproductive spread sheets, from the University of Nebraska. The programs may be used individually or as part of an interconnected system.)

Segregated Early Weaning Simulator Model
What: This program takes into account biological parameters, farrowing facility utilization, replacement gilt parameters, feed costs, market weight, selling price, facility costs and labor costs.

Program/ Hardware: Microsoft Excel '97

Source: University of Nebraska Web site at http://ianrwww.unl.edu/ianr/anisci/swine/levis/ or call (402) 472-6445.

Price: Free downloads or $15 for disks of six programs.
(See the September 2000 issue of Pork)

Segregated Early Weaning Simulator Model Inventory and Productivity
What: This program simultaneously calculates animal inventories and productivity for two situations. It takes into account biological parameters, farrowing facility utilization and gilt replacement rates.

Program/ Hardware: Microsoft Excel 1997

Source: University of Nebraska Web site at http://ianrwww.unl.edu/ianr/anisci/swine/levis/ or call (402) 472-6445.

Price: Free downloads or $15 for disks of six programs.
(See the September 2000 issue of Pork)

PRODUCTION

National Pork Database, NPPC National Production and Financial Standards
What: This database lets you enter basic production inputs and illustrates how you compare with other producers nationwide. The program has 243 benchmarks, including breeding, nursery, finishing and the total pork operation.

Program/ Hardware: Internet access.

Source: National Pork Producers Council, (515) 223-2600 or www.nppc.org

Price: $25 per month for database access.
(See the August 2000 issue of Pork)

PigNet Swine Networking Analysis
What: This program takes into account pig flow, feeding programs, operating expenses, facility ownership costs and semen prices to determine production information. The program provides you with production projections, feed costs and requirements, annual budget, contracting analysis, data banks and a formula pricing output.

Program/ Hardware: Microsoft Excel 1996

Source: University of Minnesota at http://apecon.agri.umn.edu/topicfarm.html

Price: Free downloads.

BIOSECURITY

NCSU Biosecurity Index: How Does Your Biosecurity Rank?
What: Swine diseases cost the pork industry millions of dollars every year. Progress requires farm managers to implement strict biosecurity procedures. The North Carolina State University Biosecurity Index consists of three indices reflecting three basic aspects of biosecurity. As you work through each section answer the questions posed with "Y" or "N". Worksheet cells with a yellow background require specific farm or supplier data. Cells calculated by the spreadsheet have a white background.

Program/ Hardware: The spreadsheet was created in Excel 7.0 for Windows '95. Not all cells will display accurate information until all user input cells have been filled in.

Source: North Carolina State University, Extension Swine Husbandry http://mark.asci.ncsu.edu/Veterinary/Bioindex/biosecurityindex.htm.

Price: Free downloads.

PACKING PLANT FEASIBILITY

NPPC Cost of a Packing Plant Model
What: This CD-ROM was developed as a result of an engineering study and takes into account input costs, hog weights, hog prices, percent of yield and product prices. You also input utility, marketing and packaging costs. There's also a feature to analyze value-added opportunities that may arise.

Program/ Hardware: Microsoft Excel

Source: CD-ROM available from the National Pork Producers Council, call Jeff Ward at (515) 223-2600.

Price: $50 plus tax.