Question

This is a table to show how to calculate a three-month moving average. Please use this same data to calculate a four-month moving average. ACTUAL SHED SALES 10 12 13 16 19 23 26 30 28 18 16 MONTH 3-MONTH MOVING AVERAGE January March (10+ 12 + 13)3 -11.67 (12 13+ 16/3-13.67 (13 + 16 + 19)/3# 16.00 (16 + 19 +23Y3- 19.33 19 +23 + 26V3-22.67 (23+26 +30/3-26.33 (26+30 +28)V3-28.00 (30 +28 + 18/3-25.33 (28 + 18 + 163-20.67 (18 16 + 14V3- 16.00 April June July August October November December January
Develop a four month moving aeage forecast for Wallace Garden Supply and compute the MAD A theee month moving average forecast was developed in the attached table. You may also view this table at Resources Tab under the Problem Sets Tab Question 1 of 10 0 Points month moving average forecast for Walace Gardien Supplyis Please round it to an integer and include no units OA 17 O 8 18 O C19 OD 20 Mark for Review hats Thn Qestion 2 of 0 0 Poins The Mean Absolute Deviation (MAD for the above forecant is
0 0
Add a comment Improve this question Transcribed image text
Know the answer?
Add Answer to:
This is a table to show how to calculate a three-month moving average. Please use this...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use a three-period simple moving average and weighted-moving average and Naive methods to forecast the 8th...

    Use a three-period simple moving average and weighted-moving average and Naive methods to forecast the 8th month. Calculate and compare the MAD for methods. Month Sales MA AD WMA AD Naive AD 1 20 --- --- --- --- --- --- 2 25 --- --- --- --- --- --- 3 22 --- --- --- --- --- --- 4 26 5 22 6 24 7 26 8 ---- ? ? AD: Absolute Deviation MA: Moving Average WMA: Weighted Moving Average

  • VORE Senty Editor Use a three period simple moving average and weighted-moving average and Naive methods...

    VORE Senty Editor Use a three period simple moving average and weighted-moving average and Naive methods to forecast the 8th month Calculate and compare the MAD for methods AD WMA AD Naive AD Month Sales MA 1 20 2 25 3 22 4 26 5 22 6 24 7 26 8 ? AD: Absolute Deviation MA: Moving Average WMA: Weighted Moving Average

  • 1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks...

    1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...

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

  • observation, and 1/6 for the third most recent observation, compute a three-week weighted moving average for...

    observation, and 1/6 for the third most recent observation, compute a three-week weighted moving average for the time series. 2. a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent Error Forecast Sales Week 17 21 19 23 18 16 20 18 10 20 15 12 b. Compute the MSE for the weighted moving average in part (a) MSE - c. Do you prefer this weighted moving average to the unweighted moving average...

  • How to compute the average speed for each location? for example the pair is the location. how can...

    how to compute the average speed for each location? for example the pair is the location. how can I get all the locations of 1,2,3,4,5,6,7,8,9,10,11,12,13,14 and the speed for each of them to find the mean. I tried doing this df4=df [df [ ['pair', 'speed']]==1].mean() #To get all the pairs with 1's and it's speeds and getting the mean df4=df [df [['pair','speed']]==2].mean() #To get all the pairs with 2's and it's speeds and getting the mean . Unnamed: 0 speed...

  • A can opener manufacturer has had monthly sales for a seven-month period as follows: Month         ...

    A can opener manufacturer has had monthly sales for a seven-month period as follows: Month          Sales (000 units) Feb. 19 Mar. 18 Apr. 15 May 20 Jun. 18 Jul. 22 Aug. 20 a) Plot the data b) Forecast September's sales volume and the previous months and calculate MAD for each method using each of the following: 1)The naïve approach. 2)A four-month moving average. 3)A weighted average using .50 for the recent month, .30 for 2 months ago, and .20...

  • Question 3 part a & b. please show work! 3. The following time series shows the...

    Question 3 part a & b. please show work! 3. The following time series shows the number of units of a particular product sold over the past six months. Units Sold Month (Thousands) 23 2 17 3 17 4 5 26 11 23 6 a. Use a = 0.2 to compute the exponential smoothing values for the time series, forecast the sales volume for month 7, and fill in the unknown spaces. Units Sold Forecast (F) error Squared error Month...

  • You want to compare how two forecasting methods would perform on some historical sales data. You...

    You want to compare how two forecasting methods would perform on some historical sales data. You will forecast the sales for months 4 through 19, calculate the mean absolute deviation (MAD) for both methods, and you can claim that the one that has lower MAD performed better, at least for the historical data. a) The first method is known as the moving average method. The forecast for a month will be the average sales of three previous months. So, forecast...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT