Instructions:Complete a Project Performance Analysis OR CV/SV Calculations. I need calculations and answers only. Thanks.

PROJECT PERFORMANCE ANALYSIS CASE STUDY 13.1 way Project per month at $500,000 per me Planned linear accomplishment of work Al work is measurable except Program Management Support, which is LOE A work in process at end of month. Autormance Reports: he Monthly Performance Data Table and Integrated Program Management Report (IPMR) for on that follow this page. he Schedule Variance Percentage (SV%) st Variance Percentage (CV%) Cost Performance Index - Efficiency (CPI) Cost Performance Index - Productivity (CPI) Schedule Performance Index (SPI) urths ahead or behind schedule Recent Complete Pervert Spent 1. Complete Performance Index (TCPI) ndependent Estimate at Completion (IEAC) stimated Completion Date (in months) (ECD) erage Performance Rate Required to achieve the ECD calculate the items listed above. Note 1: Reference the Earned Value Analysis Formulas section in Section 6 foto Note 2: Where multiple formulas are provided to calculate a data element, select who to be the most likely outcome or most accurate indicator and be prepared to SUO Item Description (DID) is placed on a contract, the IPMR formats are often used to Note 3. Even when the Integrated Program Management Data and Analysis on ect data before the IPMDAR Contract Performance Dataset (CPD) is submitted to customer. The two DIDs have similar data requirements, In addition: 1. Based on the IPMR data, what type of subcontract is used for the materials coment etc.)? Cost Plus, Time and Materials, or Firm Fixed Price? 2. Where multiple formulas are provided to calculate a data element, select what you be the most likely outcome or most accurate indicator and be prepared to support you 3. Using the IMPR for month 7 and the IPMR DID extract, be prepared to discuss the corte best, worst, and most likely estimated cost at completion. Use your analysis to so sition Month Ari Budget Budget 1 2.5 25 2 2.5 Highway IPMR Progress Months 1 Through 7 (In millions of Dollars) Current Cum to Date Earned Actuals Earned Value Budget Value Actuals 1.0 1.0 25 1.0 1.0 1.5 1.5 5.0 2.5 2.0 7.5 4.5 4.75 1.5 1.25 10.0 6.0 6.0 1.5 1.75 12.5 7.5 7.75 2.0 2.25 15.0 9.5 10.0 4.0 4.5 17.5 13.5 14.5 2.5 3 25 2.5 2.25 4 25 2.5 5 25 25 6 25 2.5 7 9 2.5 25 25 1 Budget at Completion = $30M Estimate at Completion = $30.5M Estimated Completion Date = Month 15 (3 months late) Note: Budget is based on a plan of 5 miles per month at $500,000 per mile 5 miles x $500,000 per mile = $2,500,000 (Budget) Status is based on the number of miles completed times the budget value of $500,000 per me Example: In month seven, 8 miles were completed. 8 miles x $500,000 per mile = $4,000,000 (Eamed Value) Tntegrated Program Management Report Format 1 - Work Breakdown Structure 1. Contractor Dollars in Thousands a. Name 2. Contract Wippity Bipp Construction Co. a. Name 3. Program 6. Location Address & Zip Code) CAL TRANS 20 a. Name 4. Raport period 1 Briarpatch Lane b. Number Hohway 73 Extension From YYYYIMMIDO) XX-0783 b. Phase Thumperville, CA 90633 C. Type ROTSE d. Share Ratio CPFF 6. contract Data C. LVMS Acceptace NIA No Yes b. To (YYYY/MM/DD) (2001.05.06) a. Quantity b. Negotiated Coat Month 7 c. Est. Coat of Auth. Unpriced Work d. Target Profile e. Target Price 1. Estimated Price $30,000 g. Contract Ceiling h. Estimated Contract LOGOTINO O 6. Estimated Cost at Completion $3.000 $33,000 $33,500 NA Celing NA (MYYMMDD) Management Estimate Contract Budget Base 7. Authortred Contractor Representative af Completion Variance 1. Name (Last, First, Middle initial) b. Title (0) (2) (3) Quick, I.M. Program Manager 1. Bent Case 30.000 b. Worst Case c. Signature 36.000 d. Date Signed (YYYY/MMDD) Most Likely 30.500 -500 I.M. Quick Month 3 10 Performance Data Item Current Period Cumulative To Date Reprogramming Budgeted Cost Actual Variance Budgeted Cost Variance Adjustments At Completion Actual Work Work Cost Work Work Work Scheduled Performed Performed Schedule Coat Cost Work Coat Scheduled Performed Performed Schedule Cout Schedule Budget Budgetinte variante Variance Variance (1) (2) @ 14 15) 10 (0) (10) (11) (120) 1201 (13) (10 1151 18 . WBS Program Mgmt./ Support 160 160 110 50 1,160 1160 600 0 500 1.950 1360 800 Excavation Base 650 1,000 1,225 350 -225 4,600 3.200 3,727 -1,300 -827 8.000 8.403 -403 340 Hauling 600 826 260 -226 2,100 963 1,713 1,137 -750 3,600 4,190 -890 Materials 850 1,390 1,390 540 0 6,126 0 5,325 5,325 -800 10,500 10.500 170 157 67 90 -13 592 522 572 Testing inspection -80 -70 750 -20 770 0 O O 0 0 0 b. Cost of Money 0 0 0 0 0 5,200 693 780 260 5.287 433 3,033 693 -87 2,340 2,613 -17 -173 c. Gen. & Admin. d. Undistributed Budget -500 13,500 14,800 30,000 30,500 1,500 4,000 9. Subtotal (Performance -500 17,600 -1,000 2,600 4,600 4,000 Measurement Baselino 1. Management Reserve 30,000 17,500 13,600 14,800 4,000 -1,000 2,600 4,000 1,500 D. Reconciliation To Contract Budget Base . Variance Adjustment bon contract Variance 4,600 500 P. TOTAL PROJECT PERFORMANCE ANALYSIS CASE STUDY 13.1 way Project per month at $500,000 per me Planned linear accomplishment of work Al work is measurable except Program Management Support, which is LOE A work in process at end of month. Autormance Reports: he Monthly Performance Data Table and Integrated Program Management Report (IPMR) for on that follow this page. he Schedule Variance Percentage (SV%) st Variance Percentage (CV%) Cost Performance Index - Efficiency (CPI) Cost Performance Index - Productivity (CPI) Schedule Performance Index (SPI) urths ahead or behind schedule Recent Complete Pervert Spent 1. Complete Performance Index (TCPI) ndependent Estimate at Completion (IEAC) stimated Completion Date (in months) (ECD) erage Performance Rate Required to achieve the ECD calculate the items listed above. Note 1: Reference the Earned Value Analysis Formulas section in Section 6 foto Note 2: Where multiple formulas are provided to calculate a data element, select who to be the most likely outcome or most accurate indicator and be prepared to SUO Item Description (DID) is placed on a contract, the IPMR formats are often used to Note 3. Even when the Integrated Program Management Data and Analysis on ect data before the IPMDAR Contract Performance Dataset (CPD) is submitted to customer. The two DIDs have similar data requirements, In addition: 1. Based on the IPMR data, what type of subcontract is used for the materials coment etc.)? Cost Plus, Time and Materials, or Firm Fixed Price? 2. Where multiple formulas are provided to calculate a data element, select what you be the most likely outcome or most accurate indicator and be prepared to support you 3. Using the IMPR for month 7 and the IPMR DID extract, be prepared to discuss the corte best, worst, and most likely estimated cost at completion. Use your analysis to so sition Month Ari Budget Budget 1 2.5 25 2 2.5 Highway IPMR Progress Months 1 Through 7 (In millions of Dollars) Current Cum to Date Earned Actuals Earned Value Budget Value Actuals 1.0 1.0 25 1.0 1.0 1.5 1.5 5.0 2.5 2.0 7.5 4.5 4.75 1.5 1.25 10.0 6.0 6.0 1.5 1.75 12.5 7.5 7.75 2.0 2.25 15.0 9.5 10.0 4.0 4.5 17.5 13.5 14.5 2.5 3 25 2.5 2.25 4 25 2.5 5 25 25 6 25 2.5 7 9 2.5 25 25 1 Budget at Completion = $30M Estimate at Completion = $30.5M Estimated Completion Date = Month 15 (3 months late) Note: Budget is based on a plan of 5 miles per month at $500,000 per mile 5 miles x $500,000 per mile = $2,500,000 (Budget) Status is based on the number of miles completed times the budget value of $500,000 per me Example: In month seven, 8 miles were completed. 8 miles x $500,000 per mile = $4,000,000 (Eamed Value) Tntegrated Program Management Report Format 1 - Work Breakdown Structure 1. Contractor Dollars in Thousands a. Name 2. Contract Wippity Bipp Construction Co. a. Name 3. Program 6. Location Address & Zip Code) CAL TRANS 20 a. Name 4. Raport period 1 Briarpatch Lane b. Number Hohway 73 Extension From YYYYIMMIDO) XX-0783 b. Phase Thumperville, CA 90633 C. Type ROTSE d. Share Ratio CPFF 6. contract Data C. LVMS Acceptace NIA No Yes b. To (YYYY/MM/DD) (2001.05.06) a. Quantity b. Negotiated Coat Month 7 c. Est. Coat of Auth. Unpriced Work d. Target Profile e. Target Price 1. Estimated Price $30,000 g. Contract Ceiling h. Estimated Contract LOGOTINO O 6. Estimated Cost at Completion $3.000 $33,000 $33,500 NA Celing NA (MYYMMDD) Management Estimate Contract Budget Base 7. Authortred Contractor Representative af Completion Variance 1. Name (Last, First, Middle initial) b. Title (0) (2) (3) Quick, I.M. Program Manager 1. Bent Case 30.000 b. Worst Case c. Signature 36.000 d. Date Signed (YYYY/MMDD) Most Likely 30.500 -500 I.M. Quick Month 3 10 Performance Data Item Current Period Cumulative To Date Reprogramming Budgeted Cost Actual Variance Budgeted Cost Variance Adjustments At Completion Actual Work Work Cost Work Work Work Scheduled Performed Performed Schedule Coat Cost Work Coat Scheduled Performed Performed Schedule Cout Schedule Budget Budgetinte variante Variance Variance (1) (2) @ 14 15) 10 (0) (10) (11) (120) 1201 (13) (10 1151 18 . WBS Program Mgmt./ Support 160 160 110 50 1,160 1160 600 0 500 1.950 1360 800 Excavation Base 650 1,000 1,225 350 -225 4,600 3.200 3,727 -1,300 -827 8.000 8.403 -403 340 Hauling 600 826 260 -226 2,100 963 1,713 1,137 -750 3,600 4,190 -890 Materials 850 1,390 1,390 540 0 6,126 0 5,325 5,325 -800 10,500 10.500 170 157 67 90 -13 592 522 572 Testing inspection -80 -70 750 -20 770 0 O O 0 0 0 b. Cost of Money 0 0 0 0 0 5,200 693 780 260 5.287 433 3,033 693 -87 2,340 2,613 -17 -173 c. Gen. & Admin. d. Undistributed Budget -500 13,500 14,800 30,000 30,500 1,500 4,000 9. Subtotal (Performance -500 17,600 -1,000 2,600 4,600 4,000 Measurement Baselino 1. Management Reserve 30,000 17,500 13,600 14,800 4,000 -1,000 2,600 4,000 1,500 D. Reconciliation To Contract Budget Base . Variance Adjustment bon contract Variance 4,600 500 P. TOTAL