Track and optimize team resource allocation across projects and identify skill gaps
Track team member allocation across projects, identify over/under-utilized resources, and surface skill gaps for upcoming work. Generates allocation matrices and capacity planning reports.
Extract parameters — Parse from user input:
For VIEW command — Generate current allocation snapshot:
Fetch all Asana tasks assigned to team members:
Use the `list_tasks` MCP tool
--filter "assignee-team=[team-name]" --max 500
Extract: assigned team member, project, task, due date, estimated effort
Fetch calendar events for team (meetings, blocked time):
Use the `calendar_events` MCP tool
--attendee "[team-email-list]" --days-ahead 30
Calculate meeting load per person
Load team roles and capacity from vault:
cat ~/.second-brain/vault/team/*.md
Extract: role, department, capacity (hours/week available), skills, seniority
For PLAN command — Plan allocation for upcoming work:
Use the `search_memory` MCP tool with query: "project pipeline upcoming initiative"
For GAPS command — Identify skill/capacity gaps:
Use the `search_memory` MCP tool with query: "needed skills project requirements"
Build allocation matrix — Team member × Project/Work:
| Team Member | Role | Current Allocation | Capacity Remaining | % Utilized |
|-------------|------|-------------------|-------------------|-----------|
| [Name] | [Role] | [Current tasks] | [X hours/week] | [Y%] |
Generate allocation report with sections:
Current Allocation Summary:
Allocation by Team Member:
| Name | Role | % Utilized | Projects | Blocker? |
|---|---|---|---|---|
| [Name] | [Role] | [X%] | [Project 1, Project 2] | [Overloaded/Underutilized/Optimal] |
Over-Allocated Team Members (>100% utilization):
Under-Allocated Resources (<50% utilization):
Skills Assessment:
Project Resource Needs vs. Supply:
| Project | Timeline | Needs | Available | Gap | Risk |
|---|---|---|---|---|---|
| [Project] | [Dates] | [4 eng, 1 design] | [3 eng, 1 design] | [1 eng] | High |
Identify conflicts and recommendations:
Save allocation snapshot to:
~/.second-brain/vault/ops/allocation/YYYY-MM-DD-allocation.md
Include YAML frontmatter:
---
date: "[YYYY-MM-DD]"
period: "[current|[start-date] to [end-date]]"
total_capacity_hours: "[X hours/week]"
total_allocated_hours: "[X hours/week]"
utilization_percent: "[X%]"
---
Create Asana tasks for resource actions:
Use the `list_tasks` MCP tool (task creation via Asana API — log the action item with `log_note` instead)
--project "Operations" \
--name "[Resource action]: [brief description]" \
--assignee "[manager]" \
--due-date "[action-date]"
Add capacity review to calendar (monthly or quarterly):
Log the calendar item with `log_note` (calendar creation not yet in MCP)
--title "Team Capacity Review & Resource Planning" \
--date "[monthly/quarterly]" \
--recurring "[monthly|quarterly]"
Log to daily log:
- **HH:MM** — [OPS] Resource allocation snapshot: <team-name> — Utilization: <percent>% — Gaps: <count> critical
Use this structure for allocation snapshot file:
---