Event Production Budget Optimization Tracker

Design a sophisticated Excel workbook with integrated Power Query data connections that dynamically tracks and optimizes entertainment event production budgets. The system must handle multiple revenue and expense streams, including talent costs, venue expenses, marketing budgets, and potential sponsorship income. Implement advanced conditional formatting to highlight financial risks, create predictive budget variance alerts, and generate comprehensive stakeholder reporting dashboards.