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

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?
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...
please no plagiarism and must be in your own 500 words Tasks Given the fact, that...
please no plagiarism and must be in your own 500 words Tasks Given the fact, that many companies require remote workers to remain in business, research and discuss at least two the issues of securing backups. The following questions must be addressed in your answer: How are companies preparing for Remote Incident Response? How should backup media be secured/ Is the off-site storage of backups necessary in a remote culture? why or why not?
Use Word to create a task list with a minimum of 25 tasks for the project...
Use Word to create a task list with a minimum of 25 tasks for the project plan. The tasks should be in the format of verb then noun. Deliverable headings should be nouns. The list should be a complete plan to build a local area network in an office.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT