SCM 2160 05 forecasting activity - with answers

.xlsx

School

University of Manitoba *

*We aren’t endorsed by this school

Course

2160

Subject

Economics

Date

Feb 20, 2024

Type

xlsx

Pages

11

Uploaded by GeneralDeerMaster1024

Report
Week Demand Error 1 63 2 70 63 3 78 70 4 51 78 5 56 51 6 67 56 7 80 67 Week Demand Error 1 63 2 70 3 78 66.5 4 51 74 5 56 64.5 6 67 53.5 7 80 61.5 Week Demand Error 1 63 2 70 3 78 4 51 76.05 5 56 56.00 6 67 56.35 7 80 64.55 Week Demand Error 1 63 2 70 58.65 3 78 60.35 4 51 63.00 5 56 61.20 6 67 60.42 7 80 61.41 Naive Forecast Square Error Absolute Error Percenta ge Error 2-Period Moving Average Square Error Absolute Error Percenta ge Error Weighted Moving Average Square Error Absolute Error Percenta ge Error Exponential Smoothing w/ α= .15 Square Error Absolute Error Percenta ge Error
Week Demand Forecast 1 63 2 70 3 78 4 51 5 56 6 67 7 80
Week Demand Naive Forecast Error Square Error Absolute Error 1 137 2 136 137 -1 1.00 1.0 3 143 4 136 5 141 6 128 7 149 8 136 9 134 10 143 Week Demand Error Square Error Absolute Error 1 137 2 136 3 143 4 136 5 141 6 128 7 149 8 136 9 134 10 143 Week Demand Error Square Error Absolute Error 1 137 2 136 3-Period Moving Average Exponential Smoothing w/ α= .28 1. A company is trying to select a forecasting model. Using the attached spreadshe and exponential smoothing forecasts. (For exponential smoothing, use the 3-perio 2. Which forecast method should management use if the performance criterion it
3 143 4 136 5 141 6 128 7 149 8 136 9 134 10 143
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help