http://www.nouptime.com/
It would greatly depend on your traffic volume.
Static website does not relies much on direct CPU power. I would say that if it exceeds 50K visitors daily a VPS would be profitable and this being a raw number to give you an idea.
The main ressources required by a static website is apache slots actually.
new website, with 50 article and 1-2 image/article