Please state what exactly the answer is in the format given and how you get it,

Question

Please state what exactly the answer is in the format given and how you get it, thanks. Also, pls consider the answer on the question if it helps, the cross means wrong, tick means correct. I tried twice, so i attached both of the wrong answers below. the excel worksheet mentioned below can be found here. https://drive.google.com/file/d/0BwRTtt2PMBD3X2htdlREN0RxckE/view?usp=sharing

Problem 12-14 (Algorithmic) 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 $35,000. The variable cost for the product is uniformly distributed between $17 and $23 per unit. The product will sell for $55 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1,300 units and a standard deviation of 300 units. Develop an Excel worksheet simulation for this problem. Use 500 simulation trials to answer the following questions: a. What is the mean profit for the simulation? Round your answer to the nearest dollar. Mean profit = $ 75400 X b. 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 = | 0.2040 | X 96 c. What is your recommendation concerning the introduction of the product? The input in the box below will not be graded, but may be reviewed and considered by your instructor.

Explanation / Answer

The mean profit for the simulation is 10242$

Probability of loss=17%

Since the probability of loss is very low, the introduction of the product should be benificial.

Here is the attached excel file:

https://drive.google.com/file/d/0B5GF0YjRTNDRRTBEMEkyOFRBYmM/view?usp=sharing

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---