How long before the Earth's bounty runs out - a future history

Scientific American provides a detailed, hypothetical response to the question which has no doubt crossed the mind of anyone involved with the mining sector - how long before the Earth's bounty of resources runs out? The venerable US science magazine...