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
Manufacture of a certain component requires three different machining operations. Machining time for each operation has a normal distribution, and the three times are independent of one another.
The mean values are 20, 30, and 15 min, respectively, and the standard deviations are 1, 2, and 1.9 min, respectively. What is the probability that it takes at most 1 hour of machining time to
produce a randomly selected component? (Round your answer to four decimal places.)
establish the significance of random numbers in Monte Carlo simulations.
A large building may require an automated alarm system which monitors and controls all fire and security alarms in the building. Normally, the building is divided into zones and a number of alarms are associated with each zone. Alarms alert a central manned control area who may pass these on to the emergency services or may respond personally.Factors which have to be taken into account in building such a system are:Ø If the control area is unmanned and an alarm is activated this alarm should not be ignored if it is potentially serious. Emergency services should be automatically called.Ø Some but not all parts of the building may be equipped with sprinkler systems or systems to shut down electrical equipment. These should be activated if a fire alarm is confirmed. They should not be activated if there are people in the same room.Ø The building may be equipped with direction indicators which illuminate the route to the nearest exit. These should be activated when a fire alarm is…
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
- 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.arrow_forwardIn this version of dice blackjack, you toss a single die repeatedly and add up the sum of your dice tosses. Your goal is to come as close as possible to a total of 7 without going over. You may stop at any time. If your total is 8 or more, you lose. If your total is 7 or less, the house then tosses the die repeatedly. The house stops as soon as its total is 4 or more. If the house totals 8 or more, you win. Otherwise, the higher total wins. If there is a tie, the house wins. Consider the following strategies: Keep tossing until your total is 3 or more. Keep tossing until your total is 4 or more. Keep tossing until your total is 5 or more. Keep tossing until your total is 6 or more. Keep tossing until your total is 7 or more. For example, suppose you keep tossing until your total is 4 or more. Here are some examples of how the game might go: You toss a 2 and then a 3 and stop for total of 5. The house tosses a 3 and then a 2. You lose because a tie goes to the house. You toss a 3 and then a 6. You lose. You toss a 6 and stop. The house tosses a 3 and then a 2. You win. You toss a 3 and then a 4 for total of 7. The house tosses a 3 and then a 5. You win. Note that only 4 tosses need to be generated for the house, but more tosses might need to be generated for you, depending on your strategy. Develop a simulation and run it for at least 1000 iterations for each of the strategies listed previously. For each strategy, what are the two values so that you are 95% sure that your probability of winning is between these two values? Which of the five strategies appears to be best?arrow_forwardDuring an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.arrow_forward
- The annual maintenance costs of a machine that has been in use for 3 years are 300 TL, 350 TL and 375 TL, respectively. The machine is expected to be available for 8 years after purchase. The maintenance costs foreseen for the coming years are 400 TL in the first year and 150 TL in the following years. If the machine is sold today, it can be sold for 1500 TL, and in the following years for 1000 TL. What is the optimum regeneration time of the machine if the MCVO is 10%?arrow_forwardLarry Ellison starts a company that manufactures high-end custom leather bags. He hires two employees. Each employee only begins working on a bag when a customer order has been received and then she makes the bag from beginning to end. The average production time of a bag is 1.7 days, with a standard deviation of 3 days. Larry expects to receive one customer order per day on average. The interarrival times of orders have a coefficient of variation of one. X Answer Is complete but not entirely correct. (Carry at least 4 decimal places in all intermediate calculations. Round your final answer to 2 decimal places.) What is the expected duration, in days, between when an order is received and when production begins on the bag? 30.39 8 daysarrow_forwardGraph and Solve. Kindly show the probabilities and explain how to solve this question. The time between arrival of customers at the drive-up window of a bank follows an exponential distribution with mean of 8 minutes. a.What is the probability that arrival time between customers will be 10 minutes or less? b.What is the probability that arrival time between customers will be between 5 and 9 minutes?arrow_forward
- - Mom-and-Pop’s Grocery Store has a small adjacent parking lot with three parkingspaces reserved for the store’s customers. During store hours, cars enter the lot and useone of the spaces at a mean rate of 2 per hour. For n = 0, 1, 2, 3, the probability Pn that exactly n spaces currently are being used is P0 = 0.1, P1 = 0.2, P2 = 0.4, P3 = 0.3. - Midtown Bank always has two tellers on duty. The Customers arrive at checkouts at an average rate of 40 per hour. A cashier requires an average of 2 minutes to serve a customer. When both cashiers are busy, arriving customer joins a queue and wait to be served. From experience it is known that customers They wait in line for an average of 1 minute before going to the checkout. a) Describe why this is a waiting line system Mention the queuing model that can be implemented for the analysis (notation of Kendall) and why that model was chosenarrow_forward4. Mom-and-Pop's Grocery Store has a small adjacent parking lot with three parking spaces reserved for the store's customers. During store hours, cars enter the lot and use one of the spaces at a mean rate of 2 per hour. If there is no parking space available, the car just leaves without waiting. For n = 0, 1, 2, 3, the probability Pn that exactly n spaces currently are being used is Po = 0.1, P₁ = 0.2, P₂ = 0.4, P3 = 0.3. (a) This parking lot can be interpreted as being a queueing system. Identify the customers and the servers. What constitutes a service time? What is the queue capacity? (b) Determine the basic measures of performance-L, Lq, W, and Wa-for this queueing system. (c) Use the results from part (b) to determine the average length of time that a car remains in a parking space. (d) Find p, the utilization factor.arrow_forwardAdele Weiss manages the campus flower shop. Flowers must be ordered three days in advance from her supplier in Mexico. Although Valentine’s Day is fast approaching, sales are almost entirely last-minute, impulse purchases. Advance sales are so small that Weiss has no way to estimate the probability of low (25 dozen), medium (60 dozen), or high (130 dozen) demand for red roses on the big day. She buys roses for $15 per dozen and sells them for $40 per dozen. Construct a payoff table. Which decision is indicated by each of the following decision criteria?a. Maximinb. Maximaxc. Laplaced. Minimax regretarrow_forward
- The school of business has 3 fax machines. The toner in each machine needs to be changed after about 5 hours of use. There is one unit secretary who is responsible for the fax machine maintenance. It takes him 15 minutes to replace the toner cartridge. What is the probability the system is empty?arrow_forwardJankord Jewelers permits the return of their diamond wedding rings, provided the return occurs within two weeks. Typically, 20 percent are returned. If nine rings are sold today, what is the probability that fewer than four will be returned? A- 0.914 B- 0.962 C- 0.923 D- 0.935arrow_forwardIf events X and Y are mutually exclusive then A- P(X)P(Y) = 0 B- they are independent events C- their joint probability is zero D- P(X)P(Y) = P(X | Y)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,