Please disreguard Required part 2. I have another tab for those questions.

It's currently January 1, 2023, and you'll be going on Shark Tank in 2 weeks. Using the information below, create your 5-year Sales Forecast for the years 2023-2027. Information: 1 Actual annual sales in the past: \begin{tabular}{|c|c|c|c|} \hline & 2020 & 2021 & 2022 \\ \hline Actual SALES & $1,200,000 & $1,500,000 & $1,875,000 \\ \hline \end{tabular} 2 Because you feel your most recent sales are the best predictor of future sales, you weight your sales as follows: W1=0.2 and W2=0.8 Required: 1 (20 pts) Conduct a 2-year weighted annual sales forecast for the years 2023-2027. Place your results on the Sales line of the Milestone 1 Sales Forecast tab in the highlighted area