Practical Management Science
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 13, Problem 33P

Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu-ray disc players over the past two years. Managers have recorded the relevant data in the file P13_33.xlsx.

  1. a. Create a scatterplot for these data. Comment on the observed behavior of monthly sales at this store over time.
  2. b. Estimate an appropriate regression equation to explain the variation of monthly sales over the given time period. Interpret the estimated regression coefficients.
  3. c. Analyze the estimated equation’s residuals. Do they suggest that the regression equation is adequate? If not, return to part b and revise your equation. Continue to revise the equation until the results are satisfactory.
Blurred answer
Students have asked these similar questions
Answer in Excel: Consider the data below for the sales of widgets: 1. Using seasonal percentages or seasonal indexes, forecast the sales for each season in year 4, if the annual widgets sales is predicted to be 1500. 2. Develop a regression equation that captures both the trend and seasonality in this data. Use this equation to forecast the sales for each season in year 4. Season Year 1 Year 2 Year 3 Fall 505 240 210 Winter 555 460 365 Spring 400 310 204 Summer 560 450 394
A pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were as follows:Day 1 2 3 4 5 6 7 8 9Number sold 36 38 42 44 48 49 50 49 52Day 10 11 12 13 14 15Number sold 48 52 55 54 56 57a. Which method would you suggest using to predict future sales—a linear trend equation or trend-adjusted exponential smoothing? Why? b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledge cause you any concern? Explain c. Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with an initial forecast of 50 for day 8, an initial trend estimate of 2, and α = β = .3, develop forecasts for days 9 through 16. What is the MSE for the eight forecasts for which there are actual data?
A certain agency has a goal of reducing the death and disease caused by tobacco use and exposure to second-hand smoke. One of the many responsibilities of the agency is to collect data on tobacco use. Suppose the following data show the percentage of adults in the United States who were users of tobacco during an 11-year period: Year Percentage of Adults Who Smoke 1 2 22.6 22.2 3 21.4 20.7 5 20.7 6 20.5 7 19.6 8 20.3 9 20.4 10 11 (a) Construct a time series plot. Percent of Adults Who Smoke 25 20 15 10 5 19.1 18.7 2 4 6 8 10 12 Period Percent of Adults Who Smoke 15- 10 5 0 0 2 4 6 8 10 12 Period Percent of Adults Who Smoke 10 2 4 6 8 10 12 Period Percent of Adults Who Smoke 15 10- 5. 0 2 4 6 8 10 12 Period

Chapter 13 Solutions

Practical Management Science

Ch. 13.4 - Prob. 12PCh. 13.4 - A trucking company wants to predict the yearly...Ch. 13.4 - An antique collector believes that the price...Ch. 13.4 - Stock market analysts are continually looking for...Ch. 13.4 - Suppose that a regional express delivery service...Ch. 13.4 - The owner of a restaurant in Bloomington, Indiana,...Ch. 13.6 - The file P13_19.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_20.xlsx contains the monthly sales of...Ch. 13.6 - The file P13_21.xlsx contains the weekly sales of...Ch. 13.6 - The file P13_22.xlsx contains total monthly U.S....Ch. 13.7 - You have been assigned to forecast the number of...Ch. 13.7 - Simple exponential smoothing with = 0.3 is being...Ch. 13.7 - The file P13_25.xlsx contains the quarterly...Ch. 13.7 - The file P13_26.xlsx contains the monthly number...Ch. 13.7 - The file P13_27.xlsx contains yearly data on the...Ch. 13.7 - The file P13_28.xlsx contains monthly retail sales...Ch. 13.7 - The file P13_29.xlsx contains monthly time series...Ch. 13.7 - A version of simple exponential smoothing can be...Ch. 13 - Prob. 31PCh. 13 - Prob. 32PCh. 13 - Management of a home appliance store would like to...Ch. 13 - A small computer chip manufacturer wants to...Ch. 13 - The file P13_35.xlsx contains the amount of money...Ch. 13 - Prob. 36PCh. 13 - Prob. 37PCh. 13 - Prob. 39PCh. 13 - The Baker Company wants to develop a budget to...Ch. 13 - Prob. 41PCh. 13 - The file P13_42.xlsx contains monthly data on...Ch. 13 - Prob. 43PCh. 13 - Prob. 44PCh. 13 - Prob. 45PCh. 13 - Prob. 46PCh. 13 - Prob. 49P
Knowledge Booster
Background pattern image
Operations Management
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
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