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
Ch 13 Ex 8
PMT472 5.2 ASSIGNMENT: WEEK 5 EXERCISES
CH. 13 EXERCISE 8
Part A.* You are in charge of the Aurora project. Given the following project network, baseline, and status information, develop status reports for periods 1–8 and complete the performance indexes table. Calculate the EACf and VACf.
Status Report: Ending Period 1
Task
Actual % Complete
EV
AC
PV
CV
SV
A
25%
50
B
0%
0
C
0%
0
D
0%
0
E
0%
0
F
0%
0
G
0%
0
H
0%
0
Cumulative Totals
0
50
0
0
0
Status Report: Ending Period 2
Task
Actual % Complete
EV
AC
PV
CV
SV
A
50%
100
B
0%
0
C
0%
0
D
0%
0
E
0%
0
F
0%
0
G
0%
0
H
0%
0
Cumulative Totals
0
100
0
0
0
Status Report: Ending Period 3
Task
Actual % Complete
EV
AC
PV
CV
SV
A
100%
200
B
0%
0
C
0%
0
D
0%
0
E
0%
0
F
0%
0
G
0%
0
H
0%
0
Cumulative Totals
0
200
0
0
0
Status Report: Ending Period 4
Task
Actual % Complete
EV
AC
PV
CV
SV
A
100%
200
B
60%
100
C
50%
200
D
0%
0
E
0%
0
F
0%
0
G
0%
0
H
0%
0
Cumulative Totals
0
500
0
0
0
Status Report: Ending Period 5
Task
Actual % Complete
EV
AC
PV
CV
SV
A
100%
200
B
100%
200
C
100%
400
D
0%
0
E
0%
0
F
0%
0
G
0%
0
H
0%
0
Cumulative Totals
0
800
0
0
0
Status Report: Ending Period 6
Task
Actual % Complete
EV
AC
PV
CV
SV
A
100%
200
B
100%
200
C
100%
400
D
75%
100
E
0%
0
F
0%
0
G
0%
0
H
0%
0
Cumulative Totals
0
900
0
0
0
Status Report: Ending Period 7
Task
Actual % Complete
EV
AC
PV
CV
SV
A
100%
200
B
100%
200
C
100%
400
D
100%
150
E
20%
100
F
5%
50
G
0%
0
H
0%
0
Cumulative Totals
0
1100
0
0
0
Status Report: Ending Period 8
Task
Actual % Complete
EV
AC
PV
CV
SV
A
100%
200
B
100%
200
C
100%
400
D
100%
150
E
100%
350
F
10%
100
G
0%
0
H
0%
0
Cumulative Totals
0
1400
0
0
0
Performance Indexes Summary
Period
EV
AC
PV
SPI
CPI
PCIB
1
2
3
4
5
6
7
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 the current status of the project? At completion?
(Enter response)
Part B. You have met with your Aurora project team and they have provided you with the following revised estimates for the remainder of the project:
Activity F will be completed at the end of period 12 at a total cost of $500.
Activity G will be completed at the end of period 10 at a total cost of $150.
Activity H will be completed at the end of period 14 at a total cost of $200.
Calculate the EACre and VACre.
NOTE: EACre = AC + ETCre; ETCre = revised estimated cost to complete remaining work; VACre = BAC – EACre; Also note that Activity F already has $100 AC incurred on it as part of the total $500.
Cumulative Total Actual Cost at end of time period 8 (AC) (given)
(Enter value)
Estimate to Complete remaining work (revised) (ETCre)
(Type Excel formula to calculate result)
Budget at Completion (BAC) (given)
(Enter value)
Estimate at Completion (revised) (EACre)
(Type Excel formula to calculate result)
Cost Variance at Completion (revised) (VACre)
(Type Excel formula to calculate result)
Based on the revised estimates, what is the expected status of the project in terms of cost and schedule?
(Enter response)
Between the VACf and the VACre, which one would you have the greatest confidence in?
(Enter response)
image1
image2
image3
image4
image5
image6
image7
image8
image9
image10
image11
image12
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
