Excel prob

A Car dealer believes that demand for a 2014 car model will be normally distributed with a mean of 200 and standard deviation of 30. His cost of receiving a car model is $25,000, and he sells it for $40,000. Half of all leftover cars can be sold for $30,000. He is considering ordering 200, 220,

240, 260, 280, or 300 models of that car. How many should he order?

Use excel sheet-

You might want to use these functions

Rand()

Vlookup

MIN

countif