Given the following data, use exponential smoothing (a=0.20) to develop a demand forecast. Assume the forecastfor the initial period is 6.PeriodDemandPeriodForecast2213798The exponential smoothing forecast is (round your responses to two decimal places):1566.00234845136sD67

A statistical technique for predicting time series data is exponential smoothing. It is a well-liked…

Answered: Given the following data, use…

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

4. The sales (in millions of dollars) for an 18-month period are as follows. Month Sales Month Sales 1 600 600 775 10 775 3 600 11 600 4 650 12 575 700 13 625 800 14 650 550 15 600 8 775 a. Compare a three-month moving average forecast with an exponential smoothing forecast. Use a = 0.1. Which provides the better forecasts based on MSE? b. Find the forecast for the next month using the best forecast method. 2.
A firm uses simple exponential smoothing with trend adjustment to forecast demand, "a = 0.6" and "B=0.6". The Forecast including Trend (FIT) for the 1st month of 2022 was 434 units whereas the actual demand turned out to be 488 units, the trend over that period was 26. Calculate the demand forecast including trend for the 2nd month.
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
Please consider the following information and make forecasts for January, February, March, and April of Year 2. Use second-order polynomial regression to make forecasts. Adjusted seasonal index Actual sales Deseasonalized sales 836 825 Year 1 Year 2 January February March April May June July August September October November December January February March April 0.72 0.75 1:22 1.48 1 1.23 0.7 0.78 0.92 1.13 1.28 1.33 0.72 0.75 1.22 1.48 1220 1319 1020 1184 685 641 875 1008 1068 1141
Considering the fact that the number of students is relatively constant throughout the academic year, the college's cafeteria is planning for the second semester based of the actual sales the first semester. Month Actual Sales of Fall 2016 Forecast of Spring 2017 September 250 October 300 November 280 December 200 With the given information, can the forecast of November be obtained using a 3-month weighted moving average? Explain you answer.
2
Given the table below, complete the missing cell values applying the Exponential Smoothing method of forecasting and Mean Absolute Deviation. Answer also the other 2 related questions below the table. Numbers with decimal should take 2 decimal places. Actual Quarter Tonnage Unloaded 1 2 3 4 5 6 7 8 175 160 170 160 160 170 180 200 Forecast for a=3 175 175.0 170.5 167.2 165.1 166.6 170.6 Sum of absolute deviation = Absolute Deviation for a = .3 Other questions: (1) What is the MAD for a = .3? (2) Which smoothing constant would you prefer? 0.00 15.00 0.50 10.35 4.93 13.45 29.41 80.89 Forecast for a = .6 175 166.0 168.4 163.4 161.3 166.5 174.6 Absolute Deviation for a = .6 0.00 15.00 4.00 8.40 3.36 8.66 13.46 25.38
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below: Day Bicycle Victims 1 8 2 14 3 8 4 14 5 18 6 15 With an alpha value of 0.31 and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4? (Round to two decimal places) 15 What is the exponentially smoothed forecast for day 5? (Round to two decimal places)
Consider the following yearly demand values for a particular product. Year Demand 1 360 389 3 410 4 381 368 374 (a) Produce forecast for year 4,5,6, and 7 by using 3-week moving average. (b) Produce forecast for year 4,5,6, and 7 by using 3-week weighted moving average where weights are as follows; wt–3 = .1, wt-2 = .3, and wt-1 = .6. (c) Produce forecast for year 4,5,6, and 7 by using exponential smoothing with a = .2. Please assume that the forecast for the first year is 360.
Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year Year Forecast (000) 1 2 4.00 7.00 1 5.00 3 5.00 Registrations (000) a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (a) of 0.40 and a starting forecast of 5.00 for year 1 (round your responses to one decimal place): 2 3 4.6 5.56 4 4.00 4 5.34 11 9 10 7 8 6 5 9.00 9.00 6.00 10.00 13.00 14.00 12.00 5 4.80 6 7 6.48 7.49 8 6.89 9 8.14 10 10.08 11 11.64 12 11.79 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (a) = 0.40 and a starting forecast of F₁ = 5.00) is response to one decimal place). registrations (round your
Given an actual demand this period of 90, a forecast for this period of 58, and an alpha of 0.2, what would the forecast for the next period be using exponential smoothing?

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

Given the following data, use exponential smoothing (a=0.20) to develop a demand forecast. Assume the forecast for the initial period is 6. 1 Period Forecast 2 2 3 8 3 4 8 Period Demand 7 9 The exponential smoothing forecast is (round your responses to two decimal places): 1 4 6 6.00 5 13 5 6 6