# PMT 5.2 The Managerial Process

Use the Week 5 Exercises Template attached here to complete this assignment.

Click on each of the tabs in the template to view and complete each of the exercises

Thanks

## Ch 13 Ex 1

 PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES CH. 13 EXERCISE 1 In month 9 the following project information is available: actual cost is \$2,000, earned value is \$2,100, and planned cost is \$2,400. Compute the SV and CV for the project. NOTE: SV = EV – PV; CV = EV – AC Actual Cost (AC) (given) (Enter value) Earned Value (EV) (given) (Enter value) Planned Value (PV) (given) (Enter value) Schedule Variance (SV) (Type Excel formula to calculate result) Cost Variance (CV) (Type Excel formula to calculate result)

## Ch 13 Ex 2

 PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES CH. 13 EXERCISE 2 On day 51 a project has an earned value of \$600, an actual cost of \$650, and a planned cost of \$560. Compute the SV, CV, and CPI for the project. NOTE: CPI = EV / AC Actual Cost (AC) (given) (Enter value) Earned Value (EV) (given) (Enter value) Planned Value (PV) (given) (Enter value) Schedule Variance (SV) (Type Excel formula to calculate result) Cost Variance (CV) (Type Excel formula to calculate result) Cost Performance Index (CPI) (Type Excel formula to calculate result) What is your assessment of the project on day 51? (Enter response)

## Ch 13 Ex 3

 PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES CH. 13 EXERCISE 3 Given the following project network and baseline information, complete the form to develop a status report for the project at the end of period 4 and the end of period 8. NOTE: EV = Actual % Complete * total PV budget for that task. Do not use time-phased PV in this formula. Status Report: Ending Period 4 Task Actual % Complete EV AC PV CV SV A 100% 400 300 400 100 0 B 50% 1200 1000 800 200 400 C 33% 495 500 600 -5 -105 D 0% 0 0 0 0 0 E 0% 0 0 0 0 0 F 0% 0 Cumulative Totals 2095 1800 1800 295 295 The first one has been done as an example. At the end of period 4, the project is \$300 under budget and \$300 ahead of schedule. Status Report: Ending Period 8 Task Actual % Complete EV AC PV CV SV A 100% 300 400 B 100% 2200 2400 C 100% 1500 1500 D 25% 300 0 E 33% 300 F 0% 0 Cumulative Totals 0 4600 4300 0 0 From the data you have collected and computed for periods 4 and 8, what information are you prepared to tell the customer about the status of the project at the end of period 8? (Enter response)

## Ch 13 Ex 4

 PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES CH. 13 EXERCISE 4 Given the following project network, baseline, and status information, develop status reports for periods 2, 4, 6, 8 and complete the performance indexes table. Calculate the EACf and the VACf. NOTE: Scheduling Performance Index SPI = EV / PV; Percent Complete Index Budgeted Costs PCIB = EV / BAC; Budgeted Cost at Completion BAC = total PV for whole project; Estimated Cost at Completion EACf = ((BAC – cumulative total EV)/(cumulative total EV/cumulative total AC)) + cumulative total AC; Cost Variance at Completion VACf = BAC – EACf. Status Report: Ending Period 2 Task Actual % Complete EV AC PV CV SV A 75% 25 B 50% 12 C 0% 0 D 0% 0 E 0% 0 F 0% 0 Cumulative Totals 0 37 0 0 0 Status Report: Ending Period 4 Task Actual % Complete EV AC PV CV SV A 100% 35 B 100% 24 C 0% 0 D 0% 0 E 0% 0 F 0% 0 Cumulative Totals 0 59 0 0 0 Status Report: Ending Period 6 Task Actual % Complete EV AC PV CV SV A 100% 35 B 100% 24 C 75% 24 D 0% 0 E 50% 10 F 0% 0 Cumulative Totals 0 93 0 0 0 Status Report: Ending Period 8 Task Actual % Complete EV AC PV CV SV A 100% 35 B 100% 24 C 100% 32 D 33% 20 E 100% 20 F 0% 0 Cumulative Totals 0 131 0 0 0 Performance Indexes Summary Period EV AC PV SPI CPI PCIB 2 4 6 8 Estimate at Completion (forecasted) (EACf) (Type Excel formula to calculate result) Cost Variance at Completion (forecasted) (VACf) (Type Excel formula to calculate result) Based on your data, what is your assessment of the current status of the project? At completion? (Enter response)

## Ch 13 Ex 5

 PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES CH. 13 EXERCISE 5 Given the following project network, baseline, and status information, develop status reports for periods 1–4 and complete the project summary graph. Report the final SV, CV, CPI, and PCIB at the end of period 4. Status Report: Ending Period 1 Task Actual % Complete EV AC PV CV SV 1 50% 6 4 2 40% 8 3 3 25% 3 4 0% 0 5 0% 0 6 0% 0 7 0% 0 Cumulative Totals 0 17 7 0 0 Status Report: Ending Period 2 Task Actual % Complete EV AC PV CV SV 1 100% 13 2 80% 14 3 75% 8 4 0% 0 5 0% 0 6 0% 0 7 0% 0 Cumulative Totals 0 35 0 0 0 Status Report: Ending Period 3 Task Actual % Complete EV AC PV CV SV 1 100% 12 13 2 80% 15 3 100% 10 4 50% 4 5 0% 0 6 33% 4 7 0% Cumulative Totals 12 46 0 0 0 Status Report: Ending Period 4 Task Actual % Complete EV AC PV CV SV 1 100% 12 13 2 100% 15 18 3 100% 10 4 100% 8 5 30% 3 6 67% 8 7 0% 0 Cumulative Totals 27 60 0 0 0 NOTE: Insert data in table below and the graph will automatically update. Use cumulative total amounts from each time period status report. Performance Indexes Summary Period EV AC PV 1 2 3 4 End of Period 4 Schedule Variance (SV) (Enter value) End of Period 4 Cost Variance (CV) (Enter value) End of Period 4 Cost Performance Index (CPI) (Type Excel formula to calculate result) End of Period 4 Percent Complete Index Budgeted Costs (PCIB) (Type Excel formula to calculate result) Based on your data, what is your assessment of the current status of the project? (Enter response)

Summary Graph

EV 1 2 3 4 AC 1 2 3 4 PV 1 2 3 4

Time Period

Thousands of Dollars

## Ch 13 Ex 6

 PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES CH. 13 EXERCISE 6 The following labor hours data have been collected for a nanotechnology project for periods 1 through 6. Compute the SV, CV, SPI, and CPI for each period. Plot the EV and the AC on the summary graph provided. Plot the SPI, CPI, and PCIB on the index graph provided. Status Report: Ending Period 1 Task Actual % Complete EV AC PV CV SV 1 50% 5 10 2 0% 0 3 0% 0 4 0% 0 5 0% 0 6 0% 0 7 0% 0 Cumulative Totals 0 5 10 0 0 Status Report: Ending Period 2 Task Actual % Complete EV AC PV CV SV 1 100% 15 20 2 0% 0 3 0% 0 4 0% 0 5 0% 0 6 0% 0 7 0% 0 Cumulative Totals 0 15 20 0 0 Status Report: Ending Period 3 Task Actual % Complete EV AC PV CV SV 1 100% 20 15 20 2 0% 0 3 10% 2 4 20% 5 5 0% 0 6 0% 0 7 0% 0 Cumulative Totals 20 22 20 0 0 Status Report: Ending Period 4 Task Actual % Complete EV AC PV CV SV 1 100% 20 15 20 2 50% 10 3 30% 8 4 40% 15 5 0% 0 6 0% 0 7 0% 0 Cumulative Totals 20 48 20 0 0 Status Report: Ending Period 5 Task Actual % Complete EV AC PV CV SV 1 100% 20 15 20 2 100% 20 3 50% 8 4 60% 15 5 25% 4 6 0% 0 7 0% 0 Cumulative Totals 20 62 20 0 0 Status Report: Ending Period 6 Task Actual % Complete EV AC PV CV SV 1 100% 20 15 20 2 100% 20 3 80% 21 4 80% 18 5 50% 6 6 0% 0 7 0% 0 Cumulative Totals 20 80 20 0 0 NOTE: Insert data in table below and the graphs will automatically update. Use cumulative total amounts from each time period status report. Performance Indexes Summary Period EV AC PV SPI CPI PCIB 1 2 3 4 5 6 What is your assessment of the project at the end of period 6? (Enter response)

Summary Graph

EV 1 2 3 4 5 6 AC 1 2 3 4 5 6 PV 1 2 3 4 5 6

Time Period

Hundreds of Labor Hours

Index Graph

SPI 1 2 3 4 5 6 CPI 1 2 3 4 5 6 PCIB 1 2 3 4 5 6

Time Period

Index

## Ch 13 Ex 7

 PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES CH. 13 EXERCISE 7 The following data have been collected for a British healthcare IT project for two-week reporting periods 2 through 12. Compute the SV, CV, SPI, and CPI for each period. Plot the EV and the AC on the summary graph provided. Plot the SPI, CPI, and PCIB on the index graph provided. Status Report: Ending Period 2 Task Actual % Complete EV AC PV CV SV 1 50% 4 2 0% 0 3 0% 0 4 0% 0 5 0% 0 6 0% 0 7 0% 0 8 0% 0 Cumulative Totals 0 4 0 0 0 Status Report: Ending Period 4 Task Actual % Complete EV AC PV CV SV 1 100% 10 2 0% 0 3 0% 0 4 0% 0 5 0% 0 6 0% 0 7 0% 0 8 0% 0 Cumulative Totals 0 10 0 0 0 Status Report: Ending Period 6 Task Actual % Complete EV AC PV CV SV 1 100% 10 2 25% 15 3 33% 12 4 0% 0 5 0% 0 6 0% 0 7 0% 0 8 0% 0 Cumulative Totals 0 37 0 0 0 Status Report: Ending Period 8 Task Actual % Complete EV AC PV CV SV 1 100% 10 2 30% 20 3 60% 25 4 0% 0 5 0% 0 6 0% 0 7 0% 0 8 0% 0 Cumulative Totals 0 55 0 0 0 Status Report: Ending Period 10 Task Actual % Complete EV AC PV CV SV 1 100% 10 2 60% 30 3 100% 40 4 50% 20 5 0% 0 6 30% 24 7 0% 0 8 0% 0 Cumulative Totals 0 124 0 0 0 Status Report: Ending Period 12 Task Actual % Complete EV AC PV CV SV 1 100% 10 2 100% 50 3 100% 40 4 100% 40 5 50% 30 6 50% 40 7 0% 0 8 0% 0 Cumulative Totals 0 210 0 0 0 NOTE: Insert data in table below and the graphs will automatically update. Use cumulative total amounts from each time period status report. Performance Indexes Summary Period EV AC PV SPI CPI PCIB 2 4 6 8 10 12 What is your assessment of the project at the end of period 12? (Enter response)

Summary Graph

EV 2 4 6 8 10 12 AC 2 4 6 8 10 12 PV 2 4 6 8 10 12

Time Period

Hundreds of Dollars

Index Graph

SPI 2 4 6 8 10 12 CPI 2 4 6 8 10 12 PCIB 2 4 6 8 10 12

Time Period

Index