Strassel Investors buys real estate, develops it, and resells it for a profit. A new property is available, and Bud Strassel, th
e president and owner of Strassel Investors, believes it can be sold for $ 160,000. The current property owner 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?
1 answer:
You might be interested in
Answer:
The computations are shown below:
Explanation:
a. The computation of the economic order quantity is shown below:
= 229 units
The carrying cost is come from
= $2.40 × 20%
b. Time between placement of orders is
= Economic order quantity ÷Annual demand
= 229 ÷ 280
= 0.8179 years
So,
= 0.8179 × 365 days
= 298.53 days
We assume 365 days in a year
c. The average annual cost of ordering cost and carrying cost equals to
= Holding cost + ordering cost
= (Economic order quantity ÷ 2 × Holding cost) + (Annual demand ÷ Economic order quantity × ordering cost)
= (229 units ÷ 2 × $0.48) + (280 ÷ 229 units × $45)
= $54.96 + $55.02
= $109.98
d) Now the reorder level is
= Demand × lead time + safety stock
where, Demand equal to
= Expected demand ÷ total number of weeks in a year
= 280 pounds ÷ 52 weeks
= 5.38461
So, the reorder point would be
= 5.38461 × 3 + $0
= 16.15 pounds