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	June 9, 2023	Corn Supply and Demand Spreadsheet (WASDE) (1.03 MB) Grain Sorghum Supply and Demand Spreadsheet (WASDE) (458 KB) Soybean Supply and Demand Spreadsheet (WASDE) (464.5 KB) Wheat Supply and Demand Spreadsheet (WASDE) (498 KB)
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	May 25, 2022	Tips (293.02 KB) Budgets (1.15 MB) Finance (1.24 MB) Excel key: Budgets (122 KB) Excel key: Finance (25.85 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)
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-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	May 10, 2023	Vaccination Spreadsheet Tool (694.63 KB)
K-State Feeder Cattle Risk Management Tool An Excel spreadsheet for evaluating feeder cattle risk management strategies	Tonsor	February 13, 2023	Excel (1.16 MB)
KSU-Beef Replacement Excel spreadsheet to evaluate the economic value of purchasing replacement females	Tonsor Dhuyvetter	January 31, 2023	Spreadsheet (1.07 MB) MP4 (22.42 MB) WMV (30.18 MB)
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 16, 2022	Excel Tool (678.09 KB)
2023 KSU-Beef Farm Management Guide Spreadsheet An Excel spreadsheet for beef cattle enterprise budgeting to evaluate potential income, costs and profitability.	Tonsor Reid	December 16, 2022	Excel Spreadsheet (900.67 KB)
Hay Inventory Calculator This tool helps assess how much hay will be needed for the cowherd and then how much hay is available based on inventory on-hand and expected tonnage to be bailed.	Reid	May 18, 2022	Excel Worksheet (189.73 KB) Tutorial Video
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 (873.43 KB) Input Sheet in WORD (86.99 KB) Tutorial Video
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)

Policy & Risk Management
Title	Author	Date	Downloads
2023 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 6, 2023	SCO/ECO Payment Calculator (17.22 MB)
Tradeoff Between 2023/2024 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	January 13, 2023	Spreadsheet Tool (4.97 MB) Tutorial Video from 2022
Financial Benchmarking Tool A tool to assess a farm's financial position relative to other similar farms in the same region.	Herbel Reid Dikeman	August 23, 2022	PDF Instructions (390.03 KB) Spreadsheet Tool (2.32 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	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)

Swine
Title	Author	Date	Downloads
KSU-Hog Contract Evaluation Tool	Tonsor	February 17, 2023	PDF (346.53 KB) Spreadsheet (374.95 KB)
2023 KSU Swine Farm Management Guide Spreadsheet An Excel spreadsheet for swine enterprise budgeting to evaluate potential income, costs and profitability.	Tonsor Reid	December 16, 2022	Excel Spreadsheet (1.07 MB)

Dairy
Title	Author	Date	Downloads
2023 KSU-Dairy Farm Management Guide Spreadsheet Excel spreadsheet for dairy enterprise budgeting to evaluate potential income, costs and profitability.	Tonsor Reid	December 16, 2022	Excel Spreadsheet (498.53 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)

Sheep
Title	Author	Date	Downloads
2023 KSU-Sheep Farm Management Guide Spreadsheet Excel spreadsheet for dairy enterprise budgeting to evaluate potential income, costs and profitability.	Tonsor Reid	December 16, 2022	Excel Spreadsheet (1.01 MB)

Crop Production Economics
Title	Author	Date	Downloads
Seasonal Cash Grain Prices An Excel spreadsheet to evaluate seasonality in the Kansas grain market	O'Brien Reid Dhuyvetter	September 7, 2022	Spreadsheet (1.41 MB)
Considerations for taking Prevent Plant in 2022 because of Drought Conditions	Reid Haag	May 4, 2022	PDF Publication (402.92 KB) Excel Spreadsheet (304.71 KB)
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)
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)
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)
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)
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 (276.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)

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-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)
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)
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)