Answered: Based on information which option is…

Business

Operations Management

Based on information which option is the best option for the company?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
W. 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).
Play 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.
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.)
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.
Sunny Groves is a citrus grower in a southern state that has several citrus orchards. Weather forecasters are predicting a significant drop in temperatures over the next two days. The forecast calls for a 25% chance of near-freezing temperatures and a 10% chance of a deep freeze. The management of Sunny Groves is concerned that the impending bad weather may damage their crop of citrus fruit. If the weather is fine, the company stands to make 1,000,000 revenue for their harvest. There are three options that the company can take in light of the coming weather: 1. Do nothing and hope for the best. If the orchards experience near-freezing temperatures, the company will lose half of its crop (and half the revenue). A deep freeze would destroy all of the fruit (and lead to no revenue). Obviously, taking no precautions costs nothing. 2. Take moderate precautions. This involves having many workers placing heaters and warming tents about the orchards. This would cost $50,000 and reduce the…
Kroft Food Products is attempting to decide whether it should introduce a new line of salad dressings called Special Choices. The company can test market the salad dressings in selected geographic areas or bypass the test market and introduce the product nationally. The cost of the test market is $150,000. If the company conducts the test market, it must wait to see the results before deciding whether to introduce the salad dressings nationally. The probability of a positive test market result is estimated to be 0.6. Alternatively, the company can decide not to conduct the test market and go ahead and make the decision to introduce the dressings or not. If the salad dressings are introduced nationally and are a success, the company estimates that it will realize an annual profit of $1.6 million, whereas if the dressings fail, it will incur a loss of $700,000. The company believes the probability of success for the salad dressings is 0.50 if they are introduced without the test market.…
A soft drink company is considering launching a ‘seasonal soda’ that will be sold for a limited duration. They are considering selling the new soda X-Mist during the upcoming summer season. The company believes, based on its limited market analysis, that there is a 0.75 probability that X-Mist will have a successful summer season and have estimated that they will receive a profit of $4 million if it is successful. If X-Mist is not successful over the summer season, the company will incur a loss of $900,000. The firm Market-Strategies can do an extensive market analysis for a fee of $35,000. Market-Strategies has demonstrated that it is 90 percent reliable in its market analysis for soft drinks, i.e., a soda that will be successful in the market will be reported as ‘Successful’ by Market-Strategies with a probability 0.9 and a soda that will not be successful in the market will be reported as ‘Fail’ by Market-Strategies with a probability of 0.9. The soft drink company must decide…
Southern Gas Company (SGC) is preparing to make a bid for oil and gas leasing right in a newly opened drilling area in the Gulf of Mexico. SGC is trying to decide whether to place a high bid of $16 million or a low bid of $7 million. SGC expects to be bidding against its major competitor, Northern Gas Company (NGC) and predicts NGC to place a bid of $10 million with probability 0.4 or a bid of $6 million with probability 0.6. Geological data collected at the drilling site indicates a 0.15 probability of the reserves at the site being large, a 0.35 probability of being average, and a 0.50 probability of being unusable. A large or average reserve would most likely represent a net asset value of $120 million or $28 million, respectively, after all drilling and extraction costs are paid. The company that wins the bid will drill an exploration well at the site for a cost of $5 million. a. Develop a decision tree for this problem. b. What is the optimal decision according to the EMV…