For Simple Moving Average, use the previous 3 periods For Weighted Moving Average, use weights of 0 6, 0 3, and 0 1 for the previous 3 periods For Exponential Smoothing, use smoothing constant alpha 0 4 and assume the forecast for Dec 2014 to be 9,500 The spreadsheet template is set up for a 24 month period encompassing 2015 2016 Your deliverable is to populate the empty cells and upload the completed spreadsheet to Canvas Do not worry about answering the questions shown on page 230 CASE 7 1 TIRES FOR YOU Simple Moving Average Error AD Weighted Moving Average Error AD Exponential Smoothing Error AD FC APE FC APE FC APE 9,500 Period 2014 10 2014 11 2014 12 2015 01 2015 02 2015 03 2015 04 2015 05 2015 06 2015 07 2015 08 2015 09 2015 10 2015 11 2015 12 2016 01 2016 02 2016 03 2016 04 2016 05 2016 06 2016 07 2016 08 2016 09 2016 10 2016 11 2016 12 24 mo Total MAD MAPE Actual 9,797 11,134 10,687 9,724 8,786 9,254 10,691 9,256 8,700 10,192 10,751) 9,724 10,193 11,599 11,1301 10,696 9,665 10,179 11,760 9,150 9,571 8,375 11,826 10,696 11,212 9,750 9,380

The Answer is in the image, click to view ...

Question: For Simple Moving Average, use the previous 3 periods. For Weighted Moving Average, use weights of 0.6, 0.3, and 0.1 for the previous 3 periods.

For Simple Moving Average, use the previous 3 periods.

For Weighted Moving Average, use weights of 0.6, 0.3, and 0.1 for the previous 3 periods.

For Exponential Smoothing, use smoothing constant alpha = 0.4 and assume the forecast for Dec. 2014 to be 9,500.

The spreadsheet template is set up for a 24 month period encompassing 2015-2016. Your deliverable is to populate the empty cells and upload the completed spreadsheet to Canvas. Do not worry about answering the questions shown on page 230.

For Simple Moving Average, use the previous 3

CASE 7.1 - TIRES FOR YOU Simple Moving Average Error AD Weighted Moving Average Error AD Exponential Smoothing Error AD FC APE FC APE FC APE 9,500 Period 2014-10 2014-11 2014-12 2015-01 2015-02 2015-03 2015-04 2015-05 2015-06 2015-07 2015-08 2015-09 2015-10 2015-11 2015-12 2016-01 2016-02 2016-03 2016-04 2016-05 2016-06 2016-07 2016-08 2016-09 2016-10 2016-11 2016-12 24 mo. Total MAD MAPE Actual 9,797 11,134 10,687 9,724 8,786 9,254 10,691 9,256 8,700 10,192 10,751) 9,724 10,193 11,599 11,1301 10,696 9,665 10,179 11,760 9,150 9,571 8,375 11,826 10,696 11,212 9,750 9,380

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!

Tires for You 23:59 195 25 xlsx Read Case 7.1 in your textbook on pages 229-230. Using all of the data from both pages, populate the empty cells in this spreadsheet: Tires for You template.xlsx For...

For Simple Moving Average, use the previous 3 periods. For Weighted Moving Average, use weights of 0 . 6 , 0 . 3 , and 0 . 1 for the previous 3 periods. For Exponential Smoothing, use smoothing...

Read Case 7 . 1 in your textbook on pages 2 2 7 - 2 2 9 . Using all of the data from both pages, populate the empty cells in this spreadsheet: Tires for You template.xlsxDownload Tires for You...

the historical demand for a product is below. please forcast the demand in april. a.) use a 3 month simple moving average b.) use a 3 month weighted moving average with weight of 0.6, 0.3, and 0.1...

Show all work and formulas This homework is a continuation of HMWK 6. Assume that you evaluated four forecasting models: 1) moving average, n=2, 2) moving average, n=4, 3) weighted moving average,...

4. The historical demand for a product is: Week 1 2 3 4 5 Demand 40 70 100 130 160 Forecast the demand in the 6 th week by (a) using a 4-week simple moving average (1 point). (b) using a 4-week...

The following is the data for the number of complains a telephone company received during the past 5 weeks for the service they offer. Use the data to forecast the number of complaints for week 6,...

Problem 927210: Do not include anything other than numbers in your responses. For example, do not include comma or dollar sign in your numbers. As a rule of thumb, keep 2 decimal places for larger...

Question 4 The table below shows the monthly demand of a company's product in 2015. Month Demand 1 650 2 700 3 810 4 800 5 900 6 700 (a) Compute the demand of the company's product using: (i) 3-month...

Do not include anything other than numbers in your responses. For example, do not include comma or dollar sign in your numbers. As a rule of thumb, keep 2 decimal places for larger numbers and 3...

What is inventory turnover? What does it tell a stakeholder about how the entity is managing its inventory? What could be some reasons for a decreasing inventory turnover ratio ? What could be some...

Edwards Electronics recently reported $14,500 of sales, $5,500 of operating costs other than depreciation, and $1,250 of depreciation. The company had no amortization charges, it had $3,500 of bonds...

3 In Extract 1, the writer uses present tense verbs such as rises, spots and walk. Write a paragraph commenting on the verbs the writer has chosen to build detail in this extract. You should also...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...