Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
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 solutionStudents have asked these similar questions
Suppose you were preparing two-way tables of percentages for the following pairs of variables. How would you run the percentages?
Crime rate and unemployment rate
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?
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
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 - Assume that all of a companys job applicants must...Ch. 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_forwardYou 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_forward
- Based 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_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
- Discuss how likely it is that 70% of students will pass a college course with a B or an A. Then, consider the following questions: Would you look at data showing the success rate of previous courses? Would you check whether the current GPA of students in your class is high or low? What other data would you like to have before you determine the probability of 70% of students passing this course with a B or an A?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_forwardHow does the presence of uncertainty affect the usefulness of the model?arrow_forwardThe following table shows the number of televisions sold over the last ten years at a local electronic store. YEAR TV SALES 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. Use that formula to forecast television sales for years 11 and 12.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