Create intermediate Works with: Any AI

Resource Plan and Capacity Check

Table output Has example

See if the team can really do the work.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

Rate this prompt

Loading ratings…

Check capacity for my project. Tasks with effort estimates and required skills: [TASKS_AND_EFFORT]. Team members with skills and availability (hours per week, planned leave): [TEAM_AVAILABILITY]. Other commitments: [OTHER_COMMITMENTS].

Compute for each person: available hours per week = contracted hours x project share minus meetings and admin (use my percentages), then total available hours over the project, versus assigned hours, and utilization percentage (assigned / available), showing arithmetic. Flag anyone over 85 percent and skill bottlenecks (a task only one person can do).

Produce a table: Person | Skills | Available | Assigned | Utilization | Risk. Propose rebalancing, hiring or borrowing, training, or scope reduction, with trade-offs. Add a week-by-week load chart in text and a message to a resource manager requesting support (100 words). Remind me that estimates have ranges, and show the effect of a 20 percent overrun.

Return a load chart as a table of people by week, mark any week above 100 percent in bold, and list the two cheapest ways to relieve each overload, such as shifting a task or moving a deadline by days.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

See an example result (fictional data)
Team: Ana (80 percent on project, 40 hours a week contract) = 32 hours minus 4 for meetings = 28; Ben (100 percent) 40 - 6 = 34; Chen (50 percent) 20 - 2 = 18. Total per week 80 hours.
Project 8 weeks: available 640. Assigned effort: design 150, build 380, testing 140, management 60 = 730 hours.
Utilization = 730 / 640 = 114 percent. Over capacity by 90 hours.
Skill bottleneck: only Ben can do integration (120 hours; he has 34 x 8 = 272 available, ok but overloaded in weeks 4 to 6).
Options: reduce scope by 90 hours (drop reporting module, 100 hours), add contractor for 90 hours, or move the date by 1.5 weeks.
Effect of 20 percent overrun: 730 x 1.2 = 876 hours.

Illustrative only, made-up data. Your results will differ and must be reviewed.

Related prompts