Blue Bell Inc (BBI) is a company that collects smartwatches. Reprocesses them and resells them to Blue Bell Inc (BBI) is a company that collects smartwatches. Reprocesses them and resells them to consumers. Historical monthly quantities collected smartwatches ("returns") in the last seven months are displayed in the table below.

Month and units returned

August 59

September 86

October 92

November 90

December 76

January 64

February 88

a) Given the above data, calciate the forecast using a weighted moving average to forecast for the 8th month, i.e. March. Weights of 0.18, 0.34, and 0.48 for December, January, and February, respectively.

b) Calculate the sales forecast for March (8th month) using simple exponential smoothing with a = 0.30 when the forecast for January is 74 units.

c) Calculate the exponential smoothing with trend forecast of March (8th month) for the above data using an (Alpha) a of 0.40, a (delta) 8 of 0.70, a January forecast [FJanuary] of 93 units and an estimated January trend [TJanuary] of 5.65, respectively.