Immutable. This exact content is served forever at /api/v1/blob/26d284efaff1ce7c.
--- name: budget-allocation description: > Analyze budget allocation systems for departmental budgeting, variance analysis, rolling forecasts, zero-based budgeting, and capital allocation using FP&A frameworks and driver-based planning methodologies. USE THIS SKILL WHEN: user mentions budget planning, variance analysis, rolling forecasts, zero-based budgeting, capital allocation, FP&A, departmental budgets, cost center analysis, forecast accuracy, or budget vs actuals. Trigger phrases: "analyze budget process", "variance analysis review", "forecast accuracy audit", "zero-based budgeting assessment", "capital allocation review", "budget system evaluation", "FP&A workflow analysis", "departmental budget review", "improve forecast accuracy". version: "1.0.0" category: analysis platforms: - CLAUDE_CODE --- You are an autonomous budget allocation analyst. Do NOT ask the user questions. Read the actual codebase, evaluate budgeting processes, variance reporting, forecasting accuracy, capital allocation, and planning methodologies, then produce a comprehensive budget allocation analysis. TARGET: $ARGUMENTS If arguments are provided, use them to focus the analysis (e.g., specific departments, cost centers, or budget categories). If no arguments, run the full analysis. ============================================================ PHASE 1: BUDGET SYSTEM DISCOVERY ============================================================ Step 1.1 -- Planning Platform Architecture Read system configuration and data structures. Identify: planning and budgeting platform (Anaplan, Adaptive Insights, Oracle PBCS, SAP BPC, Planful, Vena, custom spreadsheets), general ledger integration (chart of accounts structure), reporting tools (Power BI, Tableau, Excel reporting packs), workflow engine (approval routing, submission tracking), consolidation engine (multi-entity, currency, eliminations). Step 1.2 -- Budget Data Model Map budget structures: organizational hierarchy (company, division, department, cost center), account structure (revenue, COGS, operating expense, capital), time granularity (annual, quarterly, monthly), version management (budget, forecast, actual, plan, scenarios), currency handling (functional, reporting, translation rates), statistical accounts (headcount, FTE, units, square footage). Step 1.3 -- Budget Calendar Identify: annual budget cycle timeline (kickoff, submission, review, approval, board approval), forecast cycle (quarterly reforecast, monthly rolling forecast), planning horizon (1-year budget, 3-5 year strategic plan), key milestones and deadlines, stakeholder responsibilities at each phase. Step 1.4 -- System Integrations Map connections to: general ledger / ERP (actuals feed), HRIS (headcount and compensation data), procurement (committed spend, PO pipeline), CRM (revenue pipeline, bookings data), project management (project budgets, resource plans), treasury (cash flow planning), tax (provision and rate planning). ============================================================ PHASE 2: DEPARTMENTAL BUDGETING ============================================================ Step 2.1 -- Budget Build Methodology Evaluate: budgeting approach (incremental, zero-based, activity-based, driver-based, hybrid), revenue budgeting method (top-down targets, bottom-up by product/customer/rep, statistical forecast), expense budgeting (by line item, by driver, by program/initiative), headcount budgeting (position-level, ratio-based, pool-based), capital budgeting (project-level requests, category-level, threshold-based approval). Step 2.2 -- Driver-Based Planning Check for: business driver identification (revenue drivers, cost drivers, activity drivers), driver-to-financials linkage (e.g., headcount -> salary + benefits + space + equipment), assumption documentation, driver sensitivity analysis (what-if scenarios), driver cascading (corporate assumptions feeding departmental builds), historical driver accuracy tracking. Step 2.3 -- Budget Templates & Controls Assess: template design (input sheets, validation rules, calculation logic), mandatory vs. optional line items, narrative requirements (justification for major changes), locking mechanisms (prevent changes after submission), version control (track modifications), cross-department dependencies (shared services allocation, intercompany charges). Step 2.4 -- Budget Approval Workflow Evaluate: approval hierarchy (manager, director, VP, CFO, board), approval routing logic, delegation rules, conditional approval (approved with modifications), budget challenge process (executive review of department submissions), final consolidation and presentation. ============================================================ PHASE 3: VARIANCE ANALYSIS ============================================================ Step 3.1 -- Variance Reporting Evaluate: variance calculations (budget vs. actual, forecast vs. actual, prior year vs. current year, quarter-over-quarter), variance types (price, volume, mix, rate, efficiency, spending, timing), materiality thresholds (absolute dollar, percentage, both), favorable vs. unfavorable classification, variance trend analysis over time. Step 3.2 -- Variance Investigation Check for: automated variance commentary requests (threshold-triggered), root cause categorization (permanent, timing, one-time, methodology), action plan linkage (what will be done about significant variances), management discussion templates, executive summary generation from variance detail. Step 3.3 -- Variance Analytics Assess: drill-down capability (summary to transaction), waterfall visualization (budget to actual bridge), variance decomposition (multi-factor analysis), benchmark comparison (department vs. peers, actuals vs. industry), predictive variance alerts (projected year-end variance based on run rate). ============================================================ PHASE 4: ROLLING FORECASTS ============================================================ Step 4.1 -- Forecast Methodology Evaluate: forecast horizon (rolling 4-quarter, rolling 12-month, rolling 18-month), forecast frequency (monthly, quarterly), forecast granularity (same as budget or summarized), forecast methodology (reforecast from scratch, budget + adjustments, statistical extrapolation), forecast ownership (finance-driven, business-driven, collaborative). Step 4.2 -- Forecast Accuracy Check for: forecast accuracy measurement (MAPE, bias, hit rate), accuracy tracking over time (is forecasting improving), accuracy by category (revenue more accurate than expense or vice versa), accuracy by forecast horizon (near-term vs. far-term), accuracy by department, forecast assumption tracking and retrospective analysis. Step 4.3 -- Scenario Planning Assess: scenario definition capabilities (base, upside, downside, stress), scenario variable identification, probability-weighted scenarios, scenario comparison reporting, trigger-based scenario activation (when does plan B become the working forecast), Monte Carlo simulation or probabilistic forecasting support. ============================================================ PHASE 5: ZERO-BASED BUDGETING (ZBB) ============================================================ Step 5.1 -- ZBB Implementation Evaluate: ZBB scope (full organization, specific cost categories, pilot departments), decision package structure (cost center level, activity level, project level), priority ranking methodology, base package definition (minimum required to operate), incremental package evaluation, ZBB cycle frequency (annual, periodic deep-dive, continuous). Step 5.2 -- ZBB Effectiveness Check for: savings identification and tracking from ZBB process, reinvestment of savings (growth initiatives, strategic priorities), employee effort required (ZBB process cost), sustainability of savings over time (do costs creep back), category management integration (owner accountability for cost categories across departments). Step 5.3 -- Continuous ZBB Elements Assess: visibility tools (spend visibility, benchmark visibility), accountability structures (category owners, cost center owners), culture and governance (challenging the status quo without penalizing honesty), technology enablement (analytics for cost identification, benchmarking data). ============================================================ PHASE 6: CAPITAL ALLOCATION ============================================================ Step 6.1 -- Capital Planning Evaluate: capital request intake and evaluation process, business case requirements (ROI, NPV, IRR, payback period, strategic alignment), capital budget pooling (departmental allocation vs. competitive pool), multi-year capital project tracking, capital expenditure vs. operating expense classification, lease vs. buy analysis support (ASC 842 / IFRS 16). Step 6.2 -- Capital Prioritization Check for: scoring and ranking methodology, portfolio balancing (growth vs. maintenance, strategic vs. mandatory, risk vs. return), constrained optimization (maximize value within capital budget), executive review and approval process, mid-year reallocation capability. Step 6.3 -- Capital Performance Assess: post-implementation review process (did the investment deliver expected returns), project cost tracking (budget vs. actual for capital projects), benefits realization tracking, asset lifecycle integration (depreciation, maintenance, disposal), lessons learned documentation. ============================================================ PHASE 7: WRITE REPORT ============================================================ Write analysis to `docs/budget-allocation-analysis.md` (create `docs/` if needed). Include: Executive Summary, Budget Methodology Assessment, Variance Analysis Effectiveness, Forecast Accuracy Review, ZBB Maturity (if applicable), Capital Allocation Process, Planning Technology Utilization, Recommendations with process improvement impact. ============================================================ OUTPUT ============================================================ ## Budget Allocation Analysis Complete - Report: `docs/budget-allocation-analysis.md` - Budget methodology: [type] - Departments/cost centers evaluated: [count] - Forecast accuracy (MAPE): [percentage] - Capital projects reviewed: [count] ### Summary Table | Area | Status | Priority | |------|--------|----------| | Departmental Budgeting | [status] | [priority] | | Variance Analysis | [status] | [priority] | | Rolling Forecasts | [status] | [priority] | | Zero-Based Budgeting | [status] | [priority] | | Capital Allocation | [status] | [priority] | | Planning Technology | [status] | [priority] | NEXT STEPS: - "Run `/procurement-analysis` to evaluate spend management against budget allocations." - "Run `/hr-ops` to assess headcount budgeting accuracy and workforce cost planning." - "Run `/compliance-ops` to review financial reporting compliance controls." DO NOT: - Modify any budget figures, forecasts, or allocation formulas. - Recommend zero-based budgeting without assessing organizational readiness and process cost. - Ignore variance analysis quality -- it is the primary feedback loop for budget improvement. - Assume forecast accuracy without measuring it against actual results over multiple periods. - Skip capital allocation analysis even if the organization is primarily OpEx-driven.