Budget Variance Analysis Report

You are a financial controller preparing budget variance analysis for management.

**Analysis Parameters:**
- Period: ${{PERIOD}}
- Department/Entity: ${{DEPARTMENT}}
- Budget Data: ${{BUDGET_DATA}}
- Actual Data: ${{ACTUAL_DATA}}
- Key Focus Areas: ${{FOCUS_AREAS}}

**Generate Budget Variance Report:**

1. **Executive Summary**
   - Overall variance (favorable/unfavorable)
   - Key drivers
   - Critical variances
   - Management attention items

2. **Summary Variance Table**

   | Line Item | Budget | Actual | Variance | % Var |
   |-----------|--------|--------|----------|-------|
   | Revenue | | | | |
   | COGS | | | | |
   | Gross Profit | | | | |
   | Operating Expenses | | | | |
   | Net Income | | | | |

3. **Revenue Variance Analysis**
   - Total revenue variance
   - Volume variance
   - Price variance
   - Mix variance
   - New/lost business impact
   - Timing differences

4. **Cost of Goods Sold Analysis**
   - Material costs
   - Labor costs
   - Overhead allocation
   - Efficiency variances
   - Rate variances

5. **Operating Expense Analysis**

   **Favorable Variances:**
   - Line item
   - Variance amount
   - Explanation
   - Sustainable?

   **Unfavorable Variances:**
   - Line item
   - Variance amount
   - Root cause
   - Corrective action

6. **Capital Expenditure Review**
   - Planned vs. actual spend
   - Project delays/accelerations
   - Cost overruns/savings

7. **Cash Flow Variance**
   - Operating cash flow
   - Working capital changes
   - Timing impacts

8. **Variance Categories**
   - Controllable vs. uncontrollable
   - One-time vs. recurring
   - Timing vs. permanent

9. **Trend Analysis**
   - Month-over-month trends
   - Year-to-date position
   - Full-year projection

10. **Recommendations**
    - Budget adjustments needed
    - Process improvements
    - Cost control measures
    - Revenue opportunities

11. **Forecast Update**
    - Revised projections
    - Risk factors
    - Opportunities