Practical Management Science, Loose-leaf Version
5th Edition
ISBN: 9781305631540
Author: WINSTON, Wayne L.; Albright, S. Christian
Publisher: Cengage Learning
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
Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is
to schedule production if the projected on-hand Inventory would be negative without it. Customer orders (committed) are as follows:
Week Customer Orders
1
2
36
28
4
1
Use a production lot size of 85 units and no beginning inventory.
Note: In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain
to enter "0" wherever required.
June
July
1
2
3
4
5
8
7
8
Forecast
60
60
60
60
60
60
60
60
Customer Orders
38
28
4
1
0
0
0
0
Projected On-Hand Inventory
MPS
ATP
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below:
Week
1
2
3
4
5
6
7
8
9
10
Demand 21 21
27
38 25
30 35
24 25
30
a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places):
Week
1
2
3
4
5
6
7
8
9
10
Demand 21
21
27
38 25
30
35
24 25 30
Forecast 21.0 21
21
24 31
28
29
32 28 26.50
b) For the forecast developed using exponential smoothing (a = 0.50 and initial forecast 21.0), the MAD = |||||sales (round your response to two decimal places).
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below:
Week
Demand
1
2
3
4
5
6
7
8
9
10
21
21
27
38
25
30
35 24 25
30
a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places):
Week
1
2
3
4
5
Demand 21 21
27 38
Forecast 21.0
☐ G
☐
☐
6
7
25 30 35
∞ ☐
8
9
10
24
25
30
Chapter 10 Solutions
Practical Management Science, Loose-leaf Version
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 - Prob. 34PCh. 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
- Each machine costs $3 Million. Building the room with all its attendant safety protection and other ancillary costs increases the spending by an additional $2.0 million dollars per MRI suite. Each machine can perform 2000 scans per year. Each reading of an MRI scan by a radiologist, along with other per-scan-related costs, is $500 per scan. The machine will last five years. Don’t worry about discount rates for this problem Graph the total costs over 5 years as a function of sales for 0-3000 patients annually. Hint: you may need to add a second MRI at some point. Suppose that you want to make a profit of $500 per scan at a target volume of 1000 patients per year, and you purchase only one machine. Superimpose the total revenue curve on top of the total cost curve in (1).arrow_forwardI need the answer to requirement C.arrow_forwardImagine you are Susan Kim and are faced with a difficult choice to either follow the orders she was given, or refusing to do so. Using each lens determine what the ethical response would be. Suppot your answer with materials from readings and lectures. For example, using Universalism what would the ethical response be? Do the same for all four lenses.arrow_forward
- Answer all these questions, selecting any company of your choice. Choose a specific type of food company. Select a specific product. Develop all the inputs that are part of the process. Develop the transformation process in a graphic (diagram, etc.). Develop all the outputs or finished products that are part of the process. Describe all the processes involved in one line of production in any manufacturing facility. Also describing how good management is the center of any part of a production company.arrow_forwardUsing exponential smoothing with α =0.2, forecast the demand for The initial forecast for January is 2000 tons. Calculate the capacity utilization for June, July and Discuss the implications of underutilized or over utilized capacity for Green Harvestarrow_forwardIn organizational development when results are improving but relationships are declining, what leadership style is appropriate? directing delegating supporting coachingarrow_forward
- What is the first thing a leader should do when moving through a cultural change? conduct an assessment comparing the practices to other high-performing organizations learn about the current organizational culture continue to monitor key metrics define expectationsarrow_forwardThe third change leadership strategy, Collaborate on Implementation, is designed to address what type of concerns? impact concerns personal concerns refinement concerns collaboration concernsarrow_forwardIf team members are concerned with specifics such as their tasks, contingency plans, resources, and timeline, what concerns do they have? implementation concerns impact concerns refinement concerns personal concernsarrow_forward
- At the developing stage of organizational development, which leadership style is most appropriate? supporting coaching delegating directingarrow_forwardDuring the start-up phase of organizations, which leadership style is appropriate? supporting coaching directing delegatingarrow_forwardRegarding relationships and results, what is typically seen in start-up orgnanizations? low results/high relationships low results/low relationships high results/high relationships high results/ low relationshipsarrow_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