need help with part 2 which is 2 questions.

t'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: 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. 2 (20 pts) Answer the questions on the Milestone 1 Questions tab. 2 (10 points) What are some ways you could potentially improve the accuracy of your forecast