Please help explain how to solve all portion of the problem below. Thank you

Problem #1 (80 points) This company wants you to predict sales of product X for August. You decide to use all the forecasting methods youve studied to come up with a prediction.

Time Series Data

Month	Sales
Jan	19
Feb	18
March	15
April	20
May	18
Jun	22
July	20

A. Using the NAVE approach forecast sales August. (show work)

B. Using a 5-month moving average. (show work)

C. Using a weighted average using .60 for July, .30 for June, .10 for May.

D. Exponential smoothing with a smoothing constant equal to .20, assuming a February forecast of 19.

E. Produce a line chart for the existing sales.

F. Linear trend. (10 points) Hint: Add a trend line to the line chart and display equation on the chart from which to predict August sales.

G. Produce a table, as pictured, to compile August predictions.

Method	Prediction
Naive
Moving Avg
Weighted Avg
Exponential smoothing
Linear

H. Analysis: (15 points)

a. What number will you present to the company as a prediction for August?

b. Were all methods appropriate for this task? Explain your thoughts. (Dont write up instructions on how to calculate anything.)