Agency Capacity Planner.
Plan who works on what for the next eight weeks, before you overbook anyone.
About this template
A people-by-weeks scheduling grid where you allocate each team member's hours across projects and see total load against their weekly capacity. Overbooked cells flag in red and free capacity shows at a glance, so staffing new work takes minutes instead of a partner meeting. Filters by role and project keep larger teams readable.
The live demo ships with sample data: A 14-person team allocated across 10 active projects for the next eight weeks, including two overbooked designers and a strategist with a free bench week.
The prompt behind this template
This is the exact description the Prized agent built it from. Yours can be one sentence: the agent fills in the rest, and you refine from there.
Show the full prompt
Build a capacity planning grid for Outpost Creative, a 14 person design and strategy agency in Portland, where two producers decide who works on what for the next eight weeks before anyone gets overbooked. Layout. A slim header holds three summary chips (team utilization this week 87 percent, people overbooked in the next four weeks 2, free hours over the next four weeks about 160) plus a role filter, a project filter, and a name search. The hero is a people by weeks grid: one row per person showing name, role badge, and weekly capacity in hours, and one column per week for the next eight weeks, each labeled by its Monday date. Every cell reads allocated hours over capacity, for example 36 / 32, tinted green below 85 percent of capacity, amber from 85 to 100 percent, and red when allocated hours exceed capacity. Clicking a cell opens a popover listing that week's allocations with project names and hours. Selecting a person opens a right side panel with a stacked bar chart of their eight week load broken down by project and an editable list of their allocations. A primary Add allocation button opens a dialog capturing person, project, hours per week, start week, and end week. Data. Seed 14 team members with realistic names, roles (5 designers, 3 strategists, 3 engineers, 2 producers, 1 content lead), and weekly capacities of 32 to 40 hours. Seed 10 active projects with client names such as Meridian Bank, Halfpipe Coffee, and Foxglove Skincare. Seed about 55 allocations so most people carry two or three projects at a time. Plant the story: designers Maya Chen and Jonas Petit are overbooked at 110 to 125 percent in weeks two through four, glowing red in the middle of the grid, and strategist Priya Nair has a completely free week five, the one wide open row that week. Behavior. Cell totals, utilization chips, and free hours are computed from allocations; users only ever enter allocations. The role filter hides rows, the project filter dims people not staffed on that project, and the roster defaults to sorting by role then name. Weeks are always the next eight starting from the current week. Visual identity. Use a deep blue accent for primary actions, utilization emphasis, and active states on a clean light neutral base, so the red overbooked cells read instantly.
More like this
All templatesAgency Utilization Dashboard
See billable utilization by person and team, and catch under-booked weeks early.
Proposal Pipeline Tracker
Track every proposal from first call to signed SOW in one board.
Retainer Burn Tracker
Know how much of each client retainer is used before the month runs out.