OuRx, a retail pharmacy chain, is faced with the decision of how much flu vaccine to order for the next flu season. OuRx

[answerhappygod]

OuRx, a retail pharmacy chain, is faced with the decision of how
much flu vaccine to order for the next flu season. OuRx has to
place a single order for the flu vaccine several months before the
beginning of the season because it takes four to five months for
the supplier to create the vaccine. OuRx wants to more closely
examine the ordering decision because, over the past few years, the
company has ordered too much vaccine or too little. OuRx pays a
wholesale price of $12 per dose to obtain the flu vaccine from the
supplier and then sells the flu shot to their customers at a retail
price of $20. Because OuRx earns a profit on flu shots that it
sells and it can’t sell more than its supply, the appropriate
profit computation depends on whether demand exceeds the order
quantity or vice versa. Similarly, the number of lost sales and
excess doses depends on whether demand exceeds the order quantity
or vice versa. Demand for the flu vaccine is uncertain.
I want you to determine the optimal production quantity for the
vaccine (i.e., the quantity that maximizes average profit) if the
vaccine demand is assumed to follow a normal distribution with a
mean of 1,500,000 doses and a standard deviation of 250,000 doses.
Once you determine the optimal production quantity, I would like
you to use your simulation results to construct a 95% confidence
interval for mean profit and to estimate the probability that the
vaccines will run out if you produce that optimal quantity.
How do I do this in Excel step by step? Will thumbs up!