Names

BA $353$: ICE $8$

Attach a screenshot of the first $\backslash (\backslash$sim $12\backslash )$ rows of your simulation.

The data in the table is from the second problem of ICE $6.$ Now assume that the standard deviation of each activity is $\backslash (30\backslash \%\backslash )$ of the activity time; so for A $,$ the standard deviation is $\backslash (30\backslash \%*5=1\mathrm{.}5\backslash ),$ for B $,$ the standard deviation is $\backslash (30\backslash \%*10=3\backslash ),$ etc.

Simulate this network's completion time thousands of times in Excel and then estimate the answers below. First you will have to draw the network to identify all the paths through the network or go back and look at your work from ICE $6.$

a$)$ What is the average completion time?

b$)$ What is the standard deviation?

c$)$ What percent of the time is the project completed in $21$ days or less?

d$)$ What percent of the time does the project take $28$ days or more?

e$)$ In how many days will the project be completed with $\backslash (99\backslash \%\backslash )$ certainty?

f$)$ Graph and attach a cool graph that displays the distribution of the completion times.

g$)$ According to your simulation, what percentage of the time is each path through the network the critical path? $($This might be trickier than it sounds.$)$ Your answer will be five percentages that add up to $\backslash (100\backslash \%\backslash ).$