The best order quantity

Jacey Morales 11/25/23 Foo PM Suppose that a small candy store makes Valentine's Day gift boxes that cost $1275 and sell for $190. In the past, at least 40 boxes have been sold by Day, but the is uncertain, and the owner has often run short or made too many After the holiday, any unsold boxes are discounted and are sold. set up and a Monte assuming that demand is triangular with minimum value = 40, maximum value = 50, and most likely value = 47. Find the distribution of profit for order quanttes between 40 and 50 to identify the 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 88. respective , and the demand, purchase quanbty, cells B12, B13, Bl 5. and B16, respectively Then, for the Monte carlo simulation, the quantity sold is the surplus (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.) Simulation Results 40 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $25000 $250.00 $25000 $250.00 $25000 $25000 $25000 $250.00 $25000 $25000 $25000 $25000 $25000 41 $25625 $25625 $25625 $256.25 $256.25 $256.25 $256.25 $256.25 $256.25 $25625 $256.25 $25625 $25625 $25625 $25625 $25625 $25625 $25625 $25625 $25625 42 $262.50 $26250 $262.50 $262.50 $262.50 $26260 $26260 $262.50 $26260 $262.50 $262.50 $262.50 $26260 $26260 $262 so $26260 $26260 $26260 $262 50 $26260 43 $24975 $26875 $259 25 $268.75 S26875 $26875 $268.75 $26875 $26875 $249.75 $268.75 $25925 $268.75 $26875 $26875 $25925 $26875 $268.75 $26875 $268.75 44 S27500 S265S0 S275.oo $275.00 $27500 $27500 $27500 $27500 $27500 $27500 $265S0 $27500 $27500 $27500 $27500 $27500 $27500 $275 oo $27500 45 S271.75 $26225 S28125 $26225 $28125 $24325 $281.25 $271.75 $26225 $271.75 $281.25 $281.25 $28125 $281.25 $27175 $281.25 $27175 $27175 $27175 $28125 S287.50 $287.50 S28Z50 $2V50 S27&00 S287S0 $287 so $287.50 S25900 S287S0 S249S0 $25900 $287 so $27&00 $287 so $25900 $287 so $287S0 $287 so $27800 47 S28425 S29375 S28425 529375 529375 S29375 S2B425 S29375 S29375 S29375 $27475 S27475 $29375 $27475 $23675 $293.75 $29375 S26525 $22725 $25575 48 S271S0 $281 oo soso $271 so S30000 $30000 524300 S28100 $30000 S25& 75 S28725 S28725 29675 90625 S24925 $249 25 $27775 $27775 50 S293S0 $24600 $265.00 $293.50 S28400 S26500 $25550 $303.00 $26500 $290 50 $290 50 $281 no $290.50 $271 so $26200 $26200 S281 oo $30000 $233S0 $290SO $26825 $26825 $28400 $26825 529350 $277.75 S27450 528725 S284no $29675 S293S0 $28725 S293S0 $28725 S274f0 S25875 S26500 524925 S236S0 $25875 $26500