Question: i have done all the calculations for this assignment. can someone please help me answer the 2 questions below? first question is: how reliable is

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. 2 (10 points) What are some ways you could potentially improve the accuracy of your forecast
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
