for this data Year Month Time Period COGS

$11121637$

$2225506$

$3326594$

$4421933$

$5523117$

$6626979$

$7728337$

$8828926$

$9925015$

$101028196$

$111124170$

$121225004$

$211324575$

$21435848$

$31535217$

$41632759$

$51736542$

$61836109$

$71940279$

$82037816$

$92136338$

$102237814$

$112339359$

$122434151$

$312539862$

$22650664$

$32748533$

$42845382$

$52943981$

$63041276$

$73144284$

$83246920$

$93347469$

$103443187$

Apply the following

forecasting methods to forecast two years:

Implement each model in a separate

spreadsheet.

how to do

Weighted moving average using k$=12$

$($find w$\_($i$)$ using solver$)$ in excel spreadsheet explain in detail and calculate mse