SOLVE THIS PROBLEM USING EXCEL, SHOW EACH STEP YOU USED PLEASE SHOW THE EXCEL SCREENSHOTS TOO. THANK YOU! Bobs Gas n Go service station, located in a small town in upper Michigan, has the following quarterly sales from 2018 thru 2023. \ Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 \ 2018 $80,120 $91,660 $115,840 $71,940 \ 2019 $86,760 $92,920 $125,960 $75,920 \ 2020 $90,880 $96,540 $130,460 $80,750 \ 2021 $94,260 $104,680 $134,840 $86,960 \ 2022 $97,240 $108,680 $140,550 $85,280 \ 2023 $101,560 $111,200 $144,770 $89,520\ \ \ a. Construct a time series plot. Do you see any seasonality? Do you see any trend? Comment.\ b. Develop a regression model with dummy variables (to account for seasonality) to forecast by quarters. Use the following dummy variable scheme. \ Note that in this model you dont have trend; you have only seasonality.\ \ Dummy 1 takes a value of 1 for Quarter 1 and 0 for other quarters.\ Dummy 2 takes a value of 1 for Quarter 2 and 0 for other quarters.\ Dummy 3 takes a value of 1 for Quarter 3 and 0 for other quarters.\ \ Using the model develop forecast by quarter for 2024 and 2025.\ \ c. Using t =1 for the first quarter 2018, and t = 2 for the second quarter 2018 and so on, develop a regression model to account for seasonal effects of the data and the trend. Use the same dummy variable scheme as above. Using the model develop quarterly forecast for 2024 and 2025.\ \ d. Comment (looking for critical comments) on the above two models.