excel or sheets

Using the exponential smoothing forecasting techniques discussed in class, determine next three months (12 weeks) demand for the product, assuming the product sold 5000, 6000 and 7000 respectively in the previous three months. Use a base value smoothing constant () of 0.3 and the forecasting model ESFt-1 + (actual demandt - ESFt-1).

Forecast for period tFt=Ft:1+Q(Dt1Ft1) Let forecast for month 1F1=5000 units F2=F1+Q(D1F1)=5000+0.3(50005000)=5000unitsF3=F2+Q(D2F2)=5000+0.3(60005000)=5000+300=5300unitsF4=F3+(D3F3)=5300+0.3(70005300)=5300+510=5810units ,Use the forecasted results to develop a 12-week master production schedule for all the parts to be produced. Show the following in a tabular form: period in weeks, forecast demand, available items, MPS, and number on hand. Use the master schedule to develop a weekly MRP record