Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Help with the formulas in excel sheet please for each column. Strassel Investors buys real estate, develops it, and resells it for a profit. A
Help with the formulas in excel sheet please for each column.
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 $158,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 what the competitors will bid, but he assumes for planning purposes that the amount bid by each competitor will be uniformly distributed between $100,000 and $ 148,000. What is the estimate of the probability Strassel will be able to obtain the property using a bid of $ 128,000 ? (Use at least 5,000 trials. Round your answer three decimal places.) How much does Strassel need to bid to be assured of obtaining the property? o $128,000 O $138,000 $148,000 (noting that Strassel's profit is $0 if he does not win the bid). With maximization of profit as Strassel's Use the simulation model to compute the profit for each trial of the simulation run objective, use simulation to evaluate Strassel's bid alternatives of $ 128,000, $138,000 or $148,000. What is the expected profit (in dollars) for each bid alternative? (Use at least 5,000 trials. Round your answers to the nearest dollar.) expected profit for a bid of $128,000 expected profit for a bid of $138,000 expected profit for a bid of $148,000 25,930 36,520 47,110 x
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started