Johnson Company is preparing a bid on a new construction project. Two other contractors will be...

Johnson Company is preparing a bid on a new construction project. Two other contractors will be submitting bids for the same project.

Based on past bidding practices, bids from other contractors can be described by the following probability distributions:

Contractor A: Uniform probability distribution between $500,000 and $1,000,000.

Contractor B: Normal probability distribution with a mean bid of $700,000 and a standard deviation of $100,000.

a. If Johnson Company submits a bid of $750,000, what is the probability Butler will obtain the bid. Simulate 1000 trials of the contract bidding process. Note: Johnson's bid must be less than BOTH A and B.

Solutions

Expert Solution

Using Excel we will use the functions

500000+(1000000-50000)*RAND() to simulate the bids by contractor A
NORM.INV(RAND(),700000,100000) to simulate bids by contractor B

the probability Johnson will obtain the bid is same as the probability that bids of Contractor A and B are less than 750000

= (number of times the bids of Contractor A and B are less than 750000 )/(total number of simulations)

Prepare the following

copy the rows to create 1000 trials. Paste as values to avoid changes to the the simulated values

Get this

ans: the probability that Johnson will obtain the bid is 0.153

orchestra answered 10 months ago

Next > < Previous

Related Solutions

A building contractor is preparing a bid on a new construction project. Two other contractors will...

A building contractor is preparing a bid on a new construction project. Two other contractors will be submitting bids for the same project. Based on past bidding practices, bids from the other contractors can be described by the following probability distributions: Contractor Probability Distribution of Bid A Uniform probability distribution between $500,000 and $700,000 B Normal probability distribution with a mean bid of $600,000 and a standard deviation of $40,000 If required, round your answers to three decimal places. If...

Problem 12-18 (Algorithmic) A building contractor is preparing a bid on a new construction project. Two...

Problem 12-18 (Algorithmic) A building contractor is preparing a bid on a new construction project. Two other contractors will be submitting bids for the same project. Based on past bidding practices, bids from the other contractors can be described by the following probability distributions: Contractor Probability Distribution of Bid A Uniform probability distribution between $530,000 and $730,000 B Normal probability distribution with a mean bid of $630,000 and a standard deviation of $43,000 If required, round your answers to three...

Cary Construction Inc. is preparing to bid on a job building a new dorm fo the...

Cary Construction Inc. is preparing to bid on a job building a new dorm fo the local college. Cary expects that the job will require $850,000 of direct materials, $500,000 of direct labor, and $425,000 of overhead costs. Administrative and other expenses for the job are expected to be $2,000. On average last year, Cary Construction earned about $250,000 profit on a job this size and would like to increase the profit by 5 percent on new contracts. Cary normally...

The Rogers Construction Company is trying to decide whether to make a bid on a project...

The Rogers Construction Company is trying to decide whether to make a bid on a project against 4 competitors. The lowest bid will win the contract and be paid the amount they bid. It believes it will cost the company £10,000 to complete the project (if it wins the contract) and £350 to prepare the bid. Based on historical data, Rogers believes each competitor’s bid has a normal distribution with mean £15,000 and standard deviation £1,500. a) Set up a...

When preparing capital budgeting analysis for a new project, Chris Johnson, a chief financial officer at...

When preparing capital budgeting analysis for a new project, Chris Johnson, a chief financial officer at BT Industries, faced a dilemma. The project involved a production of new type of shipping containers, which were significantly more durable and had a considerably longer useful life compared to conventional containers used in the industry. The year was 2009, and the equipment necessary for producing the containers was being sold for $900K. Each year, this cost is expected to increase by 20%. The...

When preparing capital budgeting analysis for a new project, Chris Johnson, a chief financial officer at...

When preparing capital budgeting analysis for a new project, Chris Johnson, a chief financial officer at BT Industries, faced a dilemma. The project involved a production of new type of shipping containers, which were significantly more durable and had a considerably longer useful life compared to conventional containers used in the industry. The year was 2009, and the equipment necessary for producing the containers was being sold for $750K. Each year, this cost is expected to increase by 30%. The...

The construction department is planning to bid on a large project for the development of a...

The construction department is planning to bid on a large project for the development of a new airport in Chicago area. The following table shows major activities, times, and sequence required: Activity Immediate Predecessor Activity Duration, Months Optimistic Most Likely Pessimistic A - 2 3 4 B A 1 2 3 C A 4 5 12 D A 3 4 11 E B 1 3 5 F C 1 2 3 G D 1 8 9 H E, F 2...

Microsoft Project Case: Shoreline Stadium Case The G&E Company is preparing a bid to build the...

Microsoft Project Case: Shoreline Stadium Case The G&E Company is preparing a bid to build the new 47,000-seat Shoreline baseball stadium. The construction must start on July 1, 2020, and be completed in time for the start of the 2023 season in April. A penalty clause of $250,000 per day of delay beyond April 1st is written into the contract. Percival Young, the president of the company, expressed optimism at obtaining the contract and revealed that the company could net...

3. Smith’s bid of $542,000 was the lowest on a construction project that was advertised. The...

3. Smith’s bid of $542,000 was the lowest on a construction project that was advertised. The cost of the largest construction contract which Smith had previously performed was $78,000. What should the owner do to determine whether or not to let the contract to Smith?

Alden Construction is bidding against Forbes Construction for a project. Alden believes that Forbes’s bid is...

Alden Construction is bidding against Forbes Construction for a project. Alden believes that Forbes’s bid is a random variable B with the following mass function: P(B $6,000) .40, P(B $8,000) .30, P(B $11,000) .30. It will cost Alden $6,000 to complete the project. Use each of the decision criteria of this section to determine Alden’s bid. Assume that in case of a tie, Alden wins the bidding. (Hint: Let p Alden’s bid. For p 6,000, 6,000 p 8,000, 8,000 p...

Subjects