Question
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
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 $20 and $25 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,200 units and a standard deviation of 200 units. Develop an Excel worksheet 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 = $ fill in the blank 1
- 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 = fill in the blank 2 %
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started