Quantitative Problems - Forecasting

Below are monthly sales figures: Month Sales Jan 919 Feb 902 Mar 913 Apr 906 May 914 Jun 944 What is the naive forecast for July? (Provide your answer rounded to the nearest unit. Example --> 825) Below are monthly sales figures: Month Sales Jan 904 Feb 903 Mar 926 Apr 904 May 903 Jun 919 What is the 3-month moving average forecast for July? ( (Provide your answer rounded to the nearest unit. Example --> 825) Below are monthly sales figures: Month Sales Jan 911 Feb 919 Mar 922 Apr 921 May 940 Jun 921 What is the weighted moving average forecast for July using the weights below? Most recent period: .50 Next most recent period:.30 Next: .20 (Provide your answer rounded to the nearest unit. Example --> 825) Below are monthly sales figures: Month Sales Jan 905 Feb 910 Mar 925 Apr 912 May 921 Jun 920 What is the value for "b" ? (also called the slope of the linear trend line) (Provide your answer rounded to 4 decimal places unit. Example --> 55.1234) Below are monthly sales figures: Month Sales Jan 905 Feb 910 Mar 925 Apr 912 May 921 Jun 920 What is the value for "a" ? (also called the y-intercept of the linear trend line) (Provide your answer rounded to 4 decimal places unit. Example --> 55.1234) Below are monthly sales figures: Month Sales Jan 905 Feb 910 Mar 925 Apr 912 May 921 Jun 920 Using the values you calculated for "b" and "a" provide a forecast for August. (Provide your answer rounded to the nearest unit. Example --> 825)