Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
Forecasts and actual sales of digital music players at Just Say Music are as follows:
Month | Actual Sales | |
March | 150 | 170 |
April | 207 | 214 |
May | 202 | 190 |
June | 265 | 247 |
July | 268 | 242 |
August | 250 | 210 |
September | 285 | 240 |
October | 267 | 192 |
-
What is the forecast for November, using a two-period moving average? Round your answer to two decimal places.
-
What is the forecast for November, using a three-period moving average? Round your answer to two decimal places.
-
Compute MSE for the two- and three-period moving average models and compare your results. Do not round intermediate calculations. Round your answers to two decimal places.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 13 images
Knowledge Booster
Similar questions
- You have a data set that includes time period and past sales data, and you want to use a time series forecasting technique. Which of the following forecasting methodologies is considered a time series forecasting technique? a.Group of answer choices b.Delphi method c.Simple movement smoothing d.Weighted moving average e.Simulation f.Exponential averagingarrow_forwardPlease answer it ASAP. With only short explanation. Please answer fast i will really upvote.arrow_forwardwhat are the differences between the following models? 1) Moving average models 2) Simple exponential smoothing 3) Holt's exponential smoothing 4) Winter's exponential smoothing 5) The Bass model In your answer, write down the equation for each model. What does each variable mean? Finally, why would I use one model as opposed to the others? For example, the Bass Model is used to forecast the adoption rate for new innovations, or sigmoid shaped growth.arrow_forward
- From the following annual data of sales (in 000 .$.) Find the trend values by using least square method. Also estimate the sales of 2014. Year 2004 2005 2006 2007 2008 2009 2010 Sales {In 000 $} 77 88 94 85 91 98 90arrow_forwardYear Season Sales 2018 Winter 40 2018 Spring 29 2018 Summer 31 2018 Fall 40 2019 Winter 102 2019 Spring 87 2019 Summer 96 2019 Fall 132 2020 Winter 105 2020 Spring 93 2020 Summer 105 2020 Fall 117 2021 Winter 141 2021 Spring 39 2021 Summer 114 2021 Fall 123 What is the slope of the trend equation obtained by linear regression? Round to two decimal digits. What is the intercept of the trend equation obtained by linear regression? Round to two decimal digits. What is the seasonal index for Spring? Round to two decimal digits. The quarter number for Winter of 2018 is 1. What is the quarter number for Spring of 2025? What is the trend based forecast for Spring of 2025. Round to a whole number. What is the seasonally adjusted trend based forecast for Spring of 2025? Please do not use excel to find the slope and intercept, thank you so much!arrow_forwardIt wouldnt let me take a screenshot of the table so I had to copy and paste it in here. My question is: How do you Calculate a moving average forecast using the last 2 and 4 dates of stay. What is the prediction for 7/1/2021 for each technique? Discussion Question 1 - 200 room hotel Forecasts MA 2 Errors MA 4 Errors ES (0.8) Errors ES (0.5) Errors Date Day of Week Rooms Sold MA 2 MA 4 ES (0.8) ES (0.5) AE APE AE APE AE APE AE APE 6/1/2021 Tuesday 123 6/2/2021 Wednesday 109 6/3/2021 Thursday 140 6/4/2021 Friday 199 6/5/2021 Saturday 179 6/6/2021 Sunday 140 6/7/2021 Monday 117 6/8/2021 Tuesday 132 6/9/2021 Wednesday 108 6/10/2021 Thursday 151…arrow_forward
- How does a food company forecast demand for its meat snack and sausage products? Oberto Sausage, an 85-year-old family business in Washington State, sells beef jerky and other packaged meat products, such as pork rinds and smoked sausage sticks, directly to mass merchandisers and supermarket chains. Oberto has been enjoying double-digit growth. The company has also been expanding its consumer marketing efforts into the digital realm; it recently concluded a successful sweepstakes promotion that invited participants to text in their entries from their cell phones. Growing demand means accurate forecasting is critical to Oberto’s ability to provide a steady supply of fresh products to the right places at the right time. Forecasting also ensures Oberto has the necessary ingredients and packaging available to fill orders on time. In its recent search for a new computer-based forecasting system, the company looked for a way to create a model of routine and ongoing…arrow_forwardList and describe the differences between forecasts and predictions?arrow_forwardDo not use chatgpt. Answer in step by step with explanation.arrow_forward
- The following data are for calculator sales in units at an electronics store over the past nine weeks: Week Sales Week Sales 45 6 53 50 7 59 44 8 59 51 64 57 Use trend projection with regression to forecast sales for weeks 10 - 13. What are the error measures (CFE, MSE, G. MAD, and MAPE) for this forecasting procedure? How about ?? Obtain the trend projection with regression forecast for weeks 10 - 13. (Enter your responses rounded to two decimal places.) Period Forecast, F 10 64.81 11 67.06 12 69.31 13 71.56 Obtain the error measures. (Enter your responses rounded to two decimal places.) CFE MSE MAD MAPE 6.72 2.75 2.1 4.1 % Find the coefficient of determination (). The coefficient of determination ? = (Enter your response rounded to two decimal places.)arrow_forwardAn example of the Quantitative Method of forecasting is O Multiple Regression Market Research O the Delphi Methode O Jury of Executive Opinionarrow_forwardCan you please solve all parts of the question manually. Thank you!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,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.