Please answer the last 3 questions with the given information:

1 (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) How reliable is your Sales Forecast? Explain your answer. 2 (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) You used a weighted moving average to forecast your sales figures. Name two other methods of forecasting that may produce a more accurate result, and explain why you think the results would be better with these two selected methods. (HINT: See Week 1 and Week 3 Lessons) MILESTONE 1 SALES \& GROSS PROFIT FORECAST Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. It's currently January 1, 2023, and you'll be going on Shark Tank in 2 weeks. Using the information below, create your 5year 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. (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) Looking at your Gross Profits across the forecasted years, do you think the sharks will provide the funding you are requesting? Explain why or why not