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
By selecting Cigna Accredo pharmacy that i identify in my resand compare the current feedback system against the “Characteristics of a Good Multiple Source Feedback Systems” described in section 8-3-3. What can be improved? As a consultant, what recommendations would you make?
Scenario
You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill.
Accurate forecasts are important for many reasons, including for the company to ensure they have the materials
they need to create the products required in a certain period of time. Your objective is to minimize the forecast
error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%.
You have historical monthly sales data for the past year and access to software that provides forecasts based on
five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential
Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given
data, you will identify trends and patterns to create a more accurate forecast.
Approach
Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…
Approach
Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next
month.
Remember to select the forecasting technique that produces the forecast error nearest to zero. For example:
a. Naïve Forecast is 230 and the Forecast Error is -15.
b. 3-Month Moving Forecast is 290 and the Forecast Error is -75.
c. Exponential Smoothing Forecast for .2 is 308 and the Forecast Error is -93.
d. Exponential Smoothing Forecast for .5 is 279 and the Forecast Error is -64.
e. Seasonal Forecast is 297 and the Forecast Error is -82.
The forecast for the next month would be 230 as the Naïve Forecast had the Forecast Error closest to zero with a
-15. This forecasting technique was the best performing technique for that month. You do not need to do any
external analysis-the forecast error for each strategy is already calculated for you in the tables below.
Naïve
Month Period
Actual
Demand
Naïve Forecast
Error
3-
Month
Moving
Forecast
3-
Month
Moving…
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
- Scenario You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill. Accurate forecasts are important for many reasons, including for the company to ensure they have the materials they need to create the products required in a certain period of time. Your objective is to minimize the forecast error, which will be measured using the Mean Absolute Percentage Error (MAPE) with a goal of being below 25%. You have historical monthly sales data for the past year and access to software that provides forecasts based on five different forecasting techniques (Naïve, 3-Month Moving Average, Exponential Smoothing for .2, Exponential Smooth for .5, and Seasonal) to help determine the best forecast for that particular month. Based on the given data, you will identify trends and patterns to create a more accurate forecast. Approach Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next…arrow_forwardUse the internet to obtain crash safety ratings for passenger vehicles. Then, answer thesequestions:a. Which vehicles received the highest ratings? The lowest ratings?b. How important are crash-safety ratings to new car buyers? Does the degree of importancedepend on the circumstances of the buyer?c. Which types of buyers would you expect to be the most concerned with crash-safety ratings?d. Are there other features of a new car that might sway a buyer from focusing solely on crashsafety? If so, what might they be?arrow_forward“Implementing a Performance Management Communication Plan at Accounting, Inc.” Evaluate Accounting Inc.’s communication plan. Specifically, does it answer all of the questions that a good communication plan should answer? Which questions are left unanswered? How would you provide answers to the unanswered questions? “Implementing an Appeals Process at Accounting, Inc.” If you were to design an appeals process to handle these complaints well, what would be the appeal process? Describe the recommended process and why.arrow_forward
- The annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200 per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk ordering as given below. Can the manager reduce his costs by taking advantage of either of these discounts? Recommend the best ordering policy for the store. Order size Unit cost (Rs.) 1 – 49 pcs. 20.00 50 – 149 pcs. 19.50 150 – 299 pcs. 19.00 300 pcs. or more 18.00arrow_forwardHelp answer showing level work and formulasarrow_forwardI need to forecast using a 3-Period-Moving-Average-Monthly forecasting model which I did but then I need to use my forecast numbers to generate a Master Production Schedule (MPS) I have to Start with actual sales (my own test data numbers) for August-2022 Oct-2022 i need to create MPS to supply demand starting November-2022 April 2023 I just added numbers without applying formulas to the mps on the right side of the spreadsheet because I do not know how to do it. The second image is the example of what it should look like. Thank You.arrow_forward
- Solve the following Question 1. How do volume and variety affect the process selection and layout types? Discuss 2. How is the human resource aspect important to operation function? Discuss 3. Discuss the supply network design and its impact on the overall performance of the organization.arrow_forwardHelp with question?arrow_forwardWhat are some good examples of bullet points on a resume for a Christian Elementary School?arrow_forward
- What is an example of a cover letter for a Christian School Long-Term Substitute Teaching position?arrow_forwardThe supply chain is a conventional notion, but organizations are only really interested in making products that they can sell to customers. Provided they have reliable supplies of materials and reasonable transport for finished products, logistics is irrelevant. Do you think this is true? If yes, explain, and if no, clearly explain as well.arrow_forwardworking as a program operations managerarrow_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