Question: For the same actual demand data above, perform a forecast using: Moving average of 3 periods. Exponential smoothing of (a=0.2).Make the first forecast value equal

For the same actual demand data above, perform a forecast using:

Moving average of 3 periods.

Exponential smoothing of (a=0.2).Make the first forecast value equal to 3.

Sketch your results on an excel sheet (period vs. Demand and vs. forecast values)

Date Actual demand (TVs/day) Forecast value (TVs/day) Moving average (3) expo smoothing (a=0.2) 1 7-Sep-14 0 3 2 8-Sept. 2 5 3 9-Sept. 6 7 4 10-Sept. 15 12 5 11-Sept. 8 10 6 12-Sept. 7 8 7 13-Sept. 7 4 8 14-Sept. 2 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question 2 (30 points): For the same actual demand data above, perform a forecast using: Moving average of 3 periods. Exponential smoothing of (a=0.2). Make the first forecast value equal to the...

Question 3 (5 points): For the same actual demand data above, perform a forecast using: - Moving average of 3 periods. - Exponential smoothing of (a=0.2). Make the first forecast value equal to 3 . -...

CHAPTER 12: A major source of revenue in Texas is a state sales tax. One category of tax is classified as Retail Trade. The following table gives four years of quarterly data: Year Quarter Sales Tax...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

CHAPTER 17TIME SERIES ANALYSIS AND FORECASTING MULTIPLE CHOICE 1. Which of the following is not present in a time series? a. seasonality b. operational variations c. trend d. cycles ANS: B PTS: 1...

Old MathJax webview Description Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve your technical skills you have attained. Through the individual...

NT 5160, Fall 2015 Semester Individual Case Assignment: Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case...

Business Decision Analysis Description Case studies are used to enable you to apply new concepts, use the tools you have mastered, and improve your technical skills you have attained. Through the...

Parts III, V, and VI of this case study dealt with obtaining an understanding of internal control and assessing control risk for transactions affecting accounts payable of Pinnacle Manufacturing. In...

List the five functions of an MIS.

How is so 4 2 - be separated from po 4 3 -

Steel Mill Inc. agrees to deliver a certain quantity of steel to T - Bar Framing Corporation. The agreement states that delivery is to be within 9 days, although the parties intend 9 0 days. The...