In August 2007, a car dealer is trying to determine how many 2008 cars to order. Each car ordered in August 2007 costs $10,000. The demand for the dealer’s 2008 models has the probability distribution...

In August 2007, a car dealer is trying to determine how many 2008 cars to order. Each car ordered in August 2007 costs $10,000. The demand for the dealer’s 2008 models has the probability distribution shown in the file P11_12.xlsx. Each car sells for $15,000. If demand for 2008 cars exceeds the number of cars ordered in August, the dealer must reorder at a cost of $12,000 per car. Excess cars can be sold at $9000 per car. Use simulation to determine how many cars to order in August. For your optimal order quantity, find a 95% confidence interval for the expected profit.