### Develop a four month moving average forecast for Wallace Garden Supply and compute the MAD

in Mathematics by Euler
Previewing 5 of 7 total pages.
Money-back guarantee
Regular Price: \$21.43
You Save: \$6.43

You have 0 credits. Earn credits

#### Description

**A+ Tutorial/Guide

5-13: Develop a four month moving average forecast for Wallace Garden Supply and compute the MAD. A three month moving average forecast was developed in the section on moving averages in Table 5.3

5-15: Data collected on the yearly demand for 50 lb. bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a three year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Which method do you think is best?

YEAR DEMAND FOR FERTILIZER

``                                                                                                         (1,000s of bags)``

1 4

2 6

3 4

4 5

5 10

6 8

7 7

8 9

9 12

10 14

11 15

5-16: Develop a trend line for the demand for fertilizer in Problem 5-15, using any computer software.

5-19: Sales of Cool-Man air conditioners have grown steadily during the past 5 years

YEAR SALES

1 450

2 495

3 518

4 563

5 584

6 ?

The sales manager had predicted, before the business started, that year 1s sales would be 410 air conditioners. Using exponential smoothing with a weight ? = 0.30, develop forecasts for years 2 through 6.

5-25: Sales of industrial vacuum cleaners at R. Lowenthal Supply Co. over the past 13 months are as follows:

SALES (\$1,000) MONTH SALES (\$1,000) MONTH

11 January 14 August

14 February 17 September

16 March 12 October

10 April 14 November

15 May 16 December

17 June 11 January

(a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February.

(b) Using a weighted moving average with three periods, determine a demand for vacuum cleaners for February.

(c) Evaluate the accuracy of each of these methods.

(d) What other factors might R. Lowenthal consider in forecasting sales?

Euler
@dgoodz
11351
759
Rating:
Published On:
04/03/2013
Print Length:
7 page(s)
File Name:
Quantitative Analysis 5-13, 5-15, 5-16, 5-19, 5-25.xlsx
File Size:
52.49 KB (0.05 MB)
Sold By:
Euler
Purchased:
14 times
Best Seller Ranking:
#299