Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed
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 Statistics

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra With Applications

Authors: Gareth Williams

7th Edition

0763790923, 9780763790929

More Books

Students also viewed these Mathematics questions

Question

What are some common ways e-business fraud is perpetrated?

Answered: 1 week ago