L. David Roper
http://arts.bev.net/RoperLDavid/
23 December 2007
Zinc is used to make high-strength steel alloys and many kinds of batteries. The graph below shows the zinc extraction data for the world and two Verhulst function fits to the data in order to extrapolate into the future.

Zinc extraction rate for the world and Verhulst function fits to the data.
The red curve is a fit with total amount to be extracted of 600 x 106 tonnes, which incorporates the latest reserves estimate, and the blue curve is fit with total amount to be extracted of 900 x 106 tonnes, which incorporates the latest reserves-base estimate.
The extraction rate for recent years is overshooting the curves determined by the current estimate of reserves and reserves base.
Zinc, especially the nickel used in batteries, is recycled to a high degree. Assume that:
The effective zinc available for making items after the first ten recycling cycles is shown in the following graph, along with the effective zinc available for each cycle:

The equation for a recyling cycle is
,
where Ei is the amount available from the previous cycle. Here is an example of the Excel coding:
{=(($J$2+$I$2)/2+(($J$2-$I$2)/2)*TANH((A27-$K$2)/$L$2))*SUM($I$27:I27*(EXP(-1*((A27-$A$27:A27-$N$2)/$O$2)^2/2))/$O$2/SQRT(2*PI()))} (The curly bracket surrounding the term makes it into an array; it must be entered by holding down the SHIFT & CTRL keys while pressing the ENTER key.)
Of course, the recycling could be extended to more cycles, skewing the curve further into the future. However, the peak and fall off after it will not change because further cycles are essentally zero in that time region.
Thus, under the assumptions given above, the effective amount of zinc available for making items peaks at about 2035 and falls off rapidly after that. Humans will have taken concentrated zinc deposits and scattered them across the surface of the earth.
The Excel spreadsheet is set up to make it easy to calculate with different recycling assumptions.