Hi, I really need help figuring out to answer question number 1 on how to conduct a 2 year weighted moving average to forecast the annual sales, I need help with the formulas, and I also need help with question number 2 on computing the cost of goods sold using the percent of sales method.

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, Cost of Goods Sold (COGS), and Gross Profit 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 3 You are certain you can get volume discounts on your parts and materials now that your Sales are expected to increase. So, you estimate your COGS will be 52% of Sales, which is less than it has been in the past. Required: 1 (15 pts: 5 for showing work, 10 for accuracy) Conduct a 2 -year weighted moving average to forecast the annual sales for the years 2023-2027. Place your results on the Sales line of the Milestone 1 Sales Forecast tab in the highlighted area. (HINT: See Week 3 Lesson) 2 (10 pts: 2 for showing work, 8 for accuracy) Using the Percent-of-Sales method, compute Cost of Goods Sold. Then compute Gross Profit. Place your results on Milestone 1 Sales Forecast tab in the highlighted area. (HINT: see Week 3 Lesson) 3 (15 pts: 3 for spelling/grammar, 12 for correct answers) Answer the questions on the Milestone 1 Questions tab