Question: Answer D and E only please Charlie owns a company that sells and installs hot tubs; sales are fairly consistent from year to year. The
Answer D and E only please

Charlie owns a company that sells and installs hot tubs; sales are fairly consistent from year to year. The table below shows average sales per month for the previous year. Based on last year's data, calculate the forecasts for average sales per month for May - August, using the different methods below. a) Calculate the simple 3-month moving average forecast for May-August. (8 points) b) Calculate the weighted 3-month moving average for May - August using weights of 0.55,0.30, and 0.15 (highest weight for the most recent period). ( 8 points) c) Calculate the single exponential smoothing forecast for May - August using an initial forecast (F1) for February of 500 , and an of 0.45 . (10 points) d) Determine the equation of the linear trend line based on the data from February August; indicate the forecast for May - August. (12 points) e) Calculate the trend-adjusted exponential smoothing forecasts for May - August using an initial trend forecast ( T1) for February of 50 , and initial exponential smoothing forecast (S1) for February of 500 ; also, use an of 0.35 and a of 0.50 . (12 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
