VCASE: Trend $/$ Seasonality

Forecasting Assignment in Excel

Month Sales in Units $-$ By Year

$1234$

January $480575608654$

February $236327397435$

March $482540612683$

April $448502603654$

May $158208228275$

June $489573605654$

July $498508627684$

August $430498578701$

September $544585692741$

October $496526581620$

November $487552632763$

December $525587656687$

Totals $5273598168197551$

$<<<$ The trend line for this data is y $=767\mathrm{.}2$ x $+4488>>>$

$1.$ Determine the forecast $($total$)$ for Year $5$

$2.$ Given the above data, what forecasting technique would be appropriate?

$3.$ Create a forecast using your recommended technique $($use whole numbers$)$

$--------------------------------------------------------------------------------------------$

$$ This CASE should be completed in Excel with the appropriate

formulas. Instructions for formulas used on e $-$conestoga.

$$ There should be a total of $2$ worksheets. $1$st $($answers$)$ & $2$nd $($formulas sheet with

student Name and ID number in footer$)$

$$ Upload a copy of excel file to the Assignments dropbox in eConestoga.

$$ This assignment will be marked on the use of formulas learned in BCA$1$ and BCA$2$

$$ Remember you want to build formulas for the future, not for the present. There should

be no numbers in the formulas! Please use cell references $-$ not numbers $-$ in formulas,

and use "calculated" totals to verify your data entry. Max $2$ decimals