Please see the attached file for question. I am unable to get the correct answers as listed in my document even though I have the correct formula entered.

(See attached file for full problem description)
---
Develop a worksheet for this problem. Safety First is considering the introduction of a new product. The fixed cost is $30,000 to begin the production. The variable cost is uniformly distributed between $16 and $24 per unit. It will sell for $50 per unit Demand for this product is best described by a normal probability distribution with a mean of 1200 units & a std deviation of 300 units. Use 500 simulation trials to answer these questions:

1. What is the mean profit for the simulation? Answer is approx. $6,000; simulation results will vary with most simulations having a mean profit between $5,500 & $6,500.
2. What is the probability the project will remain in a loss? 120 to 150 of the 500 simulation trials should show a loss; so the probability of a loss should be between .24 & .30
3. What is your recommendation concerning the introduction of the project? This project appears to risky
---

Run the "Probability Theory in Decision Making" simulation and then ... The probabilities shown above represent the states of nature and the decision ...

8. Perform a hand simulation for the first three customers to arrive at a ticket booth to purchase a ticket. Discrete probability distributions for the two ...

... Explain how simulation can be used to estimate the probability the profit ... a. If the decision maker knows nothing about the probabilities of the four states ...

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

...probability Cumulative Call type Probability probability Not referred 0.25 0.25 Cumulative probability is calculated to set up the simulation Referred 0.75 1. ...

... Rental Probability Simulation Probability as per Sim prob Expected duration= Duration total simulation *duration 1 day 0.5 7 0.7 0.7 2 days 0.3 3 0.3 0.6 3 ...