Answer to Question #219198 in Macroeconomics for BROTHER

Question

Based on the given sales volume of AZ’s sanitizer product for 16 weeks, construct the trend projection using graphs, 3 weeks moving average, and exponential smoothing methods. Weeks Sanitizer sales 1 5600 2 5200 3 4570 4 4305 5 5465 6 8900 7 15680 8 24680 9 35040 10 36500 11 38575 12 35300 13 35200 14 35150 15 34950 16 34500

Answer 1

We have used Excel to help you solve the problem.

First, we have entered the data as follows:

Select the column of the data (not the time) including the label > Insert > Insert Line or Area Chart > Line (under 2-D Line).

Go to Design > Quick Layout, and select a layout which displays the chart title, and both axes titles.

The following output is obtained:

After a more-or-less constant sales for the first 4 weeks, the graph shows an exponential increase till the 9^th week. Thereafter, the sanitizer sales become relatively constant aside from slight fluctuations.

For the 3-week moving average, go to Data Analysis > Moving Average > OK.

Enter Input Range as $B$1:$B$16, tick on Labels, and enter Output Range as $C$2.

Click OK.

The relevant moving average values are stored in column C.

For an exponential smoothing (smoothing or damping constants unknown), go to Data Analysis > Exponential Smoothing > OK.

Enter Input Range as $B$1:$B$16, tick on Labels, and enter Output Range as $D$2.

Click OK.

The relevant exponential smoothing values are stored in column D.

The following image shows the moving average and exponential smoothing projections for the time periods given here: