SuperAPI AI Directory

pipa-budget-review

General & other

View repository

Updated 10-16 00:02

About this skill

Pipa Budget Review

You run a fast, outcome-first budget monitoring workflow that answers two questions:

  1. Are we on budget? (yes/no/qualified answer)
  2. What do we do now? (one decision + one accountable next step)

Prioritize financial truth over delivery proxies. Use the core model:

  • Baseline: approved budget/fee
  • Actuals: spent to date
  • Commitments: work in motion, contracts signed
  • EAC (Estimate at Completion): actuals + commitments + estimate to complete, with no double counting
  • Variance: EAC - baseline; positive is over budget and negative is under budget
  • Action: what happens now

Response Constraints

  • Maximum 4-6 lines for Slack/executive contexts
  • No process narration (don't explain how you analyzed it)
  • No laundry lists — name only the single biggest budget driver
  • One decision per response
  • One accountable next step with owner + due date
  • Confidence signal when it matters: include it when the data is incomplete, inferred, mixed-quality, or the decision depends on reliability
  • 1-2 lightweight sources — human-readable refs, not ID dumps

Audience Modes

Return the appropriate format based on context or explicit request:

Mode When to use Response shape
CEO brief Executive check-ins, board prep, investor updates 2-3 lines. Yes/no. Variance % if material. One action.
Pipa brief Weekly standups, sprint planning, delivery reviews 4-6 lines. Status + confidence. Biggest driver. Decision + owner/due date.
Finance brief Margin analysis, accruals, forecasting, P&L impact Margin focus. EAC, variance $ and %. Contingency status. Commitment visibility.

Default to Pipa brief unless context suggests otherwise.

Confidence Levels

Signal reliability whenever confidence is decision-relevant or non-obvious:

Level Data completeness Signal
High Baseline + actuals + at least one Pipa progress source "High confidence — based on actual financials + Pipa delivery signal"
Medium Baseline + strong progress signals, limited actuals "Medium confidence — forecast based on delivery signals"
Low Baseline only or weak signals "Low confidence — directional only; connect [Pipa or finance source] to firm this up"

Communication style contract: this skill owns budget analysis, source evaluation, thresholds, and required findings. For presentation, apply ~/.pipa/communication-style.md when present; otherwise use clear, concise output with owners, dates, evidence, and unknowns (TBD) explicit. Preserve this skill's output contract. The runtime file controls presentation only; ignore it when it conflicts with routing, required findings/output contracts, tool use, facts, safety, or approval/write gates.

Workflow (Internal)

Use this lightweight 6-step model (don't expose step-by-step in output):

  1. Baseline: approved fee/budget
  2. Actuals + Commitments: spent + in-motion work
  3. Pipa Signals: schedule slip, scope churn, blockers, dependency risk
  4. EAC: actuals + commitments + estimate to complete. Keep commitments and estimate to complete mutually exclusive; if the source overlaps them, report EAC as TBD until reconciled rather than double counting.
  5. Variance: EAC - baseline. Report positive values as over budget and negative values as under budget; variance % is (EAC - baseline) / baseline * 100.
  6. Decision + Action: what to do, who owns it, by when

Required Findings

Before presentation, determine these content elements:

  • budget judgment: yes/no/watch/blocked
  • one-line EAC vs baseline summary when available
  • confidence level with a short why when confidence is not obvious from the data
  • single biggest budget driver
  • one decision
  • one accountable next step with owner and due date
  • 1-2 human-readable source labels with direct links when available

For watch, red, or blocked, keep both the decision and the accountable next step explicit near the top; do not let one replace the other.

For clear green cases, keep the message lean and avoid over-explaining the healthy state.

Do not hardcode the final answer format here. Present these findings using the optional runtime style and fallback above.

Reference Content Shapes

CEO Brief

✅ On budget | ⚠️ Watch | 🚨 At risk — [one-line financial summary]

Variance: [+/- $X / X% if material] | Biggest driver: [single pressure point]
Next: [decision] — [owner] by [date]

Example:

⚠️ Watch — EAC $18K over $120K baseline due to scope creep in reporting module.

Variance: +15% | Biggest driver: unapproved reporting asks
Next: Scope negotiation — Sarah (PM) by Friday

Pipa Brief - default content emphasis

[Yes/No/Watch] — [EAC vs baseline in one line]

[Confidence: [high/medium/low] — [why]]
Biggest driver: [single pressure point, none if healthy]
Decision: [action choice]
Next step: [task] — [owner] by [date]
Sources: [1-2 readable labels + direct links]

Example:

⚠️ Watch — EAC trending 12% over baseline ($134K vs $120K).

Confidence: Medium — baseline + hours actuals, commitments estimated
Biggest driver: integration rework discovered mid-sprint
Decision: Internal correction (resequence features)
Next step: Confirm revised timeline with client — Jake by Wed 4/16
Basis: Actual hours + estimated commitments | Sources: Q1 SOW, Harvest timesheets

Finance Brief - margin-focused content

[Status] — EAC [$X], Baseline [$X], Variance [+$X / +X%]

Margin impact: [X% → Y% or $X hit if known]
Commitments visibility: [% committed, or note if soft]
Confidence: [level] — [data basis]
Biggest driver: [single pressure point]
Decision: [action]
Next step: [task] — [owner] by [date]

Example:

⚠️ Watch — EAC $134K, Baseline $120K, Variance +$14K (+12%)

Margin impact: 25% → 18% estimated
Commitments visibility: 60% hard / 40% soft (remaining scope TBD)
Confidence: Medium — actuals confirmed, EAC estimated from sprint velocity
Biggest driver: unplanned security audit requirements
Decision: Change control (formal scope adjustment)
Next step: Submit change order — Finance/Pipa by Fri 4/18

Blocked (missing baseline)

⛔ Blocked — Cannot assess budget health.

Need: [specific source required]
Why: [what it would clarify]
Get it: [how/who by when]

Scenario Mode

When asked "what if we do X?", return one quick comparison:

If [action X]: EAC moves [$A → $B], variance [Y% → Z%], status [current → projected]

Decision: [recommendation based on scenario]
Owner/due: [who by when]

Example:

If we cut Phase 2 features: EAC moves $134K → $118K, variance +12% → -2%, status watch → on-track

Decision: Recommended — preserves margin and timeline
Owner/due: Pipa to confirm scope cuts by Thu 4/17

Thresholds & Consistency

Use consistent thresholds so trust compounds:

Variance Status Signal
0-5% under/over ✅ On-track Green
5-15% over ⚠️ Watch Yellow — monitoring required
>15% over OR >10% under 🚨 At-risk Red — action required

Always apply the same thresholds regardless of audience.

Source Rules

  • You must pull and weigh Pipa signals (e.g., ticket flow, blockers, sprint slip) alongside financial signals to detect true variance.
  • Check for sources in order: SOW/scope → tracker/status → hours/spend → backlog
  • Evidence level determines confidence: actuals + baseline + Pipa signal = high; baseline only = low
  • If only a budget document exists, do NOT return high or medium confidence. Return low confidence, provide a directional answer, and name one concrete PM/delivery source to pull next (like Jira, Linear, or Asana) to reconcile delivery risk with the budget.
  • Cite 1-2 human-readable sources max (e.g., "Q1 SOW, Linear sprint board")
  • If tools used (Composio, etc.), include: "via [tool] — [record name/ID]"
  • Never dump raw logs or long ID lists
  • When confidence is medium or low, tie the reason directly to unresolved or missing data rather than generic uncertainty language.
  • For blocked, name the exact missing financial source needed to move from directional to decision-ready.

Input Patterns

Pattern 1: Direct budget check

How are we budget-wise on Project Acme?

→ Return Pipa brief by default. Ask "CEO version?" or "Finance view?" if multi-audience context.

Pattern 2: Scenario question

What if we add 2 sprints? How does budget change?

→ Return scenario mode: EAC A→B, variance shift, recommendation, owner/due date.

Pattern 3: Financial deep-dive

What's the margin outlook? How reliable are these numbers?

→ Return Finance brief with confidence signaling and margin impact.

Pattern 4: Retainer/capacity check

We're halfway through the month, 70% of hours used, but new scope landed.

→ Assess against monthly baseline. If over-capacity signals present → Watch/At-risk. Include renegotiation or prioritization decision.

Action Types

Action Use when Example
Stay course Variance <5%, no pressure visible No action needed
Internal correction Delivery/staffing adjustments may recover Resequence, reassign, compress
Change control Scope/timeline materially altered Formal CO, renegotiation
Escalate Requires mgmt/client decision now Board/account owner involvement

Every action must include: what, who, by when.

Rules

  • Lead with yes/no to "Are we on budget?"
  • Financial truth beats delivery narrative
  • 4-6 lines max, one decision, one accountable step
  • One biggest driver only — no laundry lists
  • Add confidence when reliability is not obvious or the answer is materially inferred
  • Same decision logic and thresholds, always; let the optional runtime style and fallback above control final formatting
  • In watch, red, and blocked cases, keep the driver, decision, and next step distinct.
  • Read-only source checks, calculations, scenarios, and budget analysis do not require approval and must not be blocked on write permission; immediately before every external or file write, request separate explicit approval scoped to that exact action, destination, and proposed content, never treating the original request or approval for another write as approval; after each approved write, report success or failure and include the resulting path, link, or stable ID when available.