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?

... also predicts the nature of the individual based upon the calculated values ... a) Using excel, calculate the expected value of each project and identify the ...

... If you are calculating something using a table, the number ... she is taking 5 classes this semester, calculate the probability... 1. Let denotes the profit per game. ...

... a 0.60 probability of low attendance with profits of $45 ... stands pat, the expected value is calculated in following ... stand pat because the net profit is higher. ...

... (a) Calculate the expected profit under each promotion strategy (b) Calculate the standard deviation ... The solution calculates the standard deviation of the ...

... After calculating the expected present value of company's profit... First, we will calculate the expected value of ... Present Value of Company's Profit = +0.0*(25000 ...

... if conditions are good, and a profit of $300 ... The probability distribution of conditions follows: Conditions: Poor Good ... 40% 50% 10% (i) Calculate the expected ...

... conditions are poor, a profit of $45 if conditions are good, and a profit of $135 ... The probability distribution of conditions follows: ... i) Calculate the expected ...

... Your profits will also depend on whether you buy the equipment as follows: *Buy the bulldozer and the economy is good should yield a profit of $120K ...

... EXTRA CREDIT-Using the probabilities you calculated in problem ... on rounding, the numbers you calculate may be ... functions that are useful for calculating Z scores ...