Question 2Historical demand for Peeps is as displayed in the table.MonthJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberDemand111831394453678296Develop forecasts from June through October using these techniques: moving average of twoperiod, simple exponential smoothing with an alpha of 0.8, and Holt's method with alpha=0.2and beta=0.1. For the exponential smoothing model assume that the forecast for May is theactual demand for May. For Holt's model, the level and trend for May are assumed to be 44 and12. Judge which forecast method is the best based on MAD. Please take the average for april may and june toforcast for june and calulate the rest with thesame reference

Forecasting is a systematic process of estimating future trends, outcomes, or events based on…

Answered: Question 2 Historical demand for Peeps…

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

FORECASTING- EXPONENTIAL SMOOTHING QUESTION 3 PERIOD АCTUAL 1 42 2 40 3 43 4 40 5 41 39 7 46 8 44 9. 45 10 38 11 40 12 a) Consider exponential smoothing forecasts using smoothing constants (a) 0.1 and 0.4
using minitab
eBook Problem 6-05 Consider the following time series data. 3 16 Week 1 Week 2 Value 18 13 a. Choose the correct time series plot (1) € (!!!) Time Series Value Time Series Value 28642986420 284H2G86420 1 4 11 2 {B} 2 TH 3 Week (t) Week (t) 5 6 € (iv) Time Series Value Time Series Value 28642 NO 28642 NO 1 2 2 4 3₁ Week (t) Week (t) 5 6
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
solve all parts within 30 mins
Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 315 February 418 March 390 April 430 May 400 [ June 480 July 430 August 320 September 385 October 530 November 592 555 December 300 400 350 460 390 395 355 245 340 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third 0.25. Do the problem using quarters, as opposed to forecasting separate months. (Round your answer to 2 decimal places.) Forecast for the fourth quarter
Freya is a new name in the retail industry that just started off its journey. With the right strategies, the brand’s grandeur will only rise with time. However, the founders really want to predict the customer demand right for the month of June. Hence, they need to figure out the right forecasting techniques. They are considering 2-period Moving Average, Naive technique, and Exponential Smoothing (use any value between .10 - .18 as the value of alpha). Figure out the better forecasting technique among 2 periods Moving Average, Naive technique, and Exponential Smoothing by doing the error calculation. Period Demand 2period Moving Average Naive technique Exponential Smoothing January 80 85 82 70 February 84 82 ** ** March 89 ** ** ** April 95 ** ** ** May 98 ** ** **
It 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…
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.
Justify the trade-off between responsiveness and consistency in a time-series forecasting system.
2. Given the following data, use exponential smoothing with a = 0.2 and a = 0.5 to generate forecasts for periods 2 through 6. Use MAD and MSE to decide which of the two models produced a better forecast. Period Actual Forecast 1 15 17 2 18 3 14 4 16 5 13 6 16
Font Paragraph Styles Question 3 Consider the following from an estate agent's business nationally: Month Houses Sold Jan Feb Mar 380 360 390 Apr May June July Aug Sep Oct 400 390 380 394 454 460 460 Nov Dec 430 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) Define moving averages and how they're useful in forecasting (use Harvard referencing) c) At races, your horse, White Rum, has a probability of 1/20 of coming 1st, 1/10 of coming 2nd and a probability of 4 in coming 3rd. First place pays $5,000 to the winner, second place $4,000 and third place $1,350. Hence, is it worth entering the race if it costs $1050?

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