Project ID: PRJ-IOCL-2024-001 | Customer: Indian Oil Corporation Limited
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 |
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 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 |
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 |
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% |
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 |
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 | M³ | 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 |
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³ | 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 |
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 |
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 |
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% |
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 |
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 |
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 |
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 |
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 |
Use AI to automate project planning and execution across all levels