Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The equipment installation group at Globus Enterprises is about to make a cost estimate to determine how much it will cost to install a back-up

The equipment installation group at Globus Enterprises is about to make a cost estimate to determine how much it will cost to install a back-up generator at a government laboratory facility. Over the years, this group has carried out more than 100 such installations and has developed a database reflecting past experience. Data on the distribution of cost for design work, building effort, and testing effort is provided in Table 1.

Cheapest

($/%)

Usual

($/%)

Expensive

($/%)

Design

9,000/30

10,000/40

12,000/30

Build

60,000/20

70,000/60

80,000/20

Test

18,000/20

20,000/50

24,000/30

Table 1. Historical Data on Cost Distributions

The data in the table picture the cost of an effort and the percentage of times this cost is achieved. For example, 30% of the time, Design cost $9,000; 40% of the time it cost $10,000; 30% of the time it cost $12,000.

00 16 45 84 18

83 28 82 36 91

95 14 80 68 34

54 55 13 20 70

57 68 61 37 30

09 81 24 55 21

Table 2. Two-digit Random Numbers

Conduct a Monte Carlo simulation to create a distribution portraying total estimated project costs. Employ ten iterations in your computation. Display the distribution graphically.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions