Question
please help me in this Question. Its about simulation problem... you should do it in excel... The management of Madeira Manufacturing Company is considering the
please help me in this Question. Its about simulation problem... you should do it in excel...
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 $3000 The variable cost for the product is uniformly distributed between $16 and $24 per unit with most likely value of $20 per unit. The product will sell for $50 per unit. Demand for the product is expected to range from 300 to 2100 units, with 1200 units the most likely demand.
1-using 30 trials simulation to develop the profit model for this product.
2-compute the mean, min and max for profit
3-what is the probability of loss
4-provide the base case, worst case, best case, analysis in case of simulation and not simulation, compare between them.
5-discuss why simulation would be desirable.
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