--- name: budget-planning description: Plan and manage budgets using bottom-up, top-down, or zero-based approaches. Use when creating annual budgets, allocating department budgets, building multi-year financial plans, tracking budget variances, or conducting budget review cycles. Triggers on phrases like "create budget", "annual budget", "budget allocation", "zero-based budget", "department budget", "budget template", "budget cycle", "capital budget". --- # Budget Planning & Management Orchestrate comprehensive budget planning across all departments and cost centers. ## Workflow 1. Define budget framework: planning methodology, fiscal calendar, approval hierarchy, and consolidation rules. 2. Gather baseline data: prior year actuals, YTD vs. budget, headcount plan, strategic initiatives, inflation assumptions. 3. Distribute department-specific budget templates pre-populated with historicals and AI-generated suggestions. 4. Collect bottom-up department submissions with validation against spending patterns and narrative requirements. 5. Apply top-down corporate allocation constraints: revenue targets, expense envelopes, cost ratio targets. 6. Conduct zero-based review for applicable departments — every expense requires fresh justification. 7. Roll up to consolidated corporate budget; reconcile to targets and resolve gaps/overages. 8. Perform variance analysis: line-item comparison to prior year, per-head metrics, benchmark comparison. 9. Execute approval workflow: department head → finance leadership → CFO/CEO → Board notification. 10. Lock approved budget, deploy to departments, configure budget vs. actual monitoring. ## Planning Methodologies ### Methodology Selection Framework ``` BUDGET PLANNING METHODOLOGY COMPARISON ======================================= Incremental Budgeting: Approach: Start with prior year actuals, adjust for known changes Best for: Stable operations, predictable cost drivers, annual adjustments < 10% Timeline: 4–6 weeks Effort: Low (finance team leads, minimal department input) Pros: Fast, simple, low conflict, easy to explain Cons: Perpetuates inefficiencies, no fresh scrutiny, "use it or lose it" culture Cost adjustment formula: Prior Year × (1 + Inflation Rate) + Headcount Change + Known Projects Typical inflation factors: Salaried 2–3%, Benefits 5–7%, Travel 3–5%, Supplies 2–4% Zero-Based Budgeting (ZBB): Approach: Every expense justified from scratch each cycle Best for: Cost reduction needed, new management, restructuring, departments >$5M spend Timeline: 8–12 weeks Effort: Very High (every manager builds decision units) Pros: Eliminates waste, aligns spend to strategy, forces prioritization Cons: Time-intensive, demotivating, can miss long-term investments, high turnover risk Decision Unit structure: - Each unit = a distinct spending area with a cost owner - Ranked by strategic value and ROI - Base level (must-have) vs. enhancement level (nice-to-have) - Typical: 50–200 decision units per department Roll-forward rate: Only top 70–80% of decision units get funded each cycle Top-Down (Allocative): Approach: Senior leadership sets targets; departments work within envelopes Best for: Mature organizations, clear strategic priorities, cost reduction mandates Timeline: 2–4 weeks Effort: Low–Medium Pros: Strategic alignment, speed, clear accountability Cons: Departments may feel disconnected, unrealistic targets, under-funding risk Allocation formula: - Revenue departments: Budget = Revenue Target × Target Cost Ratio - Support departments: Budget = Headcount × Cost per FTE + Fixed Overhead - Example: Engineering budget = $100M revenue × 15% target ratio = $15M Bottom-Up (Participative): Approach: Each department builds its own budget independently Best for: Decentralized orgs, department expertise needed, collaborative culture Timeline: 6–8 weeks Effort: Medium–High Pros: Department ownership, realistic estimates, higher buy-in Cons: Budget inflation ("sandbagging"), slow, may exceed corporate targets Typical sandbag factor: Departments request 5–15% above actual need Mitigation: Finance reviews and challenges each department's assumptions Hybrid Approach (Most Common for mid-to-large companies): Approach: Top-down envelope + bottom-up build + zero-based review of top categories Timeline: 6–10 weeks Effort: Medium Pros: Balances speed, accuracy, and strategic alignment Cons: More complex process, requires strong finance BP team Typical split: 60% incremental, 25% bottom-up, 15% zero-based ``` ### Budget Cycle Timeline ``` ANNUAL BUDGET CYCLE — 12-WEEK PLAYBOOK ======================================== Phase 1: Preparation (Weeks 1–2) Week 1: - CFO issues budget guidance memo: overall targets, growth assumptions, cost reduction targets - Finance team prepares budget templates (Excel, Adaptive Insights, Anaplan) - Headcount plan finalized with HR (open positions, planned hires, attrition) - Inflation assumptions: CPI 2–3%, healthcare 5–7%, IT services 3–5% - FX assumptions: locked at plan rates or scenario-based (base/upside/downside) Week 2: - Budget kickoff meeting with all department heads (virtual or in-person) - Training session on budget templates and submission process - Department heads begin data gathering - Finance business partners assigned to each department Phase 2: Department Builds (Weeks 3–6) Week 3–4: - Department heads draft budgets using templates - Include: headcount plan, compensation changes, operating expenses, capex - Narrative required for: any line item >15% change YoY, new initiatives, vendor changes - Finance BPs review department drafts; provide feedback within 48 hours Week 5–6: - Department heads revise based on feedback - First-pass submissions due - Finance team consolidates and compares to top-down targets - Identify departments over or under envelope (flag for negotiation) Phase 3: Consolidation & Challenge (Weeks 7–9) Week 7: - Finance team produces consolidated view - Variance report: bottom-up total vs. top-down targets by department - Department heads with >10% variance invited to finance review meetings Week 8: - Negotiation meetings: Finance challenges high-variance departments - Zero-based review of flagged categories (typically top 5 spend areas) - Revisions made; second-pass submissions collected - Finance re-consolidates and validates Week 9: - Final consolidated budget reviewed by CFO - Scenario analysis: base case, upside (+10% revenue), downside (-10% revenue) - Sensitivity: test impact of 1% revenue change on key ratios - CFO presents to CEO for pre-approval Phase 4: Approval & Deployment (Weeks 10–12) Week 10: - CEO approves final budget - Board notification memo (summary, key changes, no detailed budget typically) - Budget locked in system; change process established Week 11: - Department budgets distributed with formal letters - Budget vs. actual dashboards configured - Variance reporting schedule set (monthly for all, weekly for P&L-sensitive) - Training for new tools or processes Week 12: - Budget cycle officially closed - Lessons learned documented for next cycle - Rolling forecast initialized from approved budget ``` ## Budget Template Structure ### Standard Department Budget Template ``` ANNUAL DEPARTMENT BUDGET — [Department Name] — FY2025 ====================================================== REVENUE SECTION (Revenue-Generating Departments Only) Gross Revenue: $XXX,XXX Less: Discounts/Returns: ($XX,XXX) Net Revenue: $XXX,XXX Revenue growth vs. PY: +X.X% Revenue per FTE: $XXX,XXX Key assumptions: [customer count, ARPU, conversion rate, etc.] HEADCOUNT & COMPENSATION Current FTEs: XX Planned additions: X (Months: M3, M6, M9) Planned attrition: X (estimated) End-year FTEs: XX Salary Budget: $XXX,XXX Avg salary increase: 3.0% Merit pool: 2.5% of total salary New hire cost (avg): $XX,XXX × X hires = $XX,XXX Benefits Budget: $XX,XXX (28–35% of salary) Bonus/Incentive Pool: $XX,XXX (X% of salary) Payroll Taxes: $XX,XXX (7.65% + state FUTA/SUTA) Training & Development: $XX,XXX (2–5% of salary) ─────────────────────────────────────────────── Total People Cost: $XXX,XXX OPERATING EXPENSES Travel & Entertainment: $XX,XXX (X% of revenue or $X per FTE) Professional Services: $XX,XXX (consulting, legal, advisory) Software & Subscriptions: $XX,XXX (SaaS licenses, tools) Marketing & Events: $XX,XXX (campaigns, trade shows) Training & Education: $XX,XXX (courses, certifications) Office & Facilities: $XX,XXX (lease, utilities, supplies) Insurance: $XX,XXX (D&O, cyber, professional liab.) Recruitment: $XX,XXX (agency fees, job boards) Miscellaneous: $XX,XXX (miscellaneous, contingency 2–3%) ─────────────────────────────────────────────── Total Operating Expenses: $XXX,XXX CAPITAL EXPENDITURES (if applicable) Hardware/Equipment: $XX,XXX Software Development: $XX,XXX Facilities Improvement: $XX,XXX ─────────────────────────────────────────────── Total Capex: $XX,XXX NARRATIVE SECTION Key assumptions: [growth drivers, pricing changes, new products] Major initiatives: [project name, cost, expected ROI] Risks/dependencies: [what could impact the budget] Variances >15% YoY justification: [explain each] ``` ### Budget Template by Company Size ``` BUDGET TEMPLATE COMPLEXITY BY COMPANY SIZE =========================================== Startup (1–50 employees, <$5M revenue): Simplified template: - Revenue forecast (monthly, 12-month) - Headcount plan (names, not just counts) - Top 10 expense categories - Capex (if any) - Cash flow projection (monthly burn rate) Process: Single spreadsheet; founder/CFO builds; 2-week cycle Review: Monthly vs. actual; rolling 13-week cash forecast Tools: Excel, Google Sheets, Ramp, Mercury SMB (51–250 employees, $5M–$50M revenue): Medium template: - Department-level P&L - Monthly revenue by product/service line - Headcount by department with compensation detail - Operating expenses by category (15–20 line items) - Capex plan - Headcount-loaded cost center view Process: 6-week cycle; finance team supports; department head ownership Review: Monthly close with variance report; quarterly forecast update Tools: NetSuite, QuickBooks Online Advanced, Excel, Float, Vena Mid-Market (251–2,500 employees, $50M–$500M revenue): Comprehensive template: - Cost center-level P&L with monthly detail - Revenue by product, region, and customer segment - Headcount with salary bands, merit, bonus, benefits loading - Operating expenses by GL account with vendor detail - Capex with depreciation schedule - Multi-currency (if international) - Scenario modeling (base, upside, downside) Process: 8–10 week cycle; FP&A leads; Finance BPs embedded Review: Monthly with management reporting; quarterly board update Tools: Adaptive Insights (Workday), Anaplan, Oracle EPM, SAP BW Enterprise (2,500+ employees, $500M+ revenue): Enterprise-grade template: - Entity, segment, region, product, and customer dimensions - Multi-GAAP reporting (US GAAP, IFRS, local GAAP) - FX translation and hedging budgets - Transfer pricing budgets for intercompany - Consolidated and entity-level views - Driver-based modeling (revenue = units × price × mix) - Integration with ERP and HCM systems - Workflow automation with approval chains Process: 10–14 week cycle; dedicated planning team Review: Monthly close within 5 business days; quarterly board package Tools: Oracle Hyperion, SAP Analytics Cloud, Anaplan, Workday Adaptive, Tableau ``` ## Budget Governance and Controls ### Budget Change Process ``` BUDGET AMENDMENT PROCESS ========================= When budget changes are needed mid-year: Type 1: Intra-department reallocation (within same department) - Threshold: Any amount within department budget - Approval: Department head only - Process: Submit form; Finance validates within 2 business days - Documentation: Brief narrative of reason and impact - Frequency: Common; typically 3–5 per department per year Type 2: Inter-department transfer (between departments) - Threshold: Up to $50K or 5% of recipient budget - Approval: Both department heads + Finance Director - Process: Transfer request form; Finance validates; 3-day turnaround - Documentation: Full narrative with business justification - Impact: Both departments' budgets adjusted; P&L reallocation - Frequency: Moderate; typically 1–3 per quarter Type 3: Budget increase (exceeds approved budget) - Threshold: Up to 10% of original budget - Approval: CFO (up to $100K) or CEO (>$100K) - Process: Formal budget increase request with ROI analysis - Required data: Prior spend, business case, expected return, funding source - Board notification: Any single increase >$500K or >5% of total budget - Frequency: Limited; should occur < 5 times per year organization-wide Type 4: Strategic reallocation (significant budget restructuring) - Trigger: Major business change, acquisition, market disruption - Approval: CEO + CFO + Board Finance Committee - Process: Full re-forecast with updated assumptions - Scope: May involve multiple departments; consolidated impact analysis - Communication: All department heads briefed on changes - Frequency: Rare; typically 0–2 per year Budget change log: - Every change tracked with date, approver, amount, and reason - Monthly summary included in management reporting - Year-end analysis: total budget vs. original (identify planning accuracy) - Typical variance: 3–8% for well-run organizations; >15% indicates planning issues ``` ### Budget Accuracy Metrics ``` BUDGET ACCURACY TRACKING ========================= Metric: Budget Accuracy Score Formula: 1 - (|Actual - Budget| / Budget) for each GL account Target: > 90% accuracy (|variance| < 10% of budget) Reporting: Monthly by department and category Scoring: Green (90–100%): Accurate; no action needed Yellow (80–89%): Monitor; review with department head Red (< 80%): Investigate; process improvement needed Common accuracy issues by category: Headcount salary: 95–98% (highly predictable) Travel: 75–85% (volatile; project-based) Professional services: 70–80% (hard to predict) Marketing: 80–90% (campaign timing affects timing) Software/subscriptions: 95–98% (contract-based) Recruiting: 65–80% (timing of hires unpredictable) Rolling forecast accuracy: - Month 1 forecast accuracy: > 95% target - Month 3 forecast accuracy: > 85% target - Month 6 forecast accuracy: > 75% target - Year-end forecast accuracy: > 80% target Planning quality metrics: - Budget cycle time: Target < 10 weeks - Department submission on-time rate: > 90% - Number of revision cycles: Target 2 (draft → revise → final) - Budget change requests mid-year: < 5% of total budget ``` ## Department-Specific Budgeting ### Revenue Department Budgets ``` REVENUE BUDGET BUILD ===================== Revenue = Pipeline × Conversion Rate × Average Deal Size Sales team budget components: - Headcount: AE, SDR, AM, Sales Ops (by territory/region) - Compensation: Base + commission (OTE = base + target commission) - Commission pool: Typically 15–30% of target revenue - Tools: CRM (Salesforce $12K/user/yr), dialer, email tools - Travel: Client meetings ($500–1,500 per trip, 2–4 trips/month per AE) - Enablement: Training, content, deal support Budgeting methodology: 1. Revenue target set by leadership (top-down) 2. Sales Ops builds capacity model: headcount × productivity × win rate 3. Validate against historical performance and pipeline coverage 4. Pipeline coverage target: 3–4x quarterly quota 5. Revenue per rep: $500K–$2M (SMB), $2M–$10M (Enterprise) Key ratios: - Sales to revenue ratio: 15–30% of revenue - SDR to AE ratio: 2–4 SDRs per AE - Revenue per sales rep: benchmark by company and segment - Commission as % of revenue: 10–25% ``` ### G&A Budget Benchmarks ``` G&A SPEND BENCHMARKS BY COMPANY SIZE ====================================== General & Administrative as % of Revenue: Startup (<$5M revenue): 40–60% (heavy per-head fixed costs) SMB ($5M–$50M revenue): 20–35% (economies of scale kick in) Mid-Market ($50M–$500M): 12–25% (efficient operations) Enterprise ($500M+ revenue): 8–15% (significant economies of scale) Per-head G&A cost: Startup: $150K–$250K per FTE SMB: $120K–$180K per FTE Mid-Market: $100K–$150K per FTE Enterprise: $80K–$120K per FTE G&A breakdown (% of total G&A): Executive compensation: 20–35% Finance/Accounting: 15–25% Legal/Compliance: 10–15% HR/Admin: 10–20% Office/Facilities: 5–10% Insurance: 3–8% Professional services: 5–10% IT (if not in Opex): 5–10% ``` ## Edge Cases - **First-year budget for new company**: No historical data available - Approach: Use top-down methodology based on business plan and market research - Benchmark against comparable companies (industry reports, comp databases) - Build headcount plan month-by-month with realistic ramp assumptions - Include 15–25% contingency for unknowns - Cash flow projection critical: track burn rate and runway monthly - Review assumptions quarterly; re-forecast if revenue misses by >20% - **Budget during merger or acquisition**: Two or more budgets need integration - Day 1: Maintain separate budgets; identify overlaps and synergies - Day 30: Integrated budget with synergy targets (typically 10–20% cost savings) - Synergy capture timeline: 30% in Year 1, 60% in Year 2, 100% by Year 3 - Redundancy elimination: shared services, vendor consolidation, headcount - Revenue synergies: cross-sell opportunities, combined market access - **Budget in declining industry**: Revenue declining despite cost control - Focus: Cash preservation and strategic repositioning - Cost reduction targets: 10–30% of operating expenses - Voluntary separation programs: $15K–$50K per employee (vs. $50K–$150K involuntary) - Revenue diversification budget: allocate 5–10% of budget to new opportunities - Monthly cash monitoring: weekly cash calls during severe decline - **Multi-currency budget**: International operations with FX exposure - Base currency: All budgets translated to reporting currency (typically USD) - FX assumption: Base case (current rates), sensitivity (±5%, ±10%) - Translation vs. transaction: Budget in local currency; translate for consolidation - Hedge budget: Include hedging costs (options, forwards) in treasury budget - Local compliance: Budget must meet local regulatory and tax requirements - **Budget for project-based company** (consulting, construction): - Revenue tied to project wins; budget per project with margin targets - Utilization rate: Budget based on billable vs. non-billable time - Target utilization: 70–85% for consultants, 60–75% for technical staff - Project margin: Gross margin 20–40%; net margin 10–20% - Pipeline budgeting: Resource allocation based on weighted pipeline (25% in negotiation, 75% committed) - **Post-IPO budget transition**: Private company adjusts to public company requirements - New expense categories: SEC reporting, transfer agent, investor relations ($500K–$2M/yr) - D&O insurance: $200K–$1M+ annually - Audit fees: Big 4 engagement $200K–$2M depending on complexity - SOX compliance: Internal control testing, documentation ($100K–$500K) - Investor relations team: 1–3 FTEs ($150K–$300K per FTE loaded) ## Integration Points - **ERP Systems**: NetSuite, SAP S/4HANA, Oracle ERP Cloud — budget storage, actuals integration, variance reporting - **Planning Platforms**: Adaptive Insights (Workday), Anaplan, Oracle Hyperion EPM, Vena Solutions, SAP Analytics Cloud — collaborative budgeting, scenario modeling - **HCM Systems**: Workday HCM, ADP, BambooHR — headcount plans, compensation budgets, benefits loading - **Expense Management**: Rippling, Expensify, Concur — actual spend tracking vs. budget - **BI & Analytics**: Tableau, Power BI, Looker — budget dashboards, drill-down analysis, self-service reporting - **Document Management**: SharePoint, Google Drive — budget narratives, approval documentation - **Approval Workflows**: ApprovalMax, Airtable — budget change request routing - **Spreadsheets**: Excel (universal fallback, pivot tables, Power Query for data consolidation) - **CRM**: Salesforce — pipeline-to-revenue budget validation - **Data Warehouse**: Snowflake, BigQuery — centralized actuals data for budget vs. actual comparison