Steps

$1.$ Read scenario and approach.

$2.$ In Activity $1$ you will need to forecast for each month of Year $2,$ beginning in January.

$3.$ The Year $1$ Table provides Actual Demand as well as the demand that forecasted using $5$ different forecasting techniques: Na$$ve$,3-$Month Moving Average, Exponential Smoothing for $\mathrm{.}2,$ Exponential Smooth for $\mathrm{.}5,$ and Seasonal. From month to month, different techniques may be more effective, which you can tell from the Forecast Error. The most effective technique is the one with a Forecast Error closest to $0.$

$4.$ Note that the Year $2$ table will fill out automatically as you input your forecasts in the Activity section.

$5.$ To get started with your own forecast:

a$.$ Review the Year $1$ data. Look especially at the latest month of data to identify which forecasting strategy was most effective for that month.

b$.$ Use the JAN Year $2$ input box in the Activity section to input your forecast. Input the forecast from the strategy that performed best in the previous month. That month Actual Demand will automatically be filled out for you.

c$.$ In the Year $2$ table you can see how the different forecasting strategies performed. Remember you want to use the strategy that was most effective for the latest month. Repeat the steps each month to complete the Activity inputs.

$6.$ For Activity $2,$ review your forecasts and identify which forecasting technique best fit the data based on overall performance. $($Typically the technique you used most frequently.$)$

$7.$ Click the I

I button to keep your progress. Once you've finished the assignment, click the button to receive your grade and feedback. Scenario

You have been given a task to create a demand forecast for the second year of sales of a premium outdoor grill. Accurate forecasts are important for many reasons, including for the company to ensure they have the materials they need to create the products required in a certain period of time. Your objective is to minimize the forecast error, which will be measured using the Mean Absolute Percentage Error $($MAPE$)$ with a goal of being below $25\backslash \%.$

You have historical monthly sales data for the past year and access to software that provides forecasts based on five different forecasting techniques $($Na$$ve$,3-$Month Moving Average, Exponential Smoothing for $\mathrm{.}2,$ Exponential Smooth for $\mathrm{.}5,$ and Seasonal$)$ to help determine the best forecast for that particular month. Based on the given data, you will identify trends and patterns to create a more accurate forecast.

Approach

Consider the previous month's forecast to identify which technique is most effective. Use that to forecast the next month.

Remember to select the forecasting technique that produces the forecast error nearest to zero. For example:

a$.$ Na$$ve Forecast is $230$ and the Forecast Error is $-15.$

b$.3-$Month Moving Forecast is $290$ and the Forecast Error is $-75.$

c$.$ Exponential Smoothing Forecast for $\mathrm{.}2$ is $308$ and the Forecast Error is $-93.$

d$.$ Exponential Smoothing Forecast for $\mathrm{.}5$ is $279$ and the Forecast Error is $-64.$

e$.$ Seasonal Forecast is $297$ and the Forecast Error is $-82.$

The forecast for the next month would be $230$ as the Na$$ve Forecast had the Forecast Error closest to zero with a $-15.$ This forecasting technique was the best performing technique for that month. You do not need to do any external analysis$-$the forecast error for each strategy is already calculated for you in the tables below. $\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline lonth & Period & Actual Demand & Na$$ve & $\backslash$begin$\{$tabular$\}\{$l$\}$

Na$$ve $\backslash \backslash$

Forecast $\backslash \backslash$

Error

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Month $\backslash \backslash$

Moving $\backslash \backslash$

Forecast

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Month $\backslash \backslash$

Moving $\backslash \backslash$

Forecast $\backslash \backslash$

Error

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Exponential $\backslash \backslash$

Smoothing $\backslash \backslash$

Forecast $\backslash \backslash$

for $\mathrm{.}2$

$\backslash$end$\{$tabular$\}$ & Exponential Smoothing $.2$ Forecast Error & $\backslash$begin$\{$tabular$\}\{$l$\}$

Exponential $\backslash \backslash$

Smoothing $\backslash \backslash$

Forecast $\backslash \backslash$

for $\mathrm{.}5$

$\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}$

Exponential $\backslash \backslash$

Smoothing $\backslash \backslash$

$.5$ Forecast $\backslash \backslash$

Error

$\backslash$end$\{$tabular$\}$ & Seasonal & $\backslash$begin$\{$tabular$\}\{$l$\}$

Seasor $\backslash \backslash$

Foreca $\backslash \backslash$

Errol

$\backslash$end$\{$tabular$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{13\}\{|$l$|\}\{-$ Year $1\}\backslash \backslash$

$\backslash$hline JAN & $1$ & $75$ & $70$ & $5$ & & & $74$ & $1$ & $73$ & $2$ & $79$ & $-4\backslash \backslash$

$\backslash$hline FEB & $2$ & $80$ & $75$ & $5$ & & & $74$ & $6$ & $74$ & $6$ & $94$ & $-14\backslash \backslash$

$\backslash$hline VAR & $3$ & $75$ & $80$ & $-5$ & $75$ & $0$ & $75$ & $0$ & $77$ & $-2$ & $83$ & $-8\backslash \backslash$

$\backslash$hline APR & $4$ & $103$ & $75$ & $28$ & $77$ & $26$ & $75$ & $28$ & $76$ & $27$ & $100$ & $3\backslash \backslash$

$\backslash$hline MAY & $5$ & $108$ & $103$ & $5$ & $86$ & $22$ & $81$ & $27$ & $90$ & $18$ & $83$ & $25\backslash \backslash$

$\backslash$hline JUN & $6$ & $112$ & $108$ & $4$ & $95$ & $17$ & $86$ & $26$ & $99$ & $13$ & $92$ & $20\backslash \backslash$

$\backslash$hline JUL & $7$ & $94$ & $112$ & $-18$ & $108$ & $-14$ & $91$ & $3$ & $106$ & $-12$ & $83$ & $11\backslash \backslash$

$\backslash$hline AUG & $8$ & $112$ & $94$ & $18$ & $105$ & $7$ & $92$ & $20$ & $100$ & $12$ & $101$ & $11\backslash \backslash$

$\backslash$hline jEPT & $9$ & $80$ & $112$ & $-32$ & $106$ & $-26$ & $96$ & $-16$ & $106$ & $-26$ & $77$ & $3\backslash \backslash$

$\backslash$hline OCT & $10$ & $70$ & $80$ & $-10$ & $95$ & $-25$ & $93$ & $-23$ & $93$ & $-23$ & $83$ & $-13\backslash \backslash$

$\backslash$hline VOV & $11$ & $80$ & $70$ & $10$ & $87$ & $-7$ & $88$ & $-8$ & $82$ & $-2$ & $94$ & $-14\backslash \backslash$

$\backslash$hline DEC & $12$ & $70$ & $80$ & $-10$ & $77$ & $-7$ & $86$ & $-16$ & $81$ & $-11$ & $91$ & $-21\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{13\}\{|$l$|\}\{-$ Year $2\}\backslash \backslash$

Activity $1$: Year $2$ Forecast

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multirow$[$t$]\{2\}\{*\}\{$Forecast next period$\}$ & $\backslash$multirow$\{2\}\{*\}\{$Year $2\}$ & $\backslash$multirow$\{2\}\{*\}\{$MAPE$\backslash \%\}$ & $\backslash$multirow$[$t$]\{2\}\{*\}\{$Average MAPE$\}$ & $\backslash$multicolumn$\{3\}\{|$c$|\}\{$Actual Demand$\}$ & $\backslash$multirow$[$b$]\{2\}\{*\}\{$Seasonal Index$\}\backslash \backslash$

$\backslash$hline & & & & Month & Year $1$ & Year $2$ & $\backslash \backslash$

$\backslash$hline JAN & $$ & & & JAN & $75$ & & $0\mathrm{.}954\backslash \backslash$

$\backslash$hline FEB & $-$ & & & FEB & $80$ & & $0\mathrm{.}848\backslash \backslash$

$\backslash$hline MAR & & & & MAR & $75$ & & $0\mathrm{.}901\backslash \backslash$

$\backslash$hline APR & & & & APR & $103$ & & $1\mathrm{.}033\backslash \backslash$

$\backslash$hline MAY & & & & MAY & $108$ & & $1\mathrm{.}298\backslash \backslash$

$\backslash$hline JUN & $\backslash (\backslash$checkmark $\backslash )$ & & & JUN & $112$ & & $1\mathrm{.}219\backslash \backslash$

$\backslash$hline JUL & & & & JUL & $94$ & & $1\mathrm{.}139\backslash \backslash$

$\backslash$hline AUG & & & & AUG & $112$ & & $1\mathrm{.}113\backslash \backslash$

$\backslash$hline SEPT & $\backslash (\backslash$checkmark $\backslash )$ & & & SEPT & $80$ & & $1\mathrm{.}033\backslash \backslash$

$\backslash$hline OCT & & & & OCT & $70$ & & $0\mathrm{.}848\backslash \backslash$

$\backslash$hline NOV & $\backslash (\backslash$cdot $\backslash )$ & & & NOV & $80$ & & $0\mathrm{.}848\backslash \backslash$

$\backslash$hline DEC & & & & DEC