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 2P
Use Excel’s functions (not @RISK) to generate 1000 random numbers from a
- a. Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?
- b. What fraction of these random numbers are within k standard deviations of the mean? Answer for k = 1; for k = 2; for k = 3. Are the answers close to what they should be (about 68% for k = 1, about 95% for k = 2, and over 99% for k = 3)?
- c. Create a histogram of the random numbers using about 10 bins of your choice. Does this histogram have approximately the shape you would expect?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
9. Research Methodology
Fully explain the Quantitative research methodology that and add in the following
sub-sections:
. Data Collection
•
Data Analysis
Ruby-Star Incorporated is considering two different vendors for one of its top-selling products which has an average weekly demand of 40 units and is
valued at $80 per unit. Inbound shipments from vendor 1 will average 340 units with an average lead time (including ordering delays and transit time) of 2
weeks. Inbound shipments from vendor 2 will average 550 units with an average lead time of 1 week. Ruby-Star operates 52 weeks per year; it carries a
2-week supply of inventory as safety stock and no anticipation inventory.
a. The average aggregate inventory value of the product if Ruby-Star used vendor 1 exclusively is $ (Enter your response as a whole number.)
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows:
Year
Mileage
1
3,000
2
3
4
4,000
3,450
3,850
5
3,800
a) Using a 2-year moving average, the forecast for year 6 =
miles (round your response to the nearest whole number).
b) If a 2-year moving average is used to make the forecast, the MAD based on this = miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)
c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = ☐ miles (round your response to the nearest whole number).
miles (round your response to one decimal place). (Hint: You will have only 3 years of
The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.40 and 0.60 =
matched data.)
d) Using…
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
- Task time estimates for the modification of an assembly line at Jim Goodale's Carbondale, Illinois, factory are as follows: B D G Time Activity (in hours) Immediate Predecessor(s) A 5.0 B 7.5 C 5.0 A DEFC 8.0 B, C 4.5 Figure 2 A B, C 7.7 D G 5.0 E, F This exercise contains only part a. a) The correct precedence diagram for the project is shown in 目 F B Figure 3 A E B E ☑ D Farrow_forwardDave Fletcher was able to determine the activity times for constructing his laser scanning machine. Fletcher would like to determine ES, EF, LS, LF, and slack for each activity. The total project completion time and the critical path should also be determined. Here are the activity times: Activity Time (weeks) Immediate Predecessor(s) Activity Time (weeks) Immediate Predecessor(s) A 6 E 3 B B 8 F 6 B C 3 A G 11 C, E D 1 A H 7 D, F Dave's earliest start (ES) and earliest finish (EF) are: Activity ES .EF A 0 6 B 0 8 C 3 9 D 6 E F 8 G 22 H 21 Dave's latest start (LS) and latest finish (LF) are: Activity LS LF H 15 G 11 F 9arrow_forwardThere are multiple ways a company can enter a foreign market. Explore two possibilities such as exporting, foreign direct investment, and collaborations (joint ventures, alliances, licensing, franchising), and evaluate the pros and cons of each method. Which types of products and services would be appropriate for each market entry method?arrow_forward
- 01,3 ☐ Question 3 Scenario 9.3 4 pts The Talbot Company uses electrical assemblies to produce an array of small appliances. One of its high cost/high volume assemblies, the XO-01, has an estimated annual demand of 8,000 units. Talbot estimates the cost to place an order is $50, and the holding cost for each assembly is $20 per year. The company operates 250 days per year. Use the information in Scenario 9.3. What is the annual inventory holding cost if Talbot orders using the EOQ quantity? O less than or equal to $1,500 Ogreater than $4,000 but less than or equal to $6,500 O greater than $6,500 O greater than $1,500 but less than or equal to $4,000 Nextarrow_forwardAnalyze Walmart Inc. operations and conducting a strengths, weaknesses, opportunities, and threats (SWOT) analysis. Pay attention to Walmart Inc. strengths and opportunities to come up with a social cause that meshes well with them. Focusing on areas where Walmart Inc. excels and then finding a social cause that can benefit from Walmart Inc. strengths can also ultimately help Consider how shareholder and stakeholder theories of ethics will impact the selection of a target social cause for Walmart Inc to pursue. What responsibility does Walmart Inc. owe to its stockholders and stakeholders? Will pursuing a social responsibility program detract from the responsibilities to these two groups? Any program that is implement will redirect resources toward the social cause and away from the stockholders and stakeholders. Is it ethical? Walmart Inc SWOT analysis. Justify each item of the analysis. Evaluate the ethical implications of pursuing a social responsibility program in terms of the…arrow_forwardDetail Instructions Consider the following activities, activity times and precedence relations for a hypothetical Athletic Club Building project. Activity Activity Description Normal Time (weeks) Immediate Predecessors A Form project team 9 B Prepare renovation plans 12 A C Demolish interior space 10 B D Upgrade utility systems 20 A E Select equipment, furniture & 10 B fixtures F Hire Staff 10 A G Renovate building 30 B,C H Purchase equipment, furniture & 26 E fixtures Install equipment, furniture & 4 D.G.H fixtures 3 FI J Train staffarrow_forward
- How do you think smaller companies, with less sophisticated systems compared to giants like Amazon, can apply Little's Law to optimize their operations? Please Provide a referencearrow_forwardWhat are your thoughts on how businesses can account for real-world variability when applying Little's Law, especially in industries where demand is highly unpredictable? Please provide referencearrow_forwardHow can businesses integrate Petri Net modeling with Little's Law to enhance supply chain resilience, especially in unexpected disruptions such as supplier delays or demand fluctuations? Please provide a refernencearrow_forward
- How can businesses integrate Petri Net modeling with Little's Law to enhance supply chain resilience, especially in unexpected disruptions such as supplier delays or demand fluctuations?arrow_forwardLearning Activity 5: Expansion in Global Markets Discussion Questions: Bubble (or “boba”) tea is a milky tea containing chewy tapioca balls. It is has gained huge popularity in markets across Asia and is now also in North America and Europe. In your view will the recent exponential growth continue, and will it be at the expense of other drinks such as traditional black or green tea or coffee? Can global markets continue to support its growth, and what age group is mainly targeted?arrow_forwardDyson, a high-tech home appliance maker, has cut ties with Malaysian supplier ATA IMS Bhd following an audit of the company's labour practices and allegations by a whistleblower. ATA is already under US investigation over forced labour allegations. Dyson has terminated its contracts and is in talks with its customer over the audit findings. ATA, which produces parts for Dyson's vacuum cleaners and air purifiers, tumbled 30% to its lowest since April 2020. The termination is a significant blow for Malaysia, a major electronics manufacturing hub, which has faced scrutiny this year over claims of abusive working and living conditions. Dyson terminated the relationship with six months' contractual notice, hoping it would give ATA the impetus to improve and enable an orderly withdrawal in the interests of the workers they employ. Former ATA worker Dhan Kumar Limbu was beaten by police in Malaysia after sharing information about conditions at the factory with activists. ATA denied all…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