Question: Compute ans show step by step 3. Exercise Three: Given the date below for Chambers Electronics, and using your knowledge of Forecasting Time Series with

Compute ans show step by step

3. Exercise Three: Given the date below for Chambers Electronics, and using your knowledge of Forecasting Time Series with Seasonal Indices, (a) find the Centered Moving Average as shown in class (use the same weights as shown in class, and they must add up to 4), (b) compute the Seasonal Ratio, (c) find the Seasonal Index, (d) calculate the Deseasonalized Values, (e) compute the Deseasonalized Forecast for the given series, (f) tabulate the Actual Forecast for the given series, (g) find the Mean Absolute Deviation, the Mean Squared Error, and the Mean Absolute Percentage Error, (h) forecast the Deseasonalized Values for periods 21, 22, 23, and 24, (i) forecast the Actual values for periods 21, 22, 23, and 24, (k) as shown in class, use the GRG-Non Linear Solver to find the weights that minimize the Mean Absolute Percentage Error (MAPE). (4 Points). (Given) 2016 2017 2018 2019 2020 Quarter 1 205 225 266 286 347 Quarter 2 184 205 194 255 266 Quarter 3 174 205 215 235 296 Quarter 4 215 306 326 387 519 3. Exercise Three: Given the date below for Chambers Electronics, and using your knowledge of Forecasting Time Series with Seasonal Indices, (a) find the Centered Moving Average as shown in class (use the same weights as shown in class, and they must add up to 4), (b) compute the Seasonal Ratio, (c) find the Seasonal Index, (d) calculate the Deseasonalized Values, (e) compute the Deseasonalized Forecast for the given series, (f) tabulate the Actual Forecast for the given series, (g) find the Mean Absolute Deviation, the Mean Squared Error, and the Mean Absolute Percentage Error, (h) forecast the Deseasonalized Values for periods 21, 22, 23, and 24, (i) forecast the Actual values for periods 21, 22, 23, and 24, (k) as shown in class, use the GRG-Non Linear Solver to find the weights that minimize the Mean Absolute Percentage Error (MAPE). (4 Points). (Given) 2016 2017 2018 2019 2020 Quarter 1 205 225 266 286 347 Quarter 2 184 205 194 255 266 Quarter 3 174 205 215 235 296 Quarter 4 215 306 326 387 519

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!

Exercise Two: Given the date below for Chambers Electronics, and using your knowledge of Forecasting Time Series with Seasonal Indices, (a) find the Centered Moving Average as shown in class (use the...

1. Exercise One: Vartax Motors produces three lines of luxury vehicles, Model A, Model B, and Model C. The profits for each model are, $235,000, $485,000 and $790,000, respectively. The company...

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...

SUMMARY this journal, the length of it should not be more than 2 pages, with 1.5 spacing size 12 Times New Rome. Available online at www.sciencedirect.com Journal of Empirical Finance 15 (2008) 199 -...

PART A: The following table gives restaurant sales data for the Timber Ridge ski lodge over a three year period. For the first part of this exercise, assume that the revenues are randomly...

PARTI OVERVIEW The following discussion expands upon exponential smoothing and seasonality as presented in Chapter 11, Forecasting, in the text. There are a variety of forecasting methods and...

It is estimated that the expected market rate of return is 11.45% when the risk-free rate is 3.97%. Under CAPM, if the beta of Company-Q (BQ) is 1.84, what would be the expected return for Company-Q?...

Prepare a statement of cash flow using the given information and determine the ending cash balance. John's Mini Grocery had the following transactions during the year (2021): a. Purchase of goods -...

1 . Confirmations should be drafted on client _ _ _ _ _ _ _ _ _ _ blank . 2 . Confirmations should include a request that the bank confirm _ _ _ _ _ _ _ _ _ _ blank borrowings . 3 . Auditors need to...

What is an example of constructive feedback? provide reference