Subject : Linear regression question In August of the current year, a car dealer is trying to determine how many cars of the next model year to...

Subject : Linear regression question

In August of the current year, a car dealer is trying to determine how many cars of the next model year to order. Each car ordered in August costs $20,000. The demand for the dealer's next year models has the probability distribution shown in the file attached.xlsx. Each car sells for $25,000. If demand for the next year's cars exceeds the number of cars ordered in August, the dealer must reorder at a cost of $22,000 per car. Excess cars can be disposed of at $17,000 per car.

Please use simulation to determine how many cars to order in August. For your optimal order quantity, find a 95% confidence interval for the order quantity of 30.