Solving Optimal Groundwater Problems with Excel

Kimberly Burnett, Water Resources, James Roumasset, Christopher Wada, Education, Environment, Publications

Abstract: Welfare maximizing management of coastal groundwater requires a sequence of pumping targets, typically terminating with a constant withdrawal rate in the long run. In contrast, managing according to sustainable yield at best identifies the constant rate of pumping in the long run. We illustrate an accessible solution method, using Excel Solver to find the optimal transition paths of groundwater pumping, price, and head level and the corresponding solutions in the long run. The developed framework is applied to the Pearl Harbor Aquifer (PHA) in Hawaii using data from previous studies. Each step of the solution process is described, including setting parameter values and defining objective, variable, and constraint cells in Excel to facilitate successful replication of the results. Possible extensions are also discussed such as watershed conservation, protection of groundwater dependent ecosystems, and management of multiple aquifers.

Wada, Christopher A., et al. “Solving Optimal Groundwater Problems with Excel.” Applied Economics Teaching Resources (AETR) 5.2 (2023).

Leave a Comment

Your email address will not be published. Required fields are marked *

The University of Hawaii Economic Research Organization (UHERO) welcomes online comments to stories that are posted on our website or social media pages. Comments are intended to be a forum for open, respectful, and family-friendly discussion. UHERO reserves the right to remove anything posted on our website or social media pages that is deemed inappropriate. All comments are moderated and will therefore have a delayed post time.
Some guidelines (not an exhaustive list) we use when moderating/approving comments include:

  • Do not bully, intimidate, or harass any user.
  • Do not post content that is hateful, threatening or wildly off-topic; or do anything unlawful, malicious, discriminatory or defamatory.
  • Observe confidentiality laws at all times.
  • Do not post spam or advertisements.
  • Observe fair use, copyright and disclosure laws.
  • Do not use vulgar language or profanity.

UHERO may amend this policy from time to time.