PROJECT MANAGEMENT

Weekly Capacity Forecast: Sprint Commitments vs PTO

Every Monday, compares each team's committed Linear story points against available working hours after subtracting approved PTO.

CategoryProject Management
Enginesim
Difficultyintermediate
Triggerschedule
Steps6
Setup~15 min

How it runs

The automated pipeline, trigger to output.

  • TriggerMonday 8am schedule
  • ActionSum committed points per team from active Linear cycleLinearLinear
  • ActionPull PTO and holidays from shared Google CalendarGoogle CalendarGoogle Calendar
  • LogicConvert points to hours and compare against available capacity
  • LogicTag teams over vs under capacity
  • OutputPost per-team load digest to SlackSlack

What it does

Produces a weekly snapshot of whether each team has bitten off more than it can chew. It pulls the points committed to the active Linear sprint, calculates real available hours from the shared Google Calendar (subtracting approved PTO and holidays), and flags teams that are over-allocated before the sprint goes sideways.

When to use it

Run this when you manage several squads and keep getting surprised mid-sprint by carryover. It turns "we thought we had the bandwidth" into a number you see every Monday morning.

How it works

  1. 1A Monday-morning schedule fires the run.
  2. 2It queries Linear for each team's active cycle and sums committed estimate points.
  3. 3It reads the shared Google Calendar for the sprint window and totals PTO and holiday hours per person.
  4. 4A logic step converts committed points to expected hours (using a per-team velocity ratio) and compares against available hours minus PTO.
  5. 5Teams exceeding their available hours are tagged over-capacity; the rest get a healthy/under tag.
  6. 6A formatted digest with each team's load percentage posts to a Slack planning channel.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect LinearIssues, projects, cycles, triage.
  2. 2
    Connect Google CalendarEvents, attendees, availability.
  3. 3
    Connect SlackChannels, DMs, threads, mentions.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.