Practical Management Science, Loose-leaf Version
5th Edition
ISBN: 9781305631540
Author: WINSTON, Wayne L.; Albright, S. Christian
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Question
Chapter 10, Problem 49P
Summary Introduction
To explain: Whether correlation will play a significant role in the simulation in terms of realism.
Simulation modeling:
A simulation model is a computerized model that depicts or imitates a real-life situation. It is like other mathematical models except that it incorporates the concept of uncertainty in one or more number of the input variables.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Senior executives at an oil company are trying to decide whether to drill for oil in a particular field. It costs the company $750,000 to drill. The company estimates that if oil is found the estimated value will be $3,650,000. At present, the company believes that there is a 48% chance that the field actually contains oil.
Before drilling, the company can hire an expert at a cost of $75,000 to perform tests to make a prediction of whether oil is present. Based on a similar test, the probability that the test will predict oil on the field is 0.55. The probability of actually finding oil when oil was predicted is 0.85. The probability of actually finding oil when no oil was predicted is 0.2.
What is the EMV if the company hires the expert?
The average return for large-cap domestic stock funds over the three years 2009-2011 was 14.6%. Assume the three-year returns were normally distributed across funds with a standard deviation of 4.8%.
a. What is the probability an individual large-cap domestic stock fund had a three-year return of at least 20% (to 4 decimals)?
b. What is the probability an individual large-cap domestic stock fund had a three-year return of 10% or less (to 4 decimals)?
c. How big does the return have to be to put a domestic stock fund in the top 10% for the three-year period (to 2 decimals)?
%
Suppose that you work at a local food
manufacturer and are given the task of
investigating your company's seasonal sales
patterns over the past 10 years (2011 to
2020). After adjusting your sales values for
inflation, you calculate the following
seasonal sales averages (in millions):
Spring: 39
Summer: 46
Fall: 32
Winter: 23
Use this information to seasonally adjust
your 2021 Winter sales total of 29 million.
Round your answer to two decimal points
and omit any units (1.23 NOT $1.23 million).
Chapter 10 Solutions
Practical Management Science, Loose-leaf Version
Ch. 10.2 - Use the RAND function and the Copy command to...Ch. 10.2 - Use Excels functions (not @RISK) to generate 1000...Ch. 10.2 - Use @RISK to draw a uniform distribution from 400...Ch. 10.2 - Use @RISK to draw a normal distribution with mean...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - Use @RISK to draw a binomial distribution that...Ch. 10.2 - Use @RISK to draw a triangular distribution with...Ch. 10.2 - We all hate to keep track of small change. By...Ch. 10.4 - Prob. 11PCh. 10.4 - In August of the current year, a car dealer is...
Ch. 10.4 - Prob. 13PCh. 10.4 - Prob. 14PCh. 10.4 - Prob. 15PCh. 10.5 - If you add several normally distributed random...Ch. 10.5 - In Problem 11 from the previous section, we stated...Ch. 10.5 - Continuing the previous problem, assume, as in...Ch. 10.5 - In Problem 12 of the previous section, suppose...Ch. 10.5 - Use @RISK to analyze the sweatshirt situation in...Ch. 10.5 - Although the normal distribution is a reasonable...Ch. 10.6 - When you use @RISKs correlation feature to...Ch. 10.6 - Prob. 24PCh. 10.6 - Prob. 25PCh. 10.6 - Prob. 28PCh. 10 - Six months before its annual convention, the...Ch. 10 - Prob. 30PCh. 10 - A new edition of a very popular textbook will be...Ch. 10 - Prob. 32PCh. 10 - W. L. Brown, a direct marketer of womens clothing,...Ch. 10 - Prob. 34PCh. 10 - Lemingtons is trying to determine how many Jean...Ch. 10 - Dilberts Department Store is trying to determine...Ch. 10 - It is surprising (but true) that if 23 people are...Ch. 10 - Prob. 40PCh. 10 - At the beginning of each week, a machine is in one...Ch. 10 - Simulation can be used to illustrate a number of...Ch. 10 - Prob. 43PCh. 10 - Prob. 46PCh. 10 - If you want to replicate the results of a...Ch. 10 - Suppose you simulate a gambling situation where...Ch. 10 - Prob. 49PCh. 10 - Big Hit Video must determine how many copies of a...Ch. 10 - Prob. 51PCh. 10 - Prob. 52PCh. 10 - Why is the RISKCORRMAT function necessary? How...Ch. 10 - Consider the claim that normally distributed...Ch. 10 - Prob. 55PCh. 10 - When you use a RISKSIMTABLE function for a...Ch. 10 - Consider a situation where there is a cost that is...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- The game of Chuck-a-Luck is played as follows: You pick a number between 1 and 6 and toss three dice. If your number does not appear, you lose 1. If your number appears x times, you win x. On the average, use simulation to find the average amount of money you will win or lose on each play of the game.arrow_forwardSoftware development is an inherently risky and uncertain process. For example, there are many examples of software that couldnt be finished by the scheduled release datebugs still remained and features werent ready. (Many people believe this was the case with Office 2007.) How might you simulate the development of a software product? What random inputs would be required? Which outputs would be of interest? Which measures of the probability distributions of these outputs would be most important?arrow_forwardBased on Babich (1992). Suppose that each week each of 300 families buys a gallon of orange juice from company A, B, or C. Let pA denote the probability that a gallon produced by company A is of unsatisfactory quality, and define pB and pC similarly for companies B and C. If the last gallon of juice purchased by a family is satisfactory, the next week they will purchase a gallon of juice from the same company. If the last gallon of juice purchased by a family is not satisfactory, the family will purchase a gallon from a competitor. Consider a week in which A families have purchased juice A, B families have purchased juice B, and C families have purchased juice C. Assume that families that switch brands during a period are allocated to the remaining brands in a manner that is proportional to the current market shares of the other brands. For example, if a customer switches from brand A, there is probability B/(B + C) that he will switch to brand B and probability C/(B + C) that he will switch to brand C. Suppose that the market is currently divided equally: 10,000 families for each of the three brands. a. After a year, what will the market share for each firm be? Assume pA = 0.10, pB = 0.15, and pC = 0.20. (Hint: You will need to use the RISKBINOMLAL function to see how many people switch from A and then use the RISKBENOMIAL function again to see how many switch from A to B and from A to C. However, if your model requires more RISKBINOMIAL functions than the number allowed in the academic version of @RISK, remember that you can instead use the BENOM.INV (or the old CRITBENOM) function to generate binomially distributed random numbers. This takes the form =BINOM.INV (ntrials, psuccess, RAND()).) b. Suppose a 1% increase in market share is worth 10,000 per week to company A. Company A believes that for a cost of 1 million per year it can cut the percentage of unsatisfactory juice cartons in half. Is this worthwhile? (Use the same values of pA, pB, and pC as in part a.)arrow_forward
- You now have 5000. You will toss a fair coin four times. Before each toss you can bet any amount of your money (including none) on the outcome of the toss. If heads comes up, you win the amount you bet. If tails comes up, you lose the amount you bet. Your goal is to reach 15,000. It turns out that you can maximize your chance of reaching 15,000 by betting either the money you have on hand or 15,000 minus the money you have on hand, whichever is smaller. Use simulation to estimate the probability that you will reach your goal with this betting strategy.arrow_forwardPlay Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.arrow_forwardA salesperson uses three different airlines. The probabilities of switching from one airline to another in consecutive flights are shown below. If the last flight was on Delta, what is the probability that the next was on American? American Delta Southwest American 0.5 0.25 0.25 Delta 0.2 0.6 0.2 Southwest 0.3 0.3 0.4 A 0.5 B 0.2 C 0.25 D 0.6arrow_forward
- A GMAC MBA new-matriculants survey provided the following data for 2018 students. Excel File: data04-53.xlsx Applied to More Than One School Yes No 23 and under 207 201 24-26 299 379 Age Group 27-30 185 268 31-35 66 193 36 and over 51 169 a. Given that a person applied to more than one school, what is the probability that the person is 24 - 26 years old (to 2 decimals)? b. Given that a person is in the 36 and over age group, what is the probability that the person applied to more than one school (to 4 decimals)? c. What is the probability that a person is 24 - 26 years old or applied to more than one school (to 4 decimals)? d. Suppose a person is known to have applied to only one school. What is the probability that the person is 31 or more years old (to 4 decimals)? e. Is the number of schools applied to independent of age? Explain. Select your answer -arrow_forwardAn information will be having predictive value if it can assist to: a. Predict the past b. Predict the present c. Predict the environment d. Predict the futurarrow_forwardDo you agree that all students in tertiary level (college, university, etc.) need to take at least one statistics subject in their program? Explain why.arrow_forward
- What price do farmers get for their watermelon crops? In the third week of July, a random sample of 42 farming regions gave a sample mean of = $6.88 per 100 pounds of watermelon. Assume that σ is known to be $1.92 per 100 pounds. (a) Find a 90% confidence interval for the population mean price (per 100 pounds) that farmers in this region get for their watermelon crop (in dollars). What is the margin of error (in dollars)? (For each answer, enter a number. Round your answers to two decimal places.)lower limit $ upper limit $ margin of error $ (b) Find the sample size necessary for a 90% confidence level with maximal error of estimate E = 0.27 for the mean price per 100 pounds of watermelon. (Enter a number. Round up to the nearest whole number.) farming regions (c) A farm brings 15 tons of watermelon to market. Find a 90% confidence interval for the population mean cash value of this crop (in dollars). What is the margin of error (in dollars)? Hint: 1 ton is 2000…arrow_forwardCompcomm, Inc., is an international communications andinformation technology company that has seen the value ofits common stock appreciate substantially in recent years.A stock analyst would like to predict the stock prices ofCompcomm for an extended period with simulation. Basedon historical data, the analyst has developed the followingprobability distribution for the movement of Compcommstock prices per day:arrow_forwardA television network earns an average of $25 million each season from a hit program and loses an average of $8 million each season on a program that turns out to be a flop. Of all programs picked up by this network in recent years, 25% turn out to be hits and 75% turn out to be flops. At a cost of C dollars, a market research firm will analyze a pilot episode of a prospec- tive program and issue a report predicting whether the given programwill end up being a hit. If the program is actually going to be a hit, there is a 75% chance that the market researchers will predict the program to be a hit. If the program is actually going to be a flop, there is only a 30% chance that the market researchers will predict the program to be a hit.a. What is the maximum value of C that the network should be willing to pay the market research firm?b. Calculate and interpret EVPI for this decision problem.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License