Skill Mix Table in the BOE

Feature Request: Skill Mix Table in BOE

Summary:
Add a skill mix table to the BOE that displays the proportion of resource hours by role/skill for both actual ledger data and estimated resources. This will give users a clear, at-a-glance view of how work is distributed across different skill types within a given BOE.

Problem Statement:
Today, users cannot easily see how resource effort is distributed across different skill types within a BOE. Actual hours from the ledger are available, but they are not summarized in a way that shows the percentage mix of each resource type. Similarly, estimated resources are tracked, but their relative contribution by skill is not visible. This makes it difficult to validate whether the planned staffing model aligns with actuals, identify imbalances in the skill mix, or communicate resource composition to stakeholders.

Proposed Solution:
Introduce a “Skill Mix” table in the BOE that summarizes resource usage as a percentage of total hours, for both actuals and estimates.

• For actuals, calculate skill mix as: Individual Resource Hours / Total Hours over the selected BOE scope (e.g., project, period, or cost element range).

• For estimates, calculate skill mix using the estimated hours for each resource or role relative to total estimated hours.

• Allow grouping by resource attributes such as role, labor category, or skill type (based on existing resource master data).

• Display both absolute hours and percentage of total for each skill group, clearly labeled (e.g., “Actual Hours”, “Actual % of Total”, “Estimated Hours”, “Estimated % of Total”).

• Support basic filtering (e.g., by time period, organization, contract line, or WBS/PBS element as applicable) to refine which hours are included in the calculation.

• Ensure the skill mix table refreshes automatically when underlying ledger data or estimates are updated.

• Provide export capability (e.g., to Excel or PDF) so users can include the skill mix table in reviews and audit packages.

Benefits:

• Provides a clear, quantitative view of how effort is distributed across different skills.

• Helps compare actual staffing patterns against planned or target skill mixes.

• Supports more informed staffing, planning, and pricing decisions.

• Improves transparency for stakeholders and reviewers by summarizing complex resourcing data in an easy-to-read table.

• Reduces manual effort required to pull hours and compute percentages outside the system.