Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A B D E F G H M N. O P You would like to determine the expected duration and variance for the project's seven

image text in transcribed

A B D E F G H M N. O P You would like to determine the expected duration and variance for the project's seven activities named A to G. Table 4 has the weights assigned to optimistic, most likely, and pessimistic situations. The expected duration for an activity is the weighted average of the weights and the duration for the activities in each of the situations. As an example, expected duration for Activity A=Weight of Optimistic * Optimistic duration + Weight of Most Likely * Most Likely duration + Weight of Pessimistic * Pessimistic duration. (e) Using the Sumproduct function, write a formula in cell H25 to compute the Expected duration for Activity A. Copy the formula to cells H26 to H31. The variance of activity is computed using formula ((p - 0)/6)^2, where p is the pessimistic duration and o is the optimistic duration. The value 6 is the sum of the weights. 16 (f) Write a formula in cell 125 to compute the activity A variance. Copy the formula to cells 126 to 131. 17 18 Table 4: Weights Optimistic Most likely Pessimistic 19 (0) (m) (p) 20 1 4 1 21 Sample Answer 22 Table 5: Expected duration and variance for seven activities 23 Preceding Most likely Pessimistic Expected Table 5: Expected duration and variance for seven activities Activity Optimistic (o) Variance o? 24 Activities (p) t (days) Activity Preceding Most likely Pessimistic Expected Optimistic (0) Activities (p) 25 6 (m) A 7 8 t(days) A 6 7 8 7.00 26 B 6 9 14 B 6 9 14 9.33 27 A 7 9 11 C 7 9 11 9.00 28 D A 5 10 12 D 5 10 12 9.50 29 E C,B 7 10 12 E C,B 7 10 12 9.83 30 F D 8 8 11 D 8 8 11 8.50 31 G E,F 5 8 10 E,F 5 8 10 7.83 32 (m) Variance o? 0.111111 1.777778 0.444444 1.361111 0.694444 0.250000 0.694444 F G

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Corporate Finance Law

Authors: Eilis Ferran, Look Chan Ho

2nd Edition

0199671354, 978-0199671359

More Books

Students also viewed these Finance questions