Insert

Draw

Page Layout

Formulas

Data

Review

View

Automate

Tell me

Calibri $($Body$)$

$11$

$A^n{A}^n$

Wrap Text $$

General

B

I

$U_{?}$

$aA.$

Merge & Center

fx $41$

A

B

C

D

E

F

G

H

$($iii$)$ Enter appropriate formulae in the shaded cells to calculate an exponential smoothing forecast for week $9$ demand.

You should use the smoothing constant specified above and week one demand as the starting forecast for week two.

$($iv$)$ Use the forecasts from weeks $4$ to $8$ to calculate the MAPE.

$\backslash$table$[[$Week$,\backslash$table$[[$Starting$],[$forecast$]],\backslash$table$[[$Demand$],[(00$s$)]],,],[1,,45,,\backslash$table$[[$Forecast for$],[$next week$]]],[2,45,40,,,],[3,,38,,,],[4,,43,,,],[5,,39,,,],[6,,43,,,],[7,,47,,,],[8,,33,,,],[9,,,,,]]$

Absolute

percentage

error

MAPE:

Ready

instructions

$01$

Q$2$

Q$3$

$04$

Q$5$