Question: The department manager has decided that the appropriate forecasting model for the sales of laptops at a local electronics store is the Winter's Model with

The department manager has decided that the appropriate forecasting model for the sales of laptops at a local electronics store is the Winter's Model with additive trend and multiplicative seasonality. Given the time series data set in the Excel spreadsheet (Sheet 1 - Laptops), make the forecasts for the four (4) quarters (Q1, Q2, Q3 and Q4) for the year 2021. Make sure to include a line chart with markers indicating the actual demand, the trend line, and your forecasts. Also, calculate the MAD, MSE, MAPE, bias and the tracking signal for the manager's forecast. Use the supplied Excel spreadsheet to input your answers with the correct formulas. Would you accept the manager's forecast based on any of the measurements above? Explain briefly. H J K L M N Period Time Prd 1 Q1 2 Q2 3 Q3 4 04 5 Q1 6 Q2 7 Q3 8 04 9 Q1 10 Q2 11 Q3 12 04 13 Q1 14 Q2 15 Q3 16 04 17 Q1 18 19 Q3 20 04 Year 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2020 2020 2020 2020 2021 2021 2021 2021 Demand (D) 200 216 222 270 218 236 246 296 258 264 276 322 282 290 306 358 Q2 The department manager has decided that the appropriate forecasting model for the sales of laptops at a local electronics store is the Winter's Model with additive trend and multiplicative seasonality. Given the time series data set in the Excel spreadsheet (Sheet 1 - Laptops), make the forecasts for the four (4) quarters (Q1, Q2, Q3 and Q4) for the year 2021. Make sure to include a line chart with markers indicating the actual demand, the trend line, and your forecasts. Also, calculate the MAD, MSE, MAPE, bias and the tracking signal for the manager's forecast. Use the supplied Excel spreadsheet to input your answers with the correct formulas. Would you accept the manager's forecast based on any of the measurements above? Explain briefly. H J K L M N Period Time Prd 1 Q1 2 Q2 3 Q3 4 04 5 Q1 6 Q2 7 Q3 8 04 9 Q1 10 Q2 11 Q3 12 04 13 Q1 14 Q2 15 Q3 16 04 17 Q1 18 19 Q3 20 04 Year 2017 2017 2017 2017 2018 2018 2018 2018 2019 2019 2019 2019 2020 2020 2020 2020 2021 2021 2021 2021 Demand (D) 200 216 222 270 218 236 246 296 258 264 276 322 282 290 306 358 Q2

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 Finance Questions!

The department manager has decided that the appropriate forecasting model for the sales of laptops at a local electronics store is the Winter's Model with additive trend and multiplicative...

please answer the last portion of the problem as well! The department manager has decided that the appropriate forecasting model for the sales of laptops at a local electronics store is the Winter's...

excel please \begin{tabular}{|l|c|cc|c} \hline & Period & Time Prd & Year & Demand (I \\ \hline 4 & 1 & Q1 & 2018 & 200 \\ \hline 5 & 2 & Q2 & 2018 & 216 \\ \hline 6 & 3 & Q3 & 2018 & 222 \\ \hline 7...

NOTE** READ THE CASE AND FOLLOW ALL INSTRUCTIONS STEP BY STEP. CALCULATION ON EXCEL VERY IMPORTANT. Above is the case, now follows the questions. EXCEL file and well explained work important. THE...

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

The question is the last one Optimal Inventory Management Accurate forecasts are vital to our business because they drive all of our production and distribution decisions." Jason Kwok, general...

The question is the last one Chinese Pharmaceuticals (HK) Limited: Effective Forecasting for Optimal Inventory Management Accurate forecasts are vital to our business because they drive all of our...

Following are the most recent balance sheets for Country Kettles, Inc. Excluding accumulated depreciation, determine whether each item is a source or a use of cash, and the amount. COUNTRY KETTLES,...

Consider a rm that produces 10 units of gold a year from today. The price of gold next year, S T , is normally distributed with mean 100 and volatility of 20%. The rm knows that there will be a buyer...

What does a higher margin value indicate when measuring insertion loss?

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...