Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 11, Problem 56P
A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs will cover the fixed cost of the equipment. Suppose a company must make such a decision for a four-year time horizon, given the following data. Use simulation to estimate the probability that producing in house is better than outsourcing.
- If the company outsources production, it will have to purchase the product from the manufacturer for $25 per unit. This unit cost will remain constant for the next four years.
- The company will sell the product for $42 per unit. This price will remain constant for the next four years.
- If the company produces the product in house, it must buy a $500,000 machine that is
depreciated on a straight-line basis over four years, and its cost of production will be $9 per unit. This unit cost will remain constant for the next four years. - The demand in year 1 has a worst case of 10,000 units, a most likely case of 14,000 units, and a best case of 16,000 units.
- The average annual growth in demand for years 2-4 has a worst case of 7%, a most likely case of 15%, and a best case of 20%. Whatever this annual growth is, it will be the same in each of the years.
- The tax rate is 35%.
- Cash flows are discounted at 8% per year.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionChapter 11 Solutions
Practical Management Science
Ch. 11.2 - If the number of competitors in Example 11.1...Ch. 11.2 - In Example 11.1, the possible profits vary from...Ch. 11.2 - Referring to Example 11.1, if the average bid for...Ch. 11.2 - See how sensitive the results in Example 11.2 are...Ch. 11.2 - In Example 11.2, the gamma distribution was used...Ch. 11.2 - Prob. 6PCh. 11.2 - In Example 11.3, suppose you want to run five...Ch. 11.2 - In Example 11.3, if a batch fails to pass...Ch. 11.3 - Rerun the new car simulation from Example 11.4,...Ch. 11.3 - Rerun the new car simulation from Example 11.4,...
Ch. 11.3 - In the cash balance model from Example 11.5, the...Ch. 11.3 - Prob. 12PCh. 11.3 - Prob. 13PCh. 11.3 - The simulation output from Example 11.6 indicates...Ch. 11.3 - Prob. 15PCh. 11.3 - Referring to the retirement example in Example...Ch. 11.3 - A European put option allows an investor to sell a...Ch. 11.3 - Prob. 18PCh. 11.3 - Prob. 19PCh. 11.3 - Based on Kelly (1956). You currently have 100....Ch. 11.3 - Amanda has 30 years to save for her retirement. At...Ch. 11.3 - In the financial world, there are many types of...Ch. 11.3 - Suppose you currently have a portfolio of three...Ch. 11.3 - If you own a stock, buying a put option on the...Ch. 11.3 - Prob. 25PCh. 11.3 - Prob. 26PCh. 11.3 - Prob. 27PCh. 11.3 - Prob. 28PCh. 11.4 - Prob. 29PCh. 11.4 - Seas Beginning sells clothing by mail order. An...Ch. 11.4 - Based on Babich (1992). Suppose that each week...Ch. 11.4 - The customer loyalty model in Example 11.9 assumes...Ch. 11.4 - Prob. 33PCh. 11.4 - Suppose that GLC earns a 2000 profit each time a...Ch. 11.4 - Prob. 35PCh. 11.5 - A martingale betting strategy works as follows....Ch. 11.5 - The game of Chuck-a-Luck is played as follows: You...Ch. 11.5 - You have 5 and your opponent has 10. You flip a...Ch. 11.5 - Assume a very good NBA team has a 70% chance of...Ch. 11.5 - Consider the following card game. The player and...Ch. 11.5 - Prob. 42PCh. 11 - You now have 5000. You will toss a fair coin four...Ch. 11 - You now have 10,000, all of which is invested in a...Ch. 11 - Suppose you have invested 25% of your portfolio in...Ch. 11 - Prob. 47PCh. 11 - Based on Marcus (1990). The Balboa mutual fund has...Ch. 11 - Prob. 50PCh. 11 - Prob. 52PCh. 11 - The annual demand for Prizdol, a prescription drug...Ch. 11 - Prob. 54PCh. 11 - The DC Cisco office is trying to predict the...Ch. 11 - A common decision is whether a company should buy...Ch. 11 - Suppose you begin year 1 with 5000. At the...Ch. 11 - You are considering a 10-year investment project....Ch. 11 - Play Things is developing a new Lady Gaga doll....Ch. 11 - An automobile manufacturer is considering whether...Ch. 11 - It costs a pharmaceutical company 75,000 to...Ch. 11 - Prob. 65PCh. 11 - Rework the previous problem for a case in which...Ch. 11 - Prob. 68PCh. 11 - The Tinkan Company produces one-pound cans for the...Ch. 11 - Prob. 70PCh. 11 - In this version of dice blackjack, you toss a...Ch. 11 - Prob. 76PCh. 11 - It is January 1 of year 0, and Merck is trying to...Ch. 11 - Suppose you are an HR (human resources) manager at...Ch. 11 - You are an avid basketball fan, and you would like...Ch. 11 - Suppose you are a financial analyst and your...Ch. 11 - Software development is an inherently risky and...Ch. 11 - Health care is continually in the news. Can (or...
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
- If you want to replicate the results of a simulation model with Excel functions only, not @RISK, you can build a data table and let the column input cell be any blank cell. Explain why this works.arrow_forwardAssume a very good NBA team has a 70% chance of winning in each game it plays. During an 82-game season what is the average length of the teams longest winning streak? What is the probability that the team has a winning streak of at least 16 games? Use simulation to answer these questions, where each iteration of the simulation generates the outcomes of all 82 games.arrow_forwardSix months before its annual convention, the American Medical Association must determine how many rooms to reserve. At this time, the AMA can reserve rooms at a cost of 150 per room. The AMA believes the number of doctors attending the convention will be normally distributed with a mean of 5000 and a standard deviation of 1000. If the number of people attending the convention exceeds the number of rooms reserved, extra rooms must be reserved at a cost of 250 per room. a. Use simulation with @RISK to determine the number of rooms that should be reserved to minimize the expected cost to the AMA. Try possible values from 4100 to 4900 in increments of 100. b. Redo part a for the case where the number attending has a triangular distribution with minimum value 2000, maximum value 7000, and most likely value 5000. Does this change the substantive results from part a?arrow_forward
- You now have 10,000, all of which is invested in a sports team. Each year there is a 60% chance that the value of the team will increase by 60% and a 40% chance that the value of the team will decrease by 60%. Estimate the mean and median value of your investment after 50 years. Explain the large difference between the estimated mean and median.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_forwardW. L. Brown, a direct marketer of womens clothing, must determine how many telephone operators to schedule during each part of the day. W. L. Brown estimates that the number of phone calls received each hour of a typical eight-hour shift can be described by the probability distribution in the file P10_33.xlsx. Each operator can handle 15 calls per hour and costs the company 20 per hour. Each phone call that is not handled is assumed to cost the company 6 in lost profit. Considering the options of employing 6, 8, 10, 12, 14, or 16 operators, use simulation to determine the number of operators that minimizes the expected hourly cost (labor costs plus lost profits).arrow_forward
- The DC Cisco office is trying to predict the revenue it will generate next week. Ten deals may close next week. The probability of each deal closing and data on the possible size of each deal (in millions of dollars) are listed in the file P11_55.xlsx. Use simulation to estimate total revenue. Based on the simulation, the company can be 95% certain that its total revenue will be between what two numbers?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_forwardAssume that all of a companys job applicants must take a test, and that the scores on this test are normally distributed. The selection ratio is the cutoff point used by the company in its hiring process. For example, a selection ratio of 25% means that the company will accept applicants for jobs who rank in the top 25% of all applicants. If the company chooses a selection ratio of 25%, the average test score of those selected will be 1.27 standard deviations above average. Use simulation to verify this fact, proceeding as follows. a. Show that if the company wants to accept only the top 25% of all applicants, it should accept applicants whose test scores are at least 0.674 standard deviation above average. (No simulation is required here. Just use the appropriate Excel normal function.) b. Now generate 1000 test scores from a normal distribution with mean 0 and standard deviation 1. The average test score of those selected is the average of the scores that are at least 0.674. To determine this, use Excels DAVERAGE function. To do so, put the heading Score in cell A3, generate the 1000 test scores in the range A4:A1003, and name the range A3:A1003 Data. In cells C3 and C4, enter the labels Score and 0.674. (The range C3:C4 is called the criterion range.) Then calculate the average of all applicants who will be hired by entering the formula =DAVERAGE(Data, "Score", C3:C4) in any cell. This average should be close to the theoretical average, 1.27. This formula works as follows. Excel finds all observations in the Data range that satisfy the criterion described in the range C3:C4 (Score0.674). Then it averages the values in the Score column (the second argument of DAVERAGE) corresponding to these entries. See online help for more about Excels database D functions. c. What information would the company need to determine an optimal selection ratio? How could it determine the optimal selection ratio?arrow_forward
- Based on Kelly (1956). You currently have 100. Each week you can invest any amount of money you currently have in a risky investment. With probability 0.4, the amount you invest is tripled (e.g., if you invest 100, you increase your asset position by 300), and, with probability 0.6, the amount you invest is lost. Consider the following investment strategies: Each week, invest 10% of your money. Each week, invest 30% of your money. Each week, invest 50% of your money. Use @RISK to simulate 100 weeks of each strategy 1000 times. Which strategy appears to be best in terms of the maximum growth rate? (In general, if you can multiply your investment by M with probability p and lose your investment with probability q = 1 p, you should invest a fraction [p(M 1) q]/(M 1) of your money each week. This strategy maximizes the expected growth rate of your fortune and is known as the Kelly criterion.) (Hint: If an initial wealth of I dollars grows to F dollars in 100 weeks, the weekly growth rate, labeled r, satisfies F = (I + r)100, so that r = (F/I)1/100 1.)arrow_forwardYou have 5 and your opponent has 10. You flip a fair coin and if heads comes up, your opponent pays you 1. If tails comes up, you pay your opponent 1. The game is finished when one player has all the money or after 100 tosses, whichever comes first. Use simulation to estimate the probability that you end up with all the money and the probability that neither of you goes broke in 100 tosses.arrow_forwardSimulation can be used to illustrate a number of results from statistics that are difficult to understand with nonsimulation arguments. One is the famous central limit theorem, which says that if you sample enough values from any population distribution and then average these values, the resulting average will be approximately normally distributed. Confirm this by using @ RISK with the following population distributions (run a separate simulation for each): (a) discrete with possible values 1 and 2 and probabilities 0.2 and 0.8; (b) exponential with mean 1 (use the RISKEXPON function with the single argument 1); (c) triangular with minimum, most likely, and maximum values equal to 1,9, and 10. (Note that each of these distributions is very skewed.) Run each simulation with 10 values in each average, and run 1000 iterations to simulate 1000 averages. Create a histogram of the averages to see whether it is indeed bell-shaped. Then repeat, using 30 values in each average. Are the histograms based on 10 values qualitatively different from those, based on 30?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