The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost
Fantastic news! We've Found the answer you've been seeking!
Question:
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b917e7d0c5_206667b917e5cab8.jpg)
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 $36,000. The variable cost for the product is uniformly distributed between $20 and $28 per unit. The product will sell for $56 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 100 units. Develop an Excelworksheet(see attachment for numbers)simulation for this problem. Use 500 simulation trials to answer the following questions:
- What is the mean profit for the simulation? Round your answer to the nearest dollar. Mean profit = ??$
- What is the probability that the project will result in a loss? Recalculate the numerical value of probability in percent and then round your answer to the nearest whole number. Probability of Loss = ??%
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667b917eb7887_206667b917ea3c7e.jpg)
Posted Date: