Purchase Solution

Forecasting using different approaches - an example

Not what you're looking for?

Ask Custom Question

Present three forecasts, one that would result from the use of each of the following approaches (show all formulas):

Calculate the appropriate naïve approach and list two or more advantages of using this approach.

Compute a five-period moving average and list two or more advantages of using this approach.

Compute a weighted average using the four most recent periods with weights assigned as follows: .40 (most recent), .30, .20, and .10 and list one or more advantages of using this approach.

The owner of a bakery has the following demands for chocolate chip cookies per day (Period: Number of Demands):

1: 112

2: 136

3: 122

4: 139

5: 118

6: 137

7: 125

8: 141

Purchase this Solution

Solution Summary

This solution describes different forecasting approaches and their advantages. Using an example data set, these forecasts are calculated and compared. An Excel file shows the underlying calculations (using formulas).

Solution Preview

Hi,

All the information you will need is in the .doc file, but if you'd like to see how I've constructed graphs or check how to forecast using spreadsheets you can also look in the Excel file.

The text below is pasted for your convenience, but to see the formulas and graph please refer to the attached .doc file.

------

Hi,

First of all, these exercises deal with forecasting which is a fairly complex issue. But let's try some simple forecasting tools.
Naïve forecast as the name suggests is very simple - it assumes that the last observed value will continue to be observed in the future. Our last observation ...

Purchase this Solution


Free BrainMass Quizzes
Learning Lean

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

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.