UNIVERSITY OF MISSOURI EXTENSION
 

Decision Tools

Decision tools and calculators have been developed to assist decision making for beef producers. Some of these spreadsheets may contain macros that will need to be enabled to function correctly. To download a spreadsheet, right click on the link, select "save" and save it to a location on your computer. Then find the file on your computer and open it from that location.

Business Management and Marketing

Replacement Cow Bid Price Calculator
Cow-calf producers can use this tool to estimate the return on investment of a cow purchase and calculate the break-even bid price for a cow. Also, use this tool to assist with the keep or cull decision by comparing the net present value of a heifer to her current market value.

Missouri Backgrounding Cattle Budget
Producers can use to estimate costs and returns for backgrounding cattle on a per head and per group basis. Additionally, a calculator can help estimate yardage cost for an operation.

Missouri Feeder Cattle Basis Calculator
Use to calculate the basis of the reported livestock auctions in the state of Missouri.

Cow-calf Marketing Evaluator
Use to determine whether to: sell calves at weaning, sell after a backgrounding period, background the calves and then own through finishing or send the calves directly to a feedyard and retain ownership through finishing.

Stocker Evaluator
Instructions
Stocker operators can use to determine: return to ownership and management, purchase price to attain desired return and sale price to attain desired return.

Feeder Calf Evaluator Instructions
Cattle feeders can use to determine: return to ownership and management, purchase price to attain desired return and sale price to attain desired return.

Retained Ownership Evaluator
Instructions
Producers can use to determine return to ownership and management and sale price to attain desired return.

Backgrounding Profitmeter
The Backgrounding Profitmeters help determine the current profitability of backgrounding, given a set of production parameters. Users can model a current baseline versus planned and change the key drivers of average daily gain and stocking rate for each profitmeter.

Missouri Beef Budgets
Updated each year in November and available for both Northern and Southern Missouri.

Diagnostic Test Breakeven Calculator
This spreadsheet can be used by veterinarians and diagnostic laboratories to evaluate the economic return for implementing herd diagnostic screening for diseases affecting beef cattle. It also evaluates the sensitivity of the assumptions used by the veterinarian.

Determining Replacement Rate for Cow-Calf Herds
This spreadsheet can be used to determine the number of replacement heifers needed to keep the herd size constant given the pregnancy/retention rates for each age classification of cows.

Determining the Value of Replacement Heifer Development Systems
This spreadsheet can be used by producers and their veterinarians to determine the value of an alternate heifer development system compared to the farm's current production inputs. You will be asked to fill in several variables concerning the herd's current production and economic situation. The output is the amount of dollars available for the farm or per pregnant heifer to move to the alternate system. By using several production scenarios (expected case, best case, worst case), a confidence range can be produced for your situation.

Pregnancy Histograms
This spreadsheet can be used to create pregnancy histograms. Inputing several variables will allow the user to customize the spreadsheet to their own operation.

Using BRD-Treatment Option Calculator
This spreadsheet can be used by veterinarians consulting with feedlot and stocker cattle producers interested in evaluating their options for treatment protocols for bovine respiratory disease. The spreadsheet allows you to compare your current therapy (cost and "death rate following treatment") with an alternate treatment of a different cost. You will be asked to fill in several variables concerning the situation you are evaluating. The output is the needed "death rate following treatment" for the alternate therapy to be economically equivalent to the current therapy. By using several production scenarios (expected case, best case, worst case), a confidence range can be produced for your situation.

Drought

Drought Management Options
This spreadsheet evaluates three management options for drought, which include: buying pasture, hay and supplements to feed until drought and winter are finished, ship herd to graze outside the drought region, and destock/restock.

Ammoniation of Low Quality Roughages
This spreadsheet evaluates costs and benefits of ammoniating low quality roughages.

Forage Cost Per Ton Calculator
This calculator demonstrates the cost per ton of dry matter between differing bale sizes and moisture levels.

Genetics/Bull Selection

These decision tools were developed by Bob Weaber, Kansas State University Cow/Calf Extension Specialist

Across Breed EPD Calculator
Microsoft Excel based worksheet to adjust a list of animals’ Expected Progeny Differences (EPD) from one breed base to another breeds using the USDA Meat Animal Research Centers Across Breed EPD Adjustment Factors released at the 2009 Beef Improvement Federation meeting.

Adjusted Birth Weight, Weaning Weight, and Yearling Weight Worksheet
Microsoft Excel based worksheet to compute age and age-of-dam adjusted birth, weaning and yearling weights for beef cattle using the standard Beef Improvement Federations equations and adjustment factors.

Qualitative Trait Inheritance Calculator
Microsoft Excel based worksheet to estimate the probability of animals having various genotypes and phenotypes for simply inherited traits (coat color and horn/polled status). Allows users to input genotypes of parents and provides estimates of genotype and phenotype frequencies for resulting progeny.

Nutrition

Stockpiled Pasture Decision Table
Used to compare the practice of stockpiling tall fescue to other feed and forage options.

Mineral Feed Tag Evaluator
Used to evaluate commercial mineral mixes relative to NRC requirements using known mineral sources.

Trace Mineral Supplement Calculator
Instructions
Used to create trace mineral premixes relative to defined specifications.

Mark Trump/Kenneth Suter Mineral Calculator
Least cost custom mineral formulation tool used in conjunction with forage and supplement analysis.

Nutrients

Feedval2
Nutrient value estimation using corn, soybean meal, limestone and dical as reference values. Enter prices for reference feeds and Feedval2 returns the value of nutrients (Net energy of lactation, crude protein, calcium and phosphorus) found in alternative feedstuffs relative to reference feeds. If feedstuffs can be purchased at prices lower than calculated values, nutrients are priced at a discount to reference feedstuffs.

Feedval3
Instructions
Nutrient value estimation using corn, soybean meal, limestone and dical as reference values. Enter prices for reference feeds and Feedval3 returns the value of nutrients (Net energy of gain, crude protein, calcium and phosphorus) found in alternative feedstuffs relative to reference feeds. If feedstuffs can be purchased at prices lower than calculated values, nutrients are priced at a discount to reference feedstuffs.