Metric dependency map
Driver tree
Metrics expand left to right into the formula components they depend on.
Contribution Margin (%)
[contribution_margin_db] / [total_revenue] * 100
Contribution Margin (DB)
[internal_service_el2] - [travel_costs] - [total_labor_costs]
Internal Service (EL2)
[internal_service_el1] - [subcontractor_external]
Total Labor Costs
[direct_labor_costs] + [onboarding_training_costs] + [paid_leave_sick_leave] + [paid_leave_vacation] + [calculated_labor_overheads]
Travel Costs
[travel_costs]
Calculated Labor Overheads
[calculated_labor_overheads]
Direct Labor Costs
[direct_labor_costs]
Internal Service (EL1)
[total_revenue] - [subcontractor_division] - [subcontractor_group]
Onboarding / Training Costs
[onboarding_training_costs]
Paid Leave (Sick Leave)
[paid_leave_sick_leave]
Paid Leave (Vacation)
[paid_leave_vacation]
Subcontractor (External)
[subcontractor_external]
Subcontractor (Division)
[subcontractor_division]
Subcontractor (Group)
[subcontractor_group]
Total Revenue
[total_revenue]
Unconnected metrics
30 metrics
Accrual / Adjustment
[accrual_adjustment]
Actual Revenue (Fixed Price)
[actual_revenue_fixed_price]
Actual Revenue (Hourly)
[actual_revenue_hourly]
Actual Revenue (Other)
[actual_revenue_other]
Actual Working Hours
[actual_working_hours]
Break Hours
[break_hours]
Contracted Fixed Price
[contracted_fixed_price]
Contribution Margin Level 1 (%)
[contribution_margin_level_1]
Contribution Margin Level 1 (DB-1)
[contribution_margin_level_1_db_1]
Contribution Margin Level 2 (%)
[contribution_margin_level_2]
Contribution Margin Level 2 (DB-2)
[contribution_margin_level_2_db_2]
Cost Variance (Delta)
[cost_variance_delta]
Fixed Salary Hours
[fixed_salary_hours]
Hour Variance
[hour_variance]
Internal Service Total
[internal_service_total]
Material Costs
[material_costs]
Planned Contribution Margin
[planned_contribution_margin]
Planned Labor Cost Ratio
[planned_labor_cost_ratio]
Planned Overhead / Cost Factor
[planned_overhead_cost_factor]
Planned Subcontractor Ratio
[planned_subcontractor_ratio]
Planned Working Hours
[planned_working_hours]
Productive Hours
[productive_hours]
Service Quality Actual (%)
[service_quality_actual]
Service Quality Target (%)
[service_quality_target]
Subcontractor Hours
[subcontractor_hours]
Subcontractor Hours (Training)
[subcontractor_hours_training]
Total Services (excluding training)
[total_services_excluding_training]
Total Subcontractor Services
[total_subcontractor_services]
Training Hours
[training_hours]
Vehicle Costs
[vehicle_costs]