Question: Develop a model that conducts Monte Carlo Simulation for a given schedule. The model will prompt the user for the number of desired samples (please

Develop a model that conducts Monte Carlo Simulation for a given schedule. The model will prompt the user for the number of desired samples (please use 250,000 as the default value) and takes a CSV file in the format of the attached file as input. Please generate the following answers from the model: i. The total duration of the entire project in terms of: a) Mean and standard deviation b) A plot of CDF ii. Build a function that prompts the user to input a desired confidence level (in percentage) and determines the completion date to finish with the given confidence level: “This project will finish within _____ days with a _____ confidence level” iii. Draw a column chart that?

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 Programming Questions!

Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...

Hi, I am doing a project for derivatives class and I have some questions about a regression and Monte Carlo simulation that I need to come up with. So the goal is to hedge against CDS instruments by...

Question: While reading the case, look for inputs to the model that are subject to uncertainty. This means any input to the model that is not fixed and could change. The case provides context that...

Probability and Statistics - Problem Set c Keith M. Chugg October 2, 2015 1 Preliminaries, Combinatorics, Set Probability 1.1. A number of bats are in a cave. 2 bats can see out of their left eye. 3...

Introduction: You have recently been hired as a Financial Analyst in the Finance Department of Zeta Auto Corporation which is seeking to expand production. The CFO asks you to help decide whether the...

Decision Trees Tomado Chart Monte Carlo Simulation Discount Bundles Support Download Company TreePlan Decision Tree Add-in for Excel For Mac Excel 2011-2016-2019-365 and Windows Excel...

Requirements: Use the Lakeshore Bank case to design a spreadsheet risk monitoring model. Your model should have the components included in the template we have been using in class. These components...

Hi! I need help on finishing what I could not figure out. I got the basic analysis part and tornado diagram finished. I need help on the breakeven and the CP part. If you could look over the WACC tab...

2. This is the Research Guide I am using and some of the things I found in it. Management (apus.edu). This guide enhances students studying management with a lot of resources and information,...

Riding a bicycle at a constant speed requires the rider to provide enough constant force to the pedals to overcome the resistance forces. To make this problem easier to calculate, assume that there...

7. Question 7 Refer to Step 3.3. In the "Unconstrained " or "Short Selling " version of the optimal risky portfolio, what is the portfolio mean ? Write your answer as a percentage ,with no percentage...

Real-world financial statements do not follow a cookie-cutter design: each one is a little bit different. The same account may be called something different on different firms' statements, and some...

Explain how this demonstrates how short term aberrations e do not affect the long run. Streaks of all heads or all tails affect the long run probability The short term aberrations make it so that the...

Bottles 4 All began business on August 1, 2023 and has selected a July 31, 2024 fiscal year-end. Bottles 4 All has negotiated with 2 suppliers of drink bottles and will start by selling 3 types of...

Tyler Countys general fund starts the fiscal year 2020 with a $250,000 balance for net property taxes receivable. The balance is net of a $200,000 allowance for uncollectible taxes. The county also...

Show that a paraboloidal wave centered at the point P1 is converted by a lens of focal length f into a paraboloidal wave centered about P2, where 1/z1+1/z2=1/f. [hint: using U1, U2 and t] Pz P1 Z1

A firm has total assets of $ 1 0 0 and total debt of $ 2 5 . Equity is $ 7 5 . Debt - equity ratio is 3 . Debt ratios is 2 5 % . Equity ratio is 7 5 % .

Examine the following data: a. Construct a scatter plot of the data. Determine the order of the polynomial that is represented by the data. b. Obtain an estimate of the model identified in part a. c....

The following correlation matrix is associated with the same data used to build the regression model in Problem 15-1: Does this output indicate any potential multicollinearity problems with the...

Discuss the difference between a cyclical component and a seasonal component. Which component is more predictable, seasonal or cyclical? Discuss and illustrate with examples.

The tax situation for houses with rentals is a bit more complicated than we presented in the chapter. On one hand, Sanjay and Sarah must pay taxes on any rental income, which will increase their...

Although the expected value is a straightforward and appealing summary of an alternative, it does have its limitations. We interpret the EMV as the average amount that would be obtained by playing...

When a movie producer decides whether to produce a major motion picture, the main question is how much revenue the movie will generate. Draw a decision tree of this situation, assuming that there is...