Charlie owns a company that sells and installs hot tubs; sales are fairly consistent from year to year. The table below
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Charlie owns a company that sells and installs hot tubs; sales are fairly consistent from year to year. The table below
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. Average Sales per Month Month February 550 March 450 April 600 May 850 June 925 July 675 August 500 a) Calculate the simple 3-month moving average forecast for May - August. (9 points) May: 550+450+600/3=533.33 June: 450+600+850/3=633.33 July: 600+850+925/3 = 791.67 August: 850+925+675/3=816.67 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). (9 points) May = (550*0.15)+( c) Calculate the single exponential smoothing forecast for May- August using an initial forecast (F1) for February of 500, and an a of 0.45. (12 points)
Charlie owns a