1. Use the following information to construct a "Tracking Gantt" chart using MS Project.
| Activities |
Duration |
Preceding |
| A |
5 days |
none |
| B |
4 days |
A |
| C |
3 days |
A |
| D |
6 days |
B, C |
| E |
4 days |
|
| F |
2 days |
D, E |
Highlight project status on day 14 using the tracking option and assuming that all tasks to date have been completed on time. Print/capture the output file.
2. Using the information in Problem 1, highlight the project's status on day 14 but assume that activity D has not yet begun. What would the new tracking Gantt chart show? Print/capture the output file.
3. Use the following table to calculate project schedule variance based on the units listed. (Figures are in thousands.)
Schedule Variance Work Units
|
|
A
|
B
|
C
|
D
|
E
|
F
|
Total
|
|
Planned Value
|
20
|
15
|
10
|
25
|
20
|
20
|
110
|
|
Earned Value
|
10
|
10
|
10
|
20
|
25
|
25
|
|
|
Schedule variance
|
|
|
|
|
|
|
|
4. Using the data in the table below, complete the table by calculating the cumulative planned and cumulative actual monthly budgets through the end of June. Complete the earned value column on the right. Assume the project is planned for a 12-month duration and $250,000 budget.
Activity Jan Feb Mar Apr May Jun Plan % C Value
Staffing 8 7 15 100_______
Blueprinting 4 6 10 100_______
Prototype
Development 2 8 10 70 _______
Full Design 3 8 10 21 67________
Construction 2 30 32 25________
Transfer 10 10 0
Monthly Plan ____________________________________________________
Cumulative _______________________________________________
Monthly Actual 10 15 6 14 9 40
Cumul. Actual____________________________________________________________
5. Using the data from Problem 4, calculate the following values:
Schedule Variances
Planned Value (PV)
Earned Value (EV)
Schedule Performance Index (SPI)
Estimated Time to Completion
Cost Variances
Actual Cost of Work Performed (AC)
Earned Value (EV)
Cost Performance Index (CPI)
Estimated Cost to Completion