A specialty hedge fund is considering the purchase of a Jackson Pollock painting. It estimates the value of the painting to be $185 million. In an auction, both the number of competing bids and the amount of the competing bids is uncertain. The hedge fund has maintained a file summarizing 10 recent art auctions that it believes are similar to the upcoming auction. It is considering a bid of $163 million and would like to evaluate its chances of winning the upcoming auction with this bid. $\begin{array}{|c|c|c|c|c|c|c|c|}
\text { Bid Amount (As Fraction of Estimated Share Value) }\
\hline \text { Company } & \mathbf{1} & \mathbf{2} & \mathbf{3} & \mathbf{4} & \mathbf{5} & \mathbf{6} & \mathbf{7} \
\hline 1 & 0.817 & 0.884 & 0.756 & & & & \
\hline 2 & 0.771 & 0.863 & 0.825 & 0.819 & 0.851 & 0.786 & \
\hline 3 & 0.804 & 0.851 & 0.786 & & & 0.851 & \
\hline 4 & 0.880 & 0.756 & 0.874 & 0.877 & 0.910 & & \
\hline 5 & 0.890 & 0.804 & 0.819 & 0.860 & 0.880 & 0.880 & \
\hline 6 & 0.851 & 0.786 & 0.896 & 0.784 & 0.792 & 0.792 & \
\hline 7 & 0.881 & 0.786 & 0.804 & 0.819 & & & \
\hline 8 & 0.804 & 0.819 & 0.860 & 0.880 & 0.773 & & 0.824 \
\hline 9 & 0.819 & 0.896 & 0.877 & 0.860 & 0.784 & 0.819 & 0.880 \
\hline 10 & 0.756 & 0.804 & 0.786 & 0.786 & 0.819 & 0.885 & \
\hline
\end{array}$
a. Construct a spreadsheet simulation model for this auction. Use a discrete uniform distribution between the minimum and maximum number of bidders in the 10 observed auctions to model the number of bidders in the Jackson Pollock auction. Fit a realistic distribution to the bid data to generate values of competing bid amounts. Use ASP to apply simulation optimization to determine the hedge fund's bid amount that maximizes the expected return = P(winning auction)*(185 - bid amount). Hint: Placing reasonable bounds on the highest and lowest possible bid amount will greatly assist the optimization algorithm.
b. What is the probability that the hedge fund wins the auction if it bids the amount that maximizes its expected return?

Question

A specialty hedge fund is considering the purchase of a Jackson Pollock painting. It estimates the value of the painting to be $185 million. In an auction, both the number of competing bids and the amount of the competing bids is uncertain. The hedge fund has maintained a file summarizing 10 recent art auctions that it believes are similar to the upcoming auction. It is considering a bid of $163 million and would like to evaluate its chances of winning the upcoming auction with this bid. $\begin{array}{|c|c|c|c|c|c|c|c|}
\text { Bid Amount (As Fraction of Estimated Share Value) }\
\hline \text { Company } & \mathbf{1} & \mathbf{2} & \mathbf{3} & \mathbf{4} & \mathbf{5} & \mathbf{6} & \mathbf{7} \
\hline 1 & 0.817 & 0.884 & 0.756 & & & & \
\hline 2 & 0.771 & 0.863 & 0.825 & 0.819 & 0.851 & 0.786 & \
\hline 3 & 0.804 & 0.851 & 0.786 & & & 0.851 & \
\hline 4 & 0.880 & 0.756 & 0.874 & 0.877 & 0.910 & & \
\hline 5 & 0.890 & 0.804 & 0.819 & 0.860 & 0.880 & 0.880 & \
\hline 6 & 0.851 & 0.786 & 0.896 & 0.784 & 0.792 & 0.792 & \
\hline 7 & 0.881 & 0.786 & 0.804 & 0.819 & & & \
\hline 8 & 0.804 & 0.819 & 0.860 & 0.880 & 0.773 & & 0.824 \
\hline 9 & 0.819 & 0.896 & 0.877 & 0.860 & 0.784 & 0.819 & 0.880 \
\hline 10 & 0.756 & 0.804 & 0.786 & 0.786 & 0.819 & 0.885 & \
\hline
\end{array}$ 
a. Construct a spreadsheet simulation model for this auction. Use a discrete uniform distribution between the minimum and maximum number of bidders in the 10 observed auctions to model the number of bidders in the Jackson Pollock auction. Fit a realistic distribution to the bid data to generate values of competing bid amounts. Use ASP to apply simulation optimization to determine the hedge fund's bid amount that maximizes the expected return = P(winning auction)*(185 - bid amount). Hint: Placing reasonable bounds on the highest and lowest possible bid amount will greatly assist the optimization algorithm.
b. What is the probability that the hedge fund wins the auction if it bids the amount that maximizes its expected return?

Quizplus · Accepted Answer

The Answer of A specialty hedge fund is considering the purchase of a Jackson Pollock painting. It estimates the value of the painting to be $185 million. In an auction, both the number of competing bids and the amount of the competing bids is uncertain. The hedge fund has maintained a file summarizing 10 recent art auctions that it believes are similar to the upcoming auction. It is considering a bid of $163 million and would like to evaluate its chances of winning the upcoming auction with this bid. $\begin{array}{|c|c|c|c|c|c|c|c|}
\text { Bid Amount (As Fraction of Estimated Share Value) }\
\hline \text { Company } & \mathbf{1} & \mathbf{2} & \mathbf{3} & \mathbf{4} & \mathbf{5} & \mathbf{6} & \mathbf{7} \
\hline 1 & 0.817 & 0.884 & 0.756 & & & & \
\hline 2 & 0.771 & 0.863 & 0.825 & 0.819 & 0.851 & 0.786 & \
\hline 3 & 0.804 & 0.851 & 0.786 & & & 0.851 & \
\hline 4 & 0.880 & 0.756 & 0.874 & 0.877 & 0.910 & & \
\hline 5 & 0.890 & 0.804 & 0.819 & 0.860 & 0.880 & 0.880 & \
\hline 6 & 0.851 & 0.786 & 0.896 & 0.784 & 0.792 & 0.792 & \
\hline 7 & 0.881 & 0.786 & 0.804 & 0.819 & & & \
\hline 8 & 0.804 & 0.819 & 0.860 & 0.880 & 0.773 & & 0.824 \
\hline 9 & 0.819 & 0.896 & 0.877 & 0.860 & 0.784 & 0.819 & 0.880 \
\hline 10 & 0.756 & 0.804 & 0.786 & 0.786 & 0.819 & 0.885 & \
\hline
\end{array}$ 
a. Construct a spreadsheet simulation model for this auction. Use a discrete uniform distribution between the minimum and maximum number of bidders in the 10 observed auctions to model the number of bidders in the Jackson Pollock auction. Fit a realistic distribution to the bid data to generate values of competing bid amounts. Use ASP to apply simulation optimization to determine the hedge fund's bid amount that maximizes the expected return = P(winning auction)*(185 - bid amount). Hint: Placing reasonable bounds on the highest and lowest possible bid amount will greatly assist the optimization algorithm.
b. What is the probability that the hedge fund wins the auction if it bids the amount that maximizes its expected return?

A Specialty Hedge Fund Is Considering the Purchase of a Jackson