Question: Please show formulas input in excel and the solver parameters (i.e objective, changing variable cells, and constraints). Please provide a detailed step-by-step description of your

Please show formulas input in excel and the solver parameters (i.e objective, changing variable cells, and constraints). Please provide a detailed step-by-step description of your proposed solution. Please don't copy solutions from other Chegg questions. Thank you!

A contractor has found that her cost for a certain construction job is subject to random variation. She believes its actual value follows a continuous uniform distribution between $9000 and $11000 with a mean of $10,000. The cost to prepare her bid is $500. She is competing in a sealed bid competition with four other contractors. She believes that the bids submitted by the other contractors will vary triangularly with a minimum equal to her minimum cost, a most likely value equal to her 1.3 times her mean cost and a maximum equal to 2.5 times her mean cost and that their bids are independent of each other. She will win the competition if her bid is smaller than the bids of all four competitors. If she wins, her profit will be the difference between her bid and her cost minus the proposal preparation cost. If she loses her proposal preparation cost is lost and her profit is -$500.

Simulate 1000 bids in which her bid amount is $14,000 and determine the distribution of her profit. Include the histogram in your response. Also determine the probability that she wins the competition and the probability that she loses money. Compare these results for bid amounts of $13000 and $15000

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 General Management Questions!