Workload Balancer & Re-allocation Advisor

The problem this kills

Some people on your team are drowning while others have room - and you only find out when something slips, someone burns out, or a deadline blows up. Figuring out who is over capacity, who could take more, and which exact task should move (to someone who actually has the skill) is hours of squinting at a spreadsheet. So it doesn't happen, and the imbalance just compounds.

Worse, when you do rebalance by hand, it's easy to over-shuffle - moving ten things when three would have fixed it - which itself becomes disruption nobody wanted.

This tool does the math and the matching for you, then hands you a short list of specific, defensible moves to approve. Nothing changes until you say so.

What you'll build

A private web app, just for your team, that:

• Imports your current allocations from a CSV or Google Sheet (or your system later) - people, their capacity, their skills, and every task currently assigned.
• Detects imbalance - calculates each person's load against their capacity and flags who is over and who is under.
• Proposes specific moves - "Move task Onboarding deck from Priya (118% loaded) to Sam (62% loaded, has the Design skill)" - each with a plain-English rationale.
• Minimizes disruption - prefers the fewest moves that fix the imbalance, and only ever suggests a move to someone who has the required skill.
• Puts a manager in charge - every proposed move is reviewed and accepted, edited, or rejected one at a time. Nothing auto-moves.
• Exports the approved changes as a clean CSV in the exact columns your system of record expects.

What's inside the Implementation Plan

• It interviews you first. Before writing a line of code, the plan has the AI agent ask you about your real process - how you track allocations today, what "capacity" means for your team (hours? story points? number of tasks?), your skill taxonomy, your naming and ID conventions, your peak periods, and your real approval rules. It reads back a short tailored spec, you confirm it, and only then does it build. You get a tool shaped to your team, not a generic template.
• A step-by-step build, each step ending with a ready-to-paste prompt.
• A data model tuned to your answers (people, capacity, skills, tasks, allocations, proposed moves, approvals).
• The imbalance + matching logic, with skill respect and fewest-moves bias baked in.
• A manager review screen with accept / edit / reject per move.
• The CSV export in your system's column shape.
• A "No API yet?" fallback so you can build and use the whole thing this weekend with just spreadsheets.
• A verification checklist so you know it actually works.

The governance it includes (this is the point)

This isn't a black box that quietly reshuffles your team. It's built so you can defend every change:

• Login so only your team can open the tool.
• Row-level security so each organization only ever sees its own people and allocations.
• A complete audit trail - who proposed, who approved or rejected, and when.
• A hard human-in-the-loop gate - the AI drafts the moves; a manager reviews and approves; only then does anything get committed or exported. The tool never moves work on its own.
• Duplicate guards - keyed on the task/assignment ID, so the same move can't be proposed or committed twice.

Who it's for

Resource managers, delivery leads, and team leads who own how work is distributed across a team and are accountable for both throughput and not burning people out. If you live in a capacity spreadsheet and dread rebalancing day, this is for you.

You've got this - paste the first prompt and let the interview tailor it to your team.