Use 2 period Weighted Moving Average forecasting and solve using excel

Case Problem: Electra-City is a retail store that sells audio and video equipment for the home and car. Each month, the manager of the store must order merchandise from a distant warehouse Currently, the manager is trying to estimate how many woofers the store is likely to sell in the next month. To assist in this process, he has collected the data shown in accompanied table on the number of woofers sold in each of the previous 24 months. He wants to use these data in making his prediction