Tab

Window

Help

west$-2.$amazonaws.com$/$uploads$/$pdf$\_$attachment$/$file$/160918525/$m$2\_$Problem$\_$SetF$24....$

$\frac{1}{2}$

$50\%$

Name

uID $$

Note: You will find the two Demo videos in the module very helpful in solving these problems.

Problem $1.$ GameStop $($Tampa$)$ is forecasting sales for the Playstation $5$ in week $6,$ below are the sales figures for the last $5$ weeks:

$\backslash$table$[[$time t$,$Week,Sold$],[1,5$ Weeks ago:,$700],[2,4$ Weeks ago:,$725],[3,3$ Weeks ago:,$750],[4,2$ Weeks ago:,$780],[5,1$ Week ago:,$795]]$

Provide the equation $($formula$)$ and the forcecast for week $6$ sales using the specified method. You may type or handwrite your answers in the space provided but you must stay within the text box for each question. Round your final answers to the nearest whole number.

Nalua Annrnach $795$

$1\mathrm{.}1$ Forecast using the Naive Approach $(5$ points$)$

$1\mathrm{.}2$ Equation and forecast using a three$-$week moving average. Use the numeric values in your equation shown here, not Excel cell locations.$(10$ points$)$

$1\mathrm{.}3$ Equation and forecast using a weighted average using $75$ for last week $($time $t=5),15$ for $2$ weeks ago $($time $t=4)$ and $.10$ for $3$ weeks ago $($time $t=3).$ Use the numeric values in your equation,

$1\mathrm{.}4$ Equation and forecast using Exponential Smoothing with a smoothing constant equal to $40.$ To start, use a forecast of $700$ for time $t=2$ Show only the numeric values used to calculate the final week and round your final answer to the nearest whole number $(20$ points$)$

$(0\mathrm{.}75795)+(0\mathrm{.}15780)=788\mathrm{.}25q,$

$767$