SOFTROBOT AI ERP - PROJECT MANPOWER ATP MANAGEMENT

Total Employees

4,862

Allocated

3,614

Idle

428

On Leave

192

Shortage

241

Vacancy Tickets

Project Wise Manpower ATP Allocation & Vacancy Ticket Scheduler

PROJECT	ACTIVITY	DEPARTMENT	SKILL	ATP DELIVERY DATE	PLANNED	ALLOCATED	IDLE	ON LEAVE	AVAILABLE ATP	REQUIRED	SHORTAGE	ACTION	TICKET STATUS
Metro Rail Package A	Steel Structure Erection	Execution	Rigger	20-May-2026	65	58	2	4	3	12	9	GENERATE VACANCY TICKET	OPEN
Airport HVAC	Duct Installation	HVAC	Duct Fitter	22-May-2026	120	98	10	4	18	15	0	ALLOCATE IDLE MANPOWER	APPROVED
Refinery Project	Pipe Welding	Mechanical	6G Welder	25-May-2026	85	81	0	2	2	10	8	INTER PROJECT TRANSFER	OPEN
Data Center Project	Cable Tray Installation	Electrical	Electrician	28-May-2026	74	60	7	3	11	9	0	BLOCK RESOURCE	READY
Warehouse Expansion	Flooring Work	Civil	Mason	30-May-2026	96	91	0	1	4	18	14	LABOUR CONTRACTOR TICKET	ESCALATED
Solar Plant EPC	Module Mounting	Execution	Helper	03-Jun-2026	210	160	28	5	45	40	0	ALLOCATE IDLE TEAM	COMPLETED
Industrial Shed	Fabrication	Workshop	Fabricator	06-Jun-2026	54	48	1	2	4	11	7	RECRUITMENT APPROVAL	OPEN
Hospital HVAC	AHU Installation	HVAC	Supervisor	10-Jun-2026	18	14	2	1	3	3	0	RESOURCE RESERVED	APPROVED

PROJECT MANPOWER ATP LOGIC

1. Manpower ATP Formula

AVAILABLE ATP = TOTAL PLANNED - ALLOCATED - ON LEAVE

IF AVAILABLE ATP < REQUIRED MANPOWER
THEN SHORTAGE EXISTS

2. AI Resource Allocation Logic

System allocation priority:

Idle Employees
Nearby Site Transfer
Upcoming Release Employees
Contract Labour
Recruitment Vacancy
Subcontractor Hiring

3. ATP Linked With Project Delivery

Manpower planning automatically linked with:

Project ATP Dates
BBU Activities
Project Item Scheduler
Execution DPR
Material Availability
Asset Availability
Shift Planning

4. Automatic Ticket Generation

IF SHORTAGE EXISTS:

Create Vacancy Ticket
Create HR Recruitment Ticket
Create Inter Project Transfer Ticket
Create Contractor Hiring Ticket
Create Approval Escalation Ticket

5. Leave Management Impact

AI considers:

Approved Leave
Absent Employees
Night Shift Availability
Weekly Off
Holiday Calendar
Overtime Planning

before ATP manpower commitment.

6. Construction & EPC Workforce Planning

Planning categories:

Project Engineers
Supervisors
Foreman
Operators
Technicians
Welders
Fitters
Electricians
Helpers
Contract Labour

7. AI Optimization Engine

AI continuously optimizes:

Utilization %
Idle Workforce
Labour Productivity
Shift Balancing
Overtime Cost
Recruitment Forecast

ERP SQL Manpower ATP Scheduler Logic


SELECT
    PROJECTID,
    DEPARTMENT,
    SKILL,
    TOTALPLANNED,
    ALLOCATED,
    IDLE,
    ONLEAVE,
    REQUIREDQTY
FROM PROJECTMANPOWERATP


AVAILABLEATP =
    TOTALPLANNED
    - ALLOCATED
    - ONLEAVE


IF AVAILABLEATP < REQUIREDQTY

BEGIN

    SHORTAGE =
        REQUIREDQTY - AVAILABLEATP

    GENERATE VACANCY TICKET

    IF IDLE AVAILABLE
        CREATE TRANSFER TICKET

    ELSE
        CREATE HR RECRUITMENT TICKET

END


SCHEDULER RUN:
    EVERY 1 HOUR

AI Workforce Planning Flow


PROJECT DELIVERY ATP
            ↓
ACTIVITY WISE MANPOWER PLAN
            ↓
SKILL WISE REQUIREMENT
            ↓
AVAILABLE ATP CHECK
            ↓
SHORTAGE IDENTIFICATION
            ↓
IDLE RESOURCE SEARCH
            ↓
INTER PROJECT TRANSFER
            ↓
HR VACANCY GENERATION
            ↓
RECRUITMENT / CONTRACT LABOUR
            ↓
SITE DEPLOYMENT
            ↓
ATTENDANCE & PRODUCTIVITY TRACKING