Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Period Month Demand Level Seasonal Forecast Error ABS % Error Sq. Error 1 Jan 100 2 Feb 138 3 Mar 71 4 Apr 100 5
Period | Month | Demand | Level | Seasonal | Forecast | Error | ABS % Error | Sq. Error |
1 | Jan | 100 | ||||||
2 | Feb | 138 | ||||||
3 | Mar | 71 | ||||||
4 | Apr | 100 | ||||||
5 | May | 124 | ||||||
6 | Jun | 73 | ||||||
7 | Jul | 96 | ||||||
8 | Aug | 136 | ||||||
9 | Sep | 76 | ||||||
10 | Oct | 95 | ||||||
11 | Nov | 134 | ||||||
12 | Dec | 69 | ||||||
13 | Jan | 100 | ||||||
14 | Feb | 129 | ||||||
15 | Mar | 71 | ||||||
16 | Apr | 86 | ||||||
17 | May | 138 | ||||||
18 | Jun | 80 | ||||||
19 | Jul | 86 | ||||||
20 | Aug | 131 | ||||||
21 | Sep | 82 | ||||||
22 | Oct | 93 | ||||||
23 | Nov | 124 | ||||||
24 | Dec | 77 |
ME: | |
MAPE: | |
MSE: |
For the forecasting part, please use exponential smoothing with the following initalization values: seasonal=100
alpha value of 0.1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started