ERPWEB: Advanced AI ERP System

Admin User

IOCL EPC Project - Refinery Expansion

Project ID: PRJ-IOCL-2024-001 | Customer: Indian Oil Corporation Limited

Project Timeline

142 Days
Start: 15 Jun 2024 End: 04 Nov 2024

Budget Status

₹4.2 CR
Allocated: ₹6.0 CR 70% Utilized

Items Planned

24
Completed: 8 In Progress: 10

Resource Allocation

84%
Manpower: 42/50 Equipment: 18/22
Sales
Project
Planning
Execution
AP
AR
GL
HR
Payroll
Leads/Pre-Tender
Opportunity/Tender
Offer/Estimate/Bid
Sales/Post-Tender
Project
Leads/Pre-Tender Management
Lead ID Customer Project Description Value (₹ CR) Probability Expected Date Status Actions
LD-IOCL-001 IOCL Refinery Expansion - Phase 1 12.5 80% 2024-07-15 Hot Lead
LD-BPCL-002 BPCL LPG Bottling Plant 8.2 60% 2024-08-20 Warm Lead
LD-HPCL-003 HPCL Pipeline Project 15.8 70% 2024-09-10 Hot Lead
Opportunity/Tender Management
Tender ID Customer Tender Description Bid Value (₹ CR) Submission Date Status Actions
TDR-IOCL-001 IOCL Refinery EPC Project 60.0 2024-04-10 Submitted
TDR-ONGC-002 ONGC Offshore Platform 85.5 2024-05-15 In Progress
Offer/Estimate/Bid Management
Offer ID Customer Offer Description Value (₹ CR) Submission Date Validity (Days) Status Actions
OFF-IOCL-001 IOCL Refinery EPC Project - Phase 1 60.0 2024-04-10 30 Accepted
OFF-ONGC-002 ONGC Offshore Platform Construction 85.5 2024-05-15 45 Under Review
Sales/Post-Tender Management
SO Number Customer Project Value (₹ CR) Order Date Delivery Date Status Actions
SO-IOCL-001 IOCL Refinery Expansion 60.0 2024-04-25 2024-11-04 In Progress
SO-BPCL-002 BPCL LPG Plant Upgrade 28.5 2024-03-10 2024-08-15 Delivered
Project Item Deliverables (ITEMID with Plan & Dependency)
ITEMID Description Plan Start Date Plan End Date Duration (Days) Dependency Status Progress Actions
DWG-001 Engineering Drawings & Documentation 76
30%
PUMP-001 Centrifugal Pumps Installation 57
0%
VESSEL-001 Pressure Vessels Installation 76
0%
Level 2: Project Execution - Payment Schedule
Engineering
Procurement
Construction
Item Total Value (₹) 20% on Code 2 Delivery 30% on Code 1 Delivery 50% on Drawing Delivery Status Actions
P&ID Development 1,200,000
20% ₹240,000 Paid
30% ₹360,000 Pending
50% ₹600,000 Not Due
In Progress
Equipment Layout Drawings 850,000
20% ₹170,000 Paid
30% ₹255,000 Paid
50% ₹425,000 Pending
In Progress
Structural Design 950,000
20% ₹190,000 Paid
30% ₹285,000 Pending
50% ₹475,000 Not Due
In Progress
Electrical Design 780,000
20% ₹156,000 Paid
30% ₹234,000 Paid
50% ₹390,000 Pending
Completed
Instrumentation Design 650,000
20% ₹130,000 Paid
30% ₹195,000 Paid
50% ₹325,000 Paid
Completed
Item Total Value (₹) 40% on Material Delivery 40% on Installation 20% on Go-Live Status Actions
Centrifugal Pumps 2,500,000
40% ₹1,000,000 Paid
40% ₹1,000,000 Pending
20% ₹500,000 Not Due
In Progress
Pressure Vessels 3,200,000
40% ₹1,280,000 Paid
40% ₹1,280,000 Paid
20% ₹640,000 Pending
In Progress
Heat Exchangers 1,800,000
40% ₹720,000 Paid
40% ₹720,000 Pending
20% ₹360,000 Not Due
In Progress
Control Valves 950,000
40% ₹380,000 Paid
40% ₹380,000 Paid
20% ₹190,000 Paid
Completed
Instrumentation Panels 1,100,000
40% ₹440,000 Paid
40% ₹440,000 Paid
20% ₹220,000 Paid
Completed
Item Total Value (₹) 10% on Site Clearance 20% on Cement Arrival 30% on Plinth 20% on Walls 20% on Plaster Status Actions
Pump House Building 4,500,000
10% ₹450,000 Paid
20% ₹900,000 Paid
30% ₹1,350,000 Paid
20% ₹900,000 Pending
20% ₹900,000 Not Due
In Progress
Control Room Building 3,200,000
10% ₹320,000 Paid
20% ₹640,000 Paid
30% ₹960,000 Paid
20% ₹640,000 Paid
20% ₹640,000 Pending
In Progress
Pipe Rack Foundation 2,800,000
10% ₹280,000 Paid
20% ₹560,000 Paid
30% ₹840,000 Paid
20% ₹560,000 Paid
20% ₹560,000 Paid
Completed
Equipment Foundations 3,500,000
10% ₹350,000 Paid
20% ₹700,000 Paid
30% ₹1,050,000 Pending
20% ₹700,000 Not Due
20% ₹700,000 Not Due
In Progress
Boundary Wall 1,600,000
10% ₹160,000 Paid
20% ₹320,000 Paid
30% ₹480,000 Paid
20% ₹320,000 Paid
20% ₹320,000 Paid
Completed
Planning Resources per ITEMID (BOM: Activity, Man, Material, etc.)
Activity
Manpower
Material
Machinery
Logistics
Activity ID Activity Description Duration (Days) Start Date End Date Predecessor Resource Cost (₹) Actions
ACT-DWG-001 P&ID Development 2024-05-18 Design Team A
ACT-DWG-002 Equipment Layout Drawings 2024-06-09 Design Team B
ACT-PUMP-001 Pump Foundation Construction 2024-07-30 Civil Team A
ACT-PUMP-002 Pump Installation & Alignment 2024-08-11 Mechanical Team
ACT-VESSEL-001 Vessel Foundation Construction 2024-08-20 Civil Team B
Total 2,080,000
Resource ID Role Quantity Rate (₹/day) Days Required Total Cost (₹) Vendor Actions
MAN-DWG-001 Senior Design Engineer 3 5,000 40 600,000 Internal
MAN-DWG-002 CAD Technician 5 3,000 40 600,000 Internal
MAN-PUMP-001 Mechanical Engineer 4 4,500 30 540,000 Internal
MAN-PUMP-002 Pump Technician 6 2,500 25 375,000 Internal
MAN-VESSEL-001 Welding Engineer 3 4,800 35 504,000 Internal
MAN-VESSEL-002 NDT Technician 4 3,200 20 256,000 Internal
MAN-SITE-001 Site Supervisor 2 6,000 60 720,000 Internal
MAN-SITE-002 Safety Officer 2 5,500 60 660,000 Internal
MAN-CIVIL-001 Civil Engineer 3 4,200 45 567,000 Internal
MAN-ELEC-001 Electrical Engineer 2 4,800 40 384,000 Internal
Total 5,206,000
Material ID Description Quantity Unit Rate (₹) Total Cost (₹) Supplier Actions
MAT-STEEL-001 Structural Steel ISMB 300 50 MT 65,000 3,250,000 Steel Authority Ltd.
MAT-PIPE-001 CS Pipes 8" Sch 40 200 Meter 2,500 500,000 Pipe Solutions Inc.
MAT-CONC-001 Concrete M30 Grade 150 5,800 870,000 RMC Suppliers
MAT-ELEC-001 Power Cables 4C x 300sqmm 800 Meter 850 680,000 Electrical Mart
MAT-INSTR-001 Control Cables 2C x 1.5sqmm 2500 Meter 120 300,000 Instrumentation World
Total 5,600,000
Equipment ID Description Quantity Rate (₹/day) Days Required Total Cost (₹) Vendor Actions
EQ-CRANE-001 Mobile Crane 50T 2 15,000 30 900,000 Heavy Equipment Co.
EQ-WELDER-001 Arc Welding Machine 8 800 45 288,000 Welding Solutions
EQ-COMP-001 Air Compressor 250CFM 3 2,500 40 300,000 Air Tools Ltd.
EQ-GEN-001 Diesel Generator 250KVA 2 5,000 60 600,000 Power Gen Co.
EQ-EXCV-001 Excavator 1.2M³ 1 12,000 25 300,000 Earth Movers Inc.
Total 2,388,000
Logistics ID Description From To Distance (km) Rate (₹/km) Total Cost (₹) Actions
LOG-STEEL-001 Steel Transportation Jamshedpur Site 350 25 437,500
LOG-EQUIP-001 Equipment Transportation Mumbai Site 1800 30 1,620,000
LOG-CONC-001 Concrete Transportation Plant Site 25 120 450,000
LOG-SITE-001 Site Material Movement Store Work Area 2 50 75,000
Total 2,582,500
Execution per ITEMID (MRP, PO, Receiving, etc.)
MRP Planning
Purchase Order
Receiving & Store
Consuming/Delivery
Inventory
Transfer
Adjust
RA Bill
GRN Number PO Number Vendor Item Qty Received Received Date Store Location Status Actions
GRN-2024-001 PO-2024-STL-001 Steel Authority Ltd. Structural Steel ISMB 300 40 MT 2024-06-12 Store A, Rack 5 Stored
GRN-2024-002 PO-2024-PIP-001 Pipe Solutions Inc. CS Pipes 8" Sch 40 80 M 2024-06-18 Store B, Rack 2 Partial
GRN-2024-003 PO-2024-CON-001 RMC Suppliers Concrete M30 Grade 50 M³ 2024-07-05 Site Store Consumed
GRN-2024-004 PO-2024-ELC-001 Electrical Mart Power Cables 4C x 300sqmm 250 M 2024-07-20 Store C, Rack 1 Pending Inspection
GRN-2024-005 PO-2024-INSTR-001 Instrumentation World Control Valves 4" 12 Nos 2024-07-25 Store D, Rack 3 Stored
Issue ID Material Qty Issued Issue Date Project/Work Order Issued To Status Actions
ISS-2024-001 Structural Steel ISMB 300 25 MT 2024-06-20 PRJ-IOCL-2024-001 Civil Team Issued
ISS-2024-002 CS Pipes 8" Sch 40 60 M 2024-06-25 PRJ-IOCL-2024-001 Piping Team Issued
ISS-2024-003 Concrete M30 Grade 45 M³ 2024-07-10 PRJ-IOCL-2024-001 Concrete Team Consumed
Material ID Description Current Stock Unit Reorder Level Last Updated Status Actions
MAT-STEEL-001 Structural Steel ISMB 300 15 MT MT 10 MT 2024-07-25 Adequate
MAT-PIPE-001 CS Pipes 8" Sch 40 20 M Meter 50 M 2024-07-25 Low Stock
MAT-CONC-001 Concrete M30 Grade 5 M³ 20 M³ 2024-07-25 Low Stock
MAT-ELEC-001 Power Cables 4C x 300sqmm 120 M Meter 100 M 2024-07-25 Adequate
MAT-INSTR-001 Control Valves 4" 8 Nos Nos 5 Nos 2024-07-25 Adequate
MRP ID Material Required Qty Required Date Available Stock Shortage Status Actions
MRP-001 Structural Steel ISMB 300 50 MT 2024-06-15 12 MT 38 MT Planning
MRP-002 CS Pipes 8" Sch 40 200 M 2024-06-20 45 M 155 M Planning
MRP-003 Concrete M30 Grade 150 M³ 2024-07-01 0 M³ 150 M³ Planning
MRP-004 Power Cables 4C x 300sqmm 800 M 2024-07-15 120 M 680 M Planning
MRP-005 Control Cables 2C x 1.5sqmm 2500 M 2024-08-01 300 M 2200 M Draft
PO Number Vendor Item Qty Rate (₹) Total (₹) PO Date Delivery Date Status Actions
PO-2024-STL-001 Steel Authority Ltd. Structural Steel ISMB 300 40 MT 65,000 2,600,000 2024-05-10 2024-06-10 Delivered
PO-2024-PIP-001 Pipe Solutions Inc. CS Pipes 8" Sch 40 160 M 2,500 400,000 2024-05-12 2024-06-15 In Transit
PO-2024-CON-001 RMC Suppliers Concrete M30 Grade 100 M³ 5,800 580,000 2024-06-20 2024-07-05 Confirmed
PO-2024-ELC-001 Electrical Mart Power Cables 4C x 300sqmm 500 M 850 425,000 2024-06-25 2024-07-20 Draft
Level 5: AP Accounts Payable
Bills
Bill Passing
Purchase Voucher
Returns Voucher
Payments
Outstanding
Aging
Party Reconciliations
Bill No Vendor Bill Date Due Date Amount (₹) GST Total (₹) Status Actions
BL-001 Steel Authority Ltd. 2024-06-12 2024-07-12 2,600,000 468,000 3,068,000 Pending
BL-002 Pipe Solutions Inc. 2024-06-18 2024-07-18 400,000 72,000 472,000 Pending
Vendor Total Outstanding (₹) Current (₹) 1-30 Days (₹) 31-60 Days (₹) 61-90 Days (₹) >90 Days (₹) Actions
Steel Authority Ltd. 3,068,000 3,068,000 0 0 0 0
Pipe Solutions Inc. 472,000 472,000 0 0 0 0
Vendor Total Due (₹) Current 1-30 Days 31-60 Days 61-90 Days >90 Days
Steel Authority Ltd. 3,068,000 3,068,000 0 0 0 0
Pipe Solutions Inc. 472,000 472,000 0 0 0 0
Heavy Equipment Co. 1,250,000 850,000 400,000 0 0 0
Level 6: AR Accounts Receivable
Proforma
Invoice
Sales Voucher
Returns Voucher
Receipts
Outstanding
Aging
Party Reconciliations
Invoice No Customer Invoice Date Due Date Amount (₹) GST Total (₹) Status Actions
INV-IOCL-001 IOCL 2024-06-01 2024-07-01 12,500,000 2,250,000 14,750,000 Pending
INV-IOCL-002 IOCL 2024-06-15 2024-07-15 8,750,000 1,575,000 10,325,000 Pending
Customer Total Outstanding (₹) Current (₹) 1-30 Days (₹) 31-60 Days (₹) 61-90 Days (₹) >90 Days (₹) Actions
IOCL 25,075,000 25,075,000 0 0 0 0
BPCL 8,200,000 8,200,000 0 0 0 0
Customer Total Due (₹) Current 1-30 Days 31-60 Days 61-90 Days >90 Days
IOCL 25,075,000 25,075,000 0 0 0 0
BPCL 8,200,000 8,200,000 0 0 0 0
HPCL 12,500,000 8,500,000 4,000,000 0 0 0
Level 7: GL General Ledger
Ledgers
Vouchers
Bank Statement
Bank Reconciliation
Daybooks
Statements
Registers
P&L
Balance Sheet
Ledger Code Ledger Name Group Opening Balance (₹) Debit (₹) Credit (₹) Closing Balance (₹) Actions
10001 Cash in Hand Current Assets 500,000 1,250,000 850,000 900,000
10002 Bank of India Current Assets 2,500,000 5,800,000 3,200,000 5,100,000
Particulars Amount (₹) % of Revenue
Revenue 125,000,000 100.0%
  Direct Costs 85,000,000 68.0%
Gross Profit 40,000,000 32.0%
  Operating Expenses 15,000,000 12.0%
  Administrative Expenses 8,000,000 6.4%
Operating Profit 17,000,000 13.6%
  Interest & Finance Charges 2,500,000 2.0%
  Depreciation 1,800,000 1.4%
Net Profit Before Tax 12,700,000 10.2%
  Tax Expense 3,810,000 3.0%
Net Profit After Tax 8,890,000 7.1%

Assets

Particulars Amount (₹)
Fixed Assets 45,000,000
  Land & Building 25,000,000
  Plant & Machinery 15,000,000
  Office Equipment 5,000,000
Current Assets 65,575,000
  Cash & Bank 6,000,000
  Receivables 45,875,000
  Inventory 13,700,000
Total Assets 110,575,000

Liabilities & Equity

Particulars Amount (₹)
Current Liabilities 25,868,000
  Accounts Payable 18,500,000
  Short-term Loans 7,368,000
Long-term Liabilities 35,000,000
  Term Loans 25,000,000
  Debentures 10,000,000
Equity 49,707,000
  Share Capital 40,000,000
  Reserves & Surplus 9,707,000
Total Liabilities & Equity 110,575,000
Level 8: HR Management
Recruitment
Onboarding
Salary
Orientation
Daily Report
Appraisal
Separation
Req ID Position Department Required By Status Applications Actions
REQ-2024-001 Senior Design Engineer Engineering 2024-07-15 Interviewing 12
REQ-2024-002 Project Manager Project Management 2024-08-01 Screening 8
REQ-2024-003 Site Supervisor Construction 2024-06-30 Filled 15
REQ-2024-004 Safety Officer HSE 2024-07-20 Draft 0
Rajesh Kumar
Active
Employee ID: EMP-001
Department: Engineering
Designation: Senior Design Engineer
Date of Joining: 2022-03-15
Basic Salary
₹65,000
HRA
₹26,000
Special Allowance
₹15,000
PF
₹7,800
Gross Salary
₹1,06,000
Net Salary
₹89,200
Priya Sharma
Active
Employee ID: EMP-002
Department: Project Management
Designation: Project Manager
Date of Joining: 2021-08-10
Basic Salary
₹85,000
HRA
₹34,000
Special Allowance
₹25,000
PF
₹10,200
Gross Salary
₹1,44,000
Net Salary
₹1,18,800
Level 9: Payroll Management
Time Office
Leave
Travel
Claims
Advance
Loan
Bonus
Settlement
Payroll
PF
ESIC
Gratuity
TDS
Employee ID Employee Name Date In Time Out Time Total Hours Overtime Status Actions
EMP-001 Rajesh Kumar 2024-07-01 09:05 AM 06:15 PM 9.17 1.17 Present
EMP-002 Priya Sharma 2024-07-01 09:15 AM 06:30 PM 9.25 1.25 Present
EMP-003 Amit Patel 2024-07-01 09:00 AM 05:45 PM 8.75 0.75 Present
EMP-004 Sanjay Singh 2024-07-01 - - 0 0 Absent
EMP-005 Neha Gupta 2024-07-01 10:30 AM 07:00 PM 8.5 0.5 Half Day
₹5,42,800
Total Gross Pay
₹68,480
Total Deductions
₹4,74,320
Total Net Pay
25
Employees
Employee ID Employee Name Basic Salary Allowances Deductions Net Salary Pay Date Status Actions
EMP-001 Rajesh Kumar 65,000 41,000 16,800 89,200 2024-07-31 Paid
EMP-002 Priya Sharma 85,000 59,000 25,200 1,18,800 2024-07-31 Paid
EMP-003 Amit Patel 55,000 33,000 13,200 74,800 2024-07-31 Paid
EMP-004 Sanjay Singh 48,000 28,800 11,520 65,280 2024-07-31 Pending
EMP-005 Neha Gupta 52,000 31,200 12,480 70,720 2024-07-31 Paid

AI Employee Processing

Use AI to automate project planning and execution across all levels