Question: Use the data given in the table below to build the demand forecast using a 4 - week moving average as well as simple exponential

Use the data given in the table below to build the demand forecast using a 4-week moving average as well as simple exponential smoothing using alpha =0.1. Calculate MAPE in both the cases.

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!

Q:

solve number 2 please Year Quarter Unemployment rate 1974 1 5.4 2 5.3 3 5.3 4 5.6 1975 1 6.9 2 7.2 3 7.2 a. Estimate the unemployment rates in the fourth quarter of 1975 and the first quarter of 1976...

Q:

A) Forcast April through September using a 3-month moving average. B) Use simple exponential smoothing with an alpha of 0.3 to estimate April through September, using the average of January through...

Q:

1. The Canadian unemployment rate as a percentage of the civilian labor force (seasonally adjusted) between 1974 and the third quarter of 1975 is shown below: Quarter Unemployment rate Year 1974 1...

Q:

i want handwritten solution not with excel 1. The Canadian unemployment rate as a percentage of the civilian labor force (seasonally adjusted) between 1974 and the third quarter of 1975 is shown...

Q:

Week Number of smart phones Sold Forecast using 3 period moving average Error Forecast using exponential smoothing (with a=0.4) Error 1 48 2 41 3 55 4 64 5 62 6 55 7 8 Answer the following questions...

Q:

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this...

Q:

1. The Galamtour company has demand for an item for months January through September. Your manager needs to compare two forecasting strategies to see which one performed better over time. Month...

Q:

11 Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over...

Q:

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this...

Q:

Question 1: Following table shows the monthly sales of television at a retail store: Month Number of television Sold Forecast using 3 period moving average Error Forecast using exponential smoothing...

Q:

You started out with $440 and spent 60% of it. Then you spent 28% of what was left. How much money do you have left?

Q:

Given matrix A and vector b as shown below: 2 1 010 I A = 00 and b = (a) Compute B=ATA and find B- using any method you know. [2, 8 points] (b) Explain why Ax=b is inconsistent, and write down the...

Q:

Assume that you have found Galloway Inc. is under levered, with an actual debt ratio of 1 0 % and an optimal debt ratio of 4 0 % . Galloway is a mid - eap company that pays substantial dividends. It...

Q:

Bond X is noncallable and has 20 years to maturity, a 9% annual coupon, and a $1,000 par value. Your required return on Bond X is 12%; if you buy it, you plan to hold it for 5 years. You (and the...