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.
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 $
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.
Step 1: Draw the diagram:
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,...