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.

1. 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