Order ready-to-submit essays. No Plagiarism Guarantee!
Note: All our papers are written from scratch by human writers to ensure authenticity and originality.
Please see attached file for full problem description.
Check your essay before you submit. See exactly what your professor sees.
See your AI and plagiarism results before your instructor does.Get the exact same report your professor uses. Trusted by 50,000+ students worldwide.
5-12
Develop a four-month moving average forecast for Garden Wallace Supply and compute the MAD. A three-month moving average forecast was developed in the section on the moving averages in Table 5.3.
5-13
Using MAD, determine whether the forecast in Problem 5-12 or the forecast in the section concerning Wallace Garden Supply is more accurate.
5-14
Data collected on the yearly demand for 50-pound 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 two years are each given the 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-18
Sales of Cool-Man air conditioners have grown steadily during the past five 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 1’s sales would be 410 air conditioners. Using the exponential smoothing with a weight of = 0.30, develop forecasts for years 2 through 6.
5-22
Using the trend projection method, develop a forecasting model for the sales of Cool-Man air conditioners (see problem 5-18).
5-33
Management of Davis’s Department Store has used time-series extrapolation to forecast retail sales for the next four quarters. The sales estimates are $100,000, $120,000, $140,000, and $160,000 for the respective quarters before adjusting for seasonality. Seasonal indices for the four quarters have been found to be 1.30, 0.90, 0.70, and 1.10, respectively. Compute a seasonalized or adjusted sales forecast.
© BrainMass Inc. brainmass.com March 21, 2019, 4:05 pm ad1c9bdddf
https://brainmass.com/business/business-management/forecasting-problems-173331
Attachments
Module 4 Exercise.doc