Question

In: Statistics and Probability

Assume that for this project to be completed, five independent tasks must be completed. These tasks...

Assume that for this project to be completed, five independent tasks must be completed. These tasks are proceeding in parallel by five different subcontractors. To keep it simple, let's assume that each task takes between 1 and 5 months to complete (uniformly distributed, i.e. equally likely to take any amount of time between 1 and 5 months). So, the mean time to complete each task is 3 months and the probability of any given task taking 3 months or longer is 0.5. However, the project is NOT considered complete until ALL five tasks are complete. Conduct a Monte-Carlo Simulation with 100 experiments to answer the following questions:

Q1: What is the probability that the project finishes in 3 months or less?

Q2: What is the expected project completion time?

Q3: Develop a table (using Frequency function) and a graph (histogram) of distribution of project completion times.

Combine all your answers and explanations in one Excel file for submission. Submit your file here at Moodle. No hard copy/printed submissions required.

Solutions

Expert Solution


Related Solutions

A project has just completed its 87th task of a total of 150 tasks in its...
A project has just completed its 87th task of a total of 150 tasks in its project plan. The project has a total budget of $1,500,000. It was scheduled to have spent $500,000 at this point in the plan, but has actually spent only $400,000. The project manager estimates that the value of the work actually finished is $300,000. What are the spending and schedule variances for the project? What are the SPI and CPI? What is the EAC, assuming...
Q3-Compartmentalization. The project must be compartmentalized into a number of manageable activities and tasks. Why?
Q3-Compartmentalization. The project must be compartmentalized into a number of manageable activities and tasks. Why?
Below is a list of jobs that must be accomplished to complete the new project. Assume...
Below is a list of jobs that must be accomplished to complete the new project. Assume the company wants to complete the project as early as possible, a) what is the added project cost? You need not to show the network diagram.      Activity Immediate Predecessor Normal Time (Days) Crash Time (Days) Normal Cost Crash Cost A None 8 7 $45 $50 B A 3 1 $60 $65 C A 11 9 $110 $150 D A 6 5 $50 $90...
In one sentence each, describe the five basic management tasks.
In one sentence each, describe the five basic management tasks.
One of the tasks that needed to be completed after activity sequencing, is allotting duration times...
One of the tasks that needed to be completed after activity sequencing, is allotting duration times for each activity. Name and discuss three options for calculating activity duration.
Briefly discuss the four main tasks in project management:project planning, project scheduling, project monitoring and...
Briefly discuss the four main tasks in project management: project planning, project scheduling, project monitoring and controlling, and project reporting. Also, discuss what role does stakeholders play in project Management?
A project has five activities: A, B, C, and D, which must be carried out sequentially....
A project has five activities: A, B, C, and D, which must be carried out sequentially. The probability distributions of the number of weeks required to complete each of the activities A, B, and C are uniform in intervals [1,5], [2,3], and [3,6], respectively. The number of weeks required to complete activity D is a beta distribution with shape parameters a=2 and b=5, lower bound 2, and upper bound 10. Use simulation to forecast the total completion time of the...
Explain the five key tasks of a manager according to Fayol ORGANISATIONAL BEHAVIOUR
Explain the five key tasks of a manager according to Fayol ORGANISATIONAL BEHAVIOUR
Make a list of three tasks using health information systems that would need to be completed...
Make a list of three tasks using health information systems that would need to be completed by a healthcare manager on a daily basis. How would you prioritize them? what is the Reference for this informations?
A project consists of two tasks. Task A is scheduled to begin at the start of...
A project consists of two tasks. Task A is scheduled to begin at the start of Week 1 and finish at the end of Week 4. Task B is scheduled to begin at the start of Week 2 and finish at the end of Week 3. The budgeted cost for Task A is $80,000, and for Task B is $40,000. 1. Creat a cost loaded for this project: Round the number to the closest integer number and input it without...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT