project management excel part 1

3. A small project is composed of seven activities whose time estimates are listed in the following table: Beginning Node 1 Ending Node 2 Estimated Duration (weeks) Optimistic Most Likely Pessimistic 1 1 7 1 4 7 1 3 1 4 2 7 9 2 5 1 1 1 3 5 2 2 14 4 6 2 6 10 5 6 3 3 15 a. Using the classic PERT model, what is the probability that the project will be completed two weeks earlier than its expected duration? b. Based on the classic PERT model, what due date has a 90 percent chance (or greater) of being met? 4. A project is budgeted to cost a cumulative $500 each week for five weeks scheduled (week 1 costing $500, week 2 costing $1,000, ... week 5 costing $2,500). The actual cumulative cost of the work performed is $600 each week. At week 1, 25% of the project is completed; at week 2, 45%; at week 3, 75%; at week 4, 95%; and at week 5, 100%. For each week, calculate the earned value, schedule variance, cost variance, schedule index, and cost index