Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

limit on the random the version of olver accessible may not be able moblems 16, 17, We recommend we Excel function than Analytic these problems

image text in transcribed
limit on the random the version of olver accessible may not be able moblems 16, 17, We recommend we Excel function than Analytic these problems 15. 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 prop- erty 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 $150,000. a. Develop a worksheet that can be used to simulate the bids made by the two competitors. Strassel is considering a bid of $130,000 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 $130,000? b. How much does Strassel need to bid to be assured of obtaining the property? What is the profit associated with this bid? c. 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 $130,000, $140,000, or $150,000. What is the recommended bid, and what is the expected profit? .. .. for mactanrant that is currently appraising its customer ser- limit on the random the version of olver accessible may not be able moblems 16, 17, We recommend we Excel function than Analytic these problems 15. 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 prop- erty 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 $150,000. a. Develop a worksheet that can be used to simulate the bids made by the two competitors. Strassel is considering a bid of $130,000 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 $130,000? b. How much does Strassel need to bid to be assured of obtaining the property? What is the profit associated with this bid? c. 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 $130,000, $140,000, or $150,000. What is the recommended bid, and what is the expected profit? .. .. for mactanrant that is currently appraising its customer ser

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance Capital Markets Financial Management And Investment Management

Authors: Frank J. Fabozzi, Pamela Peterson Drake

1st Edition

0470407352, 978-0470407356

More Books

Students also viewed these Finance questions

Question

Why is it a good idea to avoid being judgmental? (p. 177)

Answered: 1 week ago