Question

In: Accounting

Build an Earned Value Management (EVM) model using these variables: Planned Value: $45,000 i.Note for understanding,...

Build an Earned Value Management (EVM) model using these variables:

Planned Value: $45,000

i.Note for understanding, this based on time, and what we expected to use based on time.  Your schedule variance is based on earned and planned.

Actual Cost: $39,500

Earned Value (how much has been spent based on planned costs) : $43,500

i.Note for understanding, this usually based on expected costs at the task level.  In other words, for the tasks complete the project was expected to use this much costs. Your cost variance is based on actual and earned.

Balance at Completion: $172,000

Original Time in Months: 14

Calculate in the model:

Cost Variance

Schedule Variance

Cost Performance Index

Schedule Performance Index

Estimate at Completion

Estimated Time

Use conditional formatting to render any “bad” values red, “good” values green and “0” values yellow.  Do cell by Cell.

Analyze the data and denote your evaluation of the project.  Include in the evaluation comments on schedule, costs, and performance

Solutions

Expert Solution

Amount in USD ($)
Planned Value? (PV) 45000
Earned Value? (EV) 43500
Actual Cost? (AC) 39500
Budget at Completion (BAC) 172000
1. Cost Variance (CV) = EV - AC = 43500-39500 4000 As Cost Variance is positive, this means we are under budget.
2. Schedule Variance (SV) = EV - PV = 43500 - 45000 (1500) As Schedule Variance is negative, this means we are behind schedule.   
3. Cost Performance Index(CPI) = EV/AC = 43500/39500 1.10 AS the CPI is greater than one, we are earning more than the amount spent. In other words, we are under budget.
4. Schedule Performance Index (SPI) = EV/PV = 43500/45000 0.97 As the SPI is less than one, this means less work has been completed than the planned work. In other words, we are behind schedule.
5. Estimate at Completion = BAC/CPI = 172000/1.10 156183.91 if the project continues to progress with CPI = 1.10 until the end, we will have to spend 156183.91 USD to complete the project.

Related Solutions

Earned Value Management (EVM) is a project management technique for measuring project performance (schedule, cost mainly)...
Earned Value Management (EVM) is a project management technique for measuring project performance (schedule, cost mainly) and progress in an objective manner in terms of work achieved (Value): The data identified below was listed in a project’s status report. At time of status report: Planned Value of work (PV) = $70,000 Earned Value of work performed (EV) = $50,000 Actual Cost of work performed (AC) = $75,000 Original Planning: Budgeted cost At Completion (BAC) = $110,000 Original length of the...
Earned Value Management (EVM) is a project management technique for measuring project performance (schedule, cost mainly)...
Earned Value Management (EVM) is a project management technique for measuring project performance (schedule, cost mainly) and progress in an objective manner in terms of work achieved (Value): The data identified below was listed in a project’s status report. At time of status report: Planned Value of work (PV) = $70,000 Earned Value of work performed (EV) = $50,000 Actual Cost of work performed (AC) = $75,000 Original Planning: Budgeted cost At Completion (BAC) = $110,000 Original length of the...
Earned Value Management (EVM) is a project management technique for measuring project performance (schedule, cost mainly)...
Earned Value Management (EVM) is a project management technique for measuring project performance (schedule, cost mainly) and progress in an objective manner in terms of work achieved (Value): The data identified below was listed in a project’s status report. At time of status report: Planned Value of work (PV) = $70,000 Earned Value of work performed (EV) = $50,000 Actual Cost of work performed (AC) = $75,000 Original Planning: Budgeted cost At Completion (BAC) = $110,000 Original length of the...
Actual Cost, planned value and earned value of the activities of an ongoing project after 5...
Actual Cost, planned value and earned value of the activities of an ongoing project after 5 months and after 8 months are given below. All values and costs are in Rs lakhs. Comment on status of the a) Activities (Activity delayed/early, activity cost overrun/underrun) b) status of project and estimated total cost at completion at 5 months and at 8 months. After 5 months    Activity. EV PV AC Comment    A 10 10 8    B 18 15 12...
Compare and Contrast Earned Value Management with Financial Management Responsibilities
Compare and Contrast Earned Value Management with Financial Management Responsibilities
what are the disadvantages in using Earned Value and a PMIS?
what are the disadvantages in using Earned Value and a PMIS?
Build a conceptional model for a Hotel Management System. The solution should be presented as an...
Build a conceptional model for a Hotel Management System. The solution should be presented as an ER-diagram. Base your design on the following requirements. • The database should record information about Customer, Hotel, Booking, Rooms, Employee, Feedback, and Payments. • A Customer has a name which consists of firstName, middleName and lastName. Customers are identified by a unique customerID. A Customer has an Address, phoneNo and email address – Customers can place any number of Bookings (including none). Customer may...
How does project scope, project budget and earned value management conpare and contrast?
How does project scope, project budget and earned value management conpare and contrast?
A: Provide a numerical example of how Earned Value Management may mislead us as to whether...
A: Provide a numerical example of how Earned Value Management may mislead us as to whether the project in on time and on budget.  Use the Critical Chain concepts if you want to help illustrate your answer. B: What must management do to implement Critical Chain and how do they do it.  How must management focus change for Critical Chain to be successful compared to traditional project management?
I need to build a simple model of a coffee shop using Arena simulation
I need to build a simple model of a coffee shop using Arena simulation
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT