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	November 9, 2023	Corn Supply and Demand Spreadsheet (WASDE) (1.04 MB) Grain Sorghum Supply and Demand Spreadsheet (WASDE) (460.5 KB) Soybean Supply and Demand Spreadsheet (WASDE) (466 KB) Wheat Supply and Demand Spreadsheet (WASDE) (500 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)

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	October 27, 2023	Spreadsheet Tool (1.41 MB)
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)
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)
KSU Irrigation Energy Cost A spreadsheet to compare the costs of irrigation energy options	Griffin Dhuyvetter Dumler	May 23, 2016	Excel (1.03 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)

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 21, 2023	Excel Tool (870.37 KB) Input Sheet in WORD (86.99 KB) Tutorial Video
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	July 13, 2023	Calf Vaccination Spreadsheet Tool (693.33 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
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
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 31, 2023	PDF Instructions (390.03 KB) Spreadsheet Tool (2.32 MB)
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
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	February 26, 2020	Excel Spreadsheet (15.2 KB)
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)

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

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)

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-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	Dhuyvetter Dumler	June 30, 2016	PDF Publication (136.36 KB) Excel (298.8 KB)