Decision Tools | AgManager.info

Decision Tools

Miscellaneous
Title	Author	Date	Downloads
U.S. Supply and Demand (WASDE) Spreadsheets The World Agricultural Supply and Demand Estimates (WASDE) are released on about the 10th of each month by USDA. These spreadsheets provides historical data for corn, grain sorghum, wheat, and soybeans, from 1973 to present.	Llewelyn	September 10, 2021	Corn Supply and Demand Spreadsheet (WASDE) (980.5 KB) Grain Sorghum Supply and Demand Spreadsheet (WASDE) (413 KB) Soybean Supply and Demand Spreadsheet (WASDE) (419 KB) Wheat Supply and Demand Spreadsheet (WASDE) (451.5 KB)
KSU-Streambank Stabilization An Excel spreadsheet program to estimate the economic benefits and costs of streambank stabilization projects	Reid Smith Williams	March 14, 2017	Excel (4.45 MB)
KSU-Vegetative Buffer An Excel spreadsheet program to estimate the economic benefits and costs of vegetative buffers	Reid Smith Williams	March 14, 2017	Excel (2.59 MB)
Tips and Exercises for Using Excel Spreadsheets A manual and exercises used at Excel workshops to help users understand the basics of using Microsoft Excel (pdf)	Llewelyn Dhuyvetter	June 29, 2016	Tips (152.95 KB) Budgets (1.15 MB) Finance (1.24 MB) Excel key: Budgets (122 KB) Excel key: Finance (25.85 KB)
KSU-HomeWastewaterTreatment An Excel spreadsheet program to estimate the economic costs of wastewater treatment systems for homeowners	Smith Williams	May 5, 2016	Excel (1.13 MB)

Beef
Title	Author	Date	Downloads
KSU-Detailed Cow Calf Budget This spreadsheet allows a user to develop a detailed beef cow/calf enterprise budget to evaluate potential income, costs, and profitability.	Reid Johnson	September 9, 2021	Excel Spreadsheet Tool (943.3 KB) Input Sheet in Word (84.52 KB) Tutorial Video
K-State Feeder Cattle Risk Management Tool An Excel spreadsheet for evaluating feeder cattle risk management strategies	Tonsor	April 13, 2021	Excel (1.33 MB)
KSU-Merck Calf Vaccination Program Assessment Tool This spreadsheet is a decision-aid tool for cattle producers to compare expected net profit difference between alternative calf vaccination programs.	Tonsor Renter	March 11, 2021	Spreadsheet Tool (701.57 KB)
KSU-Beef Farm Management Guide Spreadsheet An Excel spreadsheet for beef cattle enterprise budgeting to evaluate potential income, costs and profitability.	Tonsor Reid	December 14, 2020	Excel Spreadsheet (900.71 KB)
KSU-Beef Cow Lease (Simple) An Excel spreadsheet for establishing a calf-income split or cash rental rate for leasing a beef cow herd	Tonsor Reid	December 18, 2019	Excel (681.19 KB)
KSU-Beef Replacement Excel spreadsheet to evaluate the economic value of purchasing replacement females	Tonsor Dhuyvetter	January 17, 2017	Excel (1.08 MB) MP4 (22.42 MB) WMV (30.18 MB)
Pasture Rental Rate Decision Tool An Excel spreadsheet for establishing a pasture rental rate based on budgeted income and party contributions.	Taylor Reid	December 27, 2016	PDF publication (951.54 KB) Spreadsheet (1008.63 KB)
KSU-Cattle Supplementation Cost An Excel spreadsheet to evaluate the total costs of various protein supplement programs for cow/calf and stocker producers	Pendell Dhuyvetter Smith Blasi	June 29, 2016	Excel (1.93 MB)
KSU-Bull vs AI Breeding Costs An Excel spreadsheet to evaluate the economic costs and benefits of natural (bull) breeding versus artificial insemination (AI) in beef herds	Pendell Dhuyvetter Johnson	November 11, 2015	Excel (714.64 KB)
Cattle Breakeven Prices Yearling-Fed An Excel spreadsheet for calculating breakeven cattle prices of yearlings placed on feed	Tonsor Dhuyvetter Highfill	October 13, 2015	Excel (754.34 KB)
Cattle Breakeven Prices Calf-Yearling An Excel spreadsheet for calculating breakeven cattle prices between the calf and yearling stages	Tonsor Dhuyvetter Highfill	October 13, 2015	Excel (1.31 MB)
KSU-BeefCowLease A spreadsheet budgeting program to determine equitable share lease rental arrangements for beef cowherds (Oklahoma State/K-State version)	Dhuyvetter Doye	January 20, 2013	PDF-Article (666.14 KB) PDF-Form (144 KB) Excel (1.4 MB)

Policy & Risk Management
Title	Author	Date	Downloads
Financial Benchmarking Tool A tool to assess a farm's financial position relative to other similar farms in the same region.	Herbel Reid Dikeman	June 21, 2021	PDF Instructions (390.03 KB) Excel Tool (2.33 MB)
2021 Supplemental Coverage Option (SCO) and Enhanced Coverage Option (ECO) Payment Calculator This calculator will show SCO and ECO payments based on final county yields and harvest price for a farmer's underlying crop insurance contract.	Ifft	March 15, 2021	SCO Payment Calculator (17.13 MB)
Tradeoff Between 2021/2022 ARC and PLC This spreadsheet shows the tradeoff between ARC-CO and PLC payments at various Marketing Year Average prices and county yield levels.	Reid	February 4, 2021	Spreadsheet (3.48 MB) Tutorial Video
2020 Supplemental Coverage Option (SCO) Payment Calculator This calculator will show SCO payments based on final county yields and harvest price for a farmer's underlying crop insurance contract.	Reid	March 2, 2020	Excel Spreadsheet (17.25 MB)
2019 Supplemental Coverage Option (SCO) Payment Calculator This spreadsheet will allow you to calculate a 2019 SCO payment based on the final county yield and underlying crop insurance contract.	Reid	March 2, 2020	Excel Spreadsheet (18.17 MB)
Monthly Cash Flow for Operating Loan Determination A spreadsheet to assist in building a monthly cash flow statement to determine operating loan levels.	Reid Dikeman	August 8, 2018	Excel Spreadsheet (741.23 KB)
KSU-Integrated Financial Statements An Excel spreadsheet to build a balance sheet, income statement, and cash flow from farm records. Financial ratios are also computed.	Herbel Reid Dikeman	December 6, 2017	Hand fill-in Statements (207.73 KB) Spreadsheet with Example Farm (280.83 KB) Blank Financial Statements Spreadsheet (277.94 KB)
KSU-Insurance Alternatives for Winter-Damaged Wheat An Excel spreadsheet for helping producers analyze options for wheat damaged by winter weather.		May 11, 2017	Excel (148.59 KB)
Working Capital 5-Year Spreadsheet A spreadsheet to evaluate working capital needs for a 5-year horizon. Presented at the 2016/2017 "Top 10 Considerations to Navigate the Struggling Farm Economy" programs.	Featherstone	December 12, 2016	Spreadsheet (19.17 KB)
AGR-Lite Whole-Farm Revenue Insurance An Excel spreadsheet to assess the AGR-Lite whole farm insurance program for a farming operation	Llewelyn Barnaby	May 24, 2016	PDF-Instructions (65.48 KB) Excel (1.68 MB)
KSU-Income Statement This spreadsheet includes a cash only and accrual adjusted income statement. This was presented at the 2020 Farm Finanical Skills for Kansas Women in Ag. series.	Reid Winsor		Excel Spreadsheet (15.2 KB)

Crop Production Economics
Title	Author	Date	Downloads
KSU-Prevented Planting on Corn A spreadsheet tool to help producers evaluate the options they have once they hit the final planting date for corn and what might be most economical given projected harvest prices.	Reid	June 3, 2021	Excel Spreadsheet (315.97 KB)
Seasonal Cash Grain Prices An Excel spreadsheet to evaluate seasonality in the Kansas grain market	O'Brien Reid Dhuyvetter	September 17, 2020	Excel Spreadsheet (1.39 MB)
WASDE Quick Analysis Spreadsheet Dan O’Brien evaluates the numbers from the USDA WASDE grain supply and demand report.	O'Brien	September 13, 2018	Excel (186.62 KB)
Methods of Valuing Corn or Grain Sorghum Silage A spreadsheet tool designed to look at silage pricing methods from both the owner and buyer perspectives.	Reid Holman	August 2, 2018	Paper (377.53 KB) Excel Spreadsheet (29.25 KB)
Wheat Grazeout Partial Budget This spreadsheet is designed to help a producer make the decision to pull cattle at wheat jointing and harvest as a grain crop or to grazeout wheat	Reid Lollato Holman	April 17, 2018	Excel Spreadsheet (18.24 KB) Agronomy E-Update Article
KSU-Fertilizer Tool An Excel spreadsheet to calculate which combinations of fertilizers will meet the nutrient requirements of a field, at the lowest cost.	Ibendahl	March 30, 2017	PDF (178.23 KB) Excel (439.72 KB)
KSU-Cover Crop Cost-Return Budget An Excel spreadsheet to analyze the economics of planting a cover crop based on short-term benefits	Taylor Reid Shoup Farney	August 10, 2016	Excel Spreadsheet (1.08 MB)
Economics of Spraying Field Crops An Excel spreadsheet to analyze the economics of spraying a crop field based on the anticipated yield response	Griffin Dhuyvetter Jardine	July 8, 2016	Excel (2.92 MB)
Bermuda Hay Economics An Excel spreadsheet to analyze the economics of planting bermuda grass and harvesting as hay	Dhuyvetter Moyer	July 8, 2016	Excel (3.83 MB)
KSU Irrigation Energy Cost A spreadsheet to compare the costs of irrigation energy options	Griffin Dhuyvetter Dumler	May 23, 2016	Excel (1.03 MB)
Guidance & Section Control Profit Calculator A computer spreadsheet program to analyze the economics of investing in machine guidance and section control technologies	Dhuyvetter Smith Kastens	May 20, 2016	PDF (420.31 KB) Excel (1.39 MB) Video-WMV (18.59 MB)
KSU-OptionStrategies An Excel spreadsheet to compare alternative marketing strategies that use the futures and options markets	Dhuyvetter	December 12, 2013	Excel (968 KB)

Land Leasing & Purchase
Title	Author	Date	Downloads
Lease Simulation Tool Instructional videos for using the Lease Simulation Tool: 1. General Overview 2. How to Create a New Budget 3. Cash Versus Share Rent 4. How to Interpret Results 5. How to Run Simulations	Ibendahl	December 14, 2020	Excel (448.82 KB)
KSU-Lease An Excel spreadsheet to determine equitable crop share and cash lease rental arrangements	Taylor Dhuyvetter Kastens	July 8, 2016	User Guide (127.79 KB) Excel (487.44 KB)
KSU-Landbuy An Excel spreadsheet to analyze land purchase prices and land values in general	Taylor Dhuyvetter Kastens	August 20, 2013	PDF (880.93 KB) Excel (341.5 KB) Video Guide (47.9 MB) Audio Guide (10.69 MB)
KSU-FlexRent An Excel spreadsheet to calculate flexible cropland rents based on price, yield, or revenue	Taylor Dhuyvetter Kastens	January 18, 2012	PDF Publication (75.19 KB) Excel (337.5 KB)

Sheep
Title	Author	Date	Downloads
KSU-Sheep Farm Management Guide Spreadsheet An Excel spreadsheet for sheep enterprise budgeting to evaluate potential income, costs and profitability.	Pendell Reid	December 14, 2020	Excel Spreadsheet (1.01 MB)

Swine
Title	Author	Date	Downloads
KSU Swine Farm Management Guide Spreadsheet An Excel spreadsheet for swine enterprise budgeting to evaluate potential income, costs and profitability	Tonsor Reid	December 14, 2020	Excel Spreadsheet (1.07 MB)
KSU-Hog Contract Evaluation Tool	Tonsor	June 18, 2020	PDF (254.2 KB) Spreadsheet (363.26 KB)

Dairy
Title	Author	Date	Downloads
KSU-Dairy Farm Management Guide Spreadsheet Excel spreadsheet for dairy enterprise budgeting to evaluate potential income, costs and profitability	Tonsor Reid	December 14, 2020	Excel Spreadsheet (498.9 KB)
KSU-SilageValue A spreadsheet program to estimate the vaue of corn or grain sorghum silage based upon the price of grain, harvesting costs, and nutrients removed	Reid Dhuyvetter	July 8, 2016	Excel
Silage Storage: Economics of Bunkers, Piles, or Bags for Dairy A spreadsheet to evaluate the storage capacity requirements and the economic costs associated with storing silage in bunkers, piles, or plastic bags	Dhuyvetter	March 1, 2014	PDF Publication (46.93 KB) Excel (762.94 KB)

Limit-Feeding Stockers
Title	Author	Date	Downloads
K-State Feedlot Budget Tool - Limit-Fed or Ad Lib - Marketing on the Grid Accompanying article HERE	Tonsor Blasi Hissong	September 16, 2020	Excel (218.6 KB)
K-State Feedlot Budget Tool - Limit-Fed or Ad Lib - Marketing Live Cattle Accompanying article HERE	Tonsor Blasi Hissong	September 16, 2020	Excel (216.06 KB)
K-State Backgrounding Budget Tool - Limit-Fed or Ad Lib - Stocker Phase Accompanying article and video HERE	Tonsor Blasi Hissong	September 16, 2020	Excel (209.19 KB)

Machinery & Building
Title	Author	Date	Downloads
Machinery Cost Calculator 1. Click the link below to download the set-up file. 2. Open the file, click "More Info", then the "Run Anyway" button. 3. Click "Install", then "Finish" when completed. Locate the "Machinery Cost Calculator" on the desktop and double-click to open. Machinery Cost Calculator - Windows Version (Set-up)	Ibendahl	July 7, 2020
KSU-Truck Cost An Excel spreadsheet to estimate the cost of owning and operating a truck	Llewelyn Dhuyvetter	June 30, 2016	Excel (249.2 KB)
KSU-Machinery Costs An Excel spreadsheet to assist producers in calculating farm specific custom farming rates and benchmarking machinery costs	Dhuyvetter Kastens Beaton	June 30, 2016	PDF (181.6 KB) Excel (902.45 KB)
KSU-Building Cost-Rent An Excel spreadsheet to estimate the annual cost of owning and maintaining agricultural storage buildings to aid in determining estimates for building rent	Llewelyn Dhuyvetter Dumler	June 30, 2016	PDF Publication (136.36 KB) Excel (298.8 KB)
KSU-Own Baler An Excel spreadsheet to evaluate the economic costs of owning and operating a large square or large round hay baler	Llewelyn Dhuyvetter Kastens	June 30, 2016	PDF Publication (198.74 KB) Excel (992.76 KB)
KSU-Own Combine An Excel spreadsheet to evaluate the economic costs of owning and operating a combine	Llewelyn Dhuyvetter Kastens	June 30, 2016	Excel (720.97 KB)
KSU-Own Tractor An Excel spreadsheet to evaluate the economic costs of owning and operating a tractor	Llewelyn Dhuyvetter Kastens	June 30, 2016	PDF Publication (2.14 MB) Excel (2.79 MB)
KSU-Own Sprayer An Excel spreadsheet to evaluate the economic costs of owning and operating a self-propelled crop sprayer	Llewelyn Dhuyvetter Kastens	June 30, 2016	PDF Publication (145.2 KB) Excel (1.65 MB)
Guidance & Section Control Profit Calculator A computer spreadsheet program to analyze the economics of investing in machine guidance and section control technologies	Dhuyvetter Smith Kastens	May 20, 2016	User Guide (420.31 KB) Excel (1.39 MB) Video (18.59 MB)