Purchase Solution

Simulation using Crystal Ball / OptQuest

Not what you're looking for?

Ask Custom Question

This problem requires the use "Crystal Ball", the popular commercial spreadsheet add-in. For clarity, it is distributed by Decisioneering, Inc. This problem specifically requires that Excel and "Crystal Ball" (and OptQuest as applicable) be used - and not any other software choices. The link below directs you to a free 7-day trial: http://www.decisioneering.com/downloadform.html

Question:
Jim Jarrington owns a magazine stand at the Ovalstone business center in Roanoke, Virginia. He buys his magazines wholesale at $0.50 per magazine and sells them for $0.75. Jim has wondered about the optimal number of magazines to order each day. Based on history, he has found that demand (even though it is discrete) can be modeled by a normal distribution with a mean of 50 and standard deviation of 5. When he has more magazines than customers, he can recycle all the extra magazines the next day and receive $0.05 per magazine. On the other hand, if he has more customers than magazines, he loses some goodwill in addition to the lost profit on the potential sale of $0.25. Jim estimates the incremental lost goodwill costs five days' worth of business (that is, dissatisfied customers will go to a competitor the next week, but come back to the week after that).

Part A:
Create a spreadsheet model to determine the optimal number of magazines to order each day. Use 500 replications and round the demand values generated by the normal random number generator (RNG) to the closest integer value.

Part B:
Construct a 95% confidence interval for the expected payoff from the optimal decision.

Note: Please provide an explanation, so the student is able to understand the logic and application of the logic within the context of this problem and the software used.

Purchase this Solution
Solution Summary

A simulation using Crystal Ball is investigated. The solution is detailed and well presented. The response received a rating of "5/5" from the student who originally posted the question.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Spreadsheet simulation using Excel

    We MUST use Excel's simulation/optimization capabilites. Or, we can use an add-in to Excel called Crystal Ball/OptQuest.

  • excel simulation model

    218569 Excel simulation model using crystal ball sensitivity I am having a hard time getting this set up. Any help would be appreciated. I know how to get Crystal Ball to run..but have problems doing the initial spreadsheet setup.

  • Portfolio expected return & risk analysis using crystal Ball

    Using the frequency charts for the simulation runs in Crystal Ball determine which combination of investments would result in the greatest probability of receiving return of $120,000 or greater. Solve the following exercise using Crystall Ball.

  • Monte Carlo and Crystal Ball

    Process for Using Crystal Ball to Run a Monte Carlo Simulation In order to use Crystal ball for running Monte Carlo Simulation, an individual is required to establish the framework and design goals for the project.

  • Bijoux LeMonde-Crystal Ball Simulation decision-model

    So it is a good learning exercise for the students on decision analysis using crystal ball.

  • Crystal ball simulation

    87776 Crystal Ball Simulation Old problem with a new twist. Demand and not P&l is the variable. Demand for each quarter. Problem: difficulty in presenting these variables to run the program. Jewelry price changed as well.

  • Excel Financial Model / Mean Values

    Develop a risk profile of net income using Excel. (Model check: net income should be $110,000 for year 1 and $144,360.62 for year 5) See the attached file. I have used simple Excel as well as crystal ball simulation for your help.

  • How to set up simulated dice rolling in Excel.

    To perform this simulation, we must use Excel on its own, or Crystal Ball (simulation software add-in for excel). How do I set this up in Excel? Would I have to use like a random # generator to simulate a random 50 throws of the dice???

  • WalMart simulation re-order point

    Part A: Using the assumptions given below develop an Excel/Crystal Ball simulation and recommend an inventory policy for ordering Flat Panel TVs from their suppliers that would minimize the costs mentioned above.

View More Related Solutions