Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 10.2, Problem 1P
Use the RAND function and the Copy command to generate 100 random numbers.
- a. What fraction of the random numbers are smaller than 0.5?
- b. What fraction of the time is a random number less than 0.5 followed by a random number greater than 0.5?
- c. What fraction of the random numbers are larger than 0.8?
- d. Freeze these random numbers. However, instead of pasting them over the original random numbers, paste them onto a new range. Then press the F9 recalculate key. The original random numbers should change, but the pasted copy should remain the same.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Since the end of World War II, globalization has steadily increased with rapid expansion around the turn of the 21st century. What are some of the forces driving globalization and international business? What are some of the challenges of engaging in international business compared to doing business in your home country?
PS.53 Brother I.D. Ricks is a faculty member at BYU-Idaho whose grandchildren live in Oklahoma and California. He and his wife would like to visit their grandchildren at least once a year in these states. They currently have one vehicle with well over 100,000 miles on it, so they want to buy a newer vehicle with fewer miles and that gets better gas mileage. They are considering two options: (1) a new subcompact car that would cost $18,750 to purchase or (2) a used sedan that would cost $12,750.They anticipate that the new subcompact would get 37 miles per gallon (combined highway and around town driving) while the sedan would get 26 miles per gallon. Based on their road tripping history they expect to drive 13,000 miles per year. For the purposes of their analysis they are assuming that gas will cost $2.93 per gallon.Question: How many miles would the Ricks need to drive before the cost of these two options would be the same? (Display your answer to the nearest whole number.)
(Hint:…
Choose one major approach to job design, and then discuss how best that approach can be utilized in either your current or previous employer, including a discussion of its strengths and weaknesses.
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 results of your four plans will provide an indicative EOQ value. State this value and discuss in a precise manner, why it is not the exact, true value. Additional calculations in the form of plans E, F etc. may also assist your explanation of the EOQ and can be includedarrow_forwardi). Complete the table assuming a Level production plan. ii) Comment on your results and explain whether at this stage, you consider a Level plan is a suitable approach for this particular business. Your comment should include reference to a calculated ‘fill rate’.arrow_forwardIn the following sawtooth inventory profile diagram, two inventory plans with different order quantities (Q) and different frequencies of delivery are shown; order quantity for Plan A = 200 units and Plan B = 50 units. i). Total demand (D) is 350 units, the holding cost per unit (Ch) is equal to (£0.8) and the ordering cost per order (Co) is (£12.5). Calculate the total costs for each plan and state which one is more preferable along with the reason why. ii). There is a stark difference in the composition of the total costs of Plans A and B. Explain this difference and why it occurs. Use the breakdown of costs for each plan to help illustrate your answer.arrow_forward
- i). Complete the table for a Chase production plan. ii). Explain whether a Level or Chase plan is more suitable for the demand pattern experienced by this particular business, which incidentally relies on highly skilled workers in the production process. Assume a starting workforce of 7 and that fractional workers are permissible. You should support your answer with numerical data derived from Table 3. In comparing the costs, state any other assumptions made.arrow_forwardi). Complete for a Chase production plan. ii). Explain whether a Level or Chase plan is more suitable for the demand pattern experienced by this particular business, which incidentally relies on highly skilled workers in the production process. Assume a starting workforce of 7 and that fractional workers are permissible.arrow_forwardComplete the table for a Chase production plan.arrow_forward
- How much can the garden centre expect to sell during each quarter of next year (Year 3) accounting for seasonality? Your forecast must make use of seasonal indices. All workings must be shown in full. (NOTE: Please round your calculations to three decimal places).arrow_forwardPS.53 Brother I.D. Ricks is a faculty member at BYU-Idaho whose grandchildren live in Oklahoma and California. He and his wife would like to visit their grandchildren at least once a year in these states. They currently have one vehicle with well over 100,000 miles on it, so they want to buy a newer vehicle with fewer miles and that gets better gas mileage. They are considering two options: (1) a new subcompact car that would cost $18,750 to purchase or (2) a used sedan that would cost $12,750.They anticipate that the new subcompact would get 37 miles per gallon (combined highway and around town driving) while the sedan would get 26 miles per gallon. Based on their road tripping history they expect to drive 13,000 miles per year. For the purposes of their analysis they are assuming that gas will cost $2.93 per gallon.Question: How many miles would the Ricks need to drive before the cost of these two options would be the same? (Display your answer to the nearest whole number.) (Hint:…arrow_forwardTisjTzktxyduduarrow_forward
- Not use ai pleasearrow_forwardNot use ai pleasearrow_forwardWhat is Bitcoin? How important is it to businesses and individuals? How does it cause environmental damage and is that damage worth continued uses of Bitcoin? Read the following articles to help answer these questions: United Nations University. (2023, October 24). UN study reveals the hidden environmental impacts of bitcoin: Carbon is not the only harmful by-product. https://unu.edu/press-release/un-study-reveals-hidden-environmental-impacts-bitcoin-carbon-not-only-harmful-product#:~:text=Bitcoin%2C%20the%20most%20popular%20cryptocurrency,the%20worldwide%20Bitcoin%20mining%20network. Salam, E. (2023, April 26). Bitcoin is terrible for the environment – can it ever go green? The Guardian. https://www.theguardian.com/technology/2023/apr/26/bitcoin-mining-climate-crisis-environmental-impactarrow_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