Question
A construction company is bidding on a project and has asked you to conduct an EXCEL spreadsheet Monte Carlo simulation to determine an estimate of
A construction company is bidding on a project and has asked you to conduct an EXCEL spreadsheet Monte Carlo simulation to determine an estimate of how long the work will take as part of its bid input. The company also wants to know the risk it is taking not finishing the work on time so they want a range of completion times and the likelihood of completing it within that time period. The work has three jobs that must be completed in sequence. The company has data on how long each job takes. These data are in the associated Arena Input Analyzer data files. Data is in months. The company wants the estimate based on 100 simulation iterations for each job. Perform this Monte Carlo simulation and provide a write-up of your approach and the accompanying EXCEL spreadsheet simulation. Make sure you explain how you conducted your input data analysis.
Just make it with random values of Job times, I can not paste here 5 000 rows. You can leave just a strategy of your approach.
Step by Step Solution
3.28 Rating (157 Votes )
There are 3 Steps involved in it
Step: 1
Answer A Monte Carlo simulation can be developed using Microsoft Excel and a game of dice The Monte ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started