ECM Workforce Intelligence System
📥

No data yet

Upload your monthly employee master in the locked C&B & Headcount Input tab. The Bird’s Eye View fills in automatically.

Project D · Bird’s Eye View

Workforce decisions at a glance

Compare:
ECM MATRIX · LIVE
STAFF  ←  EMPLOYMENT LAYER  →  LABOUR
← SUPPORTROLE FUNCTIONOPERATIONS →
EXECUTIVE ECM DASHBOARD · ONE LOOK

Are we healthy?

KPIResultStatus
QUESTION 1

Where are our people?

HC% = Quadrant HC ÷ Total HC × 100
Decision rule: a factory is healthy when direct operations (Q1) sit around 65–80% of headcount. A falling Q1% means overhead is creeping in.
QUESTION 2

Where is the people-cost spent?

Cost% = Quadrant Cost ÷ Total Cost × 100
Decision rule: compare each quadrant’s cost% with its HC%. A quadrant whose cost share is much higher than its headcount share is your expensive layer — keep it under review.
QUESTION 3

Is support workforce growing faster than operations?

Growth% = (Current − Past) ÷ Past × 100
Decision rule: if any support quadrant (Q2 or Q4) grows much faster than Q1, overhead is rising — investigate before it compounds.
QUESTION 4 · FLAGSHIP KPI

Operational Support Ratio (OSR)

OSR = (Q2 + Q3 + Q4) ÷ Q1 · on cost
—
QUESTION 5 · STRATEGIC

Is workforce growth aligned with business growth?

Growth% = (Current − Past) ÷ Past × 100 · Revenue vs Headcount vs Cost
Enter revenue per period (৳) to complete the picture.
Decision rule: revenue should grow at least as fast as headcount and cost. If headcount% or cost% growth outruns revenue% growth, efficiency (revenue per employee) is falling.
QUADRANT TRENDS

How each quadrant (Q1–Q4) is changing over time

Show:
PYRAMID

Workforce shape — then vs now

📥

No data yet

Upload your organisation’s monthly employee master in the locked C&B & Headcount Input tab to populate this dashboard. Each upload adds a period to the trend series.

—

Trend review & analysis

Your workforce structure across uploaded periods, at three cadences. Each upload is added to a cadence (monthly, quarterly or yearly) and appears here as the series grows.

Cadence

Workforce pyramid — Workers / Staff / Management

Operational-staff (Q3) share

% of the roster in supervision / QC / IE. Dashed line = ~10% healthy floor.

Operations : Support balance

(Q1+Q3) vs (Q2+Q4). Shaded band = healthy 3.5–5.0 zone.

Total headcount

Workforce size across the period.

Segment mix

Share of each ECM segment — is growth balanced?

Payroll & cost-per-head

Captured from each monthly upload. Reconstructed periods show headcount only — real ৳ fills in as files are added.
📥

No data yet

Upload your organisation’s monthly employee master in the locked C&B & Headcount Input tab to populate this dashboard. Each upload adds a period to the trend series.

—

Cost × Value — read the action

One management question: is our payroll money going to the groups that drive the most output? Every employee group is plotted by what it costs per person against how much it contributes to results — so you can see which groups to invest in, protect, govern, or just watch.

Segment positioning

How to read it — → right = contributes more to output & margin · ↑ up = costs more per person each month · bigger bubble = more people. Bottom-right = high value, low cost (your best spend); top area = expensive (govern it).
Value weighting — how much each quadrant drives output / margin (1 = low · 5 = high)
Why this viewHeadcount hides the real story: a segment can be 4% of people but a fifth of payroll. Plotting cost against value tells you where money is well spent (high value) versus where it needs governing (high cost, lower value) — and where under-spend is quietly costing more than it saves.
Retain — low cost · high value. Strongest efficiency ratio. Protect and stabilise.
Invest — high cost · high value. Develop, retain talent, scale capability.
Review — high cost · low value. Restructure, reskill or rationalise.
Monitor — low cost · low value. Keep lean; automate or absorb where viable.
📥

No data yet

Upload your monthly employee master in the locked C&B & Headcount Input tab to populate this dashboard.

★

Top 10 by quadrant

Rank by:
Quadrant:
○

Departments with the highest earners

📥

No data yet

Upload your monthly employee master in the locked C&B & Headcount Input tab to run a manpower forecast.

◹

Manpower forecast & budgeting

Set a business target, then move resources into each quadrant. The readiness gauge tells you whether your manpower plan can hit the target — and what it will cost. How many Q1–Q4 resources are needed?

Business targets
+30%
Standard
No cap
Resource plan — add / reduce heads

Plan readiness score

—/ 100
—
—
Planned headcount—
Monthly payroll—
Δ vs today—
Present vs target plan — the decision
🔒

C&B & Headcount Input

Restricted to authorized HR & Compensation staff. Enter the access key to upload monthly master data.

—

Upload monthly master data

Drop the period's employee master (.xlsx). The system classifies every row into the ECM model in your browser, previews the result, and adds it to the trend series. Nothing leaves the page until you press Save.

Drop .xlsx here, or click to choose
Expected columns: EmpID · DesigName · Type · DeptName · SecName · OGross · JDate · Name
Computed for this period
Stored periods
PeriodCadenceTotalQ1Q2Q3Q4Ops:SupQ3 %Payroll ৳