Question
1. Use the following information to construct a Tracking Gantt chart using MS Project. Activities Duration Preceding Activities A 5 days none B 4 days
1. Use the following information to construct a Tracking Gantt chart using MS Project.
Activities Duration Preceding Activities
A 5 days none
B 4 days A
C 3 days A
D 6 days B, C
E 4 days B
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 projects 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.
- 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started