Problem 0:
· Project is to install 200 windows.
· Each week of the project cost is same.
· Team is paid $4000 every week plus $1000 worth of parts.
· Project is scheduled for 16 weeks.
· Calculate – BAC (Project budget)?
· After four weeks installed windows are 40. Ideally it should be 50 windows.
· Calculate PV & EV?
Answer 0:
| Problem 0: | |
| Project Duration (wks) | 16.00 |
| Each Week Cost | 5000.00 |
| BAC($) | 80000.00 |
| | |
| After 04 Weeks: | |
| Planned % Complete - (50/200) | 25.00% |
| Actual % Complete - (40/200) | 20.00% |
| | |
| Planned Value (PV)($) | 20000 |
| Earned Value (EV)($) | 16000 |
Since the earned value after four weeks is less than planned value,
That means customer is running in loss.
Problem 1:
· Project has a total budget of $3,00,000.
· So far spent $1,75,000.
· Team has completed 40% of the project work.
· However team should have completed 50% of the work.
· Calculate – EV, SV, CV, SPI, CPI ?
Answer 1:
| Problem 1: | |
| BAC | 300000.00 |
| Actual Cost | 175000.00 |
| Planned % Complete | 50.00% |
| Actual % Complete | 40.00% |
| | |
| Planned Value (PV) | 150000 |
| Earned Value (EV) | 120000 |
| | |
| SV (EV-PV) | -30000 |
| CV (EV-AC) | -55000.00 |
| | |
| SPI (EV/PV) | 0.8 |
| CPI (EV/AC) | 0.69 |
Project is behind schedule and over budget.
Problem 2:
· Project has a total budget of $6,50,000.
· Total hours of project work 7500
· So far spent $4,00,000.
· Team has completed 5100 hrs of the total project work.
· However team should have completed 4500 hrs of the total project work.
· Calculate – EV, SV, CV, SPI, CPI ?
| Problem 2: | |
| BAC ($) | 650000.00 |
| Actual Cost | 400000.00 |
| Total Work | 7500.00 |
| | |
| Planned Work (Hrs) | 4500.00 |
| Planned % Complete | 60.00% |
| | |
| Actual Work (Hrs) | 5100.00 |
| Actual % Complete | 68.00% |
| | |
| Planned Value (PV)($) | 390000.00 |
| Earned Value (EV)($) | 442000.00 |
| | |
| SV (EV-PV) ($) | 52000 |
| CV (EV-AC) ($) | 434500.00 |
| | |
| SPI (EV/PV) | 1.13 |
| CPI (EV/AC) | 1.11 |
Project is early and under budget.
Problem 3:
· Project has a total budget of $55,000.
· So far spent $25,000
· Planned project duration – 4 weeks.
· At present project has finished third week and team has completed 50% of the work.
· Calculate – EV, SV, CV, SPI, CPI ?
Note: As project has finished third week of a four week project, so planned % complete is 75%.
| Problem 3: | |
| BAC ($) | 55000.00 |
| Actual Cost | 25000.00 |
| Total Duration (Wks) | 4.00 |
| | |
| Planned % Complete | 75.00% |
| Actual % Complete | 50.00% |
| | |
| Planned Value (PV)($) | 41250.00 |
| Earned Value (EV)($) | 27500.00 |
| | |
| SV (EV-PV) ($) | -13750 |
| CV (EV-AC) ($) | 2500.00 |
| | |
| SPI (EV/PV) | 0.67 |
| CPI (EV/AC) | 1.10 |
Project is behind schedule but under budget.
Problem 4: Part 1
· Project is scheduled for two years.
· You have got six different teams working on five major fucntional areas. Some teams are ahead of schedule and other are failing behind schedule.
· I.e. Some areas are running under cost and some are over cost and that's making very hard to grasp whether the project is under or over budget.
· It is nine months into the project.
· Project has a total budget of $42,00000.
· So far spent $16, 50000
· CPI is 0.875
· Calculate – EAC, EV, SV, CV, SPI, and CPI?
| Problem 4: | |
| BAC ($) | 4200000.00 |
| Actual Cost | 1650000.00 |
| CPI (EV/AC) | 0.875 |
| | |
| EAC (BAC/CPI)($) | 4800000.00 |
| ETC (EAC-AC)($) | 3150000.00 |
| | |
| VAC($) (BAC-EAC) | -600000.00 |
Since the VAC is negative, it means that project is over budget by 60k at completion.
Problem 4: Part 2
· Now six months later
· Cost spent – 2625000
· Work complete – 70%
· Calculate – New Forecase values?
| Problem 4: Part 2 | |
| BAC ($) | 4200000.00 |
| Actual Cost | 2625000.00 |
| Actual % Complete | 70.00% |
| Earned Value (EV)($) | 2940000.00 |
| | |
| CPI (EV/AC) | 1.120 |
| EAC (BAC/CPI)($) | 3750000.00 |
| ETC (EAC-AC)($) | 1125000.00 |
| | |
| VAC($) (BAC-EAC) | 450000.00 |
Since the VAC is positive, it means that project is under budget by 45k at completion.
Problem 5:
· Project is about laying fibre optic cable.
· Cost of the project is $52 per meter to lay 4 km (4000m) cable.
· Project duration: 08 weeks
· Equal amount of cable will be laid in each week (Per week 0.5 km)
· Current week – 05
· Cable laid – 1800M
· Calculate – EV, SV, CV, SPI, and CPI?
| Problem 5: | |
| BAC ($) | 208000.00 |
| Total Duration (Wks) | 8.00 |
| | |
| After 05 Weeks: | |
| Planned % Complete (2.5 KM / 4.0 KM) | 62.50% |
| Actual % Complete (1.8 KM / 4.0 KM) | 45.00% |
| | |
| Planned Value (PV)($) | 130000 |
| Earned Value (EV)($) | 93600 |
| | |
| SV (EV-PV) ($) | -36400 |
| SPI (EV/PV) | 0.72 |
So the project is behind schedule.
Thanks & Regards,
| Arun Manglick Digital Group InfoTech Pvt. Ltd. Pyramid building, Plot No.5 Rajeev Gandhi InfoTech Park, Phase I, Hinjewadi, Pune - 411057, India Office: +91 20 66532084 Fax: +91 20 66532052 Mobile: +91 9850901262 |
No comments:
Post a Comment