# Spreadsheet and Critical Path

**Topics:**Spreadsheet, Project management, Microsoft Excel

**Pages:**4 (784 words)

**Published:**January 7, 2011

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

Please join StudyMode to read the full document