1.

A small company gathered sales data over the last 7 months as follows: Month Sales January 273 February 225 March 276 April 219 May 288 June 228 July 225 August Download CSV Do not round answers. a) What is the 3-month moving average forecast for May? b) What is the 2-month weighted moving average forecast for May using weights 3 and 2? Assign higher weight to the most recent period. c) Given that the exponentially smoothed forecast for February is 273, what is the simple exponential smoothing forecast for March with o = 0.3?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 1, 2 and 5. Do not round answers. Year Demand Forecast 252 2 236 228 4 230 5 268 6