Skip to content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Skip to content

Economic Model of Deficit Irrigation II (spreadsheet)

Metadata Updated: February 4, 2022

This spreadsheet model calculates the net income for irrigated agricultural production. The model is designed to evaluate the economics of deficit irrigation (irrigation at less than the amount required to produce maximum yield). The spreadsheet first models the water production function for a crop, then uses that relationship along with crop price and production costs to calculate net income and the irrigation amount that maximizes net income. This spreadsheet is similar to another posted at Ag Data Commons: "Economic Model of Deficit Irrigation" ( That model was designed primarily to evaluate deficit irrigation as a means to compare revenue with reduced water consumption to income gained by transferring the saved water. The model includes two common scenarios: 1) irrigation water supply is adequate but expensive, and 2) irrigation water supply is inadequate to fully irrigate the available land. In the first scenario, net income is maximized when the marginal costs of production, including water, is equal to the marginal revenue. In the second scenario, net income is maximized when the value of the water is maximized by selecting the portion of the land that should be irrigated. In the second scenario, the value and costs of the un-irrigated land are included. The first worksheet of the spreadsheet describes the relationships used in each worksheet and the input parameters required. Additional worksheets calculate the water production function, the irrigation water production function, and the net income for each of the two scenarios. The worksheets allow the user to input the various biophysical and economic parameters relevant to their conditions and allows evaluating various parameter combinations. Each worksheet contains graphs to visualize the results.

Access & Use Information

Public: This dataset is intended for public access and use. License: Creative Commons CCZero

Downloads & Resources


Metadata Created Date November 10, 2020
Metadata Updated Date February 4, 2022

Metadata Source

Harvested from USDA JSON

Additional Metadata

Resource Type Dataset
Metadata Created Date November 10, 2020
Metadata Updated Date February 4, 2022
Publisher Agricultural Research Service
Identifier a5e4e58a-d458-4272-b61f-0e1a0047c08e
Data Last Modified 2020-12-31
Public Access Level public
Bureau Code 005:18
Metadata Context
Schema Version
Catalog Describedby
Data Dictionary
Harvest Object Id 142353df-d463-4eab-ad07-446eeb4eaeb3
Harvest Source Id d3fafa34-0cb9-48f1-ab1d-5b5fdc783806
Harvest Source Title USDA JSON
Old Spatial {"type":"Polygon","coordinates":-129.287109375,26.630273470592,-129.287109375,51.098347790891,-93.427734375,51.098347790891,-93.427734375,26.630273470592}
Program Code 005:040
Source Datajson Identifier True
Source Hash 4db95d3592a2f04581fce8afc1cf4f5efa21484d
Source Schema Version 1.1
Spatial {"type":"Polygon","coordinates":-129.287109375,26.630273470592,-129.287109375,51.098347790891,-93.427734375,51.098347790891,-93.427734375,26.630273470592}

Didn't find what you're looking for? Suggest a dataset here.

An official website of the GSA's Technology Transformation Services

Looking for U.S. government information and services?