Please show the answer using excel (just a screenshot will do) and kindly show how you did it. Thank you!!

ACTIVITY: Forecasting INSTRUCTIONS: Solve the give problem completely. 1. Mr. Stevenson owns an oil refinery in Saudi that has a processing unit for making lubricating oil (called lube oil in the business). Even though the production of lubricating oil requires a high capital investment, the profit margin from this product is higher than normal straight run products such as gasoline, and diesel fuel. The production manager in the lube oil plant needs to develop a simple forecasting model for estimating its blending requirements. The table below gives the actual lubricating oil blended in a particular year. Month January February March April May June Actual oil used in liters) 12,000 14,000 15,000 18,000 21,000 19,000 13,000 24,000 33,000 20,000 18,000 16,000 July August September October November December Required: a. Develop a three-month simple moving average forecasting model. b. Develop a three-month weighted moving average using a factor of 0.5 for the most recent period, 0.3 for the next period, and 0.2 for the oldest period