1.)Based on your solution, what formula should go in cell B20 to determine the quantity of decorations sold based on the demand?

None of these answers

=B17

=MAX(B17,B18)

=MIN(B17,B18)

2.)Based on your solution, which cell represents an uncertain input?

B8

B18

B6

B14

3.)

Based on your solution assuming an order quantity of 40 boxes and doing 1,000 iterations. What is the average profit?

A store is getting ready for Valentine's day and needs to purchase Valentine's day decorations, which will be sold prior to the holiday. The store has not yet found a supplier for the decorations yet, but has done some market research. Based on that research they anticipate a 30% chance that they can get the decorations for $8.50 per box, a 60% chance they can get the decorations for $10 per box, and a 10% chance that they will have to pay $13 per box. Due to the high demand leading up to Valentine's day, the decorations are sold at $15 per box. However, after the holiday, these decorations will have to be marked down in order to sell them all. It is uncertain what average sales price will ensure that all the leftoer decorations are sold. Based on market forecasts, the average sale price that will clear out the leftovers is equally likely to be any price between $6.50 and $13.50 per box. Demand prior to the holiday is expected to be normally distributed with a mean of 40 boxes and a standard deviation of 10 boxes. Please use the following Excel to determine how many decorations the store should prepurchase to maximize their expected profit