# Question: In Example 16 1 the possible profits vary from negative to

In Example 16.1, the possible profits vary from negative to positive for each of the 10 possible bids examined.

a. For each of these, use @RISK’s RISKTARGET function to find the probability that Miller’s profit is positive. Do you believe these results should have any bearing on Miller’s choice of bid?

b. Use @RISK’s RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?

a. For each of these, use @RISK’s RISKTARGET function to find the probability that Miller’s profit is positive. Do you believe these results should have any bearing on Miller’s choice of bid?

b. Use @RISK’s RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?

**View Solution:**## Answer to relevant Questions

If the number of competitors in Example 16.1 doubles, how does the optimal bid change?Rerun the new car simulation from Example 16.4, but now use the RISKSIMTABLE function appropriately to simulate discount rates of 5%, 7.5%, 10%, 12.5%, and 15%. Comment on how the outputs change as the discount rate ...Change the new car simulation from Example 16.4 as follows. It is the same as before for years 1 through 5, including depreciation through year 5. However, the car might sell through year 10. Each year after year 5, the ...Suppose that GLC earns a $2000 profit each time a person buys a car. We want to determine how the expected profit earned from a customer depends on the quality of GLC’s cars. We assume a typical customer will purchase 10 ...You now have $10,000, all of which is invested in a sports team. Each year there is a 60% chance that the value of the team will increase by 60% and a 40% chance that the value of the team will decrease by 60%. Estimate the ...Post your question