Purchase Solution

Forecasting Problems

Not what you're looking for?

Ask Custom Question

Please see attached file for full problem description.

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.

Purchase this Solution

Solution Summary

This posting provides solution to several forecasting problems including moving average, exponential smoothing, trend analysis, weighted moving average etc.

Purchase this Solution


Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Basics of corporate finance

These questions will test you on your knowledge of finance.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.