Monte Carlo simulation project management

Monte Carlo SW for Excel - Statistical Softwar

Project Management Software - Shape Your Workflow in Minute

Understanding the Monte Carlo Analysis in Project Managemen

  1. The Monte Carlo simulation results for this project reflect a tight budget, which was indeed the case. This project also had a large amount (US$400 million) of construction scope, which had been subcontracted on a fixed price contract, thus the construction scope of work risk was on the construction company instead of the project
  2. Monte Carlo simulation in business. Monte Carlo simulation is a mathematical technique that provides accurate estimates when working with uncertainties. It uses randomness to obtain meaningful information and is effective for calculating business risks and predicting failures such as cost or scheduling overruns
  3. Monte Carlo Analysis is a risk management technique used to conduct a quantitative analysis of risks. This mathematical technique was developed in 1940 by an atomic nuclear scientist named Stanislaw Ulam and is used to analyze the impact of risks on your project — in other words, if this risk occurs, how will it affect the schedule or the cost of the project
  4. Monte Carlo simulation is a useful technique for modeling and analyzing real-world systems and situations. This paper is a conceptual paper that explores the applications of Monte Carlo simulation for managing project risks and uncertainties. The benefits of Monte Carlo simulation are using quantified data, allowing project managers t

Monte Carlo Analysis in Project Managemen

  1. Monte Carlo Analysis. In a Monte Carlo analysis, we run the same model — selecting a random value for each task — but we do it hundreds or thousands of times. Each time it runs, we record the values. When the simulation is complete, we can look at statistics from the simulation' to understand the risk in the model
  2. Monte Carlo simulation is a mathematical technique developed by John Von Neumann and Stanislaw Ulam in 1940 for Project Manhattan. Its name derives from the casino in Monte Carlo, where Stanislaw Ulam's uncle used to play often
  3. the Monte Carlo simulation evolved as a project management tool, along with specific benefits and concerns for its application. Tools: A detailed application of the Monte Carlo in predicting project duration is provided, and the applicability and viability of the method are proven through a case demonstration. Following the presenta
  4. I scheduled a project of 5 activities using Excel and applying Monte Carlo Simulation. functions used are sequence(rows,columns, start end) & randbetween(a,..
  5. Monte Carlo Simulation with Microsoft Project To overcome the challenges, associated with the PERT method, Monte Carlo simulations can be used as an alternative. Monte Carlo is a mathematical method used on risk analysis in many areas and is used to approximate the distribution of potential results based on probabilistic inputs
  6. The Monte Carlo Analysis is important in project management as it allows a project manager to calculate a probable total cost of a project as well as to find a range or a potential date of completion for the project. Since a Monte Carlo Analysis uses quantified data, this allows project managers to better communicate with senior management.
  7. Using Monte Carlo to estimate project durations and costs Dr. Mario Vanhoucke in his book The Data-Driven Project Manager , propose the following cases to model statistically the activities of any.

Monte Carlo simulation in MS Excel The Monte Carlo method is based on the generation of multiple trials to determine the expected value of a random variable. The basis of the method is provided by the following relationship: 99.8% 1 3 Pr ≈ ∑ − < N N N σ ξ µ There are a number of commercial packages that run Monte Carlo simulation. This webcast is designed to provide an entry-level introduction into probabilistic analysis and will show how Monte Carlo simulation and other techniques can.. The Monte Carlo analysis involves a series of random simulations on our three-step project. Each time, the analysis software plugs in random task durations for A, B, and C based on the.

Monte Carlo Simulation - Project Management Knowledg

Abstract. Research Question: This paper investigates whether the Monte Carlo simulation can be widely used as a practicable method for the analysis of the risks that impact project duration.Motivation: The main goal was to explore the use of the Monte Carlo simulation for project time management, and shed some light on the key benefits and drawbacks of this method Monte Carlo Simulation is a technique used to provide a better degree of certainty on the probability of outcomes in financial, project management, cost, and other forecasting models. The first step in quantifying any risk is to make certain assumptions about both the likelihood of risk event occurrence and the impacts of this risk, should it. It is well known the potential and the convenience of using Monte Carlo (MC) simulation to forecast projects' execution results in other to define and adjust its roadmap. MC simulation has great capabilities for project management solutions, and enough margins to be extended in terms of evolving the simulation model and offering better data. Portfolio Management. Bet Smarter With the Monte Carlo Simulation. Monte Carlo simulations are used to model the probability of different outcomes in a process that cannot easily be predicted

Since its introduction, Monte Carlo Simulations have assessed the impact of risk in many real-life scenarios, such as in artificial intelligence, stock prices, sales forecasting, project management, and pricing. They also provide a number of advantages over predictive models with fixed inputs, such as the ability to conduct sensitivity analysis. Application of Monte Carlo Simulation in Project Management - Part I: Introduction February 20, 2017 - 7:32 PM Contingencies to Address Project Uncertainties February 13, 2017 - 12:14 PM Essential Project Management Artefacts February 6, 2017 - 7:00 A Monte Carlo simulations are useful in a broad range of fields, including engineering, project management, oil & gas exploration and other capital-intensive industries, R&D, and insurance. This article focuses on applications in finance and business

The Monte Carlo Method in Project Managemen

Basics of Monte Carlo Simulation Risk Identificatio

  1. A Monte Carlo simulation is a model used to predict the probability of different outcomes when the intervention of random variables is present. Monte Carlo simulations help to explain the impact.
  2. The Monte Carlo simulation method was initially proposed by mathematician Stanislaw Ulam 4 in the 1940s and was used in the first electronic numerical integrator and computer (ENIAC) during the Manhattan Project, which developed the first atomic bombs. Nowadays, any personal computer has the ability to process the method using specific software
  3. @RISK Performs risk analysis using Monte Carlo simulation for Project Management. Project Management Scheduling, Cost Estimation, Risk Registers, Contingency Planning
  4. An overview of risk management techniques that can be incorporated into project plans and schedules. Learn how to use tools such as @RISK for Excel and Microsoft project to run Monte Carlo simulations on project plans. Model uncertain inputs under several scenarios to view the effect on project outputs like duration, dates, and cost
Monte Carlo Simulation in Excel - YouTube

risky. Monte Carlo simulation can be a useful tool for detecting the inherent optimistic bias of project originators. The two main commercial simulation software pack-ages are Crystal Ball and @Risk. We will use Crystal Ball to analyze a capital expenditure project involving the purchase, installation, and commercial use of an MR Monte Carlo Simulations is a free software which uses Monte Carlo method (PERT based) to compute a project's time. You can add various activities and then estimate project time. To add activities, you can enter description, precedences, distributions (Uniform, Triangular, Beta, Gaussian, and Exponential), parameters, and critical path node.To run calculation, you can specify number of. Explaining the past is much easier than predicting the future. This uncertainty raises a significant number of issues when creating a financial plan for a client. Monte Carlo simulations will illuminate the nature of that uncertainty, but only if advisors understand how it should be applied - and its limitations

PERT and Monte Carlo simulations in Microsoft Project. Schedule risk analysis is increasingly considered an integral part of the project management process and in particular the quantitative analysis of risk impacts on cost and schedule. However, the risk analysis capabilities are extremely limited. In Microsoft Project Server it is possible to. ARTICLE. Monte Carlo Simulation Provides Insights to Manage Risks. Predictive analytics help organizations navigate uncertainty, save lives, avoid surprises, make better decisions, and create market advantages that unveil new opportunities. Learn More >. ARTICLE. As A Metric, 'Average' Can Be A Dangerous Number Monte Carlo simulation, or probability simulation, is a technique used to understand the impact of risk and uncertainty in financial, project management, cost, and other forecasting models. When you have a range of values as a result, you are beginning to understand the risk and uncertainty in the model Monte Carlo simulation is also used to model project and business risk events. In this case, two probability distributions are required. First a Bernoulli distribution is used to model whether the risk event occurs - resulting in either a True or False result (e.g. a coin can be used to model a risk that has a 50% chance of occurring.

This is the key reason for performing a schedule risk analysis using Monte Carlo simulation. Barbecana's Full Monte Schedule Risk Analysis software is a very fast , easy to use, Monte Carlo solution that runs against data in your existing scheduling tool so there is no need to export the data before the analysis can be performed The Monte Carlo method of estimating project cost is based on the generation of multiple trials to determine the expected value of a random variable. There are commercial packages that run Monte Carlo simulation; however a basic spreadsheet such as Microsoft Excel can be used to run a simulation. Download the Monte Carlo Simulation in MS Excel A Monte Carlo simulation is a useful tool for predicting future results by calculating a formula multiple times with different random inputs. This is a process you can execute in Excel but it is not simple to do without some VBA or potentially expensive third party plugins. Using numpy and pandas to build a model and generate multiple potential.

What is a Monte Carlo Simulation? - PM Study Circl

Monte Carlo simulation is often used in business for risk and decision analysis, to help make decisions given uncertainties in market trends, fluctuations, and other uncertain factors.In the science and engineering communities, MC simulation is often used for uncertainty analysis, optimization, and reliability-based design.In manufacturing, MC methods are used to help allocate tolerances in. A Monte Carlo simulation is literally a computerized mathematical technique that creates hypothetical outcomes for use in quantitative analysis and decision-making. The technique is used by. The Monte Carlo Simulation Construction Essay. Chapter 4. 8.1 Introduction. The case study of this project will cover risks depending on delays, financial problems of the contractors and which are subject matter of modelling in a construction project. In addition, the case study is a hypothetical study built on a real scenario related to a. Monte Carlo Simulation in Finance and Risk Management. First, the only certainty is that there is no certainty. Second, every decision as a consequence is a matter of weighing probabilities. Third, despite uncertainty, we must decide and we must act. And lastly, we need to judge decisions not only on the results but how those decisions were made

A Monte Carlo simulation is a quantitative analysis that accounts for the risk and uncertainty of a system by including the variability in the inputs. The system may be a new product, manufacturing line, finance and business activities, and so on. The simulation uses a mathematical model of the system, which allows you to explore the behavior. The CPTs are further developed using the leaky-MAX model. Finally, the Bayesian Monte Carlo simulation-driven risk inference method is developed for predicting and quantifying the probability of construction schedule risk occurrence. A real infrastructure project was selected as a case study to verify this developed approach

Monte Carlo Simulation (MCS) is a technique that relies on two processes. Process 1 aims at developing a spreadsheet model that calculates the critical path or the total cost, etc. The calculation is setup in a single row (or Run). This row is then duplicated a large number of times (thousands) A Monte Carlo schedule simulation provides a project's decision-maker with a scope of possible results and the probabilities each outcome might happen. It gives you the extreme possibilities—the results of going-for-broke and for making more conservative decisions—along with all possible ramifications for middle-of-the-road decisions Monte Carlo Simulation is a method of estimating the value of an unknown quantity using the principles of inferential statistics. Inferential statistics corresponds to applying statistical algorithms on a sample/random variable, drawn from a sample that tends to exhibit the same properties as the population (from which it is drawn)

DOI: 10.7595/MANAGEMENT.FON.2018.0004 Corpus ID: 67095960. Examining the Value of Monte Carlo Simulation for Project Time Management @inproceedings{Avlija2018ExaminingTV, title={Examining the Value of Monte Carlo Simulation for Project Time Management}, author={Goran Avlija{\vs}}, year={2018} Yet traditional project management systems make precise deterministic projections of the project finish date, as well as cost, which everyone know will be wrong. One way to get more realistic, probabilistic estimates is Project Simulation using Monte Carlo techniques Monte Carlo simulation - Designing Buildings Wiki - Share your construction industry knowledge. A Monte Carlo simulation is a computational risk analysis tool applied to situations that are uncertain or variable. It is a mathematical way of predicting the outcomes of a situation or set of circumstances by giving a range of possible outcomes and assessing the risk impact of each PROJECT RISK MANAGEMENT USING MONTE CARLO SIMULATION AND EXCEL. In every project, especially in software and IT projects, there is the need to perform an elaborated risk management. One main task that often causes problems is the quantitative risk analysis. In this article we will show how to deal with this by using a well-known standard.

Managing project uncertainty using Monte Carlo simulation

If you are new to Monte Carlo Simulation, you may want to refer to an article I wrote back in 2004 that provides a very basic overview and demonstrates the process with an example in Excel. Monte Carlo Simulation: A Practical Guide. For very simple models, the approach used in the above article can work well Results from a Schedule Risk Simulation. The schedule risk results from a Monte Carlo simulation are shown in the histogram for below. For a simple case study, it shows that the deterministic date of 13 April 2020 is less than 1% likely to be achieved following the current plan and without further risk mitigation actions According to this numerical example, the convergence property of the proposed method is as good as the original Monte Carlo simulation. 6. ConclusionWe proposed a new analysis method for project process management. By processing one set of Monte Carlo simulation results by our method, we can analyze network characteristics efficiently Perform more Monte Carlo simulation runs. Use this information to assess project uncertainty and risk and to review and possibly change crucial variable

Monte Carlo simulation is a technique used to study how a model responds to randomly generated inputs. It typically involves a three-step process: Randomly generate N inputs (sometimes called scenarios). Run a simulation for each of the N inputs. Simulations are run on a computerized model of the system being analyzed Benefits of the Monte Carlo Simulation. The Monte Carlo simulation method has many benefits in project management, such as: *It helps you evaluate the risk of the project. *It helps you predict the chances of failure, and schedule and cost overrun. *It converts risks into numbers to assess the risk impact on the project objectives Running the Monte Carlo simulation to combine the risks. Once all the costs and distributions have been determined, the Monte Carlo simulation can be carried out to determine the overall risk for the combined costs of the project. The number of iterations required makes this process impossible to do by hand and suitable software has to be used

Download Monte Carlo Simulations for free. MCS is a tool that exploits the Monte Carlo method and, with a complex algorithm based on the PERT (Program Evaluation and Review Technique), it estimates a project's time. MCS is a opensource project and it was devolped by Java Programming Language Monte Carlo methods are used in corporate finance and mathematical finance to value and analyze (complex) instruments, portfolios and investments by simulating the various sources of uncertainty affecting their value, and then determining the distribution of their value over the range of resultant outcomes. This is usually done by help of stochastic asset models Monte Carlo Simulation For Project Schedule Probability Analysis Using Excel 1Akshay Bhaskar Bagal, 2Dr. Sumant K Kulkarni It is widely accepted that construction project schedule plays major role in project management due to its influence on success of project within stipulated duration. The uncertainty and reliability related issue Monte Carlo Simulation (MCS) placed probability distributions directly on activity durations - Did not distinguish risks from uncertainty - Could not disentangle the relative impacts of several risks on one activity - Could not assess the whole impact of a risk that affects more than one activit

Use Monte Carlo Simulation to Manage Schedule Ris

The purpose of the project is to explore the possibilities of Monte Carlo simulation in the area of project management. It is not the purpose of the project to compete with professional quantitative risk assesment tools like @Risk (by Palisade), Risk+ (by Deltek) or Crystall Ball (by Oracle, formerly by Decisioneering) Sample those simulated Takt times to build a project simulation. Observe the resulting distribution; Some Notes. I've found the Monte Carlo method to be a very useful way of forecasting projects. To close out the post, here are some observations and notes to consider before you try it for yourself. It's a good predictor of the timeline but Monte-Carlo Simulation with Crystal Ball Project Management—Global Oil Global Oil is planning to move their credit card operation to Des Moines, Iowa from their home office in Dallas. The move involves many different divisions within the company. Real estate must select one of three available office sites Monte Carlo Simulation of Sample Percentage with 10000 Repetitions In this book, we use Microsoft Excel to simulate chance processes. This workbook introduces Monte Carlo Simulation with a simple example. Typically, we use Excel to draw a sample, then compute a sample statistic, e.g., the sample average The Monte Carlo simulation was derived by mathematician Stanislaw Ulam who worked on the Manhattan Project during World War 2. While recovering from an illness, he was playing solitaires and wondered what would be the chances of a Canfield solitaire laid out with 52 cards to come out successfully

Video: Monte Carlo Simulation Example and Solution - projectcubicl

Depending on the number of factors involved, simulations can be very complex. But at a basic level, all Monte Carlo simulations have four simple steps: 1. Identify the Transfer Equation. To create a Monte Carlo simulation, you need a quantitative model of the business activity, plan, or process you wish to explore Monte Carlo simulations are algorithms used to measure risk and understand the impact of risk and uncertainty in various forecasting models, such as finances and project management. These simulations help you see the outcomes and impacts in these processes that involve a number of variables. In essence, they model various outcome probabilities Note: The name Monte Carlo simulation comes from the computer simulations performed during the 1930s and 1940s to estimate the probability that the chain reaction needed for an atom bomb to detonate would work successfully. The physicists involved in this work were big fans of gambling, so they gave the simulations the code name Monte Carlo Monte Carlo Simulation. Monte Carlo simulation uses random numbers to simulate a large number of possible scenarios. In the above case column B has a random number generated between 0 and 1, as long as that number is less than .1 (or whatever I put in cell B7) if will return 'B' in column D for the corresponding row The specialized literature illustrates how the Monte Carlo method can effectively evaluate the investment risk of PPP projects, and help investors make better decisions. The objective of this course is to provide participants with a knowledge of key issues involved in the Monte Carlo (MC) simulation for risk analysis and project finance

Risk management - PM

  1. Monte Carlo simulation, or probability simulation, is a technique used to understand the impact of risk and uncertainty in financial, project management, cost, and other forecasting models. Uncertainty in Forecasting Models When you develop a forecasting model - any model that plans ahead for the future - you make certain.
  2. Monte-Carlo simulations can be used for various purposes to analyze the behaviour of projects in (fictitious) progress. It can be used to measure the sensitivity of project activities as described in Schedule Risk Analysis: How to measure your baseline schedule's sensitivity? or to evaluate the accuracy of forecasting methods used in Earned Value Management (see Predicting project.
  3. Monte Carlo simulation of Project Delivery Time (T) based on Z-curve. A Guide to the Project Management Body of Knowledge. Project Management Institute. Savage, S. L. (2012)
  4. Monte Carlo simulation is a computerized mathematical technique to generate random sample data based on some known distribution for numerical experiments. This method is applied to risk quantitative analysis and decision making problems. This method is used by the professionals of various profiles such as finance, project management, energy.
  5. There are a number of advantages and disadvantages to Monte Carlo simulation (MCS). First of all, though, we need to understand what MCS is. MCS is best described as a way of estimating uncertainty in a model, and it works really well in nonlinear and chaotic models. The idea is that if we know there are a number of components going into a model and those components each have some sort of.

Simulation modeling in project management - AnyLogic

Monte Carlo Simulation of Project Schedules. Brian Steve Smith, PE, PMP, MBA. Course Outline. The course begins with a description of the general utility of Monte Carlo simulation, and its advantages over point case models. The data and tools required for the Monte Carlo simulation are described, and illustrated through a simple project. 557 Monte Carlo Simulation and Modeling of Schedule, Cost and Risks of Dasu Hydropower Project The main focus of this research is to devise a Monte Carlo technique was used for simulation. Pert- methodology to complete HPP well in planned time and Master software was also used for simulation which takes budget Monte Carlo stochastic simulation ¶. Using a Monte Carlo stochastic simulation method, we will estimate the probability distribution of completion time, providing much more information for decision-making on project risk than only best and worst cases. We start by defining a function that simulates the completion time of task 1 Monte Carlo simulation was found to be the most widely accepted method for estimating the required cost contingency as project cost estimators become more aware of its improved effectiveness over the traditional percentage approach. The Project Management Body of Knowledge (PMBOK) [10] advocates its use for performing quantita-tive risk analysis Monte-Carlo-Simulation. MC-Simulation is a mathematical technique, which is used to estimate the possible outcomes of uncertain events. MC-Simulations have assessed the impact of risk in many real-life scenarios, such as in artificial intelligence, stock prices, sales forecasting, project management and pricing. They also provide a number of.

@RISK for Excel | TP Analytics StorePortfolio Optimization Excel Model with Harry Markowitz&#39;s

What Is Monte Carlo Analysis in Project Management

This recommended practice (RP) defines and explains the integration of cost and schedule risk analysis using a Monte Carlo simulation of a critical path method (CPM) resource-loaded schedule. It explains in some detail the use of risk drivers [1] to represent the identified risks to a project's cost and schedule in an integrated approach risk simulation of collaborating business processes based on 2 dimensional Monte Carlo Simulation. Key words: Risk Management System, Project Management, Monte Carlo Simulation, Risk Calculation, Risk Calculation Engine, Simulation Representation, Simulation Implementation 1. Introduction A process (project or workflow) consists of several. simulation models aid the process by deriving time and cost forecasts from simulation trials that provide insight to project risks by quantifying on a statistically probable basis the chances of the project being completed within budget targets. In the models presented in this article Monte Carlo simulations are applie RENO is a user friendly platform designed for building and running complex analyses for any probabilistic or deterministic scenario. It uses an intuitive flowchart modeling approach with Monte Carlo simulation to estimate or optimize the results for risk analysis, complex reliability modeling, maintenance planning, operational research, financial planning or other analysis objectives

For Project Management - Jsto

Desktop only. RStudio for Six Sigma - Monte Carlo Simulation. Start Guided Project. In this 2-hour long project-based course, you will learn how to 1. Generate Continuous, Discrete and Categorical Data (Xs) Using Statistical Distributions 2. Create A Transfer Function That Relates The Xs With The Y (Dependent Variable) 3 A web-based tool for calculating project estimates using a Monte Carlo simulation was recently made publicly available. It was created in the hopes that agile teams will use it to facilitate conversa Exploring Monte Carlo Simulation Applications for Project What is Monte Carlo Simulation? www.riskamp.com project management, when planning the project. In construction, for example, Monte Carlo simulation project management, energy, and the resulting outcome from that sample is recorded. Monte Carlo simulation does this hundreds or [ Operations Management questions and answers. Sample Monte Carlo Simulation Results for Project Schedule Date: 1/14/08 11:13:56 AM Number of Samples: 250 Unique ID: 1 Name: Widget Completion Std Deviation: 5.2d 95% Confidence Interval: 0.6d Each bar represents 2d Completion Probability Table Sample Count 45.0 40.5 36.0 31.5 27.0 22.5 18.0 13.5 9.

Monte Carlo Simulation in Project Planning RiskAM

The monte carlo simulation handles the forecasting for us so the engineers can focus on completing tasks. The PMs focused on user stories and acceptance criteria. The stakeholders had a continuously updated forecast for when things would likely get done. In project management / scheduling there are often critical path items listed. However. Running Monte Carlo Simulator. You can browse the Python implementation for the MC simulator if curious. The driver code for project cost example is run as follows, where the number of iterations is 5000. The result will improve with higher number of iterations A critical comparison between CPM and PERT with Monte Carlo simulation in project management and scheduling book. By Y. Liu & P.W. Zhang. Book Civil Engineering and Urban Planning III. Click here to navigate to parent product. Edition 1st Edition. First Published 2014. Imprint CRC Press. Pages 4. eBook ISBN 9780429226960 GoldSim is the premier Monte Carlo simulation software solution for dynamically modeling complex systems in engineering, science and business. GoldSim supports decision-making and risk analysis by simulating future performance while quantitatively representing the uncertainty and risks inherent in all complex systems The article describes the Monte-Carlo simulation method for project risk management. The method includes a sensitivity analysis and simulation experiments. The simulation of parameters is performed with the MS Excel software and EVA - risk analysis software application on a sample investment project for an office building construction.

Construction KPI Dashboard Excel Template - Eloquens

Monte Carlo method for project management - Twproject

Capital Expenditure Forecast Excel Model Template - EloquensSample Startup Financial Model - Excel Template - EloquensThe Deltek Acumen Risk Exposure Comparison Chart

In this study, Monte Carlo simulation and Bayesian network methods are combined to present a structure for assessing the aggregated impact of risks on the completion time of a construction project. Construction projects often encounter different risks which affect and prevent their desired completion at the predicted time and budget Monte Carlo simulation: This is the technique that is widely used to learn about the risk factor and uncertainties in cost, finance, project management and different types of forecast models. There is a simulator that is used to visualize the possible output to have a clear cut understanding about the risk of taking a decision They are about queuing,inventory management, monte carlo simulation. You must be good at probability distrubition and simulation topics to do this simulations. I will send the project descriptions as DM. Max budget is 20 USD. Deadline is 24 hours. Skills: Excel, Operations Research, Simulation, Inventory Management Project Risk Management. A Monte Carlo Simulation is a way of assessing the level of risk across a whole project. So, while you may not need to use this powerful methodology, it's vital knowledge for any project manager. This video is safe for viewing in the workplace. This is learning, so, sit back and enjoy The final project will be an Asset Liability Management application and will involve Monte Carlo simulation. Quantitative Risk Management: The objective of this course is to provide a grounding in applied probability and statistics as it relates to the measurement of financial risk. The material is mainly organized around the text Quantitative. Prepare comprehensive reports for management that explains in clear terms the risks and the probability of achieving the project's delivery dates. Question 3: Detailed financial analysis using Monte-Carlo Simulation, including