Suppose that a small candy store makes Valentine's Day gift boxes that cost $$11\mathrm{.}25$ and sell for $$17\mathrm{.}00.$ In the past, at least $40$ boxes have been s any unsold boxes are discounted $50\%$ and are eventually sold. Set up and run a Monte Carlo simulation assuming that demand is triangular with $m$ and $50$ to identify the best order quantity. Use $20$ simulation trials.

Click the icon to view a sample of $220$ simulation trial results.

Say the values of the selling price, cost, and discount price are entered in cells $B6,B7,$ and $B8,$ respectively, and the demand, purchase quantity, the quantity sold is $=(B,B),$ the surplus quantity is $,$ and the profit is $=B{15}^{**}B,+B{16}^{**}B,-B{13}^{**}B($Type whole numbers. Use ascending order.$)$

Say the Monte Carlo simulation produced the provided simulation trial results. Use these results to determine the best order quantity.

The best order quantity is

$($Type a whole number.$)$