Answer the following question using $1000$ trials of simulation.

Consider the spreadsheet for a Newsvendor Model. What decision for purchase quantity results in the highest profit?

$$ A B C D E

$1$ Newsvendor Model $$ Historical Candy Sales $$

$250$

$3$ Data $45$

$440$

$5$ Selling price $$15\mathrm{.}0046$

$6$ Cost $$10\mathrm{.}0043$

$7$ Discount price $$5\mathrm{.}0043$

$8$Demand $46$

$942$

$10$Decision Variable $44$

$11$ Purchase Quantity $4843$

$1247$

$13$Model $41$

$14$ Quantity Sold $41$

$15$ Surplus Quantity $45$

$1651$

$17$ Profit $43$

$1845$

$1942$

$2044$

$2148$

$2242$

$2348$

$2443$

$2549$

$2650$

$35$

$45$

$55$

$65$