agw

Global ExperienceAGW Consultants

.

HomeAbout AGWCase StudiesReference LibraryMethodsContact Us

SPREADSHEET FOR GENERALIZED CALCULATION OF ANNUAL PUMPING AND AMORTIZATION COSTS

Dr. William M. Turner
  http://www.agwconsultants.com senatorbil@aol.com  

 Download this spreadsheet in MS Excel '97 for Windows  format.   The spreadsheet is available in English or Metric units.  Be sure to use consistent decimal currency units.  You can also view a graph of  this table (35 kb).  The headings marked in Bold are variables.  The headings in regular text are constants.  Use the downloaded spreadsheets to examine your situation, and see how much difference the transmissivity will make in cost.  

Please contact us with your  results:

Hydraulic Conductivity ft/d 67 134 201 267 334 401 668 1337
Aquifer Transmissivity USgpd/ft 50000 100000 150000 200000 250000 300000 500000 1000000
Final Aquifer Transmissivity USgpd/ft 18370 66195 115498 165003 214620 264306 463428 962237
Storage Coefficient fraction 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1
Static Water Level ft 100 100 100 100 100 100 100 100
Well Diameter ft 1.5 1.5 1.5 1.5 1.5 1.5 1.5 1.5
Length of Original Water Column ft 100 100 100 100 100 100 100 100
Length of Final Water Column ft 37 66 77 83 86 88 93 96
Drawdown ft 63.26 33.81 23.00 17.50 14.15 11.90 7.31 3.78
Total Lift ft 163 134 123 117 114 112 107 104
Pumping Period yrs 1 1 1 1 1 1 1 1
                   
Design Pumping Rate USgpm 1500 1500 1500 1500 1500 1500 1500 1500
Total Water Requirement af/yr 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000
Total Water Requirement USgpm 6190 6190 6190 6190 6190 6190 6190 6190
                   
Electric Power Cost Local/kwh 0.1 0.1 0.1 0.1 0.1 0.1 0.1 0.1
Diesel Fuel Cost Local/USgal 0 0 0 0 0 0 0 0
Gasoline Fuel Cost Local/USgal 0 0 0 0 0 0 0 0
                   
Overall Pump Efficiency fraction 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7
Motor Efficiency fraction 0.7 0.7 0.7 0.7 0.7 0.7 0.7 0.7
Pump Horsepower BHP 88 72 67 64 62 61 58 56
                   
                   
Interest Rate % 7.5 7.5 7.5 7.5 7.5 7.5 7.5 7.5
Period of Amortization yrs 30 30 30 30 30 30 30 30
                   
u none 5.729E-09 2.880E-09 1.920E-09 1.440E-09 1.152E-09 9.600E-10 5.760E-10 2.880E-10
W(u) none 18.40 19.67 20.07 20.36 20.58 20.76 21.27 21.97
Drawdown ft 63.26 33.81 23.00 17.50 14.15 11.90 7.31 3.78
                   
Hourly Pumping Cost Per Well Local 9.42 7.72 7.09 6.78 6.58 6.45 6.19 5.98
Minimum Annual Pumping Cost Per Well Local 82,476  67,595  62,137  59,357  57,667  56,528  54,213  52,425 
Minimum Annual Total Pumping Cost Local 618,567  337,976  310,687  296,787  288,335  282,641  271,063  262,127 
                   
New Well Costs Per Foot Local 60 60 60 60 60 60 60 60
Minimum New Well Cost Local 21,307  21,042  20,070  19,575  19,274  19,071  18,658  18,340 
Wells Required Because of Excessive Drawdown   3 0 0 0 0 0 0 0
Wells Required to Meet Demand   5 5 5 5 5 5 5 5
Number of Required Wells   8 5 5 5 5 5 5 5
Annual Amortization Cost Local 39,950  26,303  25,088  24,469  24,092  23,839  23,323  22,925 
                   
Annual Operation & Amortization Local 618,567  337,976  310,687  296,787  288,335  282,641  271,063  262,127 

 

Back to Top  Back to Top        
 
 

HomeAbout AGWCase StudiesReference LibraryMethodsContact Us

© 1999 AGW Consultants.  All Rights Reserved.