Problem
The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $34,000. The variable cost for the product is uniformly distributed between $18 and $25 per unit. The product will sell for $54 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1,200 units and a standard deviation of 200 units. Develop an Excel worksheet simulation for this problem. Use 500 simulation trials to answer the following questions: What is the mean profit for the simulation?