Budgeting and Forecasting

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: 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. 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 hitolirs your worki All your work must be shown on this sheet, not on a separate tab. 1 (10 points) How reliable is your Sales Forecast? Explain your answer. 2 (10 points) What are some ways you could potentially improve the accuracy of your forecast? 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: 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. 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 hitolirs your worki All your work must be shown on this sheet, not on a separate tab. 1 (10 points) How reliable is your Sales Forecast? Explain your answer. 2 (10 points) What are some ways you could potentially improve the accuracy of your forecast