Forecasting the demand by moving average method
Not what you're looking for?
You sold the following number of flowers during the last two weeks. Calculate a forecast of the demand using a 3 and 5 period moving average. Graph these forecasts and the original data using excel. What does the graph show and which of the above forecasts is best and why.
Day 1 Demand Day Demand
1 200 8 150
2 134 9 182
3 157 10 197
4 165 11 136
5 177 12 163
6 125 13 157
7 146 14 169
Purchase this Solution
Solution Summary
Solution describes the steps to calculate a forecast of demand using a 3 and 5 period moving average method.
Solution Preview
Please refer attached file for better clarity of tables and missing graph.
Solution
3-period moving average
Day Demand, D Forecast, F Absolute value
of difference, D-F
1 200
2 134
3 157
4 165 163.67 1.33
5 177 152.00 25.00
6 125 166.33 41.33
7 146 155.67 9.67
8 150 149.33 0.67
9 182 140.33 41.67
10 197 159.33 37.67
11 136 176.33 40.33
12 163 171.67 8.67
13 157 165.33 8.33
14 169 152.00 17.00
15 ...
Education
- BEng (Hons) , Birla Institute of Technology and Science, India
- MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
- "Thank you"
- "Really great step by step solution"
- "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
- "Thanks Again! This is totally a great service!"
- "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations
This quiz intended to help students understand change and resistance in organizations
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
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Basics of corporate finance
These questions will test you on your knowledge of finance.