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

in Mathematics by Euler
Favorite Add it to your favorites and revisit later
  • Develop a four month moving average forecast for Wallace Garden Supply and compute the MAD
  • Develop a four month moving average forecast for Wallace Garden Supply and compute the MAD
  • Develop a four month moving average forecast for Wallace Garden Supply and compute the MAD
  • Develop a four month moving average forecast for Wallace Garden Supply and compute the MAD
  • Develop a four month moving average forecast for Wallace Garden Supply and compute the MAD
Instant Download
Previewing 5 of 7 total pages.
Trouble downloading?
Copyright complaint
Instant download
Money-back guarantee
Regular Price: $21.43
Your Price: $15.00 (30% discount)
You Save: $6.43

Description

**A+ Tutorial/Guide

INCLUDES EXCEL SPREADSHEET WITH FORMULAS

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?

Comments (0)

You must sign in to make a comment.
Euler
@dgoodz
11146
758
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

Other items from Euler

Customers also bought

Customers also viewed