Budget Planner

Expert budget creation and management agent that builds comprehensive budgets, tracks spending against plans, analyzes variances, and optimizes resource allocation. Specializes in zero-based budgeting, rolling forecasts, and multi-scenario planning.

This skill applies structured budgeting methodologies to help organizations plan spending, control costs, and make data-driven allocation decisions. Perfect for annual planning, project budgets, departmental spending, and startup runway management.

Core Workflows

Workflow 1: Annual Budget Creation

Objective: Build a comprehensive annual operating budget from scratch

Steps:

•
Gather Historical Data
- •Prior year actuals (P&L by month)
- •Prior year budget vs actual variances
- •Headcount and compensation data
- •Vendor contracts and commitments
- •Capital expenditure history
- •Revenue trends and projections
•
Define Budget Parameters
- •Fiscal year start/end dates
- •Budget cycle (calendar vs fiscal)
- •Currency and exchange assumptions
- •Inflation assumptions (2-4% typical)
- •Headcount growth assumptions
- •Revenue growth targets
•
Revenue Budget
- •Product/service revenue projections
- •Pricing assumptions
- •Volume/unit assumptions
- •Seasonal patterns
- •New product launches
- •Customer retention assumptions
- •Geographic mix
•
Cost of Goods Sold (COGS) Budget
- •Direct materials costs
- •Direct labor costs
- •Manufacturing overhead
- •Gross margin targets
- •Unit economics assumptions
•
Operating Expense Budget
- •
  Personnel Costs:
  - •Salaries and wages (by department)
  - •Benefits (typically 20-30% of salary)
  - •Payroll taxes (7.65% FICA + state)
  - •Bonuses and commissions
  - •Stock-based compensation
  - •Contractor costs
- •
  Facilities Costs:
  - •Rent and lease payments
  - •Utilities
  - •Insurance
  - •Maintenance and repairs
  - •Property taxes
- •
  Technology Costs:
  - •Software subscriptions (SaaS)
  - •Hardware and equipment
  - •Cloud infrastructure
  - •IT support and services
- •
  Marketing Costs:
  - •Advertising and media
  - •Events and conferences
  - •Content and creative
  - •Marketing technology
  - •Agency fees
- •
  General & Administrative:
  - •Legal and professional services
  - •Accounting and audit
  - •Office supplies
  - •Travel and entertainment
  - •Training and development
•
Capital Expenditure Budget
- •Equipment purchases
- •Facility improvements
- •Technology infrastructure
- •Depreciation schedules
•
Cash Flow Implications
- •Working capital needs
- •CapEx timing
- •Seasonal cash requirements
- •Financing needs
•
Budget Consolidation
- •Roll up departmental budgets
- •Eliminate intercompany items
- •Create consolidated P&L budget
- •Balance sheet projections
- •Cash flow projections
•
Scenario Development
- •Base case (most likely)
- •Upside case (+10-20% revenue)
- •Downside case (-10-20% revenue)
- •Cost reduction scenarios

Deliverable: Complete annual budget package with P&L, departmental details, and scenarios

Workflow 2: Project Budget Development

Objective: Create a detailed budget for a specific project or initiative

Steps:

•
Project Scope Definition
- •Project objectives and deliverables
- •Timeline and milestones
- •Resource requirements
- •Success criteria
- •Constraints and dependencies
•
Work Breakdown Structure
- •Decompose project into phases
- •Identify major work packages
- •List activities within each package
- •Estimate effort for each activity
•
Resource Cost Estimation
- •
  Internal Labor:
  - •Identify required roles
  - •Estimate hours per role
  - •Apply fully-loaded labor rates
  - •Account for utilization rates
- •
  External Resources:
  - •Contractor/consultant rates
  - •Agency or vendor costs
  - •Outsourced services
•
Non-Labor Costs
- •Materials and supplies
- •Software and tools
- •Equipment and hardware
- •Travel and expenses
- •Training and certifications
- •Contingency reserve (10-20%)
•
Cost Phasing
- •Spread costs across timeline
- •Account for payment terms
- •Identify upfront vs. ongoing costs
- •Create monthly cost forecast
•
Budget Controls
- •Approval thresholds
- •Change request process
- •Variance reporting triggers
- •Contingency release criteria
•
Risk-Adjusted Budget
- •Identify cost risks
- •Probability-weighted contingency
- •Management reserve (if applicable)
- •Total project budget with reserves

Deliverable: Project budget with timeline, resource plan, and risk contingencies

Workflow 3: Zero-Based Budgeting

Objective: Build budget from scratch justifying every expense

Steps:

•
Identify Decision Units
- •Define budget owners
- •Establish decision units (departments, functions)
- •Clarify accountability
•
Define Service Levels
- •Minimum level (survival)
- •Current level (maintain status quo)
- •Improvement level (enhanced performance)
- •Each level must be costed
•
Cost Justification
- •
  For each expense, answer:
  - •Why is this needed?
  - •What happens without it?
  - •What are alternatives?
  - •What's the ROI?
•
Decision Package Creation
- •Package 1: Minimum viable operations
- •Package 2: Core operations
- •Package 3: Growth investments
- •Package 4: Strategic initiatives
•
Ranking and Prioritization
- •Stack rank all packages
- •Apply funding constraints
- •Make trade-off decisions
- •Document rationale
•
Final Budget Assembly
- •Fund packages within constraints
- •Document unfunded priorities
- •Create implementation plan

Deliverable: Zero-based budget with prioritized decision packages

Workflow 4: Rolling Forecast Update

Objective: Continuously update budget with latest actuals and projections

Steps:

•
Close Period
- •Gather actual results for completed period
- •Ensure data completeness
- •Reconcile to GL/accounting
•
Variance Analysis
- •Calculate budget vs actual variances
- •Identify significant variances (>5% or material)
- •
  Categorize as:
  - •Timing differences (will normalize)
  - •Run-rate changes (permanent)
  - •One-time items (non-recurring)
•
Forecast Adjustment
- •
  Update remaining periods based on:
  - •Run-rate from actuals
  - •Known commitments
  - •Revised assumptions
  - •New information
•
Full-Year Outlook
- •Combine YTD actuals + forecast
- •Compare to original budget
- •Calculate expected year-end variance
- •Identify risks to forecast
•
Action Planning
- •If tracking above budget: investment opportunities
- •If tracking below budget: corrective actions
- •Document assumptions and risks
- •Assign owners to actions
•
Reporting Package
- •Executive summary
- •Variance commentary
- •Updated forecast
- •Risks and opportunities
- •Recommended actions

Deliverable: Updated rolling forecast with variance analysis and action plan

Workflow 5: Startup Runway Planning

Objective: Model cash runway and funding needs for startups

Steps:

•
Current Cash Position
- •Cash on hand
- •Outstanding receivables
- •Available credit lines
- •Expected fundraise timing
•
Monthly Burn Rate Analysis
- •Current monthly expenses
- •Committed future expenses
- •Planned hiring costs
- •Growth investments
•
Revenue Assumptions
- •Current MRR/ARR
- •Growth rate assumptions
- •Churn assumptions
- •Cash collection timing
•
Runway Calculation
- •Gross burn = Total monthly expenses
- •Net burn = Gross burn - Revenue
- •Runway = Cash / Net Burn
- •Zero cash date projection
•
Scenario Modeling
- •Current trajectory
- •Aggressive growth scenario
- •Conservative/survival scenario
- •Path to profitability scenario
•
Milestone Mapping
- •Key milestones for next funding round
- •Costs to achieve milestones
- •Timeline requirements
- •Funding amount needed
•
Cash Management Actions
- •Expense reduction opportunities
- •Revenue acceleration options
- •Timing optimization
- •Bridge financing options

Deliverable: Runway model with scenarios and funding recommendations

Quick Reference

Action	Command/Trigger
Create annual budget	"Build annual budget for [year/org]"
Project budget	"Create budget for [project]"
Variance analysis	"Analyze budget vs actual for [period]"
Update forecast	"Update rolling forecast with [month] actuals"
Runway analysis	"Calculate runway with current burn"
Zero-based budget	"Build ZBB for [department]"

Budget Templates

Monthly P&L Budget Template

markdown

| Line Item | Jan | Feb | Mar | Q1 | Apr | May | Jun | Q2 | ... | FY Total |
|-----------|-----|-----|-----|----|----|-----|-----|----|----|----------|
| **Revenue** |
| Product Revenue | | | | | | | | | | |
| Service Revenue | | | | | | | | | | |
| **Total Revenue** | | | | | | | | | | |
| |
| **COGS** |
| Direct Costs | | | | | | | | | | |
| **Gross Profit** | | | | | | | | | | |
| Gross Margin % | | | | | | | | | | |
| |
| **Operating Expenses** |
| Personnel | | | | | | | | | | |
| Marketing | | | | | | | | | | |
| Technology | | | | | | | | | | |
| Facilities | | | | | | | | | | |
| G&A | | | | | | | | | | |
| **Total OpEx** | | | | | | | | | | |
| |
| **Operating Income** | | | | | | | | | | |
| Operating Margin % | | | | | | | | | | |

Variance Report Template

markdown

# Budget Variance Report: [Period]

## Executive Summary
- Total Revenue: $XXX vs Budget $XXX (X% variance)
- Total Expenses: $XXX vs Budget $XXX (X% variance)
- Net Income: $XXX vs Budget $XXX (X% variance)

## Significant Variances (>5%)

### Favorable Variances
| Line Item | Actual | Budget | Variance | Explanation |
|-----------|--------|--------|----------|-------------|
| | | | | |

### Unfavorable Variances
| Line Item | Actual | Budget | Variance | Explanation |
|-----------|--------|--------|----------|-------------|
| | | | | |

## Full-Year Impact
- Current trajectory vs annual budget
- Risks to achieving budget
- Recommended actions

## Forecast Update
- Revised full-year forecast
- Key assumption changes

Budgeting Best Practices

Planning Phase

•Start with strategic priorities
•Get executive alignment on key assumptions
•Involve budget owners early
•Build in realistic timelines
•Document all assumptions

Execution Phase

•Distribute budgets to owners
•Establish spending approval processes
•Set up variance monitoring
•Create regular reporting cadence
•Enable budget vs actual tracking

Monitoring Phase

•Monthly variance reviews
•Rolling forecast updates
•Action plans for significant variances
•Re-forecast when major changes occur
•Year-end projections

Common Budget Categories

Category	Typical % of OpEx	Notes
Personnel	60-70%	Largest expense for most companies
Technology	10-15%	Growing rapidly with SaaS adoption
Marketing	10-20%	Varies by stage and industry
Facilities	5-10%	Often fixed costs
G&A	5-10%	Legal, accounting, insurance

Integration with Other Skills

•Use with cash-flow-forecaster: Convert budget to cash projections
•Use with revenue-modeler: Develop revenue assumptions
•Use with unit-economics-calculator: Validate profitability assumptions
•Use with cost-optimizer: Identify budget reduction opportunities
•Use with financial-reporter: Create budget reporting packages

Common Pitfalls to Avoid

•Hockey stick projections: Be realistic about growth rates
•Ignoring seasonality: Build monthly fluctuations into budget
•Underestimating personnel costs: Include benefits, taxes, raises
•Forgetting one-time costs: License renewals, annual fees
•No contingency: Include 5-10% buffer for unknowns
•Static budgets: Update forecasts as reality changes
•Sandbbagging: Budgets should be achievable but ambitious
•No accountability: Assign clear owners to every line item