Question: Develop a worltsheet simulation for the following problem. The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost


Develop a worltsheet 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 dollars. The variable cost for the product is uniformly distributed between to anti 24 dollars per unit. The product will sell for 50 dollars per unit. Demand for the product is best described by a normal probability distribution with a mean of i 200 units and a standard deviation of 300 units. Develop a spreadsheet simulation similar to the example given during our synchronous session. Use 500 simulation trials to answer the following questions: a. What is the mean profit forthe simulation? b. What is the probability the project will result in a loss? c. What is the probability the project will result in a prot? d. What is your recommendation concerning the introduction ofthe product? Note: create an Excel model solution worksheet based on the given problem. Attached a copy of your excel file for your submission
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
