🛡️
RESTRICTED HRIS ACCESS CONFIDENTIAL ACCESS

Apex Enterprise HRIS Suite

Strategic Turnaround Workforce Portal (94 Staff)

Supervised by Dr. Marwa Agha | AAST Team 1

Enter 4-Digit Passcode to Unlock System
🔒 Session Verified Authentication • Capstone 2026
● LIVE EDIT MODE ON Click any text to modify
A

Apex Manufacturing HRIS 2026

Enterprise HRIS & Strategic OD Turnaround Suite (94 Staff)

AAST • Team 1 | Supervised by Dr. Marwa Agha Developed by Magdy Saber
🏠 Hub

Apex Strategic Leadership & Turnaround Command Center

Navigate between Baseline Crisis (200 HC), Target Plan (94 HC), and ROI Comparison Matrix

ACTIVE TAB: TARGET RIGHTSIZED TURNAROUND MODEL (94 STAFF SCIENTIFICALLY MODELED)
94 Staff across 4 agile tiers, 5.39M EGP monthly payroll ($107.75k), Customer Service = 32 HC, and 92% CSAT.
94 HC Model
Target Total Headcount 👥
94 Staff
≤ 100 Staff (CEO Mandate Met)
Target Monthly Wage Bill 💵
5,387,500 EGP
Market P50 Benchmark ($107.75k)
Target Annual Operating Payroll 📈
64,650,000 EGP
Sustainable Budget ($1.293M)
Target Customer CSAT
92.0%
Target ≥ 90% Achieved

🏢 Target Rightsized Organizational Structure (Approved 94 HC Plan)

New staffing distribution based on workload formulas (Erlang C, plant capacity, sales quota)

100% Synced (CS = 32)
Department Name Target Management Structure (4-Tier) Target Staff Target Monthly Payroll Target Annual Payroll Span of Control Staffing & Workload Driver Basis
Customer Service & Call Center 1 Manager, 2 Team Leads, 1 QA/WFM, 28 Agents 32 Staff 1,442,500 EGP 17,310,000 EGP 1:14 (Frontline) 2,400 calls @ 4.5m + 1hr rest (Erlang C model)
Factory Production Operations 1 Ops Manager, 2 Line Supervisors, 27 Workers 30 Staff 1,185,000 EGP 14,220,000 EGP 1:13.5 (Plant) 10,000 units/day @ 400 units/worker + 2 floaters
Commercial Sales & Business Dev 1 Commercial Head, 2 Regional Leads, 20 Sales Reps 23 Staff 1,540,000 EGP 18,480,000 EGP 1:10 (Sales) $10M revenue target / $500k annual quota per rep
Human Resources (HR Shared Services) 1 HR Lead, 3 Specialists (Recruit, Payroll, ER) 4 Staff 372,500 EGP 4,470,000 EGP 1:23.5 (HR Ratio) Lean Shared HR Services; 1:23.5 HR-to-staff ratio
Finance, Accounting & Procurement 1 Finance Head, 2 Senior Accountants, 1 Admin 4 Staff 372,500 EGP 4,470,000 EGP 1:3 (Finance) Cloud ERP automation; lean accounting unit
Executive Leadership (CEO Office) 1 Chief Executive Officer (CEO) 1 Staff 475,000 EGP 5,700,000 EGP 1:5 (Direct Heads) Executive leadership & strategic turnaround governance
Target Direct Operations Subtotal (CS + Plant + Sales) 85 Staff (90.4%) 4,697,500 EGP 56,370,000 EGP 85 Revenue-Generating Staff
Target Indirect Support Subtotal (HR + Finance) 8 Staff (8.51%) 1,085,000 EGP 13,020,000 EGP Overhead 8.51% ≤ 25% Mandate Ceiling
Total Target Company Workforce & Wage Bill 94 Staff 5,387,500 EGP 64,650,000 EGP 94 Staff / 4 Agile Tiers
🧮

Interactive Workload & FTE Mathematical Modeling Lab

Adjust transaction volume and handling time to simulate required FTE and verify departmental staffing math live

Annual Workload Volume: 120,000
10k300k600k
Average Handling Time - AHT (mins): 4.5 min
0.5m30m60m
Shrinkage & Absence Rate: 15%
0% (Ideal)15% (Benchmark)40% (High)
Mathematical FTE Calculation ✓ 100% Optimal Staffing
Total Workload Hours = 9,000 hrs
Effective Capacity / FTE = 1,632 hrs
Required Frontline FTE
28
Supervision & Quality
+4
Total Department Headcount: 32 Staff

📜 CEO Strategic Mandates & Governance Compliance Audit

Proof of 100% compliance with strict academic OD guidelines set by Dr. Marwa Agha

5 / 5 COMPLIANT
Strategic Mandate Required Target Standard Actual Proposed Metric Compliance Status OD Impact & Audit Evaluation
1. Headcount Rationalization Total Headcount ≤ 100 Staff 94 Staff (6 buffer HC) PASS / COMPLIANT Headcount rationalized from 201 to 94 (-53.0% cut, 6 buffer HC)
2. Hierarchy Flattening Management Layers = 4 Tiers 4 Tiers (Exec ➔ Dept ➔ Lead ➔ IC) PASS / COMPLIANT 7 bureaucratic layers compressed to 4; zero middle-management silos
3. Span of Control Governance Span of Control ≥ 1:6 1:12.5 Frontline Average PASS / COMPLIANT Supervisors oversee 10 to 14 reports (BPO & Lean standard)
4. Support Overhead Ratio Indirect (HR+Fin) ≤ 25% Total HC 8.51% (8 staff only) PASS / COMPLIANT Far below the 25% ceiling, saving millions in unnecessary admin costs
5. Indirect-to-Direct Ratio Indirect ≤ 33.3% of Direct (1:3) 9.41% (1:10.6 ratio) PASS / COMPLIANT 1:10.6 ratio directs 90.4% of workforce to revenue generation

📉 Diagnostic Audit & Crisis Breakdown (Pre-Turnaround Baseline)

Dr. Marwa Agha Apex Case Study — The 6 Root Organizational Diseases & Their Turnaround Solutions

Task 1: Crisis Audit
🔍
What is this section? (Task 1: Organizational Diagnostics in OD Diploma)

Before designing the 94 HC rightsizing plan, our consultancy team audited the 6 root causes behind Apex's financial distress, 38% turnover, and 11.32M EGP monthly wage bleed. Each card below details the diagnostic failure and links directly to our implemented turnaround module.

Pre-Intervention State

1. Zero Written Policies

Critical

Management relied on ad-hoc verbal rulings, generating inconsistent discipline, high legal liability, and employee disputes.

✅ Solved By:

2. No Structured Onboarding

High Impact

Immediate job throw without orientation led to 45% new hire turnover within 90 days and 3+ months time-to-productivity.

✅ Solved By:

3. Reactive Panic Hiring

SLA 45 Days

Time-to-Fill took 45 days costing $3,200 per hire, hiring without standardized interview guides or competency profiles.

✅ Solved By:

4. Severe Headcount Bloat (200 HC)

13.1M EGP/mo

Uncontrolled hiring without workload math, draining 13.1M EGP ($226.3k) monthly and generating severe operating cash deficit.

✅ Solved By:

5. Subjective Appraisal (No PMS)

No KPIs

No KPI scorecards; reviews based on personal supervisor bias, leaving top performers unrewarded and disengaged.

✅ Solved By:

6. 7-Layer Bureaucracy

Span 1:2.5

Narrow spans of control (1:2.5) with 14 managers supervising 25 sales reps, causing decision bottlenecks and paralysis.

✅ Solved By:

👥 Employee Directory & Org Hierarchy (All 94 Personnel Active Roster)

Enterprise master roster across all 94 personnel with Grid Cards View and Interactive Hierarchy Tree Canvas

⚡ Talent Acquisition Kanban (18-Day Fast-Track SLA)

Click on any candidate card to edit in-place (Click-to-Edit), or drag & drop across stages.

Target SLA: 18 Days
1. Sourcing & Screening Days 1-3
Karim Mahmoud
✏️
Quality & Production Engineer • Plant
Salma Nour
✏️
Customer Care Specialist (Call Center)
2. Structured HR Interview Days 4-7
Ahmed Mostafa
✏️
Senior Cost Accountant • Finance
3. Technical Assessment Days 8-11
Tarek Hassan
✏️
Production Shift Supervisor • Plant
4. Panel Final Interview Days 12-15
Mona Wagdy
✏️
Key Account Sales Manager
5. Offer Acceptance SLA Days 16-18
Omar Farouk
✏️
HR Operations Specialist

🚀 30–60–90 Day Talent Onboarding & Probation Hub

Structured integration journey accelerating time-to-productivity and compressing 90-day turnover to ≤ 10%

Onboarding Progress: 67% Completed
SN
Salma Nour El-Din Customer Service
Call Center Agent • Station 14
🤝 Assigned Mentor: Mostafa Ezzat (CS Team Lead)
Overall Onboarding Milestones: 67% Completed (8/12)
Day 1: Orientation Active: Phase 1 Day 90: Confirmation
Phase 1: Days 1 – 30 Integration

Culture, Safety & Policies

Phase 2: Days 31 – 60 Execution

Workload Tasks & Target KPIs

Phase 3: Days 61 – 90 Autonomy

Full Autonomy & Confirmation

📋 Standardized 6-Section Job Descriptions (Academic Benchmark Model)

Covers key benchmark roles across all departments matching Dr. Marwa Agha Task 3 requirements

Task 3: Standardized JDs
Grade 5 • P50 Market

Human Resources Manager

HR Shared Services • Code: APX-HR-001

Directs end-to-end human capital operations, enforcing ≤100 headcount, 8.51% indirect overhead, and 18-day recruitment SLA.

🎯 Primary KPI: Annual Turnover ≤ 12% | Time-to-Fill ≤ 18 Days
Grade 3 • Operational

Production Shift Supervisor

Factory Operations • Code: APX-OPS-003

Directs daily manufacturing shift with 1:13.5 span to hit 10k daily units and reduce scrap rate to ≤ 1.5%.

🎯 Primary KPI: Shift Output ≥ 98% | Scrap Rate ≤ 1.5% | Zero LTIR
Grade 1 • Frontline

Call Center & Care Agent

Customer Service • Code: APX-CS-006

Handles 85 calls/day under Erlang C workload modeling, driving CSAT to ≥ 90% and AHT ≤ 240 seconds.

🎯 Primary KPI: CSAT ≥ 90% | FCR ≥ 85% | AHT ≤ 240 sec
Grade 2 • Field Commercial

Commercial Sales Representative

Commercial Sales • Code: APX-SALES-005

Delivers $500k annual sales quota contributing to $10M corporate goal under tiered commission structure.

🎯 Primary KPI: Quota Attainment ≥ 100% | 12 New B2B Accounts/Qtr
Grade 3 • Financial Core

Senior Cost & Financial Accountant

Finance & Accounting • Code: APX-FIN-003

Manages automated manufacturing cost accounting and cloud ERP ledger reconciliations within 4-day close.

🎯 Primary KPI: Monthly Close ≤ 4 Days | 100% Audit Compliance
Grade 6 • Executive Board

Chief Executive Officer (CEO)

Executive Governance • Code: APX-EXEC-001

Executive leadership of turnaround transformation, delivering 52.4% wage reduction and $81M net savings.

🎯 Primary KPI: $71.13M Annual Savings | Net Operating Margin ≥ 18%

⚖️ Progressive Discipline Engine & Employee Handbook (10 Chapters)

Select employee by name to compute legal sanction and dispatch official notice to employee & manager

Labor Law 12/2003 Compliant

🚨 Official Sanction & Email Dispatch Engine

Mandatory HR Workflow
Direct Line Manager (CC in Email): Noha Abdel-Aziz (CS Manager)
noha.abdelaziz@apex-mfg.com
MANDATORY STATUTORY SANCTION (LABOR LAW & HANDBOOK): Article 64
Written Counseling with 30-Day PIP
Recommended Action Plan: 30-Day punctuality attendance monitoring.

📖 Employee Handbook Table of Contents (10 Chapters):

Click to Read
Ch 1: Employment Basics & Probation SLA
Read ➔
Ch 2: Code of Conduct & Anti-Corruption
Read ➔
Ch 3: Working Hours, Attendance & Shifts
Read ➔
Ch 4: Annual, Official & Sick Leaves
Read ➔
Ch 5: Salary Scale, P50 Market Pay & Allowances
Read ➔
Ch 6: Performance Appraisals & 9-Box Grid
Read ➔
Ch 7: Plant Occupational Health & Safety (HSE)
Read ➔
Ch 8: Grievance Procedures & Appeals
Read ➔
Ch 9: Progressive Discipline Matrix & Sanctions
Critical ➔
Ch 10: Separation & End-of-Service Indemnity
Read ➔

🎯 Continuous Performance Management System & 9-Box Grid Simulator

Select any job role to simulate weighted KPIs, quarterly rating, bonus payout %, and dynamic 9-Box Grid placement

100% Weighted Scorecard

Customer Service Agent Scorecard (Weight: 100%):

APX-CS-006
First Call Resolution (FCR) 35% Weight
88%
Min: 60% Target: ≥ 85% Max: 100%
Average Handle Time (AHT) 30% Weight
230 sec
Fast: 160s Target: ≤ 240s Slow: 320s
Customer Satisfaction Score (CSAT) 35% Weight
92%
Min: 60% Target: ≥ 90% Max: 100%
EVALUATED QUARTERLY RATING
4.4
Exceeds Expectations
Tier 4 • Top 20% Talent
Quarterly Merit Incentive: 115% of Target Bonus
💡 Recommended Action: Retain in Fast-Track succession pool and award quarterly performance payout.
📊 Dynamic 9-Box Placement: Star Talent (Cell 9)
Enigma
(Low/High)
Growth Talent
(Med/High)
★ STAR
(High/High)
Dilemma
(Low/Med)
Core Player
(Med/Med)
High Performer
(High/Med)
Risk / Action
(Low/Low)
Effective
(Med/Low)
Solid Pro
(High/Low)
Low Performance ➔ High Performance ➔

💰 Total Rewards & 6-Grade Salary Scale (Market P50)

Monthly Payroll Budget: 5,387,500 EGP
Grade Level Benchmark Positions Minimum Base Midpoint (P50) Maximum Base Band Spread Incentive & Merit Structure
Grade 1 Assembly Workers, Call Center Agents, Admin 27,500 EGP 32,500 EGP 37,500 EGP 36.4% Quarterly Attendance & Safety Bonus (5% - 10%)
Grade 2 Senior Accountants, HR Officers, Sales Reps Base 57,500 EGP 57,500 EGP 77,500 EGP 34.8% Quarterly Departmental Merit Bonus (10%)
Grade 3 Shift Supervisors, CS Team Leaders, QA/WFM Specialist 75,000 EGP 87,500 EGP 100,000 EGP 33.3% Sales Commission / Shift Yield Bonus (15% - 30%)
Grade 4 Regional Sales Managers, Operations Area Supervisors 135,000 EGP 120,000 EGP 185,000 EGP 37.0% Quarterly Operational & Sales Target Bonus (20%)
Grade 5 Functional Directors (HR, Finance, Sales, Plant, CS) 290,000 EGP 200,000 EGP 390,000 EGP 34.5% Annual Company EBITDA Incentive Pool (25%)
Grade 6 Chief Executive Officer (CEO) 490,000 EGP 475,000 EGP 660,000 EGP 34.8% Long-Term Turnaround Incentive & Board Bonus (35%)
💵

Live Payroll & Wage Bill Budget Financial Modeling Simulator

Simulate base adjustments, bonus pools, and employer social insurance (18.75%) on monthly/annual wage bill and savings

Base Salary Adjustment (%): 0%
-10%0% (Standard P50)+25%
Merit & Performance Bonus Pool (%): 10%
0% (No Bonus)10% (Target)30% (High Cap)
Inflation / COLA Allowance (%): 0%
0% (Absorbed)10% (Mid)20% (Max)
⚖️ Legal Compliance Note: Includes 18.75% Employer Social Insurance contribution per Law 148/2019 and progressive tax withholding schedules.
Simulated Company Payroll (94 Personnel) ✓ Healthy Solvency
Monthly Gross Wages: 5,387,500 EGP
Employer Social Ins (18.75%): 1,010,156 EGP
Total Monthly Labor Cost: 6,397,656 EGP
Annual Company Wage Bill
76,771,875 EGP
($1,535,438 USD)
Annual Savings vs Old (140 HC)
+29,550,000 EGP
(+$591,000 USD)

Wage Bill Allocation Across 6 Agile Departments

Department Headcount Grade Range Monthly Base Pool Avg Base / FTE % of Total Payroll
📞 Customer Service & CC 32 Grades 1–5 1,280,000 EGP 40,000 EGP 23.8%
⚙️ Plant Operations & Factory 30 Grades 1–5 1,215,000 EGP 40,500 EGP 22.6%
💼 Commercial Sales Force 23 Grades 2–5 1,610,000 EGP 70,000 EGP 29.9%
💰 Finance & Accounting 4 Grades 2–5 392,500 EGP 98,125 EGP 7.3%
👥 Human Resources & OD 4 Grades 2–5 415,000 EGP 103,750 EGP 7.7%
🏛️ Executive Office 1 Grade 6 475,000 EGP 475,000 EGP 8.8%

🌲 Interactive Lean Org Chart Canvas (4 Agile Tiers & Wide Span)

Click on any role to open their Microsoft Outlook Profile Card, reporting lines, and direct reports

Lean Structure (94 HC)
TA
Tier 1: Strategic Governance
Tamer Adel
Chief Executive Officer (CEO)
👥 5 Direct Reports Span 1:5
👆 Click to view Outlook Card
NA
TIER 2 (DIRECT)
Noha Abdel-Aziz
Customer Service Manager
📞 31 Total Staff • Span 1:14
👆 Outlook Profile
MH
TIER 2 (DIRECT)
Eng. Mahmoud Hassan
Plant Operations Director
🏭 29 Total Staff • Span 1:13.5
👆 Outlook Profile
KS
TIER 2 (DIRECT)
Karim El-Sayed
VP Commercial Sales
💼 22 Total Staff • Span 1:10
👆 Outlook Profile
SM
TIER 2 (SUPPORT)
Dr. Sherif Mansour
Human Resources Manager
👥 3 Direct • Ratio 1:23.5
👆 Outlook Profile
HZ
TIER 2 (SUPPORT)
Hisham Zaki
Finance & Procurement Head
💰 3 Direct • Cloud ERP
👆 Outlook Profile
TIER 3: OPERATIONAL SUPERVISION & TEAM LEADS
CS OPERATIONAL LEADS
Mostafa Ezzat & Team
2 Team Leads + 1 QA/WFM
PLANT LINE SUPERVISORS
Tarek Hassan & Team
2 Supervisors • Span 1:13.5
REGIONAL SALES LEADS
Mona Wagdy & Team
2 Regional Leads • Span 1:10
HR SHARED SPECIALISTS
Omar Farouk & Team
3 Specialists (Talent, C&B, ER)
SENIOR ACCOUNTANTS
Ahmed Mostafa & Team
2 Accountants + 1 Admin
TIER 4: FRONTLINE OPERATIONS & WORKFORCE
28 Call Center Agents Grade 1
85 Calls/Day • Erlang C Model
Ex: Salma Nour El-Din
27 Factory Technicians Grade 1
10,000 Units/Day • 400 Units/Worker
Ex: Ahmed Refaat
20 Commercial Sales Reps Grade 2
$500k Quota/Rep • $10M Rev Target
Ex: Youssef Khaled
Central Shared HR
Fully Servicing All 94 Personnel
Automated Cloud ERP
Real-Time Financial Analytics