SOFTROBOT AI ERP - PROJECT ASSET ATP MANAGEMENT SCHEDULAR

Total Assets

2,846

Assets In Use

1,782

Idle Assets

412

In Maintenance

163

ATP Shortages

Urgent Tickets

Project ATP Asset Allocation & Ticket Generation

ASSET CODE	ASSET DESCRIPTION	PROJECT	ACTIVITY	REQUIRED DATE	TOTAL ASSET	IN USE	IDLE	MAINTENANCE	AVAILABLE ATP	REQUIRED	SHORTAGE	ACTION	TICKET STATUS
EQ-1001	Hydra Crane 14T	Metro Rail Package A	Steel Girder Erection	20-May-2026	6	5	0	1	0	2	2	GENERATE RENTAL TICKET	OPEN
EQ-1002	Boom Lift 12M	Airport HVAC	Duct Installation	22-May-2026	10	6	2	1	3	2	0	ALLOCATE IDLE ASSET	APPROVED
EQ-1003	Concrete Mixer Machine	Industrial Shed	Foundation Work	25-May-2026	8	7	0	1	0	3	3	INTER PROJECT TRANSFER	OPEN
EQ-1004	Welding Machine 400A	Refinery Project	Pipe Welding	28-May-2026	40	28	6	2	10	8	0	BLOCK FOR PROJECT	COMPLETED
EQ-1005	Forklift 5T	Warehouse Expansion	Material Shifting	01-Jun-2026	5	4	0	1	0	2	2	OUTSOURCE EQUIPMENT	ESCALATED
EQ-1006	Scaffolding Set	Hospital HVAC	AHU Installation	03-Jun-2026	1500	1200	200	20	280	250	0	ALLOCATE AVAILABLE STOCK	READY
EQ-1007	Trailer 40FT	Logistics Division	Heavy Equipment Transport	05-Jun-2026	14	11	1	1	2	5	3	GENERATE HIRING TICKET	OPEN
EQ-1008	Diesel Generator 125 KVA	Data Center Project	Temporary Site Power	06-Jun-2026	7	5	1	0	2	2	0	PROJECT RESERVATION	APPROVED

PROJECT ATP ASSET MANAGEMENT LOGIC

1. ATP (Available To Promise) Asset Logic

AVAILABLE ATP = TOTAL ASSET - IN USE - IN MAINTENANCE

IF AVAILABLE ATP < PROJECT REQUIREMENT
THEN GENERATE SHORTAGE TICKET

2. Asset Allocation Priority

AI allocation sequence:

Idle Assets
Nearby Site Transfer
Return Expected Assets
Rental Assets
External Vendor Hiring
Emergency Procurement

3. Construction Activity Planning

Assets linked with:

Project WBS
BBU Activity
Execution Schedule
Manpower Planning
Material Delivery Plan
Site Readiness

4. Maintenance Blocking Logic

Assets under:

Preventive Maintenance
Breakdown Maintenance
Calibration
Fitness Certification
Insurance Expiry

are automatically blocked from ATP availability.

5. Auto Ticket Generation

IF SHORTAGE EXISTS:

Generate Asset Transfer Ticket
Generate Rental Approval Ticket
Generate Vendor Hiring Ticket
Generate Maintenance Priority Ticket
Generate Transport Ticket

6. Logistics Asset Planning

AI tracks:

Trailer Movement
Vehicle Utilization
Fuel Consumption
Driver Availability
Distance Planning
Trip Scheduling

7. Idle Asset Optimization

Idle assets are identified across all projects. AI recommends:

Inter-site Transfer
Rental Recovery
Asset Disposal
Maintenance Scheduling
Utilization Improvement

ERP SQL ATP Asset Scheduler Logic


SELECT
    ASSETCODE,
    ASSETNAME,
    TOTALQTY,
    INUSEQTY,
    IDLEQTY,
    MAINTENANCEQTY,
    PROJECTREQQTY
FROM ASSETATPMASTER


AVAILABLEATP =
    TOTALQTY
    - INUSEQTY
    - MAINTENANCEQTY


IF AVAILABLEATP < PROJECTREQQTY

BEGIN

    SHORTAGE =
        PROJECTREQQTY - AVAILABLEATP

    GENERATE ASSET TICKET

    IF IDLE ASSET AVAILABLE
        CREATE TRANSFER TICKET

    ELSE
        CREATE RENTAL / HIRING TICKET

END


SCHEDULER RUN:
    EVERY 2 HOURS

AI Asset Management Flow


PROJECT DELIVERY PLAN
            ↓
ACTIVITY WISE ASSET REQUIREMENT
            ↓
ATP AVAILABILITY CHECK
            ↓
SHORTAGE IDENTIFICATION
            ↓
IDLE ASSET SEARCH
            ↓
INTER PROJECT TRANSFER
            ↓
RENTAL / PROCUREMENT
            ↓
TRANSPORT TICKET
            ↓
SITE DELIVERY
            ↓
RETURN / MAINTENANCE
            ↓
ASSET REUSE OPTIMIZATION