Apply 4-period SMA and 4-period WMA (0.1, 0.2, 0.3, 0.4) to the given data. Determinethe MAD, MSE, and RSE for both method and provide the forecast for the next period usingthe method with better MSE.period demand period demand120113131212414132312215133412316130132125171281813471291913481272013312921131101282213511130231371213224138

Answered: Apply 4-period SMA and 4-period WMA…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: 3 8 9 6 7 6 3 7 10 11 Year Year Forecast (000) 1 5 1 5 2 5 4 4 4 5 11 Registrations (000) Use exponential smoothing with a smoothing constant of 0.4 to forecast the registrations at the seminar for years 2 through 12. To begin the procedure, assume that the forecast for year 1 was 5,000 people signing up (round your responses to one decimal place): 2 3 5 6 7 8 10 16 9 11 12 10 D 11 12 a) What is the MAD? Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is thousand registrations (round your response to one decimal place). b) What is the MSE? The mean squared error based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is (round your response to two decimal…
Forecasting The manager of a popular tourist resort wants to use the manual trend projection forecasting technique and exponential smoothing without trend to forecast room occupancy at the resort for the next 4 years. Using a numerical example, demonstrate how these techniques can be used to do the forecast.
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances 3 4 8 6 7 7 Demand for Guitars 4 6 7 5 10 6 This exercise contains only parts b, c, and d. Part 2 b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): Y = enter your response here + enter your response herex
Develop a forecast for the next month using a four-month moving average method. Use the Excel Functions SLOPE and INTERCEPT to write the linear regression prediction equation with Months as the independent variable and sales as the dependent variable. Use the prediction equation to estimate the number of sales in month 9.
The management of an insurance company monitors the number of mistakes made by telephone service representatives for a company they have subcontracted with. The number of mistakes for the past several months appears in this table along with forecasts for errors made with two different forecasting techniques. The column labeled Exponential was created using exponential smoothing with an alpha of 0.30. The column labeled MA is forecast using a moving average of three periods. Month Mistakes Exponential MA 1 55 2 61 3 71 4 77 71 62 5 88 73 70 6 100 77 79 7 109 84 88 8 122 92 99 9 126 101 110 10 126 108 119 Using the table above, what is the MSE for months 6−10 for the moving average technique? *THE ANSWER IS 343 BUT I WANT TO UNDERSTAND WHY AND HOW YOU GET THE ANSWER*
Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 Value 18 13 (a) Construct a time series plot. 20T 18 16- 14- Time Series Value O Week 1 2 3 4 5 6 What type of pattern exists in the data? O The data appear to follow a cyclical pattern. O The data appear to follow a trend pattern. 8 6 O The data appear to follow a seasonal pattern. O The data appear to follow a horizontal pattern. Week 1 2 0 1 3 4 5 6 18 13 15 12 (b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Time Series Value 16 14 18 + 2 13 15 4 5 6 15 12 16 3 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? 12 16 4 14 Week (c) Use a = 0.2 to compute the exponential smoothing values for the time series. Time Series Value 5 14 Forecast 6 Forecast 7 20 18 16 14 12 WE 10 2 + 7 @o 20 18 0 1 2 3 4 Week 5 6 00 0 1 2 3 4 5 Week 6 7…
A company wants to generate a forecast for unit demand for year 2017 using exponential smoothing. The actual demand in year 2016 was 120. The forecast demand in year 2016 was 110. Using this data and a smoothing constant alpha of 0.1, which of the following is the resulting year 2017 forecast value?
After using your forecasting model for six months, you decide to test it using a tracking signal. Here are the forecast and actual demands for the six-month period: PERIOD FORECAST ACTUAL May 450 500 June 500 550 July 550 400 August 600 500 September 650 675 October 700 600 Find the tracking signal of each month
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Feb Mar Apr May Jun Jul Aug Sept Oct 21 23 17 14 11 16 16 18 Nov Dec 20 20 20 24 Month Sales This exercise contains only parts b and c b) The forecast for the next month (Jan) using the naive method=sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied to the most recent month= sales (round your response to one decimal place) Using exponential smoothing with a = 0.30 and a September forecast of 21.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…
Holiday Lodge The Holiday Lodge is a large hotel and casino in the Adirondacks. The relatively new hotel is two years old, and the manager is trying to develop a plan to staff the maintenance department. The hotel’s manager wants to use the two years of data below to forecast one month ahead of maintenance calls. The data is provided in the spreadsheet named HOLIDAY LODGE DATA.XLS Month Calls 1 46 2 39 3 28 4 21 5 14 6 16 7 14 8 13 9 9 10 13 11 18 12 15 13 12 14 6 15 19 16 9 17 12 18 14 19 16 20 12 21 13 22 9 23 14 24 15 Develop a forecast for month 25 using a 4 month moving average, exponential smoothing (a = 0.2) and regression. Which forecast is preferred? Why?
The management of an insurance company monitors the number of mistakes made by telephone service representatives for a company they have subcontracted with. The number of mistakes for the past several months appears in this table along with forecasts for errors made with three different forecasting techniques. The column labeled Exponential was created using exponential smoothing with an alpha of 0.30. The column labeled MA is forecast using a moving average of three periods. The column labeled WMA uses a 3-month weighted moving average with weights of 0.65, 0.25, and 0.10 for the most-to-least recent months. Month Mistakes Exponential MA WMA 1 55 2 61 3 71 4 77 71 62 67 5 88 73 70 74 6 100 77 79 84 7 109 84 88 95 8 122 92 99 105 9 126 101 110 117 10 126 108 119 123 Using above table, what is the MSE for months 6-10 for the exponential smoothing technique? a. less than 591 b. greater than or equal to 591 but less than 595 c.…
The Polish General’s Pizza Parlor is a small restaurant catering to patrons with a taste for Europeanpizza. One of its specialties is Polish Prize pizza. The manager must forecast weekly demand for thesespecial pizzas so that he can order pizza shells weekly. Recently, demand has been as follows: a. Forecast the demand for pizza for June 23 to July 14 by using the simple moving average method withn = 3. Then, repeat the forecast by using the weighted moving average method with n = 3 andweights of 0.50, 0.30, and 0.20, with 0.50 applying to the most recent demand.b. Calculate the MAD for each method

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

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.

SEE MORE TEXTBOOKS

Apply 4-period SMA and 4-period WMA (0.1, 0.2, 0.3, 0.4) to the given data. Determine the MAD, MSE, and RSE for both method and provide the forecast for the next period using the method with better MSE.