Content Calendar Template with Capacity & Cost Calculator for Small Content Teams (runs in Excel or Google Sheets, no Airtable account needed)

Miscount your capacity and you blow the budget or miss deadlines. A freelancer or agency charges $500–$3,000 a month to plan and run a content calendar — this workbook does the capacity, cost and budget math from your own numbers.

Your numbers

Channels you publish toPosts per week per channelHours to produce one pieceTeam content hours available per weekYour loaded hourly cost ($)Freelance overflow rate ($/hour)Non-labor cost per piece — stock, tools, boosting ($)Monthly content budget ($)

Your result

Total posts per week	-
Total posts per month	-
Total posts per year	-
Production hours needed per week	-
Weekly capacity gap (hours short)	-
Team capacity used (%) — over 100 means understaffed	-

Everything updates as you type. Nothing is uploaded. This runs in your browser.

Get the full calculatorFull version: all tabs, your own file, works offline.