Question: Use the excel template provided to answer this question. A project manager has a project with three unique paths. The deterministic time estimate has the

Use the excel template provided to answer this question. A project manager has a project with three unique paths. The deterministic time estimate has the critical path at

55

days, but the other two paths are nearly that same duration and there is uncertainty in all the tasks. She decides to use monte carlo analysis to better understand the likely duration of the project.

Make a monte calro analysis of

1, 000

trials using the template. What is the average duration of the project?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Some recent financial statements for Smolira Golf, Inc., follow. Find the following financial ratios for Smolira Golf (use year-end figures rather than average values where appropriate): (Do not...

1 . Use the excel template provided to answer this question. A project manager has a project with three unique paths. The deterministic time estimate has the critical path at 5 5 days, but the other...

General Information 1. The purpose of this project is to explore the dynamics of corporate valuation used in mergers and acquisitions (M&As) and understand the information retrieval process, the...

Answer questions with full steps/answers. A town estimates that it will cost $160 million to design and construct a new water treatment plant and $12.5 million per year to maintain the plant which is...

subject: operations management Book: Managerial Decision Modeling with Spreadsheets : Balakrishnan Render Stair : Third Edition Question 1 (3 points) A cake factory can produce cakes at the rate of...

Using the attached instructions, perform a sensitivity analysis of Net Present Value (NPV) using the Excel Data Table. Submit the required Excel spreadsheets and your analysis using the Assignment...

For this project you are to create an Excel template that calculates the NPV for a project and performs a sensitivity analysis of the NPV using the Excel Data Table. I am providing a pdf copy of a...

Objective: To develop a simple project plan using a desktop application. Use the software to characterize task sequences, resource assignments, and to determine the completion time and critical path....

a 2 . Website / App Project Plan Objective: To develop a simple project plan using a desktop application. Use the software to characterize task sequences, resource assignments, and to determine the...

Catching the Bus a student is running at her top speed of 5.0 m/s to catch a bus, which is stopped at the bus stop. When the student is still 40.0 m from the bus, it starts to pull away, moving with...

Phenols are often effective antioxidants (Problem 21.26 and "The Chemistry of . . . Antioxidants" in Section 10.11) because they are said to "trap" radicals. The trapping occurs when phenols react...

How is the required return of an investment related to its level of risk? Required returns are determined by businesses rather than particular levels of risk. Investors will have a higher required...

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...