Forecast
Not what you're looking for?
(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.
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.