Forecast for month n = (An-1 + An-2 + An-3 + An-4)/4
FMay = (46+48+42+40)/4 = 44
FJune = (44+46+48+42)/4 = 45
FJuly = (45+44+46+48)/4 = 45.75
What is the forecast for July using a four-month moving average? DEC 96 APR 46 JAN...
What is the forecast for May using a four-month moving average? Nov. Dec. Jan. Feb. Mar. April 29 26 30 32 38 36 38 34 33 32 Please explain how to arrive at the correct answer. Thanks a lot Step by step would be great.
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average values. Forecast and plot the upcoming period’s sales using the moving average series that fits best. Explain why you chose that particular MA. Why is it inadvisable to use the Moving Average approach to forecast far into the future? Month Sale Month Sale Month Sale Oct-12 13.30 Oct-13 24.01 Oct-14 50.56 Nov-12 1.70 Nov-13 32.67 Nov-14 60.06 Dec-12 11.44 Dec-13 23.19 Dec-14 61.73 Jan-13...
Use the following sales data to answer the questions. Month Sales January $250,000 February $200,000 March $300,000 April $350,000 May $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...
What is the demand forecast for May if you use a 3 month moving average based on the following forecast and actual demand data? Jan Feb Mar Apr Forecast 12 11 12 12 Actual 10 13 12 10 (Points : 3.03) 12 11 10.67 11.67
1)Given the data in the table, calculate the four period moving average forecast for unemployment rate for October 2011. Express your result in percent, without the percent sign (e.g., 7.3 for 7.3%). Unemployment Year Month Rate (%) 2010 Oct 6.8 Nov 7.0 Dec 7.5 2011 Jan 8.0 Feb 8.2 Mar 8.5 Apr 8.6 May 8.6 Jun 8.9 Jul 9.1 Aug 8.8 Sep 8.7 Oct
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Last year 170 200 210 240 250 270 225 215 215 275 280 300 This year 205 210 140 255 245 220 Forecast...
Question 1 Calcuate a five-period moving average forecast for June Period Actual Forecsat Jan 545 Feb 567 Mar 568 Apr 561 May 476 June
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 24 Sales 19 23 16 15 13 15 17 18 22 21 23 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach 22.67sales (round...
The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar 16 Apr May 15 13 Jun 18 Jul 15 Aug Sept Oct Nov Dec 18 19 22 202 This exercise contains only parts de b) The forecast for the next month (Jan) using the naive method = 24 sales (round your response to a whole number) The forecast for the next period (Jan) using a 3-month moving average approach = 22 sales (round your...
Given the following data, what is the Mean Absolute Deviation (MAD): Month Demand Forecast Jan 100 110 Feb 100 100 Mar 120 100 Apr 110 90 May 100 110 Jun 90 100 Jul 80 90 Aug 90 80 Sep 100 110 Oct 110 100 Nov 110 110 Dec 120 110 A. 10 B. 20 C. 30 D. 133.33