Company Metalworks produces metal plates that are used in construction. You are a planning manager for Metalworks.

Forecast below shows historical sales of metal plates assemblies that are used in construction.

Lead time for metal material is $6$ weeks and you need to provide materials forecast to your suppliers, that will provide firm re

You need to generate forecast for metal plates $,$ to ensure you will be able to distribute this information to check internal and

Today is Jan $-23.$ Listed below are the historical sales

$1.$ Calculate a forecast using a simple $3$ months moving average

$2.$ Calculate the forecast using $3-$period weighted moving average. Use weights of $0\mathrm{.}6,0\mathrm{.}3$ and $0\mathrm{.}1$ for the most recent period, second most recent period and $3$rd most recent period accordingly

$3.$ Calculate the forecast using exponential smoothing method. Assume the forecast per period is $9500$ and alpha is $0\mathrm{.}40$

Por favor revisa con atenci$$n$,$ debemos completar la columna del a$$o $2023$ no cometas errores

Simple Moving Average

$202120222023$

Jan $9,724$

Feb $8,786$

March $9,254$

April $10,691$

May $9,256$

June $8,700$

July $10,192$

August $10,751$

September $9,724$

October $9,79710,193$

November $11,13411,599$

December $10,68711,130$

Weighted Moving Average

$202120222023$

Jan $9,724$

Feb $8,786$

March $9,254$

April $10,691$

May $9,256$

June $8,700$

July $10,192$

August $10,751$

September $9,724$

October $9,79710,193$

November $11,13411,599$

December $10,68711,130$

Exponential Smoothing

$202120222023$

Jan $9,724$

Feb $8,786$

March $9,254$

April $10,691$

May $9,256$

June $8,700$

July $10,192$

August $10,751$

September $9,724$

October $9,79710,193$

November $11,13411,599$

December $10,68711,130$