PMAN 650 Session 5 Individual Assignment (v3) Earned Value Management Introduction All of you have had at least an introduction to earned value management in the project management fundamentals course. Many of you may have had the opportunity to use earned value management in your professional careers. In practice, most EVM analysis results are generated by scheduling software or other applications. As a project manager, you must have a good handle on the concepts and be able to verify the accuracy of EVM analysis results. In this assignment, you will have an opportunity to brush up and expand upon your EVM knowledge and skills by applying EVM concepts to a practical problem. THIS ASSIGNMENT REQUIRES A MANUAL ANALYSIS - DO NOT USE MICROSOFT PROJECT. Problem Background Your project consists of seven activities shown in the table below, along with: (1) planned start and finish dates; (2) activity budgets; and (3) earned value (EV) accrual rules from you project cost management plan. Activity Planned Start 1 2 3 4 5 6 7 6-Jun-16 11-Jul-16 20-Jun-16 25-Jul-16 19-Sep-16 17-Oct-16 7-Nov-16 Planned Finish 8-Jul-16 5-Aug-16 12-Aug-16 16-Sep-16 14-Oct-16 4-Nov-16 18-Nov-16 Budget 25,000 20,000 50,000 60,000 30,000 20,000 10,000 EV Accrual Rule Percent Complete with Gates Fixed Formula - 0/100 Weighted Milestones Percent Complete with Gates Fixed Formula - 40/60 Fixed Formula -30/70 Fixed Formula - 100/0 Assumptions 1. Assume a five-day work week including holidays occurring during the work week. 2. For all activities (except activities 3 and 4), assume the expenditure rate is constant over the duration of the activity, i.e., the amount planned to be spent each week is the same. 3. For activity 3, the planned expenditure profile is shown below: PMAN 650 Session 5 Individual Assignment (v3) Earned Value Management Activity 3 Weekly Planned Expenditures 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 1 2 3 4 5 6 7 8 4. For activity 4, the planned expenditure profile is shown below: Activity 4 Weekly Planned Expenditures 12000 10000 8000 6000 4000 2000 0 1 2 3 4 5 6 7 8 The project sponsor wants you (the PM) to present a project cost and schedule performance assessment using data through Friday, July 29, 2016. You have collected the following information: Activity 1 2 3 4 5 6 7 Actual Start 6/6/2016 7/11/2016 6/20/2016 7/25/2016 Actual Finish Expended 7/8/2016 22,000 7/29/2016 25,000 40,000 8,000 0 0 0 PMAN 650 Session 5 Individual Assignment (v3) Earned Value Management For activity 1, three equally-valued gates have been established and all gates are complete as of July 29, 2016. For activity 3, five milestones have been established with the following values: (1) milestone 1 – 10%; milestone - 20%; milestone 3 – 15%; milestone 4 -20%; milestone 5 – 35%. Four of the milestones are complete as of July 29, 2016. For activity 4, four equally values gates have been established. As of July 29, 2016 none of the gates have been reached but the activity owner estimates 30% of the work required to reach the first gate has been accomplished. Show all work. Round dollar values to the nearest dollar. Calculate all other variables to three decimal places. 1. Earned Value Measures a. Calculate earned value measures for each activity and for the cumulative project as of July 29, 2016; fill in the table below: Activity Planned Value (PV) Earned Value (EV) Actual Cost (AC) Activity One 22,000 Activity Two 25,000 Activity Three 40,000 Activity Four 8,000 Activity Five 0 Activity Six 0 Activity Seven 0 Entire Project 2. Earned Value Performance Measures a. Calculate earned value performance parameters for each activity and for the cumulative project as of July 29, 2016; fill in the table below: PMAN 650 Session 5 Individual Assignment (v3) Earned Value Management Activity Schedule Variance (SV) Schedule Performance Index (SPI) Cost Variance (CV) Cost Performance Index (CPI) Activity One Activity Two Activity Three Activity Four Activity Five Activity Six Activity Seven Entire Project b. Is the project ahead of schedule, on schedule, or behind schedule? What EVM information are you using to make this assessment and why? c. Is the project over budget, under budget, or on budget? What EVM information are you using to make this assessment and why? 3. Earned Value Forecasts a. What is the value of the “Cumulative CPI” Estimate-at-Completion (EAC)? b. Using the “Mathematical” or “Overrun to Date” Estimate-at Completion, what is the value of the Estimate-to-Complete (ETC)? c. Using the “Cumulative CPI times SPI” Estimate-At-Completion, how much more or less money (other than the current budgeted amount) will you need to finish the project? d. How much would the Cost Performance Index (CPI) have to change in order to complete the project within the original budget?