Manager Trying Determine Forecasting Method Use Based Upon Following Historical Data Calcu Q34311773

Your manager is trying to determine what forecasting method touse. Based upon the following historical data, calculate thefollowing forecast and specify what procedure you wouldutilize.

MONTHACTUALDEMAND159262364465573675775878978108111821285

a. Calculate the simple three-month movingaverage forecast for periods 4–12. (Round your answers to 3decimal places.)

MonthThree-Month
Moving Average456789101112

b. Calculate the weighted three-month movingaverage for periods 4–12 using weights of 0.40 (for the periodt−1); 0.50 (for the period t−2), and 0.10 (forthe period t−3). (Do not round intermediatecalculations. Round your answers to 1 decimal place.)

MonthThree-MonthWeighted
Moving Average456789101112

c. Calculate the single exponential smoothingforecast for periods 2–12 using an initial forecast(F1) of 58 and an α of 0.40.(Do not round intermediate

OR

 

PayPal Gateway not configured

OR

 

PayPal Gateway not configured