Spreadsheet and Critical Path

Topics: Spreadsheet, Project management, Microsoft Excel Pages: 4 (784 words) Published: January 7, 2011
Q1. Solve problem 27, page 182 of Mantel.
a.Find the expected time and variance for each task.
b.Draw the network (either AOA or AON) and the critical path and time. You may use MS Project or draw it manually. In either case, highlight or name the critical path and state the duration. c.Find the probability that the critical path will be completed in 23 weeks d.What is the probability that the other main paths will be completed in 23 weeks? e.If the paths are independent, what is the probability that the entire network will be completed in 23 weeks? SOLUTION:

(a)Expected time and Variance is calculated in the Excel file attached. (b)The AOA network is drawn below:

(c ) (d) and (e) done in the Excel Spreadsheet

Q2. Solve problem 25 on page 265 of Mantel.
a.CV
b.SV
c.SPI
d.CPI

SOLUTION:
According to the Question,
Earned Value (EV) = $272,000
Actual Costs (AC) = $270,000
Planned Value (PV) = $261,000
We know that:
Cost Variance (CV):
CV = EV – AC
Cost variance = $272,000 – $270,000 = $2,000
Schedule Variance (SV)
SV = EV – PV
Schedule variance = $272,000 – $261,000 = $11,000
Cost Performance Index (CPI)
CPI = EV / AC
CPI = 272,000/270,000 = 1.01
Schedule Performance Index (SPI)
SPI = EV / PV
SPI = 272,000/261,000 = 1.04
Q4. (Solver) Given the network below:
a.Draw and submit the AOA network
b.What is the critical path?
c.Using Excel Solver, determine the minimum duration. The new price is:

TaskPredNorm tNorm $Crash t Crash $
A-3502150
BA41002150
CA52003300
DB62504350
EC74004600
FD, E33002450

Suggestion: You may want to go back to Answer 2 of IA-3 and use the excel setup in that file adjusted, of course, for this network.

SOLUTION:
Step 1: Draw the diagram:

D
AB
F

C
E

Step 2: Set up the CPM Spreadsheet

Here, we have 6 activities[ A to F]
In blank spreadsheet,
Type “Activities” in A1
Type Activities letters (i.e. A to F)
In cell A3,...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Critical Path Essay
  • Critical Path Essay
  • Critical Path Essay
  • Crash task Critical Path Essay
  • Critical Path Method and Pert Essay
  • Critical Path Method Essay
  • Essay about Critical Path analysis
  • Essay on Opm 300 Critical Path of Rockfest

Become a StudyMode Member

Sign Up - It's Free