Project ID Project Name Manager Phase Estimated Cost Actual Cost Start Date
C5001 Metro Link Gaurav Execution 40000000 41000000 2024-03-01
C5002 Tech Park Tina Execution 30000000 29500000 2023-07-15
C5003 Riverfront Mall Binita Execution 25000000 27000000 2024-01-10
C5004 Bridge X Leena Execution 22000000 23000000 2024-05-05
C5005 Green Apartments Chirag Execution 18000000 17500000 2022-11-01
C5006 Hospital Wing Mohan Planning 15000000 14800000 2023-03-01
C5007 Sewage Plant Sameer Execution 14000000 14500000 2022-01-01
C5008 Solar Farm Omkar Execution 12000000 12500000 2024-06-15
C5009 Skyline Tower Amit Planning 12000000 11800000 2024-04-10
C5010 Warehouse A Karan Execution 9000000 9200000 2023-08-01
C5011 Sports Complex Nisha Execution 8000000 8600000 2023-05-20
C5012 Link Road Deepa Planning 8000000 8200000 2021-02-01
C5013 New Office Hema Planning 7000000 6900000 2024-09-01
C5014 Central Park Farah Execution 6000000 6200000 2023-11-11
C5015 Water Plant Priya Closeout 6000000 5800000 2022-04-01
C5016 Road Widen Qadir Execution 5000000 5400000 2021-06-01
C5017 Harbor Redev Eshan Closeout 5000000 4800000 2023-02-01
C5018 Market Complex Ritu Planning 3500000 3400000 2024-10-01
C5019 School Building Isha Execution 3000000 3300000 2022-08-01
C5020 Community Hall Jatin Closeout 1200000 1150000 2023-01-01
End Date Variance Variance %
2025-03-01 -200000 2.50%
2025-06-30 2000000 -1.67%
2025-12-20 -500000 8.00%
2025-05-05 200000 4.55%
2024-11-01 -200000 -2.78%
2025-02-28 200000 -1.33%
2026-12-31 1000000 3.57%
2025-06-15 -100000 4.17%
2025-01-31 300000 -1.67%
2024-09-01 -50000 2.22%
2025-05-20 200000 7.50%
2025-12-31 1000000 2.50%
2026-09-01 -200000 -1.43%
2025-11-10 600000 3.33%
2025-04-01 500000 -3.33%
2024-06-01 -200000 8.00%
2024-12-31 400000 -4.00%
2025-10-01 -100000 -2.86%
2026-08-01 500000 10.00%
2025-12-31 -500000 -4.17%
Total Estimated Costs Total Actual Costs
Planning 192000000 197700000
Execution 152000000 156700000
Closeout 122000000 127200000
Top 5 Projects by Actual Cost
45000000
40000000
35000000
30000000
25000000
20000000
15000000
10000000
5000000
0
Metro Link Tech Park Riverfront Mall Bridge X Green
Apartments
Estimated Cost Actual Cost
Green
Apartments
Phase Total estimated total actual
Planning 45500000 45100000
Execution 192000000 197700000
Closeout 12200000 11750000
Data
Manager Sum of Actual Cost Average of Variance
Amit 11800000 300000
Binita 27000000 -500000
Chirag 17500000 -200000
Deepa 8200000 1000000
Eshan 4800000 400000
This shape represents a
Farah 6200000 600000 slicer. Slicers are supported
Gaurav 41000000 -200000 in Excel 2010 or later.
Hema 6900000 -200000
Isha 3300000 500000 If the shape was modified in
an earlier version of Excel,
Jatin 1150000 -500000 or if the workbook was saved
Karan 9200000 -50000 in Excel 2003 or earlier, the
Leena 23000000 200000 slicer cannot be used.
Mohan 14800000 200000
Nisha 8600000 200000
Omkar 12500000 -100000
Priya 5800000 500000
Qadir 5400000 -200000
Ritu 3400000 -100000
Sameer 14500000 1000000
Tina 29500000 2000000
Total Result 254550000 242500
sents a
supported
later.
modified in
n of Excel,
ok was saved
earlier, the
used.