Here's a link to my resource calculator:

Plan B: Terraform Resource Calculator[docs.google.com]

First, create a copy of the spreadsheet for yourself to use. The tabs represent different tiers of city populations, go to the appropriate tab and input your population at the top to see everything you need to keep that city running.

There's also a tab to calculate the production of finished products from assembly plants.