Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
The number of hybrid cars that have be requested for rental from a car rental office during a 50 day sample period is given in the following table. Demand for Cars Number of Days Probability 3 3 0.06 4 7 0.14 5 12 0.24 6 14 0.28 7 10 0.20 8 4 0.08 50 1.00What is the expected (mean) number of hybrid rentals per day? Compute to one decimal place.
The operations manager for a water taxi company wants to decide whether to purchase a small, medium, or large new boat
for the company. The manager estimates that the annual profits (in thousands of dollars) will vary depending upon whether
passenger demand is low, moderate, or high, as shown in the following table.
ооо
Boat
none
Small
Medium
Low Medium
49
38
Large
Probability 0.3
Demand
21
60
82
53
0.3
High
68
90
118
If the company uses the expected value approach, which size boat will it decide to purchase?
small
medium
large
0.4
4. Vacation Inns is a chain of hotels operating in the southwestern part of the United States. The company
uses a toll-free telephone number to make reservations for any of its hotels. The average time to
handle each call is 3 minutes, and an average of 12 calls are received per hour. The probability
distribution that describes the arrivals is unknown. Over a period of time it is determined that the
average caller spends 6 minutes either on hold or receiving service. Find the average time in the
queue, the average time in the system, the average number in the queue, and the average number in
the system.
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 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.arrow_forwardAt the beginning of each week, a machine is in one of four conditions: 1 = excellent; 2 = good; 3 = average; 4 = bad. The weekly revenue earned by a machine in state 1, 2, 3, or 4 is 100, 90, 50, or 10, respectively. After observing the condition of the machine at the beginning of the week, the company has the option, for a cost of 200, of instantaneously replacing the machine with an excellent machine. The quality of the machine deteriorates over time, as shown in the file P10 41.xlsx. Four maintenance policies are under consideration: Policy 1: Never replace a machine. Policy 2: Immediately replace a bad machine. Policy 3: Immediately replace a bad or average machine. Policy 4: Immediately replace a bad, average, or good machine. Simulate each of these policies for 50 weeks (using at least 250 iterations each) to determine the policy that maximizes expected weekly profit. Assume that the machine at the beginning of week 1 is excellent.arrow_forwardIt 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.arrow_forward
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?arrow_forwardScenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?arrow_forwardYou 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_forward
- A software company recently designed and developed a new service for its customers. However, it needs to decide whether to launch the service next month or wait for six months. The company performs research and discovers the probability of success for both options, along with their potential revenue. It also learns the probability of failure and corresponding losses for each. *Option A: Launching the service next month has a 55% probability of success with potential revenue of $250,000. It has a 45% probability of failure with a potential loss of $125,000.* *Option B: Launching the service in six months has a 65% probability of success with potential revenue of $400,000. It has a 35% probability of failure with a potential loss of $200,000.* Which option should the company pursue?arrow_forwardA large steel manufacturing company has three options with regard to production: Produce commercially Build pilot plant Stop producing steel The management has estimated that their pilot plant, if built has 0.8 chance of high yield and 0.2 chance of low yield. If the pilot plant does show a high yield, management assigns a probability of 0.75 that the commercial plant will also have a high yield. If the pilot plant shows a low yield, there is only a 0.1 chance that the commercial plant will show a high yield. Finally, management’s best assessment of the yield on a commercial size plant without building a pilot plant first has 0.6 chance of high yield. A pilot plant will cost K300,000. The profits earned under high and low yield conditions are K12,000,000 and K1,200,000 respectively. Draw up an appropriate decision tree for the steel manufacturing company What is the company’s best strategy under EMV approacharrow_forwardThe XYZ manufacturing company is considering replacing one of its metal cutting machine which can be sold today for $3,000. If they kept this machine for 4 more years, its salvage value will be zero. The challenger costs $18,000, and its life is 4 years. The estimated salvage value of the challenger at the end of four years is $6,000. Should the XYZ company replace the old machine? Use the opportunity cost approach with rate of return of 10%. Assume operating costs per year for defender equals $2,000 and a saving in operating costs per year of 75% for challenger.arrow_forward
- Give proper and detailed explanationarrow_forwardThe Ramshead Pub sells a large quantity of beer every Saturday. From past sales records, the pub has determined the following probabilities for sales: Barrels Probability 6 .10 7 .20 8 .40 9 .25 10 .05 1 .00 Compute the expected number of barrels that will be sold on Saturday.arrow_forwardThe Astana airline always books more passengers on a flight than its capacity because of last minutes cancellations. The airline charges $835 per passenger from Almaty (Kazakhstan) to Frankfurt (Germany). However, due to overbooking, it asks a few passengers travelling more than the plane’s capacity to take another flight and offers a coupon of $350, including hotel, meal, etc. The experience has shown the following probability distribution corresponding to no-shows: Number of no-shows Probabillity 0 0.05 1 0.08 2 0.12 3 0.19 4 0.25 5 0.15 6 0.11 7 0.05 The airline hires you as a consultant because you have taken a course in supply chain management. What is the average number of no-shows based on the above distribution? How many overbookings should be made to minimize loss due to no shows, given the above probability distribution? Suppose you find out that last minute no-shows are normally distributed with a mean as determined in (a) above and a standard…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,Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
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