Question 3 Demand data for a product over the last 5 months are given below. Calculate forecasts for months 3 through 6 using two-month moving averages. Do not round answers. Month Demand Forecast 1 135 2 151 3 149 4 144 5 126 6 Download CSV\fQuestion 4 Demand data for trucks at a dealership over the last 5 years are given below. Calculate forecasts for years 4 through 6 using three-year weighted moving averages with weights 2, 2 and 4. Do not round answers. Year Demand Forecast 1 208 2 226 3 272 4 210 5 260 6 Download CSV\f. Question 5 Actual sales for a product over the last 4 periods are given below. Given a = 0.9, calculate simple exponential smoothing forecasts for periods 3 to 5. Do not round answers. Period Actual Forecast 1 300 2 210 300 3 240 4 230 5\f. Question 6 A small company gathered sales data over the last 7 months as follows: Month Sales January 249 February 210 March 204 April 201 May 207 June 255 July 285 August Download CSV Do not round answers. a) What is the 3-month moving average forecast for August? b) What is the 2-month weighted moving average forecast for August using weights 3 and 2? Assign higher weight to the most recent period. c) Given that the exponentially smoothed forecast for February is 249, what is the simple exponential smoothing forecast for March with a = 0.2?