Explore BrainMass

# Calculating mean profit and probability

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Develop a worksheet simulation for the following 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 \$30,000. The variable cost for the product is uniformly distributed between \$16 and \$24 per unit. The product will sell for \$50 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1200 units and a standard deviation of 300 units. Develop a spreadsheet simulation similar to Figure. Use 500 simulation trials to answer the following questions:

a. What is the mean profit for the simulation?
b. What is the probability the project will result in a loss?
c. What is your recommendation concerning the introduction of the product?

© BrainMass Inc. brainmass.com October 2, 2020, 3:42 am ad1c9bdddf
https://brainmass.com/statistics/probability/calculating-mean-profit-and-probability-505232

#### Solution Summary

Simulation utilizing Excel functions has been used for calculating mean profit and probability.

\$2.19