Earned Value Calculation; Schedule Variance; Cost variance
Not what you're looking for?
See attached document for charts and graphs.
5-1 Earned Value Calculation
You are 4 months into a 6 month project. The project is linear, which means that the progress and spending occurs at a constant rate. Our crack project team of highly skilled associates has worked diligently and put in extra hours to keep the project going. Our accounting department has provided the following data at the end of month 4:
Actual cost to date = $88,800
Planned expenditures to date = $101,000
The CFO is excited and has sent you an email congratulating you for being 12.07% under budget. However, is it really time to hold a team celebration? That would be fun but your project manager mentality kicks in. Those numbers look good but how are we 'really' doing? To understand the true project performance, we need to apply earned value techniques.
The missing piece we need is Earned Value (i.e. what we have actually accomplished so far). You meet with your team and find that only 6 of the 7 tasks scheduled to be complete by the end of month 4 have actually been completed. Task 7 isn't even started! This information gives you the final data you need to apply 'Earned Value' and develop an objective analysis.
1. What are the PV, EV, and AC for the project at the end of month 4?
2. What are the SV, CV, SPI, and CPI for the project?
3. Assess the project performance to date? Do you get to have the celebration?
5-2 Earned Value Calculation
Project Schedule and Budget Data Provided:
Task Duration (days) Predecessor(s) Budget
A 2 --- $1,600
B 5 --- $4,000
C 3 A $14,050
D 4 B $5,800
E 6 B $12,000
F 4 C,D $5,200
G 3 E $3,900
Project Totals: $46,550
Status of the project at the end of day 6:
Task % Complete Actual Cost of Work Performed
A 100% $1,800
B 100% $4,500
C 90% $13,500
D 10% $500
E 0% $0
F 0% $0
G 0% $0
 
Project Network Diagram
Critical Path (CP) = B - E - G = 14 days
Tasks Duration (Days)
A A A
B B B B B B
C C C C
D D D D D
E E E E E E E
F F F F F
G G G G
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
 
1. Calculate the schedule variance for each task and the total project.
2. Calculate the cost variance for each task and the total project.
3. What is your assessment of the project at this time?
Purchase this Solution
Solution Summary
This solution calculates the PV, EV and AC for the project at the end of month four, the SV, CV, SPI and CPI for the project and assesses the projects performance to date. Please see the attached Excel file.
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.