Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Choose 1,000 iterations for each simulation. Instead of the triangular distribution, change it to a normal distribution with mean of 15 and standard deviation of
Choose 1,000 iterations for each simulation. Instead of the triangular distribution, change it to a normal distribution with mean of 15 and standard deviation of 5. All samples from a normal distribution should be integers and non-negative. In separate worksheets in the same file, create the Results Summary report and the Statistics report. In the Results Summary worksheet, highlight the recommended simulation.
3. The Donaldson Game Co. orders boxes of collectable game cards for $60 per box. They sell boxes of cards for $100 per box. A new series of cards is expected in February and they plan to place boxes of the current cards on sale for $50 per box in January. Any unsold boxes after January are donated to a game convention. A review of historic sales of the cards yielded a normal distribution with a mean of 200 boxes and a standard deviation of 30. Sales at the discounted price in January are estimated to be a triangular distribution with a minimum value of 10 boxes, most likely of 15 boxes, and a maximum of 40 boxes. The alternative order you can consider is listed in the following table: Alternatives 150 175 Use @Risk to solve with 1000 iterations for 6 alternative orders. a. The Donaldson Game Co. would like to maximize its mean prot How many should it order? b. Show the @RISK Output Results. c. Show the @RISK Detailed StatisticsStep 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