Spreadsheet and Critical Path

Only available on StudyMode
  • Download(s) : 86
  • Published : January 7, 2011
Open Document
Text Preview
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,...
tracking img