Question

In: Statistics and Probability

Problem 12-15 (Algorithmic) Strassel Investors buys real estate, develops it, and resells it for a profit....

Problem 12-15 (Algorithmic)

Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $160000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100000. Two competitors will be submitting bids for the property. Strassel does not know what the competitors will bid, but he assumes for planning purposes that the amount bid by each competitor will be uniformly distributed between $100000 and $150000.

  1. Develop a worksheet that can be used to simulate the bids made by the two competitors. Strassel is considering a bid of $135000 for the property. Using a simulation of 1000 trials, what is the estimate of the probability Strassel will be able to obtain the property using a bid of $135000? Round your answer to 1 decimal place. Enter your answer as a percent.

    %
  2. How much does Strassel need to bid to be assured of obtaining the property?

    $  

    What is the profit associated with this bid?

    $  
  3. Use the simulation model to compute the profit for each trial of the simulation run. With maximization of profit as Strassel’s objective, use simulation to evaluate Strassel’s bid alternatives of $135000, $135000, or $150000. What is the recommended bid, and what is the expected profit?

    A bid of   results in the largest mean profit of $  .

Solutions

Expert Solution

1)

Estimate of probability of obtaining the property using a bid of $ 135,000 = 40 %

Profit associated with bid value of $ 135,000 = $ 10,000

2)

The upper limit of competitors bid is $ 150,000.

Therefore, Strassel need to bid $ 150,000 to be 100% sure of obtaining the property.

3) Profit associated with this bid = 160000 - 150000 = $ 10,000

4)

Expected profit with bid of $ 135,000 = $ 10000 (as determined in part 1)

Expected profit with bid of $ 150,000 = $ 160000 - 150000 = 10,000

EXCEL FORMULAS:

Cell Formula Copy to
B11 =$C$6+RAND()*($C$7-$C$6) B11:C1010
D11 =MAX(B11:C11) D11:D1010
E11 =IF(D11<$F$3,1,0) E11:E1010
F11 =($C$3-$F$3)*E11 F11:F1010
F5 =AVERAGE(E11:E1010)
F7 =AVERAGE(F11:F1010)

Related Solutions

Problem 12-15 (Algorithmic) Strassel Investors buys real estate, develops it, and resells it for a profit....
Problem 12-15 (Algorithmic) Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $170000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100000. Two competitors will be submitting bids for the property. Strassel...
Problem 16-15 (Algorithmic) Strassel Investors buys real estate, develops it, and resells it for a profit....
Problem 16-15 (Algorithmic) Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property, it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strassel does not know...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property...
Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, the president and owner of Strassel Investors, believes if he purchases and develops this property it can then be sold for $165000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100000. Two competitors will be submitting bids for the property. Strassel does not know...
6 – ​​​​​​​​​​ Strata Investors buys real estate, develops it, and resells it for a profit....
6 – ​​​​​​​​​​ Strata Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strasta, the president and owner of Strasta Investors, believes if he purchases and develops this property it can then be sold for $160,000. The current property owner has asked for bids and stated that the property will be sold for the highest bid in excess of $100,000. Two competitors will be submitting bids for the property. Strasta...
Problem 4-21 (Algorithmic) A real estate investor has the opportunity to purchase land currently zoned residential....
Problem 4-21 (Algorithmic) A real estate investor has the opportunity to purchase land currently zoned residential. If the county board approves a request to rezone the property as commercial within the next year, the investor will be able to lease the land to a large discount firm that wants to open a new store on the property. However, if the zoning change is not approved, the investor will have to sell the property at a loss. Profits (in thousands of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT