PMT 5.2 The Managerial Process
Are you pressed for time and haven’t started working on your assignment yet? Would you like to buy an assignment? Use our custom writing services for better grades. Even if your deadline is approaching fast, our writers can handle your task right when you need it. Our writers will complete your order from scratch and make sure it’s completely unique.
Order a Similar Paper Order a Different Paper
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.png
image2.png
image3.png
image4.png
image5.png
image6.png
image7.png
image8.png
image9.png
image10.png
image11.png
image12.png
Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.
Order a Similar Paper
Order a Different Paper
Do you need help with this or a different assignment? Even when your task is complicated and the deadline is in less than 2 days, you still have every chance to get a good grade for it. How? By completing the order form, you will get the finest custom-written assignment at an affordable price. We also deliver a number of services for free (e.g., revisions, editing, checking the text for authenticity). Use our paper writing service to receive effective help with your homework.
Order a Similar Paper Order a Different Paper