Question

A project has three activities A, B, and C that must be carried out sequentially, that is, A -> -> C. The probability distributions of the times required to complete each of the activities A, B, and C are uniformly distributed in intervals (1,6), (2,3) and (3,6) respectively. Find the total project completion time and run 1000 simulation trials in Excel. The "project completion time" is a(n)... Select one: O a. Input of the simulation O b. Decision variable in the simulation O c. A fixed value in the simulation O d. Output of the simulation Which of the following Excel functions would properly generate a random number for the duration of activity A in the project described above? Select one: O a. 1+ 4 RANDO O b. 1+ 5* RANDO) O c. NORM.INV(RAND0,5,1) O d. NORM.INV(RANDO,1,5) O e. 5* RANDO

Answer 1

here we want to find project completion time based on three activities (Decision variable) .A, BQc Project completion time is an (output of the simulation option D is correct Now activity. A is uniformly distributed over [1/6] We know that If x ~ U[a, b then suco)l) X-a here d1, b = 6 Also we know that number from Ulojl) and random. variable is A RANDE) gives random A-1 6-1 = RAND() A = 1 + 5* RAND(). 1 + 5* RAND() will generate random number from uniform distribution for interval [1,6]