Economic Model of Deficit Irrigation

This spreadsheet is a model of the economics of deficit irrigation that is described in detail in: Trout, T.J. and D.T. Manning. 2019. An economic and biophysical model of deficit irrigation. Agron. J. 111:1–12. doi:10.2134/agronj2019.03.0209 . The model calculates net income from a crop on a unit of land based on a quadratic crop water production function, amount of effective precipitation, irrigation efficiency, cost of the irrigation water supply, crop production costs, and revenue from selling the crop. The model includes potential income from leasing out saved irrigation water. All biophysical variables are defined in terms of the relative evapotranspiration. Net income is maximized by optimizing the amount of water consumed by the crop. The spreadsheet progressively presents biophysical and economic models of deficit irrigation with water leasing. Economic and biophysical parameters are input into the highlighted cells of each worksheet. Parameters from previous worksheets are copied to following worksheets. Relationships are graphed. Output is the net income (NI) for a set of biophysical and economic parameters and level of deficit irrigation that maximizes net income. Resources in this dataset:Resource Title: Economic Model of Deficit Irrigation (spreadsheet). File Name: WPF Econ Model V2.xlsxResource Title: Description of the Model. File Name: Description of the Deficit Irrigation Economics Model.pdfResource Description: Description of the Model inputs and operation.

Data and Resources

Field Value
accessLevel public
bureauCode {005:18}
catalog_@context https://project-open-data.cio.gov/v1.1/schema/catalog.jsonld
catalog_conformsTo https://project-open-data.cio.gov/v1.1/schema
catalog_describedBy https://project-open-data.cio.gov/v1.1/schema/catalog.json
identifier 10.15482/USDA.ADC/1504421
license https://www.usa.gov/publicdomain/label/1.0/
modified 2024-02-15
programCode {005:040}
publisher Agricultural Research Service
resource-type Dataset
source_datajson_identifier true
source_hash d6766763abe10b3e2eaa30ab7c06a59e489232ada0a8a75d3e054e39457dd969
source_schema_version 1.1
Groups
  • AmeriGEOSS
  • National Provider
  • North America
Tags
  • AmeriGEO
  • AmeriGEOSS
  • CKAN
  • GEO
  • GEOSS
  • National
  • North America
  • United States
  • agricultural-economics
  • ars
  • data-gov
  • deficit-irrigation
  • economic-model
  • irrigation-and-water-use
  • np211
isopen False
license_id us-pd
license_title us-pd
maintainer Trout, Thomas
maintainer_email thomas.trout@usda.gov
metadata_created 2025-09-24T03:22:38.759884
metadata_modified 2025-09-24T03:22:38.759897
notes <p>This spreadsheet is a model of the economics of deficit irrigation that is described in detail in: Trout, T.J. and D.T. Manning. 2019. An economic and biophysical model of deficit irrigation. Agron. J. 111:1–12. doi:10.2134/agronj2019.03.0209 . </p> <p>The model calculates net income from a crop on a unit of land based on a quadratic crop water production function, amount of effective precipitation, irrigation efficiency, cost of the irrigation water supply, crop production costs, and revenue from selling the crop. The model includes potential income from leasing out saved irrigation water. All biophysical variables are defined in terms of the relative evapotranspiration. Net income is maximized by optimizing the amount of water consumed by the crop.</p> <p>The spreadsheet progressively presents biophysical and economic models of deficit irrigation with water leasing. Economic and biophysical parameters are input into the highlighted cells of each worksheet. Parameters from previous worksheets are copied to following worksheets. Relationships are graphed. Output is the net income (NI) for a set of biophysical and economic parameters and level of deficit irrigation that maximizes net income.</p> <div><br>Resources in this dataset:</div><br><ul><li><p>Resource Title: Economic Model of Deficit Irrigation (spreadsheet).</p> <p>File Name: WPF Econ Model V2.xlsx</p></li><br><li><p>Resource Title: Description of the Model.</p> <p>File Name: Description of the Deficit Irrigation Economics Model.pdf</p><p>Resource Description: Description of the Model inputs and operation.</p></li></ul>
num_resources 2
num_tags 15
title Economic Model of Deficit Irrigation