What is the forecast for May using a four-month moving average? Nov. Dec. Jan. Feb. Mar....

Question

Question

Nov.	Dec.	Jan.	Feb.	Mar.	April
29	26	30	32	38	36

Please explain how to arrive at the correct answer. Thanks a lot Step by step would be great.

Answer 1

Answer #1

b. 34

Using the four month moving average method the forecast would be,

F(May) = {Actual(Apr) + Actual(Mar) + Actual(Feb) + Actual(Jan)}/4

= (36 + 38 + 32 + 30)/4

= 136/4

= 34

Answer 2

Similar Homework Help Questions

What is the forecast for July using a four-month moving average? DEC 96 APR 46 JAN...

What is the forecast for July using a four-month moving average? DEC 96 APR 46 JAN NIOOW 39 40 FEB 42 MAR 48
Moving average (MA) Calculate the sales using 2, 3, 4, 5, and 6 month moving average...

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...
The monthly sales for Yazici Batteries, Inc., were as follows: Jan Month Feb Mar Apr May...

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...

1)Given the data in the table, calculate the four period moving average forecast for unemployment...

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
What is the demand forecast for May if you use a 3 month moving average based...

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
The monthly sales for Yazici Batteries, Inc. were as follows: Month Jan 20 Feb 21 Mar...

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 history, use a three-quarter moving average to forecast the demand for the third...

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...

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
AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12...

AutoSaveff File Home InsertPage Layout Formulas Da D1 1 Year Month 2 1 13 17 1 January February 15 4 1 March 511 April 6 1 May 12 32 15 June 1 July 91 August 17 101 September33 15 October 12 1 November34 December 21 14 2 January26 15 2 February10 13 1 162 March 17 2 April 18 2 May 14 19 17 14 27 30 222 September25 June 21 2 23 2 25 27 3 29 3 August...

Month Sales $ Month Sales $ Jan 88,498 July 28,618 Feb 34,044 Aug 58,273 Mar 58,273...

Month Sales $ Month Sales $ Jan 88,498 July 28,618 Feb 34,044 Aug 58,273 Mar 58,273 Sep 88,498 Apr 28,618 Oct 58,273 May 88,498 Nov 34,044 June 34,044 Dec 28,618 The table contains the Sales estimates for the next year. Sales are collected as follows: In the month of Sales: 33% In the next month: 21% After 2 months: 7% After 3 months: remainder is collected What is the cash collection for September? Enter your answer rounded off to two...