Page 1 of 4 ZO 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: Actual annual sales in the past: 2020 2021 2022 Actual SALES |$1,200,000 $1,500,000| $1,875,000 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 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: 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 Week3 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 Week3 Lesson) 3 (15 pts: 3 for spelling/grammar, 12 for correct answers) Answer the questions on the Milestone 1 Questions tab. hp