Purchase Solution

Forecast

Not what you're looking for?

Ask Custom Question

(See attached file for full problem description)

---
Consider the following forecasts:

a. Calculate the three month Simple Moving Average forecast for months 4 - 11 for the following demand data:

Month Demand SMA
Forecast Error Absolute Error ( |E| )
1 120
2 115
3 125
4 119
5 127
6 114
7 120
8 124
9 116
10 137
11
b. Calculate the three month Weighted Moving Average forecast for months 4 - 11 for the following demand data using weights of 0.5, 0.3, and 0.2:

Month Demand WMA
Forecast Error Absolute Error ( |E| )
1 120
2 115
3 125
4 119
5 127
6 114
7 120
8 124
9 116
10 137
11

c. Calculate the Exponential Smoothing forecast for months 4 - 11 for the following demand data:
Use the demand for period (month) 1 as the forecast for period (month) 2. Use an alpha of 0.6

Month Demand Exponential Smoothing
Forecast Error Absolute Error ( |E| )
1 120
2 115
3 125
4 119
5 127
6 114
7 120
8 124
9 116
10 137
11

d. Determine CFE and MAD for months 4 - 11 for each of the methods in part a, b, & c

Simple Moving Average Weighted Moving Average Exponential
Smoothing
CFE
MAD

e. Use the following quarterly data (sales in units) to develop seasonal indexes:

Quarter Year 1 Year 2 Year 3 Seasonal Index Year 4
1 51 62 74
2 103 124 133
3 172 199 222
4 296 332 367
Total 622 717 796

f. If the forecasted annual demand for Year 4 is 900, calculate the quarterly demands for Year 4.

Attachments
Purchase this Solution

Solution Summary

Excel file contains solution of 6 forecasting problem.

Purchase this Solution


Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Lean your Process

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