Question: There are six forecasting methods presented in the chapter slides. Use the same data set below to forecast from April through December for all six
-
There are six forecasting methods presented in the chapter slides. Use the same data set below to forecast from April through December for all six methods. Also calculate error terms for each forecast. Please use an excel spreadsheet to do all of your work, and please plot the actual data below using the graph function.
Please watch the videos if you need to see how to make the forecasts.
Important Note: Assume you know actual values of January, February, March, and April but that you don't know actual values (even though they are given) for April through December. You only forecast the next month after the previous month is revealed.
Month X-Values of number of the month Y - values or Actual Demand for the Month Forecasted Demand Starting in April Jan 1 16 X Feb 2 22 X Mar 3 20 X Apr
4 16 X May 5 25 Jun 6 35 Jul 7 33 Aug 8 32 Sept 9 39 Oct 10 47 Nov 11 43 Dec 12 44
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
