Engagement Margin Leakage and Profitability Dashboard Brief

Role: Senior Commercial Analytics Director specializing in engagement economics and billable margin optimization across professional services firms.

Context

• Active service lines: {{firm_service_lines}}
• Costing methodology: {{cost_rate_methodology}}
• Margin degradation triggers: {{margin_leakage_triggers}}
• Integrated tool stack: {{erp_time_tracking_tools}}
• Review frequency: {{executive_review_cadence}}
• Data classification level: {{confidentiality_tier}}

Task

Develop an engagement profitability dashboard delivery brief that equips practice leaders and project managers with early-warning indicators for margin erosion, scope creep, and unrecoverable expense accumulation.

Method

1. Ingest budget, actuals, and committed cost feeds from {{erp_time_tracking_tools}}.
2. Translate {{cost_rate_methodology}} into blended cost-of-delivery models per engagement.
3. Model gross margin vs. contribution margin thresholds across {{firm_service_lines}}.
4. Define quantitative thresholds that flag active {{margin_leakage_triggers}} across in-flight projects.
5. Formulate an Earned Value Management (EVM) component calculating Cost Performance Index (CPI) and Schedule Performance Index (SPI).
6. Structure top-level portfolio health distributions showing at-risk revenue by contract type.
7. Detail engagement drill-through screens capturing staff-level hourly rate variance and non-reimbursable expenses.
8. Establish notification channels and automated action queues aligned with {{executive_review_cadence}}.

Constraints

• MUST calculate project health using both burned-cost and estimated-to-complete (ETC) metrics.
• MUST NOT display raw loaded labor costs to engagement leads lacking {{confidentiality_tier}} clearance.
• Must separate client-reimbursable expenses from firm-absorbed operating expenses in gross margin displays.
• All data refresh schedules must align strictly with {{executive_review_cadence}}.

Output format

Deliver an executive-level dashboard brief structured as follows:

1. Strategic Objectives and Governance Scope (under 250 words)
2. Margin & Leakage KPI Taxonomy (tabular format: Metric, Target, Warning Floor, Critical Alert Floor, Data Source)
3. Dashboard Wireframe Structure (Screen 1: Portfolio View, Screen 2: Engagement Detail, Screen 3: Leakage Diagnostics)
4. Access Control and Labor Cost Obfuscation Rules
5. Mitigation Workflow Automation Blueprint

Self-review

• Confirm that {{margin_leakage_triggers}} map to specific visual alerts.
• Validate that {{cost_rate_methodology}} handles contractor vs. permanent staff cost discrepancies.
• Verify adherence to {{confidentiality_tier}} across all engagement-level reports.